
CREATE TABLE `front_cms_menu_items` (
  `id` int NOT NULL AUTO_INCREMENT,
  `menu_id` int NOT NULL,
  `menu` varchar(100) DEFAULT NULL,
  `page_id` int NOT NULL,
  `parent_id` int NOT NULL,
  `ext_url` mediumtext,
  `open_new_tab` int DEFAULT '0',
  `ext_url_link` mediumtext,
  `slug` varchar(200) DEFAULT NULL,
  `weight` int DEFAULT NULL,
  `publish` int NOT NULL DEFAULT '0',
  `description` mediumtext,
  `is_active` varchar(10) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb3;

INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (1, 1, 'Home', 1, 0, NULL, NULL, NULL, 'home', 1, 0, NULL, 'no', '2018-12-14 15:55:09');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (3, 1, 'About Us', 77, 0, NULL, NULL, NULL, 'about-us-1', 5, 0, NULL, 'no', '2024-08-30 09:56:18');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (6, 1, 'Vision and Mission', 80, 3, NULL, NULL, NULL, 'vision-and-mission', 7, 0, NULL, 'no', '2024-08-30 09:56:18');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (7, 1, 'FAQ’s', 81, 3, NULL, NULL, NULL, 'faqs', 9, 0, NULL, 'no', '2024-08-30 09:56:18');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (8, 1, 'About Hospitals', 82, 3, NULL, NULL, NULL, 'about-hospitals', 6, 0, NULL, 'no', '2024-08-30 09:56:18');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (9, 1, 'Meet Our Doctors', 83, 3, NULL, NULL, NULL, 'meet-our-doctors', 8, 0, NULL, 'no', '2024-08-30 09:56:18');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (10, 1, 'testimonials', 84, 3, NULL, NULL, NULL, 'testimonials', 11, 0, NULL, 'no', '2024-08-30 09:56:18');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (13, 1, 'Events', 86, 0, NULL, NULL, NULL, 'events', 4, 0, NULL, 'no', '2024-08-30 09:56:18');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (14, 1, 'Gallery', 87, 0, NULL, NULL, NULL, 'gallery', 13, 0, NULL, 'no', '2024-08-30 09:56:18');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (15, 1, 'Contact Us', 76, 0, NULL, NULL, NULL, 'contact-us', 14, 0, NULL, 'no', '2024-08-30 09:56:18');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (16, 2, 'Home', 1, 0, NULL, NULL, NULL, 'home-1', NULL, 0, NULL, 'no', '2018-07-14 14:14:12');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (17, 2, 'About', 78, 0, NULL, NULL, NULL, 'about', NULL, 0, NULL, 'no', '2018-07-14 14:14:34');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (18, 2, 'Academics', 85, 0, NULL, NULL, NULL, 'academics-1', NULL, 0, NULL, 'no', '2018-07-14 14:16:49');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (19, 2, 'Events', 86, 0, NULL, NULL, NULL, 'events-1', NULL, 0, NULL, 'no', '2018-07-14 14:17:02');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (20, 2, 'Gallery', 87, 0, NULL, NULL, NULL, 'gallery-1', NULL, 0, NULL, 'no', '2018-07-14 14:17:17');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (21, 2, 'Contact Us', 76, 0, NULL, NULL, NULL, 'contact-us-1', NULL, 0, NULL, 'no', '2018-07-14 14:17:35');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (22, 4, 'sdfsdf', 83, 0, NULL, NULL, NULL, 'sdfsdf', NULL, 0, NULL, 'no', '2018-09-29 14:00:57');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (23, 1, 'Appointment', 0, 0, '1', NULL, 'https://demo.smart-hospital.in/form/appointment', 'appointment', 3, 0, NULL, 'no', '2024-08-30 09:56:18');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (24, 1, 'Departments', 85, 3, NULL, NULL, NULL, 'departments', 10, 0, NULL, 'no', '2024-08-30 09:56:18');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (26, 2, 'Annual Calendar', 93, 0, NULL, NULL, NULL, 'annual-calendar-1', NULL, 0, NULL, 'no', '2024-08-29 12:43:05');
INSERT INTO `front_cms_menu_items` (`id`, `menu_id`, `menu`, `page_id`, `parent_id`, `ext_url`, `open_new_tab`, `ext_url_link`, `slug`, `weight`, `publish`, `description`, `is_active`, `created_at`) VALUES (27, 1, 'Annual Calendar', 0, 0, '1', NULL, 'https://demo.smart-hospital.in/page/annual_calendar', 'annual-calendar', 2, 0, NULL, 'no', '2024-08-30 11:47:16');


#
# TABLE STRUCTURE FOR: front_cms_menus
#


CREATE TABLE `front_cms_menus` (
  `id` int NOT NULL AUTO_INCREMENT,
  `menu` varchar(100) DEFAULT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `description` mediumtext,
  `open_new_tab` int NOT NULL DEFAULT '0',
  `ext_url` mediumtext NOT NULL,
  `ext_url_link` mediumtext NOT NULL,
  `publish` int NOT NULL DEFAULT '0',
  `content_type` varchar(10) NOT NULL DEFAULT 'manual',
  `is_active` varchar(10) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

INSERT INTO `front_cms_menus` (`id`, `menu`, `slug`, `description`, `open_new_tab`, `ext_url`, `ext_url_link`, `publish`, `content_type`, `is_active`, `created_at`) VALUES (1, 'Main Menu', 'main-menu', 'Main menu', 0, '', '', 0, 'default', 'no', '2018-04-20 14:54:49');
INSERT INTO `front_cms_menus` (`id`, `menu`, `slug`, `description`, `open_new_tab`, `ext_url`, `ext_url_link`, `publish`, `content_type`, `is_active`, `created_at`) VALUES (2, 'Bottom Menu', 'bottom-menu', 'Bottom Menu', 0, '', '', 0, 'default', 'no', '2018-04-20 14:54:55');


#
# TABLE STRUCTURE FOR: front_cms_page_contents
#


CREATE TABLE `front_cms_page_contents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `page_id` int DEFAULT NULL,
  `content_type` varchar(50) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `page_id` (`page_id`),
  CONSTRAINT `front_cms_page_contents_ibfk_1` FOREIGN KEY (`page_id`) REFERENCES `front_cms_pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

INSERT INTO `front_cms_page_contents` (`id`, `page_id`, `content_type`, `created_at`) VALUES (1, 87, 'gallery', '2018-07-16 15:37:29');
INSERT INTO `front_cms_page_contents` (`id`, `page_id`, `content_type`, `created_at`) VALUES (3, 86, 'events', '2019-01-14 17:24:51');


#
# TABLE STRUCTURE FOR: front_cms_pages
#


CREATE TABLE `front_cms_pages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `page_type` varchar(10) NOT NULL DEFAULT 'manual',
  `is_homepage` int DEFAULT '0',
  `title` varchar(250) DEFAULT NULL,
  `url` varchar(250) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `meta_title` mediumtext,
  `meta_description` mediumtext,
  `meta_keyword` mediumtext,
  `feature_image` varchar(200) NOT NULL,
  `description` longtext,
  `publish_date` date NOT NULL,
  `publish` int DEFAULT '0',
  `sidebar` int DEFAULT '0',
  `is_active` varchar(10) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8mb3;

INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (1, 'default', 1, 'Home', 'page/home', 'page', 'home', '', '', '', '', '<div class=\"col-md-12 hometop\">\r\n<div class=\"row\">\r\n<div class=\"col-md-3 col-sm-6 p-0\">\r\n<div class=\"featurebox1\">\r\n<h3 class=\"he-title\">Clinic News</h3>\r\n\r\n<p>Cum sociis natoque penatibus et magnis dis parturient montesmus. Pro vel nibh et elit mollis commodo et nec augue tristique sed</p>\r\n\r\n<p><a class=\"morebtn\" href=\"#\" title=\"Read More\">Read More</a></p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-3 col-sm-6 p-0\">\r\n<div class=\"featurebox2\">\r\n<h3 class=\"he-title\">Top Doctors</h3>\r\n\r\n<p>Cum sociis natoque penatibus et magnis dis parturient montesmus. Pro vel nibh et elit mollis commodo et nec augue tristique sed</p>\r\n\r\n<p><a class=\"morebtn\" href=\"#\" title=\"Read More\">Read More</a></p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-3 col-sm-6 p-0\">\r\n<div class=\"featurebox3\">\r\n<h3 class=\"he-title\">24 Hours Service</h3>\r\n\r\n<p>Cum sociis natoque penatibus et magnis dis parturient montesmus. Pro vel nibh et elit mollis commodo et nec augue tristique sed</p>\r\n\r\n<p><a class=\"morebtn\" href=\"#\" title=\"Read More\">Read More</a></p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-3 col-sm-6 p-0\">\r\n<div class=\"featurebox4\">\r\n<h3 class=\"he-title\">Opening Hours</h3>\r\n\r\n<ul style=\"padding: 0;list-style: none;clear: both; width:100%\">\r\n	<li style=\"width:100%; clear:both\"><span class=\"pull-left\">Monday - Friday</span><span class=\"pull-right\">8.00 - 17.00</span></li>\r\n	<li style=\"width:100%; clear:both\"><span class=\"pull-left\">Saturday</span><span class=\"pull-right\">9.30 - 17.30</span></li>\r\n	<li style=\"width:100%; clear:both\"><span class=\"pull-left\">Sunday</span><span class=\"pull-right\">9.30 - 15.00</span></li>\r\n</ul>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div style=\"height:50px; clear: both\">&nbsp;</div>\r\n\r\n<div class=\"row\">\r\n<div class=\"col-md-8\">\r\n<h3>About Us</h3>\r\n\r\n<h5>What we are and our history</h5>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting,</p>\r\n\r\n<hr />\r\n<h3>Vision & Mission</h3>\r\n\r\n<h5>Our goal and thoughts</h5>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting,</p>\r\n</div>\r\n\r\n<div class=\"col-md-4\"><img class=\"img-responsive\" src=\"https://demo.smart-hospital.in/uploads/gallery/media/about.jpg\" /></div>\r\n</div>\r\n\r\n<h2 style=\"text-align: center;\">Featured Services</h2>\r\n\r\n<p style=\"text-align: center;\">We cover a big variety of medical services</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<div class=\"row text-center\">\r\n<div class=\"col-md-3 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/medicine-icons.jpg\" />\r\n<h4>Medical Treatment</h4>\r\n\r\n<p>Cum sociis natoque penatibus et magnis dis parturient montesmus. Pro vel nibh et elit mollis commodo et nec augueique</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-3 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/emergency-1547424000.jpg\" />\r\n<h4>Emergency Help</h4>\r\n\r\n<p>Cum sociis natoque penatibus et magnis dis parturient montesmus. Pro vel nibh et elit mollis commodo et nec augueique</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-3 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/doctor-icon.jpg\" />\r\n<h4>Qualified Doctors</h4>\r\n\r\n<p>Cum sociis natoque penatibus et magnis dis parturient montesmus. Pro vel nibh et elit mollis commodo et nec augueique</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-3 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/profession-icon-1547424000.jpg\" />\r\n<h4>Medical professionals</h4>\r\n\r\n<p>Cum sociis natoque penatibus et magnis dis parturient montesmus. Pro vel nibh et elit mollis commodo et nec augueique</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<hr />\r\n<h2 style=\"text-align: center;\">Our Doctors</h2>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<div class=\"row text-center\">\r\n<div class=\"col-md-3 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter1.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-3 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter2.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-3 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter3.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-3 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter4.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n</div>', '0000-00-00', 1, 1, 'no', '2019-02-05 15:02:11');
INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (2, 'default', 0, 'Complain', 'page/complain', 'page', 'complain', 'Complain form', '                                                                                                                                                                                    complain form                                                                                                                                                                                                                                ', 'complain form', '', '<div class=\"col-md-12 col-sm-12\">\r\n<h2 class=\"text-center\">Complain</h2>\r\n\r\n<p class=\"text-center\">Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy<br />\r\nnibh euismod tincidunt ut laoreet dolore magna.</p>\r\n\r\n<p class=\"text-center\">&nbsp;</p>\r\n\r\n<p class=\"text-center\">[form-builder:complain]</p>\r\n</div>', '0000-00-00', 1, 1, 'no', '2018-12-20 15:55:47');
INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (54, 'default', 0, '404 page', 'page/404-page', 'page', '404-page', '', '                                ', '', '', '<html>\r\n<head>\r\n <title></title>\r\n</head>\r\n<body>\r\n<p>404 page found</p>\r\n</body>\r\n</html>', '0000-00-00', 0, NULL, 'no', '2018-05-18 14:46:04');
INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (76, 'default', 0, 'Contact us', 'page/contact-us', 'page', 'contact-us', '', '', '', '', '<title></title>\r\n<section class=\"contact\">\r\n<div class=\"container spacet50 spaceb50\">\r\n<div class=\"row\">\r\n<div class=\"col-md-12 col-sm-12\">\r\n<h2 class=\"text-center\">LET’S TALK</h2>\r\n\r\n<p class=\"text-center\">Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy<br />\r\nnibh euismod tincidunt ut laoreet dolore magna.</p>\r\n</div>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<div class=\"col-md-12 col-sm-12\">[form-builder:contact_us]<!--./row--></div>\r\n<!--./col-md-12--></div>\r\n<!--./row--></div>\r\n<!--./container--></section>\r\n\r\n<div class=\"col-md-4 col-sm-4\">\r\n<div class=\"contact-item\">\r\n<h3>Medifine Center</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam nisl ex, efficitur et egestas sit amet, aliquet vitae magna. Proin</p>\r\n<a href=\"#\">Mon - Fri 9:00 am - 2:00 PM</a></div>\r\n<!--./contact-item--></div>\r\n<!--./col-md-4-->\r\n\r\n<div class=\"col-md-4 col-sm-4\">\r\n<div class=\"contact-item\">\r\n<h3>Enquiry Phone.</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam nisl ex, efficitur et egestas sit amet, aliquet vitae magna. Proin</p>\r\n<a href=\"#\">(+01) 102 1234 8888</a></div>\r\n<!--./contact-item--></div>\r\n<!--./col-md-4-->\r\n\r\n<div class=\"col-md-4 col-sm-4\">\r\n<div class=\"contact-item\">\r\n<h3>Drop a line.</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam nisl ex, efficitur et egestas sit amet, aliquet vitae magna. Proin</p>\r\n<a href=\"#\">info@hospital.com</a></div>\r\n<!--./contact-item--></div>\r\n<!--./col-md-4-->\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<div class=\"mapwrapper=\"><iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d398330.4846028526!2d-84.869715!3d38.741751!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x55194ec5a1ae072e!2sTimes+Square!5e0!3m2!1sen!2sus!4v1549380547982\" width=\"100%\" height=\"450\" frameborder=\"0\" style=\"border:0\" allowfullscreen></iframe></div>', '0000-00-00', 0, NULL, 'no', '2019-02-05 15:29:42');
INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (80, 'manual', 0, 'Vision and Mission', 'page/vision-and-mission', 'page', 'vision-and-mission', '', '', '', '', '<div class=\"row\">\r\n<div class=\"col-md-8 col-sm-8\">\r\n<h2 class=\"mt0\">Our Mission</h2>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusm od tempor incididunt ut labore et dolore magna aliqua.</p>\r\n\r\n<div class=\"row\">\r\n<div class=\"col-md-6 col-sm-6\">\r\n<div class=\"info-wrap\">\r\n<div class=\"icon-img\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/info-item5.png\" /></div>\r\n\r\n<div class=\"item-info-content\">\r\n<h4>Health information</h4>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisicing elit, sed do eiusmod tempor incidid.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-6 col-sm-6\">\r\n<div class=\"info-wrap\">\r\n<div class=\"icon-img\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/info-item6.png\" /></div>\r\n\r\n<div class=\"item-info-content\">\r\n<h4>Medical education</h4>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisicing elit, sed do eiusmod tempor incidid.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-6 col-sm-6\">\r\n<div class=\"info-wrap\">\r\n<div class=\"icon-img\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/info-item7.png\" /></div>\r\n\r\n<div class=\"item-info-content\">\r\n<h4>Symptom Check</h4>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisicing elit, sed do eiusmod tempor incidid.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-6 col-sm-6\">\r\n<div class=\"info-wrap\">\r\n<div class=\"icon-img\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/info-item8.png\" /></div>\r\n\r\n<div class=\"item-info-content\">\r\n<h4>Qualified Doctors</h4>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisicing elit, sed do eiusmod tempor incidid.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-4\">\r\n<div class=\"opening-hours\">\r\n<h3>MONDAY – FRIDAY</h3>\r\n\r\n<p>OPENIN HOURS</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisic ing elit, sed do eiusmod tempor incidid.</p>\r\n\r\n<ul class=\"hourlist\">\r\n	<li>Internist doctor<span>08:00 – 20:00</span></li>\r\n	<li>Family doctor<span>09:00 – 17:00</span></li>\r\n	<li>Pediatrician doctor<span>08:00 – 16:00</span></li>\r\n	<li>Physiotherapist<span>10:00 – 15:00</span></li>\r\n</ul>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div style=\"height:100px; clear:both\">&nbsp;</div>\r\n\r\n<div class=\"row\">\r\n<div class=\"col-md-4 col-sm-4\">\r\n<div class=\"opening-hours\">\r\n<h3>Goals</h3>\r\n\r\n<ul class=\"hourlist\">\r\n	<li>To equip students with a sound value system to live as good human beings and impart substantial knowledge and skill to achieve excellence in diverse fields.</li>\r\n	<li>To promote numerous co-curricular activities for the integral growth of students.</li>\r\n	<li>To provide opportunities to discover and develop talents of each student.</li>\r\n	<li>To motivate students in making learning a lifelong process and to strive for self-improvement, self growth and sell transcendence.</li>\r\n</ul>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-8 col-sm-8\">\r\n<h2 class=\"mt0\">Our Vision</h2>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusm od tempor incididunt ut labore et dolore magna aliqua.</p>\r\n\r\n<div class=\"row\">\r\n<div class=\"col-md-6 col-sm-6\">\r\n<div class=\"info-wrap\">\r\n<div class=\"icon-img\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/info-item5.png\" /></div>\r\n\r\n<div class=\"item-info-content\">\r\n<h4>Health information</h4>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisicing elit, sed do eiusmod tempor incidid.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-6 col-sm-6\">\r\n<div class=\"info-wrap\">\r\n<div class=\"icon-img\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/info-item6.png\" /></div>\r\n\r\n<div class=\"item-info-content\">\r\n<h4>Medical education</h4>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisicing elit, sed do eiusmod tempor incidid.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-6 col-sm-6\">\r\n<div class=\"info-wrap\">\r\n<div class=\"icon-img\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/info-item7.png\" /></div>\r\n\r\n<div class=\"item-info-content\">\r\n<h4>Symptom Check</h4>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisicing elit, sed do eiusmod tempor incidid.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-6 col-sm-6\">\r\n<div class=\"info-wrap\">\r\n<div class=\"icon-img\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/info-item8.png\" /></div>\r\n\r\n<div class=\"item-info-content\">\r\n<h4>Qualified Doctors</h4>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisicing elit, sed do eiusmod tempor incidid.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', '0000-00-00', 0, 1, 'no', '2019-02-05 15:11:42');
INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (81, 'manual', 0, 'faq', 'page/faq', 'page', 'faq', '', '', '', '', '<div class=\"row\">\r\n<div class=\"col-md-6\">\r\n<div class=\"pxlr-club-faq\">\r\n<div class=\"content\">\r\n<h3 class=\"sec-title\">What Our Clients Say</h3>\r\n\r\n<div aria-multiselectable=\"true\" class=\"panel-group\" id=\"accordion\" role=\"tablist\">\r\n<div class=\"panel panel-default\">\r\n<div class=\"panel-heading\" id=\"headingOne\" role=\"tab\">\r\n<h4 class=\"panel-title\"><a aria-controls=\"collapseOne\" aria-expanded=\"false\" class=\"collapsed\" data-parent=\"#accordion\" data-toggle=\"collapse\" href=\"#collapseOne\" role=\"button\">Lorem ipsum dolor sit amet, an eripuit laboramus</a></h4>\r\n</div>\r\n\r\n<div aria-labelledby=\"headingOne\" class=\"panel-collapse collapse\" id=\"collapseOne\" role=\"tabpanel\">\r\n<div class=\"panel-body pxlr-faq-body\">\r\n<p>Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven\'t heard of them accusamus labore sustainable VHS.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"panel panel-default\">\r\n<div class=\"panel-heading\" id=\"headingTwo\" role=\"tab\">\r\n<h4 class=\"panel-title\"><a aria-controls=\"collapseTwo\" aria-expanded=\"false\" class=\"collapsed\" data-parent=\"#accordion\" data-toggle=\"collapse\" href=\"#collapseTwo\" role=\"button\">What is the deposit amount for admission?</a></h4>\r\n</div>\r\n\r\n<div aria-labelledby=\"headingTwo\" class=\"panel-collapse collapse\" id=\"collapseTwo\" role=\"tabpanel\">\r\n<div class=\"panel-body pxlr-faq-body\">\r\n<p>Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven\'t heard of them accusamus labore sustainable VHS.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"panel panel-default\">\r\n<div class=\"panel-heading\" id=\"headingThree\" role=\"tab\">\r\n<h4 class=\"panel-title\"><a aria-controls=\"collapseThree\" aria-expanded=\"false\" class=\"collapsed\" data-parent=\"#accordion\" data-toggle=\"collapse\" href=\"#collapseThree\" role=\"button\">Problem with Knowledge base Article and knowledge</a></h4>\r\n</div>\r\n\r\n<div aria-labelledby=\"headingThree\" class=\"panel-collapse collapse\" id=\"collapseThree\" role=\"tabpanel\">\r\n<div class=\"panel-body pxlr-faq-body\">\r\n<p>Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven\'t heard of them accusamus labore sustainable VHS.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"panel panel-default\">\r\n<div class=\"panel-heading\" id=\"headingSeven\" role=\"tab\">\r\n<h4 class=\"panel-title\"><a aria-controls=\"collapseSeven\" aria-expanded=\"false\" class=\"collapsed\" data-parent=\"#accordion\" data-toggle=\"collapse\" href=\"#collapseSeven\" role=\"button\">Problem with Knowledge base Article and knowledge</a></h4>\r\n</div>\r\n\r\n<div aria-labelledby=\"headingSeven\" class=\"panel-collapse collapse\" id=\"collapseSeven\" role=\"tabpanel\">\r\n<div class=\"panel-body pxlr-faq-body\">\r\n<p>Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven\'t heard of them accusamus labore sustainable VHS.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"panel panel-default\">\r\n<div class=\"panel-heading\" id=\"headingEight\" role=\"tab\">\r\n<h4 class=\"panel-title\"><a aria-controls=\"collapseEight\" aria-expanded=\"false\" class=\"collapsed\" data-parent=\"#accordion\" data-toggle=\"collapse\" href=\"#collapseEight\" role=\"button\">Problem with Knowledge base Article and knowledge</a></h4>\r\n</div>\r\n\r\n<div aria-labelledby=\"headingEight\" class=\"panel-collapse collapse\" id=\"collapseEight\" role=\"tabpanel\">\r\n<div class=\"panel-body pxlr-faq-body\">\r\n<p>Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven\'t heard of them accusamus labore sustainable VHS.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-6\">\r\n<div class=\"pxlr-club-faq\">\r\n<div class=\"content\">\r\n<h3 class=\"sec-title\">What Our Doctor Say</h3>\r\n\r\n<div aria-multiselectable=\"true\" class=\"panel-group\" id=\"accordion\" role=\"tablist\">\r\n<div class=\"panel panel-default\">\r\n<div class=\"panel-heading\" id=\"headingFour\" role=\"tab\">\r\n<h4 class=\"panel-title\"><a aria-controls=\"collapseFour\" aria-expanded=\"false\" class=\"collapsed\" data-parent=\"#accordion\" data-toggle=\"collapse\" href=\"#collapseFour\" role=\"button\">Anonymous user won’t receive email private? </a></h4>\r\n</div>\r\n\r\n<div aria-labelledby=\"headingFour\" class=\"panel-collapse collapse\" id=\"collapseFour\" role=\"tabpanel\">\r\n<div class=\"panel-body pxlr-faq-body\">\r\n<p>Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it esciunt you probably haven\'t heard of them accusamus labore sustainable VHS.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"panel panel-default\">\r\n<div class=\"panel-heading\" id=\"headingFive\" role=\"tab\">\r\n<h4 class=\"panel-title\"><a aria-controls=\"collapseFive\" aria-expanded=\"false\" class=\"collapsed\" data-parent=\"#accordion\" data-toggle=\"collapse\" href=\"#collapseFive\" role=\"button\">How to have an editor like this editor? </a></h4>\r\n</div>\r\n\r\n<div aria-labelledby=\"headingFive\" class=\"panel-collapse collapse\" id=\"collapseFive\" role=\"tabpanel\">\r\n<div class=\"panel-body pxlr-faq-body\">\r\n<p>Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven\'t heard of them accusamus labore sustainable VHS.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"panel panel-default\">\r\n<div class=\"panel-heading\" id=\"headingSix\" role=\"tab\">\r\n<h4 class=\"panel-title\"><a aria-controls=\"collapseSix\" aria-expanded=\"false\" class=\"collapsed\" data-parent=\"#accordion\" data-toggle=\"collapse\" href=\"#collapseSix\" role=\"button\">Problem with Knowledge base Article? </a></h4>\r\n</div>\r\n\r\n<div aria-labelledby=\"headingSix\" class=\"panel-collapse collapse\" id=\"collapseSix\" role=\"tabpanel\">\r\n<div class=\"panel-body pxlr-faq-body\">\r\n<p>Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven\'t heard of them accusamus labore sustainable VHS.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"panel panel-default\">\r\n<div class=\"panel-heading\" id=\"headingNine\" role=\"tab\">\r\n<h4 class=\"panel-title\"><a aria-controls=\"collapseNine\" aria-expanded=\"false\" class=\"collapsed\" data-parent=\"#accordion\" data-toggle=\"collapse\" href=\"#collapseNine\" role=\"button\">Problem with Knowledge base Article? </a></h4>\r\n</div>\r\n\r\n<div aria-labelledby=\"headingNine\" class=\"panel-collapse collapse\" id=\"collapseNine\" role=\"tabpanel\">\r\n<div class=\"panel-body pxlr-faq-body\">\r\n<p>Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven\'t heard of them accusamus labore sustainable VHS.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"panel panel-default\">\r\n<div class=\"panel-heading\" id=\"headingTen\" role=\"tab\">\r\n<h4 class=\"panel-title\"><a aria-controls=\"collapseTen\" aria-expanded=\"false\" class=\"collapsed\" data-parent=\"#accordion\" data-toggle=\"collapse\" href=\"#collapseTen\" role=\"button\">Problem with Knowledge base Article? </a></h4>\r\n</div>\r\n\r\n<div aria-labelledby=\"headingTen\" class=\"panel-collapse collapse\" id=\"collapseTen\" role=\"tabpanel\">\r\n<div class=\"panel-body pxlr-faq-body\">\r\n<p>Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven\'t heard of them accusamus labore sustainable VHS.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', '0000-00-00', 0, 1, 'no', '2018-12-14 14:41:48');
INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (82, 'manual', 0, 'About Hospitals', 'page/about-hospitals', 'page', 'about-hospitals', '', '', '', '', '<div class=\"row\">\r\n<div class=\"col-md-6 col-sm-6\"><img class=\"img-responsive\" src=\"https://demo.smart-hospital.in/uploads/gallery/media/single-image-2.jpg\" /></div>\r\n\r\n<div class=\"col-md-6 col-sm-6\">\r\n<h2 class=\"mt0\">Some Words About Us</h2>\r\n\r\n<p>Medic Medical will teach physicians and nurses from around the world the principles of blood management, as well as how to manage their own blood conservation programs. The hospital was chosen based on the reputation its bloodless program has established in the medical community and because of its nationally recognized results.</p>\r\n\r\n<p>Medic Medical will teach physicians and znurses from around the world the principles of blood management, as well as how to manage their own blood conservation programs. The hospital was chosen based on the reputation its bloodless program has established in the medical community and because of its nationally recognized results.</p>\r\n\r\n<div class=\"row pt10\">\r\n<div class=\"col-md-6 col-sm-6\">\r\n<ul class=\"list1\">\r\n	<li>Emergy Case</li>\r\n	<li>Doctors Timetables</li>\r\n	<li>Vaccinations & Travel Health</li>\r\n	<li>Women’s Health</li>\r\n</ul>\r\n</div>\r\n\r\n<div class=\"col-md-6 col-sm-6\">\r\n<ul class=\"list1\">\r\n	<li>Emergy Case</li>\r\n	<li>Doctors Timetables</li>\r\n	<li>Vaccinations & Travel Health</li>\r\n	<li>Women’s Health</li>\r\n</ul>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div style=\"height: 100px; clear: both;\">&nbsp;</div>\r\n\r\n<div class=\"row\">\r\n<div class=\"col-md-8 col-sm-8\">\r\n<h2 class=\"mt0\">Our Mission</h2>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusm od tempor incididunt ut labore et dolore magna aliqua.</p>\r\n\r\n<div class=\"row\">\r\n<div class=\"col-md-6 col-sm-6\">\r\n<div class=\"info-wrap\">\r\n<div class=\"icon-img\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/info-item5.png\" /></div>\r\n\r\n<div class=\"item-info-content\">\r\n<h4>Health information</h4>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisicing elit, sed do eiusmod tempor incidid.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-6 col-sm-6\">\r\n<div class=\"info-wrap\">\r\n<div class=\"icon-img\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/info-item6.png\" /></div>\r\n\r\n<div class=\"item-info-content\">\r\n<h4>Medical education</h4>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisicing elit, sed do eiusmod tempor incidid.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-6 col-sm-6\">\r\n<div class=\"info-wrap\">\r\n<div class=\"icon-img\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/info-item7.png\" /></div>\r\n\r\n<div class=\"item-info-content\">\r\n<h4>Symptom Check</h4>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisicing elit, sed do eiusmod tempor incidid.</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-6 col-sm-6\">\r\n<div class=\"info-wrap\">\r\n<div class=\"icon-img\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/info-item8.png\" /></div>\r\n\r\n<div class=\"item-info-content\">\r\n<h4>Qualified Doctors</h4>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisicing elit, sed do eiusmod tempor incidid.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-4\">\r\n<div class=\"opening-hours\">\r\n<h3>MONDAY – FRIDAY</h3>\r\n\r\n<p>OPENIN HOURS</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adi pisic ing elit, sed do eiusmod tempor incidid.</p>\r\n\r\n<ul class=\"hourlist\">\r\n	<li>Internist doctor<span>08:00 – 20:00</span></li>\r\n	<li>Family doctor<span>09:00 – 17:00</span></li>\r\n	<li>Pediatrician doctor<span>08:00 – 16:00</span></li>\r\n	<li>Physiotherapist<span>10:00 – 15:00</span></li>\r\n</ul>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div style=\"height: 100px; clear: both;\">&nbsp;</div>\r\n\r\n<h2 class=\"mt0 text-center\">OUR SPECIALIST</h2>\r\n\r\n<p class=\"text-center\">Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<div class=\"row text-center\">\r\n<div class=\"col-md-3 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter1.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-3 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter2.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-3 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter3.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-3 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter4.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n</div>', '0000-00-00', 0, 1, 'no', '2019-02-05 15:07:54');
INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (83, 'manual', 0, 'Meet Our Doctors', 'page/meet-our-doctors', 'page', 'meet-our-doctors', '', '', '', '', '<div class=\"row\">\r\n<div class=\"col-md-3\">\r\n<ul class=\"nav nav-pills doctortap\">\r\n	<li class=\"active\"><a aria-expanded=\"false\" data-toggle=\"tab\" href=\"#practitioner\">General Practitioner</a></li>\r\n	<li><a aria-expanded=\"false\" data-toggle=\"tab\" href=\"#ophthalmologist\">Ophthalmologist</a></li>\r\n	<li><a aria-expanded=\"false\" data-toggle=\"tab\" href=\"#paediatrician\">Paediatrician</a></li>\r\n	<li><a aria-expanded=\"true\" data-toggle=\"tab\" href=\"#cardiologist\">Cardiologist</a></li>\r\n	<li><a aria-expanded=\"false\" data-toggle=\"tab\" href=\"#gynaecologist\">Gynaecologist</a></li>\r\n	<li><a aria-expanded=\"false\" data-toggle=\"tab\" href=\"#neurologist\">Neurologist</a></li>\r\n</ul>\r\n</div>\r\n\r\n<div class=\"col-md-9\">\r\n<div class=\"tab-content\"><!--Start single tab pane-->\r\n<div class=\"tab-pane active\" id=\"practitioner\">\r\n<div class=\"row\">\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter1.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter2.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter3.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter4.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter5.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter6.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"tab-pane\" id=\"ophthalmologist\">\r\n<div class=\"row\">\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter1.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter2.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter3.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"tab-pane\" id=\"paediatrician\">\r\n<div class=\"row\">\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter4.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter5.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter6.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"tab-pane\" id=\"cardiologist\">\r\n<div class=\"row\">\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter1.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter2.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter3.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"tab-pane\" id=\"gynaecologist\">\r\n<div class=\"row\">\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter4.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter5.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter6.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"tab-pane\" id=\"neurologist\">\r\n<div class=\"row\">\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter1.jpg\" />\r\n<h4>Marc Parcival</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter2.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"team-member\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/docter3.jpg\" />\r\n<h4>Alen Bailey</h4>\r\n\r\n<p>Professor</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', '0000-00-00', 0, 1, 'no', '2019-02-05 15:10:22');
INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (84, 'manual', 0, 'testimonials', 'page/testimonials', 'page', 'testimonials', '', '', '', '', '<div class=\"row\">\r\n<div class=\"col-sm-4 col-md-4\">\r\n<div class=\"user-testimonial\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/testimonial-man1.jpg\" />\r\n<h3>James Gandofin</h3>\r\n\r\n<div class=\"testimonial-content\">\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered.</p>\r\n</div>\r\n\r\n<div class=\"testimonial-icon\">&nbsp;</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-sm-4 col-md-4\">\r\n<div class=\"user-testimonial\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/testimonial-man2.jpg\" />\r\n<h3>James Gandofin</h3>\r\n\r\n<div class=\"testimonial-content\">\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered.</p>\r\n</div>\r\n\r\n<div class=\"testimonial-icon\">&nbsp;</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-sm-4 col-md-4\">\r\n<div class=\"user-testimonial\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/testimonial-man3.jpg\" />\r\n<h3>James Gandofin</h3>\r\n\r\n<div class=\"testimonial-content\">\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered.</p>\r\n</div>\r\n\r\n<div class=\"testimonial-icon\">&nbsp;</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-sm-4 col-md-4\">\r\n<div class=\"user-testimonial\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/testimonial-man4.jpg\" />\r\n<h3>James Gandofin</h3>\r\n\r\n<div class=\"testimonial-content\">\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered.</p>\r\n</div>\r\n\r\n<div class=\"testimonial-icon\">&nbsp;</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-sm-4 col-md-4\">\r\n<div class=\"user-testimonial\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/testimonial-woman1.jpg\" />\r\n<h3>James Gandofin</h3>\r\n\r\n<div class=\"testimonial-content\">\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered.</p>\r\n</div>\r\n\r\n<div class=\"testimonial-icon\">&nbsp;</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-sm-4 col-md-4\">\r\n<div class=\"user-testimonial\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/testimonial-woman2.jpg\" />\r\n<h3>James Gandofin</h3>\r\n\r\n<div class=\"testimonial-content\">\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered.</p>\r\n</div>\r\n\r\n<div class=\"testimonial-icon\">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>', '0000-00-00', 0, 1, 'no', '2019-02-05 15:14:55');
INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (85, 'manual', 0, 'Departments', 'page/departments', 'page', 'departments', '', '', '', '', '<h2 class=\"text-center\">DEPARTMENT</h2>\r\n\r\n<p class=\"text-center\">Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy<br />\r\nnibh euismod tincidunt ut laoreet dolore magna.</p>\r\n\r\n<div style=\"height: 40px; clear: both;\">&nbsp;</div>\r\n\r\n<div class=\"row text-center\">\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/doctor-icon.jpg\" />\r\n<h4>Emergency Care</h4>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever.</p>\r\n<a class=\"view-all-btn\" href=\"#\">Book Appointment</a></div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/medicine-icons.jpg\" />\r\n<h4>ENT Department</h4>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever.</p>\r\n<a class=\"view-all-btn\" href=\"#\">Book Appointment</a></div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/opration-icons.jpg\" />\r\n<h4>Eye Care</h4>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever.</p>\r\n<a class=\"view-all-btn\" href=\"#\">Book Appointment</a></div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/opration-icons.jpg\" />\r\n<h4>Diabetes Care</h4>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever.</p>\r\n<a class=\"view-all-btn\" href=\"#\">Book Appointment</a></div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/profession-icon-1547424000.jpg\" />\r\n<h4>Radiology</h4>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever.</p>\r\n<a class=\"view-all-btn\" href=\"#\">Book Appointment</a></div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/medicine-icons.jpg\" />\r\n<h4>Rheumatology</h4>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever.</p>\r\n<a class=\"view-all-btn\" href=\"#\">Book Appointment</a></div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/opration-icons.jpg\" />\r\n<h4>Lab Diagnostics</h4>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever.</p>\r\n<a class=\"view-all-btn\" href=\"#\">Book Appointment</a></div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/profession-icon-1547424000.jpg\" />\r\n<h4>Child Care</h4>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever.</p>\r\n<a class=\"view-all-btn\" href=\"#\">Book Appointment</a></div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/doctor-icon.jpg\" />\r\n<h4>X-ray</h4>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever.</p>\r\n<a class=\"view-all-btn\" href=\"#\">Book Appointment</a></div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/opration-icons.jpg\" />\r\n<h4>Surgery Department</h4>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever.</p>\r\n<a class=\"view-all-btn\" href=\"#\">Book Appointment</a></div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/profession-icon-1547424000.jpg\" />\r\n<h4>Medical Consulting</h4>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever.</p>\r\n<a class=\"view-all-btn\" href=\"#\">Book Appointment</a></div>\r\n</div>\r\n\r\n<div class=\"col-md-4 col-sm-6\">\r\n<div class=\"chooseus\"><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/doctor-icon.jpg\" />\r\n<h4>Blood Bank</h4>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever.</p>\r\n<a class=\"view-all-btn\" href=\"#\">Book Appointment</a></div>\r\n</div>\r\n</div>', '0000-00-00', 0, 1, 'no', '2019-02-05 15:13:28');
INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (86, 'manual', 0, 'Events', 'page/events', 'page', 'events', '', '', '', '', '<p>&nbsp;</p>', '0000-00-00', 0, 1, 'no', '2019-01-15 14:39:00');
INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (87, 'manual', 0, 'Gallery', 'page/gallery', 'page', 'gallery', '', '', '', '', '<title></title>\r\n<h2>Gallery</h2>', '0000-00-00', 0, NULL, 'no', '2018-12-14 16:10:07');
INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (91, 'manual', 0, 'Events1', 'page/events1', 'page', 'events1', '', '', '', '', '<p><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/2.jpg\" /></p>\r\n<title></title>\r\n<p>&nbsp;</p>', '0000-00-00', 0, NULL, 'no', '2019-02-05 15:15:51');
INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`, `created_at`) VALUES (92, 'manual', 0, 'World Health Day', 'page/world-health-day', 'page', 'world-health-day', '', '', '', '', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>WHO sponsors this day every year. The World Health Assembly in 1948 made this day official. The first celebration took place in 1950. It aims to create awareness about different health-related themes every year.</p>\r\n</body>\r\n</html>', '0000-00-00', 0, NULL, 'no', '2023-04-04 12:09:58');


#
# TABLE STRUCTURE FOR: front_cms_program_photos
#


CREATE TABLE `front_cms_program_photos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `program_id` int DEFAULT NULL,
  `media_gallery_id` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `program_id` (`program_id`),
  CONSTRAINT `front_cms_program_photos_ibfk_1` FOREIGN KEY (`program_id`) REFERENCES `front_cms_programs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb3;

INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (3, 1, 3, '2018-07-14 17:01:07');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (4, 1, 4, '2018-07-14 17:01:12');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (5, 1, 5, '2018-07-14 17:01:17');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (6, 1, 6, '2018-07-14 17:01:22');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (7, 1, 7, '2018-07-14 17:07:46');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (8, 1, 8, '2018-07-14 17:07:51');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (9, 1, 9, '2018-07-14 17:11:15');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (10, 1, 10, '2018-07-14 17:15:41');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (11, 1, 11, '2018-07-14 17:17:42');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (12, 1, 12, '2018-07-14 17:20:29');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (13, 1, 13, '2018-07-14 17:23:56');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (14, 1, 14, '2018-07-14 17:24:01');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (15, 1, 53, '2019-01-14 16:11:45');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (16, 1, 54, '2019-01-14 16:11:52');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (17, 1, 55, '2019-01-14 16:11:59');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (18, 1, 56, '2019-01-14 16:12:05');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (19, 1, 57, '2019-01-14 16:12:11');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (20, 1, 58, '2019-01-14 16:12:18');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (21, 9, 83, '2019-01-14 17:12:20');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (22, 9, 84, '2019-01-14 17:12:20');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (23, 9, 85, '2019-01-14 17:12:20');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (24, 9, 87, '2019-01-14 17:12:20');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (25, 10, 82, '2019-01-14 17:14:31');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (26, 10, 83, '2019-01-14 17:14:31');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (27, 10, 84, '2019-01-14 17:14:31');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (28, 10, 85, '2019-01-14 17:14:31');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (29, 10, 86, '2019-01-14 17:14:31');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (30, 13, 84, '2019-01-14 17:15:59');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (31, 13, 89, '2019-01-14 17:15:59');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (32, 13, 88, '2019-01-14 17:15:59');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (33, 13, 92, '2019-01-14 17:15:59');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (34, 12, 91, '2019-01-14 17:17:24');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (35, 12, 90, '2019-01-14 17:17:24');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (36, 12, 89, '2019-01-14 17:17:24');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (37, 12, 88, '2019-01-14 17:17:24');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (38, 12, 87, '2019-01-14 17:17:24');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (39, 14, 88, '2019-01-14 17:18:46');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (40, 14, 87, '2019-01-14 17:18:46');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (41, 14, 86, '2019-01-14 17:18:46');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (42, 14, 85, '2019-01-14 17:18:46');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (43, 15, 90, '2019-01-14 17:20:04');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (44, 15, 89, '2019-01-14 17:20:04');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (45, 15, 88, '2019-01-14 17:20:04');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (46, 16, 92, '2019-01-14 17:21:38');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (47, 16, 90, '2019-01-14 17:21:38');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (48, 16, 89, '2019-01-14 17:21:38');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (49, 16, 88, '2019-01-14 17:22:34');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (50, 16, 86, '2019-01-14 17:22:34');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (51, 16, 84, '2019-01-14 17:22:34');
INSERT INTO `front_cms_program_photos` (`id`, `program_id`, `media_gallery_id`, `created_at`) VALUES (52, 16, 82, '2019-01-14 17:22:34');


#
# TABLE STRUCTURE FOR: front_cms_programs
#


CREATE TABLE `front_cms_programs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(50) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `url` mediumtext,
  `title` varchar(200) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `event_start` date DEFAULT NULL,
  `event_end` date DEFAULT NULL,
  `event_venue` mediumtext,
  `description` mediumtext,
  `is_active` varchar(10) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `meta_title` mediumtext NOT NULL,
  `meta_description` mediumtext NOT NULL,
  `meta_keyword` mediumtext NOT NULL,
  `feature_image` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `publish_date` date NOT NULL,
  `publish` varchar(10) DEFAULT '0',
  `sidebar` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb3;

INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (1, 'banner', NULL, NULL, 'Banner Images', NULL, NULL, NULL, NULL, NULL, 'no', '2018-07-13 17:27:19', '', '', '', '', '0000-00-00', '0', 0);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (9, 'gallery', 'surgery', 'read/surgery', 'Surgery', NULL, NULL, NULL, NULL, '<p><span xss=\"removed\">The </span><span xss=\"removed\">spine surgeons</span><span xss=\"removed\"> perform major and complex spine surgery</span></p>', 'no', '2019-02-05 15:18:15', 'Pre Primary', 'Pre Primary', '', 'https://demo.smart-hospital.in/uploads/gallery/media/gallery3.jpg', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (10, 'gallery', 'health-wellness', 'read/health-wellness', 'Health & Wellness', NULL, NULL, NULL, NULL, '<p>The choices you make each day can have a huge effect on your health. Browse health information and tips for maintaining your health Medical Center.</p>', 'no', '2019-02-05 15:18:54', 'School Fee', 'School Fee', '', 'https://demo.smart-hospital.in/uploads/gallery/media/gallery1.jpg', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (12, 'gallery', 'hospitals-and-directions', 'read/hospitals-and-directions', 'Hospitals and Directions', NULL, NULL, NULL, NULL, '<p>One of India’s Largest Hospital Network with Over 30 Medical Specialities</p>', 'no', '2019-02-05 15:19:20', 'Activities', '', '', 'https://demo.smart-hospital.in/uploads/gallery/media/gallery12.jpg', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (13, 'gallery', 'your-health', 'read/your-health', 'Your Health', NULL, NULL, NULL, NULL, '<p>Operation Theatre</p>', 'no', '2019-02-05 15:21:40', 'Facilities', '', '', 'https://demo.smart-hospital.in/uploads/gallery/media/gallery4.jpg', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (14, 'gallery', 'procedures', 'read/procedures', 'Procedures', NULL, NULL, NULL, NULL, '<p>We Perform Some Of The Latest, Cutting-Edge Surgical & Medical Procedures</p>', 'no', '2019-02-05 15:21:24', 'Sports', '', '', 'https://demo.smart-hospital.in/uploads/gallery/media/gallery5.jpg', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (15, 'gallery', 'specialities', 'read/specialities', 'Specialities', NULL, NULL, NULL, NULL, '<p>Health Offers Superspecialist Care In Over 30 Medical Specialities</p>', 'no', '2019-02-05 15:19:36', 'Celebration', '', '', 'https://demo.smart-hospital.in/uploads/gallery/media/gallery10.jpg', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (16, 'gallery', 'recreation-centre', 'read/recreation-centre', 'Recreation Centre', NULL, NULL, NULL, NULL, '<p>Pathology</p>', 'no', '2019-02-05 15:20:46', 'Campus', '', '', 'https://demo.smart-hospital.in/uploads/gallery/media/gallery2.jpg', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (25, 'events', 'world-health-day', 'read/world-health-day', 'World Health Day', NULL, '2023-04-07', '2023-04-10', 'Global Hospital', '<p>WHO sponsors this day every year. The World Health Assembly in 1948 made this day official. The first celebration took place in 1950. It aims to create awareness about different health-related themes every year.<img src=\"https://demo.smart-hospital.in/uploads/gallery/media/world-health.jpg\" /></p>', 'no', '2023-04-04 12:14:24', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (26, 'events', 'world-day-for-safety-and-health-at-work', 'read/world-day-for-safety-and-health-at-work', 'World Day for Safety and Health at Work', NULL, '2023-04-24', '2023-04-28', 'Smart Hospital, Mumbai', '<p>It is an initiative by the International Labour Organization that started in 2003. It highlights precautions to avoid occupational accidents and diseases. This aims to make the workplace safer and hygienic. The theme for 2020 was &ldquo;Stop the pandemic: Safety and health at work can save lives&rdquo;.</p>', 'no', '2023-04-04 12:09:04', '', '', '', '', '0000-00-00', '0', 1);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (29, 'events', 'free-workshop-for-exercise', 'read/free-workshop-for-exercise', 'Free Workshop for Exercise', NULL, '2023-09-04', '2023-09-10', 'Smart Hospital', '<p>Regular physical activity helps prevent and treat noncommunicable diseases (NCDs) such as heart disease, stroke, diabetes and breast and colon cancer.&nbsp;&nbsp;</p>\r\n\r\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<img src=\"https://demo.smart-hospital.in/uploads/gallery/media/istockphoto.jpg\" /></p>', 'no', '2023-09-04 10:06:47', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (30, 'notice', 'free-workshop-for-exercise-event-for-health-management', 'page/', 'Free Workshop For Exercise Event For Health Management', '2023-09-04', NULL, NULL, NULL, '<p>Regular physical activity helps prevent and treat noncommunicable diseases (NCDs) such as heart disease, stroke, diabetes and breast and colon cancer.  </p>\r\n\r\n<p>  <img src=\"https://demo.smart-hospital.in/uploads/gallery/media/istockphoto.jpg\"></p>', 'no', '2023-09-04 10:23:41', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (31, 'events', 'healthy-balanced-diet-and-lifestyle-changes', 'read/healthy-balanced-diet-and-lifestyle-changes', 'Healthy Balanced Diet and Lifestyle Changes', NULL, '2024-02-01', '2024-02-25', 'Smart Hospital', '<p>Hepatitis, a condition characterized by liver inflammation, can have a significant impact on one&rsquo;s health and well-being. While medical interventions are essential, the role of a healthy diet, particularly one rich in protein, should not be underestimated. In this blog, we will explore how a healthy balanced diet can positively affect your liver health and discuss lifestyle changes that can contribute to its cure.</p>\r\n\r\n<p><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/Health.jpg\" /></p>', 'no', '2024-02-01 09:12:40', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (32, 'notice', 'caring-for-bone-health', 'page/', 'Caring For Bone Health', '2024-02-15', NULL, NULL, NULL, '<p>Bones play many roles in the body — providing structure, protecting organs, anchoring muscles and storing calcium. While it&#39;s important to build strong and healthy bones during childhood and adolescence.</p>\r\n\r\n<p> </p>\r\n\r\n<p><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/bone.jpg\"></p>', 'no', '2024-02-01 09:21:20', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (33, 'events', 'dermatology-types-of-skin-diseases-causes-symptoms-and-treatments', 'read/dermatology-types-of-skin-diseases-causes-symptoms-and-treatments', 'Dermatology – Types of skin diseases, causes, symptoms and Treatments', NULL, '2024-02-12', '2024-02-28', 'Apollo Hospital', '<p>Types of skin diseases are the Conditions that may affect or damage your skin are known as Skin disorders. Rashes, inflammation, itching, and other skin changes can be brought on by these illnesses.A medical professional can frequently identify a skin condition just by looking at your skin.</p>\r\n\r\n<p><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/skin_final.jpeg\" /></p>', 'no', '2024-02-01 09:27:58', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (34, 'notice', 'control-diabetes-for-a-healthy-heart', 'read/control-diabetes-for-a-healthy-heart', 'Control diabetes for a healthy heart', '2024-02-22', NULL, NULL, NULL, '<p>Diabetes has reached an epidemic level worldwide. Type 2 diabetes is marked by high levels of blood sugar. Over time, high blood sugar damages small blood vessels throughout the body. This is called microvascular disease. The damage can lead to kidney failure, nerve pain, amputation, and blindness. But the leading cause of complications and death in people with diabetes is cardiovascular disease, which involves the body’s larger blood vessels.</p>', 'no', '2024-02-01 09:31:33', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (35, 'events', 'prevention-of-diabetes-mellitus', 'read/prevention-of-diabetes-mellitus', 'Prevention of Diabetes Mellitus', NULL, '2024-03-01', '2024-03-15', 'Metro Hospital', '<p>A healthy diet, regular physical activity, maintaining a normal body weight and avoiding tobacco use are ways to prevent or delay the onset of type 2 diabetes. Diabetes can be treated and its consequences avoided or delayed with diet, physical activity,</p>\r\n\r\n<p><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/Preventions-of-Diabetes.png\" /></p>', 'no', '2024-03-01 12:13:02', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (36, 'notice', 'what-you-should-know-about-antibiotics', 'read/what-you-should-know-about-antibiotics', 'What You Should Know About Antibiotics?', '2024-03-01', NULL, NULL, NULL, '<p>We all fall ill, and doctors prescribe our medicine along with some antibiotics. Do you ever wonder what an antibiotic is? Well, antibiotics help our body fight off certain harmful bacteria when we alone cannot protect ourselves against these pathogens. We will understand it in detail, but let’s first shed some light on the history of antibiotics.</p>', 'no', '2024-03-01 12:15:17', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (37, 'notice', 'kidney-transplantation-facts-and-myths', 'read/kidney-transplantation-facts-and-myths', 'KIDNEY TRANSPLANTATION: FACTS AND MYTHS', '2024-03-12', NULL, NULL, NULL, '<p>Patients whose kidneys have permanently failed with irreversible damage are termed to have chronic kidney disease (CKD) stage 5 or End Stage Renal Disease (ESRD). Treatment options for kidney failure include lifetime dialysis or kidney transplantation.</p>', 'no', '2024-03-01 12:17:02', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (38, 'events', 'happy-womens-day', 'read/happy-womens-day', 'Happy Women\'s Day', NULL, '2024-03-05', '2024-03-08', 'Medical Hospital', '<p>Happy Women&#39;s Day to an amazing colleague who is such an inspiration to everyone around her. May you lead the way to success for more women. Happy Women&#39;s Day! celebrating 8th March.</p>\r\n\r\n<p><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/Remarkable-Women.png\" /></p>', 'no', '2024-03-01 12:21:28', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (39, 'notice', 'early-warning-signs-of-multiple-sclerosis', 'page/', 'Early warning signs of Multiple Sclerosis', '2024-04-01', NULL, NULL, NULL, '<p>The symptoms of MS vary widely from person to person and can affect any part of the body. Depending on the type of MS you have, the severity of your symptoms may vary over time or occur in spurts. Consult a neurologist for a detailed diagnosis and further medical care.</p>\r\n\r\n<p><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/als-and-.jpg\"></p>\r\n\r\n<p> </p>', 'no', '2024-04-01 12:23:10', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (40, 'events', 'health-awareness-session-on-cancer', 'read/health-awareness-session-on-cancer', 'Health Awareness Session On Cancer', NULL, '2024-04-01', '2024-04-25', 'Hospital Hall', '<p>Smart Hospital conducted a health awareness session on cancer and its treatment on the occasion of National Cancer Awareness Day in association with The Lion&#39;s Club International.</p>\r\n\r\n<p><img src=\"https://demo.smart-hospital.in/uploads/gallery/media/cancer.jpg\" /></p>', 'no', '2024-04-01 12:21:20', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (41, 'notice', '4-reasons-to-drink-beetroot-juice', 'page/', '4 Reasons to drink beetroot juice', '2024-04-05', NULL, NULL, NULL, '<p>Beet is linked to the improvement of a variety of conditions, especially for anemia. While there are no official guidelines on recommended daily intake, a cup of beet juice a day is typically harmless. According to a study, daily intake of 8.4 ounces of juice lowered both systolic and diastolic blood pressure.</p>\r\n\r\n<p>                  <img src=\"https://demo.smart-hospital.in/uploads/gallery/media/benefits- .jpg\"></p>', 'no', '2024-04-01 12:34:34', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (42, 'events', 'general-awareness-program', 'read/general-awareness-program', 'General awareness program', NULL, '2024-05-01', '2024-05-20', 'Hospital Hall Room', '<p>Smart Hospital Research and Center Raises Awareness for a Healthy You on World Health Day.The theme for World Health Day 2024 is &#39;My health, my right.</p>\r\n\r\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<img src=\"https://demo.smart-hospital.in/uploads/gallery/media/World-.jpg\" /></p>', 'no', '2024-05-02 06:38:34', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (43, 'events', 'radiology-celebration-shines-spotlight-on-safety', 'read/radiology-celebration-shines-spotlight-on-safety', 'Radiology Celebration Shines Spotlight on Safety', NULL, '2024-05-05', '2024-05-22', 'Smart hospital', '<p>Marks World Radiology Day with a Focus on Celebrity Patient Safety and Acknowledges the Crucial Role of Technicians and Paramedical Staff.Perform the radiological procedure following an optimized protocol and ensuring patient protection.</p>', 'no', '2024-05-02 06:41:36', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (44, 'notice', 'pathologists-gather-for-academic-exchange', 'read/pathologists-gather-for-academic-exchange', 'Pathologists Gather for Academic Exchange', '2024-05-02', NULL, NULL, NULL, '<p>Pathologists are often involved in the diagnosis of illness. A pathologist may examine a sample of tissue for a virus, bacteria, or other infectious agent. The vast majority of cancer diagnoses are made by, or in conjunction with, a pathologist. </p>\r\n\r\n<p>                                     <img src=\"https://demo.smart-hospital.in/uploads/gallery/media/images.jpg\"></p>', 'no', '2024-05-02 06:46:06', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (45, 'notice', 'dengue-diagnostic-guidelines', 'read/dengue-diagnostic-guidelines', 'Dengue Diagnostic Guidelines', '2024-05-10', NULL, NULL, NULL, '<p>Clinical findings include nausea, vomiting, rash, aches and pains, a positive tourniquet test, leukopenia, and the following warning signs: abdominal pain or tenderness, persistent vomiting, clinical fluid accumulation, mucosal bleeding, lethargy, restlessness, and liver enlargement.               </p>\r\n\r\n<p>                             <img src=\"https://demo.smart-hospital.in/uploads/gallery/media/dengue-fever.jpeg\"></p>', 'no', '2024-05-02 07:00:37', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (46, 'notice', 'health-systems-creating-benchmark-for-health-equity', 'page/', 'Health Systems Creating Benchmark for Health Equity', '2024-06-01', NULL, NULL, NULL, '<p>Anyone who has used roadside navigation knows there are multiple directions you can take toward a destination. But what is the best route? Health leaders face a similar question when it comes to health equity.</p>\r\n\r\n<p>                                         <img src=\"https://demo.smart-hospital.in/uploads/gallery/media/health-equity.jpg\">   </p>', 'no', '2024-06-01 11:55:45', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (47, 'notice', 'heart-pain-and-abdominal-pain-can-be-caused-by-anxiety-disorder', 'page/', 'Heart pain and abdominal pain can be caused by anxiety disorder', '2024-06-05', NULL, NULL, NULL, '<p>Patients experiencing sudden chest pain or severe abdominal pain requiring hospitalisation and treatment are surprised when doctors identify the underlying cause of their illness as anxiety disorder. Anxiety disorders often manifest under symptoms related to cardiovascular or gastrointestinal issues… However, many people only focus on treating the symptoms, failing to recognise that they’re caused by mental health issues.</p>', 'no', '2024-06-01 11:56:13', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (48, 'events', 'sh-retail-pharmacies-provides-lower-prescription-costs-higher-standards', 'read/sh-retail-pharmacies-provides-lower-prescription-costs-higher-standards', 'SH Retail Pharmacies provides lower prescription costs, higher standards', NULL, '2024-07-01', '2024-07-22', 'Smart Hospital Hall Room', '<p>SH Retail Pharmacies has some good news to share: For patients who see a SH provider, average prescription medication costs at our pharmacies are well below the national average. SH Retail Pharmacies are open to everyone, but the figures provided throughout this article are for patients who do see a SH provider.</p>', 'no', '2024-07-01 11:00:50', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (49, 'events', 'multiple-organizations-declare-behavioral-health-state-of-emergency-for-kids', 'read/multiple-organizations-declare-behavioral-health-state-of-emergency-for-kids', 'Multiple organizations declare behavioral health state of emergency for kids', NULL, '2024-07-05', '2024-07-30', 'Smart Hospital & Research Center ', '<p>Inpatient psychiatric units across the state have also experienced increases, with some children and adolescents waiting days or weeks for appropriate treatment from inpatient pediatric medical units and ERs. Three national specialty organizations &ndash;&nbsp; the American Academy of Pediatrics, American Academy of Child and Adolescent Psychiatry, and the Children&rsquo;s Hospital Association &ndash; have declared a national emergency in child and adolescent mental health.</p>', 'no', '2024-07-01 11:06:18', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (50, 'notice', 'keeping-babies-and-children-protected-in-scorching-heat-wave', 'read/keeping-babies-and-children-protected-in-scorching-heat-wave', 'Keeping babies and children protected in scorching heat wave', '2024-07-01', NULL, NULL, NULL, '<p>As extreme heat continues this week across our region, it’s critical to monitor your children — especially babies, says Madison Parker, a nurse practitioner at Beacon Medical Group Pediatrics Main Street. “Babies aren’t as adaptable to the heat change as adults. They get hot more quickly than we do,” she says. “So if you’re starting to overheat, it’s possible your baby has been overheating before you.”</p>', 'no', '2024-07-01 11:11:15', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (51, 'events', 'childrens-eye-health-and-safety-program', 'read/childrens-eye-health-and-safety-program', 'Children’s eye health and safety program', NULL, '2024-08-01', '2024-08-10', 'Smart Hospital Hall', '<p>EYES stands for Empowered Youth Experience Success. Calhoun County&#39;s EYES Program is a progressive, short-term behavioral treatment program for youth with delinquent behavior.</p>\r\n\r\n<p>&nbsp;&nbsp;<img src=\"https://demo.smart-hospital.in/uploads/gallery/media/facebook-.jpg\" /></p>', 'no', '2024-08-01 05:12:02', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (52, 'events', 'national-immunization-awareness-month-niam', 'read/national-immunization-awareness-month-niam', 'National Immunization Awareness Month (NIAM)', NULL, '2024-08-05', '2024-08-20', 'Smart Hospital Hall ', '<p>National Immunization Awareness Month (NIAM) is an annual observance held in August to highlight the importance of vaccination for people of all ages. Together, we can help raise awareness about the importance of vaccination and encourage people to talk to a healthcare provider they trust about staying up to date on their vaccinations.</p>\r\n\r\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<img src=\"https://demo.smart-hospital.in/uploads/gallery/media/national-i.jpg\" /></p>', 'no', '2024-08-01 05:17:21', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (53, 'notice', 'healthy-vision-month-2024-reframe-your-future', 'read/healthy-vision-month-2024-reframe-your-future', 'Healthy Vision Month 2024: Reframe Your Future', '2024-08-05', NULL, NULL, NULL, '<p>Healthy Vision Month 2024 encourages everyone to take proactive steps in eye care and support those with visual impairments. By staying informed and engaged, individuals can protect their vision and improve their overall quality of life. Reframe your future by prioritizing eye health today.</p>', 'no', '2024-08-01 05:20:00', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (54, 'events', 'cath-lab-and-physiology-lab', 'read/cath-lab-and-physiology-lab', 'Cath lab and physiology lab', NULL, '2024-10-01', '2024-10-10', 'Smart Hospital Hall Room', '<p>A cath lab, or cardiac catheterization laboratory, is a specialized hospital area where a range of cardiac procedures and tests are performed.The physiologist monitors the patient\'s condition from the control room, which is separated from the procedure room by lead glass. This allows the physiologist to see the patient and equipment.A cath lab is a specialized hospital room where doctors perform minimally invasive procedures to diagnose and treat heart conditions.</p>\r\n\r\n<p>&nbsp;&nbsp;<img src=\"https://demo.smart-hospital.in/uploads/gallery/media/slider5.jpg\" /></p>', 'no', '2024-10-05 04:25:39', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (55, 'notice', 'the-etpharma-biomolecule-workshop', 'page/', 'The ETPharma Biomolecule Workshop', '2024-10-10', NULL, NULL, NULL, '<p>The ETPharma Biomolecule Workshop & Connect brings together experts to delve into recent progress, challenges, and prospects in synthetic peptides, oligonucleotides, and mRNA. The event explores their immunogenicity, diverse applications, and pivotal role in therapeutic breakthroughs, providing valuable insights into pioneering research and cutting-edge technologies shaping the future of healthcare.</p>', 'no', '2024-10-05 04:33:05', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (56, 'events', 'free-bls-cpr-training-camp', 'read/free-bls-cpr-training-camp', 'FREE BLS & CPR TRAINING CAMP', NULL, '2024-11-01', '2024-11-26', 'Smart Hospital Hall Room', '<p>Free of cost Life saving training of Basic Life Support (BLS) and CPR was given to more than 200 people from the general public, which will help to save lives in case of emergency. Apart from notable presence of faculties from Dept. of Anaesthesia & Critical Care.Expert trainers delivered high-quality content, which not only kept everyone motivated but also equipped them with valuable skills. Feedback was overwhelmingly positive, with attendees praising the organization, seamless execution, and real-world applicability of the training imparted.</p>\r\n\r\n<p>&nbsp;</p>', 'no', '2024-11-07 08:03:26', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (57, 'notice', 'interview-schedule-for-regected-candidates-for-the-post-of-asstt-professor', 'read/interview-schedule-for-regected-candidates-for-the-post-of-asstt-professor', 'Interview Schedule for regected candidates for the post of Asstt. Professor.', '2024-11-07', NULL, NULL, NULL, '<p>Interview Schedule for regected candidates for the post of Asstt. Professor of various disciplines on contract basis for smart hospital.</p>', 'no', '2024-11-07 08:11:59', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (58, 'notice', 'smart-hospital-health-to-use-3d-navigation', 'page/', 'Smart Hospital Health to Use 3D Navigation', '2024-12-06', NULL, NULL, NULL, '<p>Smart Hospital Health First in World to Use 3D Navigation for Minimally Invasive Spine Surgery.“Adding the new 3D navigation system to our robotic platform demonstrates our commitment to providing patients with the highest possible level of care using the most precise and accurate implant technology.”</p>\r\n\r\n<p>                                          <img src=\"https://demo.smart-hospital.in/1733459437-121449129167527dedd1f13!The-ExcelsiusGPS-.png\"></p>\r\n\r\n<p> </p>\r\n\r\n<p> </p>', 'no', '2024-12-06 04:32:24', '', '', '', '', '0000-00-00', '0', NULL);
INSERT INTO `front_cms_programs` (`id`, `type`, `slug`, `url`, `title`, `date`, `event_start`, `event_end`, `event_venue`, `description`, `is_active`, `created_at`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `publish_date`, `publish`, `sidebar`) VALUES (59, 'events', 'health-program-helps-patients-navigate-community-services', 'read/health-program-helps-patients-navigate-community-services', 'Health Program Helps Patients Navigate Community Services', NULL, '2024-12-01', '2024-12-30', 'Smart Hospital', '<p>A program launched by Smart Hospital Health last year has connected some of Baltimore&rsquo;s most vulnerable residents to hospital-based community health advocates (CHAs) who ensure they receive not only routine primary health care, but vital community services.The program piloted at Smart Hospital Health&rsquo;s four Baltimore-area hospitals in December:&nbsp; Smart Hospital Union Memorial Hospital.</p>\r\n\r\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<img src=\"https://demo.smart-hospital.in/1733461324-15239945766752854cf2273!HNN-.png\" /></p>', 'no', '2024-12-06 05:04:05', '', '', '', '', '0000-00-00', '0', NULL);


#
# TABLE STRUCTURE FOR: front_cms_settings
#


CREATE TABLE `front_cms_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `theme` varchar(50) DEFAULT NULL,
  `is_active_rtl` int DEFAULT '0',
  `is_active_front_cms` int DEFAULT '0',
  `is_active_online_appointment` int DEFAULT '0',
  `is_active_sidebar` int DEFAULT '0',
  `logo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `contact_us_email` varchar(100) DEFAULT NULL,
  `complain_form_email` varchar(100) DEFAULT NULL,
  `sidebar_options` mediumtext NOT NULL,
  `fb_url` varchar(200) NOT NULL,
  `twitter_url` varchar(200) NOT NULL,
  `youtube_url` varchar(200) NOT NULL,
  `google_plus` varchar(200) NOT NULL,
  `instagram_url` varchar(200) NOT NULL,
  `pinterest_url` varchar(200) NOT NULL,
  `linkedin_url` varchar(200) NOT NULL,
  `google_analytics` mediumtext,
  `footer_text` varchar(500) DEFAULT NULL,
  `fav_icon` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

INSERT INTO `front_cms_settings` (`id`, `theme`, `is_active_rtl`, `is_active_front_cms`, `is_active_online_appointment`, `is_active_sidebar`, `logo`, `contact_us_email`, `complain_form_email`, `sidebar_options`, `fb_url`, `twitter_url`, `youtube_url`, `google_plus`, `instagram_url`, `pinterest_url`, `linkedin_url`, `google_analytics`, `footer_text`, `fav_icon`, `created_at`) VALUES (1, 'sky_blue', NULL, 1, 1, NULL, './uploads/hospital_content/logo/front_logo-617a7008a31f58.32204916.png', '', '', '[\"news\",\"complain\"]', 'https://www.facebook.com/login', 'https://twitter.com/login?lang=en', 'https://www.youtube.com/account', 'https://plus.google.com/people', 'https://www.instagram.com/accounts/login/', 'https://in.pinterest.com/login/', 'https://www.linkedin.com/uas/login?_l=en', '<script async src=\"https://www.googletagmanager.com/gtag/js?id=GA_TRACKING_ID\"></script>\r\n<script>\r\n  window.dataLayer = window.dataLayer || [];\r\n  function gtag(){dataLayer.push(arguments);}\r\n  gtag(\'js\', new Date());\r\n\r\n  gtag(\'config\', \'GA_TRACKING_ID\');\r\n</script>', '© Smart Hospital & Research Center 2024 All rights reserved', './uploads/hospital_content/logo/front_fav_icon-617a7008a333a5.17885108.png', '2024-10-03 07:01:42');


#
# TABLE STRUCTURE FOR: gateway_ins
#


CREATE TABLE `gateway_ins` (
  `id` int NOT NULL AUTO_INCREMENT,
  `online_appointment_id` int DEFAULT NULL,
  `type` varchar(30) NOT NULL COMMENT 'patient_bill,appointment	',
  `gateway_name` varchar(50) NOT NULL,
  `module_type` varchar(255) NOT NULL,
  `unique_id` varchar(255) NOT NULL,
  `parameter_details` mediumtext NOT NULL,
  `payment_status` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `index_type` (`type`),
  KEY `index_gateway_name` (`gateway_name`),
  KEY `index_module_type` (`module_type`),
  KEY `index_unique_id` (`unique_id`),
  KEY `online_appointment_id` (`online_appointment_id`),
  CONSTRAINT `gateway_ins_ibfk_1` FOREIGN KEY (`online_appointment_id`) REFERENCES `appointment` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

#
# TABLE STRUCTURE FOR: gateway_ins_response
#


CREATE TABLE `gateway_ins_response` (
  `id` int NOT NULL AUTO_INCREMENT,
  `gateway_ins_id` int DEFAULT NULL,
  `posted_data` text,
  `response` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `gateway_ins_id` (`gateway_ins_id`),
  CONSTRAINT `gateway_ins_response_ibfk_1` FOREIGN KEY (`gateway_ins_id`) REFERENCES `gateway_ins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

#
# TABLE STRUCTURE FOR: general_calls
#


CREATE TABLE `general_calls` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `contact` varchar(12) NOT NULL,
  `date` date NOT NULL,
  `description` text,
  `follow_up_date` date DEFAULT NULL,
  `call_duration` varchar(50) NOT NULL,
  `note` mediumtext,
  `call_type` varchar(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `index_name` (`name`),
  KEY `index_contact` (`contact`),
  KEY `index_date` (`date`),
  KEY `index_call_duration` (`call_duration`),
  KEY `index_follow_up_date` (`follow_up_date`)
) ENGINE=InnoDB AUTO_INCREMENT=268 DEFAULT CHARSET=utf8mb3;

INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (200, 'Arthur', '16516521', '2024-02-01', '', '2024-02-04', '40', '', 'Incoming', '2024-02-01 06:12:12');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (201, 'Jack', '464651651522', '2024-02-05', '', '2024-02-09', '40', '', 'Outgoing', '2024-02-01 06:15:32');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (202, 'Edward', '541561512', '2024-02-10', '', '2024-02-14', '45', '', 'Incoming', '2024-02-01 06:16:11');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (203, 'Jackson', '5416546522', '2024-02-15', '', '2024-02-19', '40', '', 'Outgoing', '2024-02-01 06:17:43');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (204, 'Harry', '5165131552', '2024-02-20', '', '2024-02-24', '40', '', 'Incoming', '2024-02-01 06:18:18');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (205, 'Mason', '1265655151', '2024-02-25', '', '2024-02-29', '45', '', 'Outgoing', '2024-02-01 06:18:53');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (206, 'Royal', '165641511', '2024-03-01', '', '2024-03-04', '45', '', 'Incoming', '2024-03-01 06:19:50');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (207, 'Ember', '1646321132', '2024-03-05', '', '2024-03-09', '45', '', 'Outgoing', '2024-03-01 06:20:26');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (208, 'Edison', '6546461', '2024-03-10', '', '2024-03-14', '40', '', 'Incoming', '2024-03-01 06:21:16');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (209, 'Ruby', '465464601', '2024-03-15', '', '2024-03-19', '45', '', 'Outgoing', '2024-03-01 06:22:15');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (210, 'Byran', '26516125165', '2024-03-20', '', '2024-03-25', '40', '', 'Incoming', '2024-03-01 06:23:35');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (211, 'Alwin', '15165200511', '2024-03-26', '', '2024-03-31', '45', '', 'Outgoing', '2024-03-01 06:24:11');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (212, 'Corbin', '5158440152', '2024-04-01', '', '2024-04-04', '40', '', 'Incoming', '2024-04-01 07:30:34');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (213, 'Sterling', '150165880', '2024-04-05', '', '2024-04-09', '45', '', 'Outgoing', '2024-04-01 07:36:59');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (214, 'Jenny', '21560151652', '2024-04-10', '', '2024-04-14', '40', '', 'Incoming', '2024-04-01 07:42:23');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (215, 'Tanner', '3251051515', '2024-04-15', '', '2024-04-19', '40', '', 'Outgoing', '2024-04-01 07:54:28');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (216, 'Alexis', '5211051512', '2024-04-20', '', '2024-04-24', '45', '', 'Incoming', '2024-04-01 07:55:52');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (217, 'Marlo', '6840851152', '2024-04-25', '', '2024-04-30', '40', '', 'Outgoing', '2024-04-01 07:56:38');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (218, 'Darwin', '5168412', '2024-05-01', '', '2024-05-04', '40', '', 'Incoming', '2024-05-01 09:49:52');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (219, 'Keaton', '184801845', '2024-05-05', '', '2024-05-09', '45', '', 'Outgoing', '2024-05-01 09:50:38');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (220, 'Albert', '56484215', '2024-05-10', '', '2024-05-14', '40', '', 'Incoming', '2024-05-01 09:51:35');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (221, 'Howard', '168016518', '2024-05-15', '', '2024-05-19', '40', '', 'Outgoing', '2024-05-01 09:53:52');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (222, 'Philip', '564084851', '2024-05-20', '', '2024-05-24', '45', '', 'Incoming', '2024-05-01 09:54:46');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (224, 'Gary', '5211015151', '2024-05-25', '', '2024-05-29', '45', '', 'Outgoing', '2024-05-01 09:58:23');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (225, 'Jameson', '5188420151', '2024-05-30', '', '2024-05-31', '40', '', 'Incoming', '2024-05-01 09:59:12');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (226, 'Arvind D\'silva', '9878685', '2024-06-01', '', '2024-06-06', '30', '', 'Incoming', '2024-06-01 09:17:48');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (227, 'William Martin', '980567567', '2024-06-05', '', '2024-06-08', '35', '', 'Outgoing', '2024-06-01 09:18:06');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (228, 'Jackson', '890657567', '2024-06-10', '', '2024-06-12', '35', '', 'Incoming', '2024-06-01 09:18:26');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (229, 'Mayank ', '908678786', '2024-06-20', '', '2024-06-18', '25', '', 'Outgoing', '2024-06-01 09:18:46');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (230, 'Marlo', '08907668678', '2024-06-25', '', '2024-06-28', '35', '', 'Incoming', '2024-06-01 09:19:09');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (231, 'Edison', '788078675', '2024-06-30', '', '2024-07-01', '50', '', 'Incoming', '2024-06-01 09:19:25');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (232, 'Aston Marsh	', '90768574', '2024-07-01', '', '2024-07-04', '30', '', 'Incoming', '2024-07-01 06:48:25');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (233, 'Lawrence	', '8907565634', '2024-07-05', '', '2024-07-08', '45', '', 'Outgoing', '2024-07-01 06:48:43');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (234, 'Tim David	', '089065757', '2024-07-10', '', '2024-07-12', '35', '', 'Incoming', '2024-07-01 06:48:59');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (236, 'Allen', '988905673', '2024-07-20', '', '2024-07-22', '45', '', 'Incoming', '2024-07-01 06:49:41');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (237, 'Robert', '890567675', '2024-07-25', '', '2024-07-28', '25', '', 'Outgoing', '2024-07-01 06:49:59');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (238, 'Darwin', '80890567', '2024-07-30', '', '2024-07-31', '40', '', 'Incoming', '2024-07-01 06:50:38');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (239, 'Arvind D\'silva	', '890678567', '2024-08-01', '', '2024-08-04', '30', '', 'Incoming', '2024-08-01 11:00:23');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (240, 'Mayank', '788906784', '2024-08-05', '', '2024-08-09', '45', '', 'Outgoing', '2024-08-01 11:00:40');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (241, 'Philip', '890768565', '2024-08-10', '', '2024-08-12', '35', '', 'Incoming', '2024-08-01 11:00:57');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (242, 'Albert', '890789564', '2024-08-15', '', '2024-08-19', '35', '', 'Incoming', '2024-08-01 11:01:14');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (243, 'Darwin	', '909807895', '2024-08-20', '', '2024-08-22', '35', '', 'Outgoing', '2024-08-01 11:01:36');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (244, 'Jackson', '896567977', '2024-08-25', '', '2024-08-28', '35', '', 'Incoming', '2024-08-01 11:01:54');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (245, 'Sterling', '980786765', '2024-08-30', '', '2024-09-01', '45', '', 'Outgoing', '2024-08-01 11:02:16');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (246, 'Harish', '980789678', '2024-08-29', '', '2024-08-31', '35', '', 'Incoming', '2024-08-29 12:37:13');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (247, 'Sonny', '78908767564', '2024-10-01', '', '2024-10-04', '45', '', 'Incoming', '2024-10-04 05:26:42');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (248, 'Hudson', '8905674644', '2024-10-05', '', '2024-10-08', '35', '', 'Outgoing', '2024-10-04 05:26:57');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (249, 'Jackson', '788905674', '2024-10-10', '', '2024-10-12', '35', '', 'Incoming', '2024-10-04 05:27:13');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (250, 'Sterling', '980905744', '2024-10-15', '', '2024-10-18', '45', '', 'Outgoing', '2024-10-04 05:27:29');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (251, 'April Clinton', '8907567466', '2024-10-20', '', '2024-10-22', '35', '', 'Incoming', '2024-10-04 05:37:36');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (252, 'Evander John', '9789789673', '2024-10-25', '', '2024-10-28', '45', '', 'Incoming', '2024-10-04 05:38:22');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (253, 'Cristian Messina', '9806574635', '2024-10-30', '', '2024-10-31', '35', '', 'Outgoing', '2024-10-04 05:38:42');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (254, 'Jackson	', '890979654', '2024-11-01', '', '2024-11-06', '45', '', 'Incoming', '2024-11-06 07:56:00');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (255, 'William', '890678544', '2024-11-05', '', '2024-11-08', '35', '', 'Outgoing', '2024-11-06 07:56:19');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (256, 'Amelia	', '890890675', '2024-11-10', '', '2024-11-12', '45', '', 'Incoming', '2024-11-06 07:56:34');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (257, 'Jaxon', '789806544', '2024-11-15', '', '2024-11-18', '35', '', 'Outgoing', '2024-11-06 07:56:54');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (258, 'Sophia Henry	', '89078896', '2024-11-20', '', '2024-11-22', '45', '', 'Incoming', '2024-11-06 08:00:02');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (259, 'Pranjal Sinha	', '908956745', '2024-11-25', '', '2024-11-28', '45', '', 'Outgoing', '2024-11-06 08:06:32');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (260, 'Hazel', '799067845', '2024-11-30', '', '2024-12-01', '35', '', 'Incoming', '2024-11-06 08:06:50');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (261, 'Hudson', '898079455', '2024-12-01', '', '2024-12-06', '45', '', 'Incoming', '2024-12-05 05:37:23');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (262, 'Jackson', '8890890674', '2024-12-05', '', '2024-12-08', '35', '', 'Incoming', '2024-12-05 05:37:36');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (263, 'Sterling', '790908664', '2024-12-10', '', '2024-12-12', '35', '', 'Outgoing', '2024-12-05 05:37:50');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (264, 'Nylah', '700896756', '2024-12-15', '', '2024-12-18', '35', '', 'Incoming', '2024-12-05 05:38:07');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (265, 'Brinly', '89896865', '2024-12-25', '', '2024-12-27', '45', '', 'Outgoing', '2024-12-05 05:38:30');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (266, 'Colton', '7898905674', '2024-12-20', '', '2024-12-22', '45', '', 'Incoming', '2024-12-05 05:46:19');
INSERT INTO `general_calls` (`id`, `name`, `contact`, `date`, `description`, `follow_up_date`, `call_duration`, `note`, `call_type`, `created_at`) VALUES (267, 'Alexander', '789089574', '2024-12-30', '', '2024-12-31', '45', '', 'Incoming', '2024-12-05 05:48:19');


#
# TABLE STRUCTURE FOR: global_shift
#


CREATE TABLE `global_shift` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `index_name` (`name`),
  KEY `index_start_time` (`start_time`),
  KEY `index_end_time` (`end_time`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

INSERT INTO `global_shift` (`id`, `name`, `start_time`, `end_time`, `date_created`) VALUES (1, 'Morning', '10:00:00', '12:30:00', '2024-08-28 07:24:40');
INSERT INTO `global_shift` (`id`, `name`, `start_time`, `end_time`, `date_created`) VALUES (3, 'Evening', '16:00:00', '19:00:00', '2021-10-25 11:22:57');


#
# TABLE STRUCTURE FOR: income
#


CREATE TABLE `income` (
  `id` int NOT NULL AUTO_INCREMENT,
  `inc_head_id` int DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `invoice_no` varchar(200) NOT NULL,
  `date` date DEFAULT NULL,
  `amount` float(10,2) DEFAULT '0.00',
  `note` text,
  `is_deleted` varchar(10) DEFAULT 'no',
  `documents` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `generated_by` int DEFAULT NULL,
  `is_active` varchar(10) DEFAULT 'yes',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `inc_head_id` (`inc_head_id`),
  KEY `generated_by` (`generated_by`),
  KEY `index_name` (`name`),
  KEY `index_invoice_no` (`invoice_no`),
  KEY `index_date` (`date`),
  KEY `index_amount` (`amount`),
  CONSTRAINT `income_ibfk_1` FOREIGN KEY (`inc_head_id`) REFERENCES `income_head` (`id`) ON DELETE CASCADE,
  CONSTRAINT `income_ibfk_2` FOREIGN KEY (`generated_by`) REFERENCES `staff` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=231 DEFAULT CHARSET=utf8mb3;

INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (134, 1, 'Patient Admission Charge', '3620', '2023-07-04', '200.00', '	This can be different than actual cost or amount paid for the care. The amount collected by a hospital for each service is almost always less than the amount charged.', 'no', NULL, 1, 'yes', '2023-07-05 09:43:50');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (136, 3, 'Staff Food Service', '5633', '2023-07-06', '200.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2023-07-06 07:14:20');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (137, 1, 'Hospital Building Rent', '3452', '2023-08-01', '250.00', 'Charge is the dollar amount a health care provider sets for services rendered before negotiating any discounts. The charge can be different from the amount paid.', 'no', NULL, 1, 'yes', '2023-08-02 05:11:02');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (144, 1, 'Medical Health Charges', '5234', '2023-09-02', '300.00', 'Charge is the dollar amount a health care provider sets for services rendered before negotiating any discounts. The charge can be different from the amount paid.', 'no', NULL, 1, 'yes', '2023-09-02 09:50:54');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (145, 2, 'Free Blood Pressure Camp', '2332', '2023-09-02', '150.00', 'Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 1, 'yes', '2023-09-02 09:57:49');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (146, 3, 'Patient Food Service', '675', '2023-09-01', '200.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2023-09-02 09:58:49');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (147, 1, 'Patient Discharge Bill', '3422', '2023-09-03', '250.00', 'This can be different than actual cost or amount paid for the care. The amount collected by a hospital for each service is almost always less than the amount charged.', 'no', NULL, 1, 'yes', '2023-09-04 04:42:26');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (148, 4, 'Motor Vehicle stand charge', '3422', '2023-09-04', '200.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage.', 'no', NULL, 1, 'yes', '2023-09-04 04:43:41');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (149, 2, 'Eye Checkup Camp', '34322', '2023-09-04', '150.00', 'Eye  Checkup Camp', 'no', NULL, 1, 'yes', '2023-09-04 04:45:16');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (150, 4, 'Motor vehicle Stand', '654', '2023-10-01', '200.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage.', 'no', NULL, 1, 'yes', '2023-10-04 09:11:35');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (151, 3, 'Patient Morning Breakfast', '56', '2023-10-02', '250.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2023-10-04 09:11:57');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (152, 1, 'Healthcare Charges', '9080', '2023-10-03', '200.00', 'Charge is the dollar amount a health care provider sets for services rendered before negotiating any discounts. The charge can be different from the amount paid. Cost varies by the party incurring the expense. To the patient, cost is the amount payable out-of-pocket for healthcare services.', 'no', NULL, 1, 'yes', '2023-10-04 09:12:34');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (153, 2, 'Free Medical Camp', '989806', '2023-10-04', '200.00', '	Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 1, 'yes', '2023-10-04 09:13:29');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (154, 4, 'Motor vehicle Stand', '34', '2023-10-05', '200.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage.', 'no', NULL, 1, 'yes', '2023-10-05 05:11:09');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (155, 1, 'Health care charges', '4352', '2023-11-01', '250.00', 'Charge is the dollar amount a health care provider sets for services rendered before negotiating any discounts. The charge can be different from the amount paid. Cost varies by the party incurring the expense. To the patient, cost is the amount payable out-of-pocket for healthcare services.', 'no', NULL, 1, 'yes', '2023-11-02 12:34:29');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (156, 4, 'Motor Vehicle stand charge', '3452', '2023-11-02', '200.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileag', 'no', NULL, 1, 'yes', '2023-11-02 12:35:08');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (157, 3, 'Patient Food Service', '6572', '2023-11-02', '250.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2023-11-02 12:42:41');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (158, 2, 'Free Dental Camp', '3422', '2023-11-03', '300.00', 'Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 1, 'yes', '2023-11-03 07:33:26');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (159, 2, 'Patient Health Care Camp', '56546', '2023-11-04', '350.00', 'Patient Health Care Camp', 'no', NULL, 1, 'yes', '2023-11-04 04:36:24');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (160, 1, 'Hospital Building Charges', '453', '2023-11-04', '450.00', 'Charge is the dollar amount a health care provider sets for services rendered before negotiating any discounts. The charge can be different from the amount paid. Cost varies by the party incurring the expense. To the patient, cost is the amount payable out-of-pocket for healthcare services.', 'no', NULL, 1, 'yes', '2023-11-04 04:37:18');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (161, 1, 'Hospital Building Charges', '3021', '2023-12-01', '250.00', 'Hospital Building Charges', 'no', NULL, 1, 'yes', '2023-12-02 12:05:05');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (162, 4, 'Motor Vehicle Stands', '2562', '2023-12-02', '200.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage', 'no', NULL, 1, 'yes', '2023-12-02 12:05:38');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (163, 2, 'Special Camping', '231', '2023-12-02', '250.00', 'Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 1, 'yes', '2023-12-02 12:06:04');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (164, 3, 'Patient Morning Breakfast', '4522', '2023-12-01', '200.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2023-12-02 12:06:39');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (165, 2, 'Eye Check-up Camp', '231', '2023-12-03', '250.00', 'This camp was to spread awareness on eye disorders, early detection of ailments, and to detect refractive errors and provide corrective glasses free of cost to the underprivileged communities.', 'no', NULL, 1, 'yes', '2023-12-04 04:28:23');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (166, 1, 'Building Charges', '452', '2023-12-04', '250.00', 'Charge is the dollar amount a health care provider sets for services rendered before negotiating any discounts. The charge can be different from the amount paid. Cost varies by the party incurring the expense. To the patient, cost is the amount payable out-of-pocket for healthcare services.', 'no', NULL, 1, 'yes', '2023-12-04 04:28:52');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (167, 3, 'Patient Food Service', '3221', '2024-01-01', '250.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2024-01-03 05:12:58');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (168, 4, 'Monthly Vehicle stand', '563', '2024-01-02', '200.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage, including time-dependent depreciation, insurance and registration fees, financing, and residential parking.', 'no', NULL, 1, 'yes', '2024-01-03 05:18:10');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (169, 1, 'Hospital Charges', '563', '2024-01-03', '350.00', '	This can be different than actual cost or amount paid for the care. The amount collected by a hospital for each service is almost always less than the amount charged.', 'no', NULL, 1, 'yes', '2024-01-03 05:19:13');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (170, 2, 'Medical Camp', '453', '2024-01-02', '250.00', 'Special Camping forms an integral part of National Service Scheme. It has special appeal to the youth as it provides unique opportunities to the students for group living.', 'no', NULL, 1, 'yes', '2024-01-03 05:21:28');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (171, 2, 'Blood Camp', '4535', '2024-01-04', '200.00', 'Special Camping forms an integral part of National Service Scheme. It has special appeal to the youth as it provides unique opportunities to the students for group living.', 'no', NULL, 1, 'yes', '2024-01-04 05:58:49');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (172, 3, 'Morning Breakfast for Patient', '5654', '2024-02-01', '250.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2024-02-01 05:21:03');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (173, 2, 'Patient Regular Health  Check -up', '564', '2024-02-01', '300.00', 'Special Camping forms an integral part of National Service Scheme. It has special appeal to the youth as it provides unique opportunities to the students for group living.', 'no', NULL, 1, 'yes', '2024-02-01 05:21:35');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (174, 1, 'Hospital Building Charge', '986', '2024-02-01', '250.00', 'Charge is the dollar amount a health care provider sets for services rendered before negotiating any discounts. The charge can be different from the amount paid. Cost varies by the party incurring the expense. To the patient, cost is the amount payable out-of-pocket for healthcare services.', 'no', NULL, 1, 'yes', '2024-02-01 05:22:23');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (175, 4, 'Motor Vehicle Stands', '342', '2024-02-02', '250.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage.', 'no', NULL, 1, 'yes', '2024-02-02 04:22:24');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (176, 2, 'Free Dental Camp', '3422', '2024-02-02', '300.00', 'Special Camping forms an integral part of National Service Scheme. It has special appeal to the youth as it provides unique opportunities to the students for group living.', 'no', NULL, 1, 'yes', '2024-02-02 04:24:53');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (177, 2, 'Medical Camp', '3526', '2024-03-01', '300.00', 'A Free medical Camp can be considered as a life-saving program that aims to provide free medical and surgical services to poor communities living in rural or urban areas by a mobile team with varieties of medical specialized services.', 'no', NULL, 1, 'yes', '2024-03-01 05:49:57');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (178, 3, 'Canteen bill', '3124', '2024-03-01', '250.00', 'The primary aspect of canteen is to provide quality and hygienically safe food to all who come in ... You will be given a table number along with your bill.', 'no', NULL, 1, 'yes', '2024-03-01 05:50:29');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (179, 4, 'Motor vehicle stand charge', '423', '2024-03-02', '200.00', 'Motor vehicle stand charge', 'no', NULL, 1, 'yes', '2024-03-02 04:53:49');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (180, 2, 'Free Dental Checkup camp', '4532', '2024-03-02', '250.00', 'Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 1, 'yes', '2024-03-02 04:54:22');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (181, 1, 'Hospital maintenance charge', '4565', '2024-03-02', '350.00', 'The total cost for the month is divided by the overall area of the property which gives the per sq ft rate for maintenance for the month.', 'no', NULL, 1, 'yes', '2024-03-02 05:05:21');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (182, 2, 'Free Blood Sugar camp', '3422', '2024-03-03', '250.00', '	Special Camping forms an integral part of National Service Scheme. It has special appeal to the youth as it provides unique opportunities to the students for group living.', 'no', NULL, 1, 'yes', '2024-03-04 04:21:31');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (183, 3, 'Patient Breakfast', '3433', '2024-03-04', '200.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2024-03-04 04:22:01');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (184, 1, 'Hospital Building Rent', '54180', '2024-04-01', '200.00', 'Charge is the dollar amount a health care provider sets for services rendered before negotiating any discounts. The charge can be different from the amount paid.	', 'no', NULL, 1, 'yes', '2024-04-01 10:01:39');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (185, 2, 'Free Medical Camp', '3263', '2024-04-01', '220.00', 'Special Camping forms an integral part of National Service Scheme.	', 'no', NULL, 1, 'yes', '2024-04-01 10:02:39');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (186, 3, 'Patient Morning Breakfast', '2152', '2024-04-01', '250.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.	', 'no', NULL, 1, 'yes', '2024-04-01 10:03:49');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (187, 4, 'Motor vehicle stand charge', '65865', '2024-04-01', '200.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileag	', 'no', NULL, 1, 'yes', '2024-04-01 10:14:40');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (188, 2, 'Free Medical checkup camp', '456234', '2024-04-02', '200.00', 'Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 1, 'yes', '2024-04-02 05:42:53');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (189, 1, 'Hospital maintenance charge', '5634', '2024-04-02', '250.00', 'The total cost for the month is divided by the overall area of the property which gives the per sq ft rate for maintenance for the month.', 'no', NULL, 1, 'yes', '2024-04-02 05:44:06');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (190, 3, 'Patient morning breakfast', '65733', '2024-04-02', '150.00', 'Patient morning breakfast', 'no', NULL, 1, 'yes', '2024-04-02 05:45:12');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (191, 4, 'Motor Stand Charges', '323', '2024-05-01', '250.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage.', 'no', NULL, 1, 'yes', '2024-05-01 09:21:59');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (192, 3, 'Patient Food service', '3422', '2024-05-01', '200.00', '	The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2024-05-01 09:29:16');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (193, 1, 'Building Maintenance charge', '23111', '2024-05-01', '300.00', 'The total cost for the month is divided by the overall area of the property which gives the per sq ft rate for maintenance for the month.', 'no', NULL, 1, 'yes', '2024-05-01 09:30:54');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (194, 2, 'Free Medical checkup camp', '5523', '2024-05-02', '250.00', '	Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 1, 'yes', '2024-05-02 04:14:29');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (195, 3, 'Patient morning breakfast', '455', '2024-05-02', '200.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2024-05-02 04:16:07');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (196, 2, 'Blood Donate camp', '4322', '2024-06-01', '250.00', 'Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 1, 'yes', '2024-06-01 04:59:48');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (197, 4, 'Motor vehicle stand charge', '56757', '2024-06-01', '200.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage', 'no', NULL, 1, 'yes', '2024-06-01 05:07:33');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (198, 2, 'Free Dental Checkup camp', '789789', '2024-06-02', '250.00', 'Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 1, 'yes', '2024-06-03 04:13:19');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (199, 4, 'Motor vehicle stand charge', '54622', '2024-06-02', '350.00', 'Motor vehicle stand charge', 'no', NULL, 1, 'yes', '2024-06-03 04:14:25');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (200, 3, 'Patient Lunch service', '435', '2024-06-03', '250.00', '	The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2024-06-03 04:14:54');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (201, 1, 'Building Maintenance charge', '789789', '2024-06-03', '200.00', 'The total cost for the month is divided by the overall area of the property which gives the per sq ft rate for maintenance for the month.', 'no', NULL, 1, 'yes', '2024-06-03 04:16:37');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (202, 2, 'Free Medical health  Camp', '231', '2024-07-01', '250.00', 'Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 1, 'yes', '2024-07-01 07:57:15');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (203, 4, 'Motor vehicle stand charge', '3432', '2024-07-01', '200.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage.', 'no', NULL, 1, 'yes', '2024-07-01 07:57:57');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (204, 1, 'Hospital Building Rent', '342', '2024-07-01', '250.00', 'The total cost for the month is divided by the overall area of the property which gives the per sq ft rate for maintenance for the month.', 'no', NULL, 1, 'yes', '2024-07-01 07:58:37');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (205, 1, 'Building Maintenance charge', '323', '2024-07-02', '250.00', 'The total cost for the month is divided by the overall area of the property which gives the per sq ft rate for maintenance for the month.', 'no', NULL, 1, 'yes', '2024-07-02 05:23:08');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (206, 2, 'Free Medical Camp', '76456', '2024-07-02', '250.00', '	Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 1, 'yes', '2024-07-02 05:23:40');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (207, 4, 'Motor vehicle stand charge', '890567', '2024-07-02', '200.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage.', 'no', NULL, 1, 'yes', '2024-07-02 05:24:33');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (208, 3, 'Patient Food Service', '422', '2024-08-01', '250.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available', 'no', NULL, 1, 'yes', '2024-08-01 05:32:03');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (209, 2, 'Children’s eye health and safety program', '89786', '2024-08-01', '300.00', 'Special Camping forms an integral part of National Service Scheme', 'no', NULL, 1, 'yes', '2024-08-01 05:32:36');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (210, 1, 'Hospital maintenance for the month', '8890', '2024-08-01', '200.00', 'The total cost for the month is divided by the overall area of the property which gives the per sq ft rate for maintenance for the month.', 'no', NULL, 1, 'yes', '2024-11-06 05:58:04');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (211, 4, 'Vehicle Charge', '78567', '2024-08-02', '250.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage.', 'no', NULL, 1, 'yes', '2024-08-02 08:05:13');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (212, 1, 'Patient Discharge', '3422', '2024-08-02', '300.00', 'This can be different than actual cost or amount paid for the care. The amount collected by a hospital for each service is almost always less than the amount charged.', 'no', NULL, 1, 'yes', '2024-08-02 08:06:06');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (213, 1, 'Building Charge', '4353', '2024-08-03', '250.00', 'The total cost for the month is divided by the overall area of the property which gives the per sq ft rate for maintenance for the month.', 'no', NULL, 1, 'yes', '2024-08-03 04:14:54');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (214, 2, 'Health Medical Checkup', '2322', '2024-08-31', '300.00', 'Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 14, 'yes', '2024-08-31 05:57:42');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (215, 3, 'Patient Food Service', '3412', '2024-10-01', '250.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2024-10-03 06:34:47');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (216, 4, 'Motor Vehicle Stand', '232', '2024-10-02', '200.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage.', 'no', NULL, 1, 'yes', '2024-10-03 06:35:32');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (217, 1, 'Hospital Building Charge', '4532', '2024-10-03', '200.00', 'Charge is the dollar amount a health care provider sets for services rendered before negotiating any discounts. The charge can be different from the amount paid.', 'no', NULL, 1, 'yes', '2024-10-03 06:36:27');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (218, 2, 'Children’s eye health and safety program', '54345', '2024-10-03', '250.00', 'Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 1, 'yes', '2024-10-03 06:37:13');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (219, 1, 'Building maintenance Charge', '34234', '2024-10-04', '250.00', 'The total cost for the month is divided by the overall area of the property which gives the per sq ft rate for maintenance for the month.', 'no', NULL, 1, 'yes', '2024-10-04 11:45:40');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (220, 3, 'Patient Morning Breakfast', '54622', '2024-10-05', '200.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2024-10-05 05:51:22');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (221, 2, 'Health Medical Checkup', '7564', '2024-11-01', '200.00', '	Special Camping forms an integral part of National Service Scheme.', 'no', NULL, 1, 'yes', '2024-11-06 05:57:42');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (222, 1, 'Hospital maintenance for the month', '9076', '2024-11-02', '250.00', '	The total cost for the month is divided by the overall area of the property which gives the per sq ft rate for maintenance for the month.', 'no', NULL, 1, 'yes', '2024-11-06 05:58:20');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (223, 3, 'Patient Food Service', '7875', '2024-11-03', '200.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available', 'no', NULL, 1, 'yes', '2024-11-06 05:59:02');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (224, 4, 'Vehicle ownership costs', '3622', '2024-11-05', '150.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage.', 'no', NULL, 1, 'yes', '2024-11-06 06:02:39');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (225, 2, 'Children’s eye health and safety program', '4543', '2024-11-06', '200.00', 'Special Camping forms an integral part of National Service Scheme', 'no', NULL, 1, 'yes', '2024-11-06 06:04:28');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (226, 4, 'Motor Vehicle  Stand Charges', '6345', '2024-12-01', '200.00', 'Vehicle ownership costs refers to fixed costs that are not directly affected by vehicle mileage.', 'no', NULL, 1, 'yes', '2024-12-04 11:12:47');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (227, 1, 'Hospital Building Rent Charge', '46757', '2024-12-02', '250.00', 'The total cost for the month is divided by the overall area of the property which gives the per sq ft rate for maintenance for the month', 'no', NULL, 1, 'yes', '2024-12-04 11:13:20');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (228, 2, 'Free Medical Camp', '6575', '2024-12-03', '300.00', 'Special Camping forms an integral part of National Service Scheme', 'no', NULL, 1, 'yes', '2024-12-04 11:14:07');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (229, 3, 'Patient Food Service', '433', '2024-12-04', '200.00', 'The right to food, and its variations, is a human right protecting the right of people to feed themselves in dignity, implying that sufficient food is available.', 'no', NULL, 1, 'yes', '2024-12-04 11:14:37');
INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_deleted`, `documents`, `generated_by`, `is_active`, `created_at`) VALUES (230, 4, 'Motor vehicle charge', '232', '2024-12-06', '200.00', '', 'no', NULL, 1, 'yes', '2024-12-06 09:13:14');


#
# TABLE STRUCTURE FOR: income_head
#


CREATE TABLE `income_head` (
  `id` int NOT NULL AUTO_INCREMENT,
  `income_category` varchar(255) DEFAULT NULL,
  `description` text,
  `is_active` varchar(10) NOT NULL DEFAULT 'yes',
  `is_deleted` varchar(10) NOT NULL DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `index_income_category` (`income_category`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

INSERT INTO `income_head` (`id`, `income_category`, `description`, `is_active`, `is_deleted`, `created_at`) VALUES (1, 'Hospital charges', 'Hospital charges', 'yes', 'no', '2021-10-25 13:49:55');
INSERT INTO `income_head` (`id`, `income_category`, `description`, `is_active`, `is_deleted`, `created_at`) VALUES (2, 'Special campaign', '\r\nThe campaign goal, aim or purpose states what needs to change, and to what extent, in order to solve the problem addressed by the campaign. Ideally, the goal should fit into a single, short sentence and be designed in a way that can be fully understood by all participants in the campaign', 'yes', 'no', '2021-10-29 05:37:32');
INSERT INTO `income_head` (`id`, `income_category`, `description`, `is_active`, `is_deleted`, `created_at`) VALUES (3, 'Canteen Rent', '', 'yes', 'no', '2021-10-25 13:50:17');
INSERT INTO `income_head` (`id`, `income_category`, `description`, `is_active`, `is_deleted`, `created_at`) VALUES (4, 'Vehicle Stand Charges', 'Revenue of this proportion can assist a hospital in adding much needed technology upgrades, new specialty equipment, or increase pay levels for valuable staff members. Its not all a question of revenue though. If done right, paid parking is a win-win for the hospital, staff, and most importantly, patients.', 'yes', 'no', '2021-10-29 05:38:40');


#
# TABLE STRUCTURE FOR: ipd_details
#


CREATE TABLE `ipd_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `patient_id` int DEFAULT NULL,
  `case_reference_id` int DEFAULT NULL,
  `height` varchar(5) DEFAULT NULL,
  `weight` varchar(5) DEFAULT NULL,
  `pulse` varchar(200) NOT NULL,
  `temperature` varchar(200) NOT NULL,
  `respiration` varchar(200) NOT NULL,
  `bp` varchar(20) DEFAULT NULL,
  `bed` int DEFAULT NULL,
  `bed_group_id` int DEFAULT NULL,
  `case_type` varchar(100) NOT NULL,
  `casualty` varchar(100) NOT NULL,
  `symptoms` longtext NOT NULL,
  `known_allergies` varchar(200) DEFAULT NULL,
  `patient_old` varchar(50) NOT NULL,
  `note` text,
  `refference` varchar(200) NOT NULL,
  `cons_doctor` int DEFAULT NULL,
  `organisation_id` int DEFAULT NULL,
  `credit_limit` varchar(100) NOT NULL,
  `payment_mode` varchar(100) NOT NULL,
  `date` datetime DEFAULT NULL,
  `discharged` varchar(200) NOT NULL,
  `live_consult` varchar(50) DEFAULT NULL,
  `generated_by` int DEFAULT NULL,
  `is_antenatal` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `patient_id` (`patient_id`),
  KEY `case_reference_id` (`case_reference_id`),
  KEY `cons_doctor` (`cons_doctor`),
  KEY `bed_group_id` (`bed_group_id`),
  KEY `bed` (`bed`),
  CONSTRAINT `ipd_details_ibfk_1` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ipd_details_ibfk_2` FOREIGN KEY (`case_reference_id`) REFERENCES `case_references` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ipd_details_ibfk_3` FOREIGN KEY (`case_reference_id`) REFERENCES `case_references` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ipd_details_ibfk_4` FOREIGN KEY (`cons_doctor`) REFERENCES `staff` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ipd_details_ibfk_5` FOREIGN KEY (`bed_group_id`) REFERENCES `bed_group` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ipd_details_ibfk_6` FOREIGN KEY (`bed`) REFERENCES `bed` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb3;

INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (2, 1, 9, '6\'4', '95', '75', '95', '65', '120', 5, 2, 'Fever', 'No', 'Cramps and injuries\r\nMuscle pain: Muscle spasms, cramps and injuries can all cause muscle pain. Some infections or tumors may also lead to muscle pain. Tendon and ligament pain: Ligaments and tendons ', NULL, 'Yes', '', '', 11, 3, '20000', '', '2021-10-25 17:54:00', 'yes', 'yes', 1, NULL, '2021-10-27 05:19:59');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (7, 1, 16, '5\'7', '45', '78', '98', '122', '122', 1, 1, '', 'Yes', 'Atopic dermatitis (Eczema)\r\nAtopic dermatitis usually develops in early childhood and is more common in people who have a family history of the condition.', 'Atopic dermatitis (Eczema)\r\nAtopic dermatitis usually develops in early childhood and is more common in people who have a family history of the condition.', '', '', '', 11, 3, '20000', '', '2021-10-30 10:00:00', 'yes', 'yes', 1, NULL, '2021-11-01 09:37:10');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (8, 2, 22, '', '', '', '', '', '', 5, 2, '', 'Yes', 'Cramps and injuries\r\nMuscle pain: Muscle spasms, cramps and injuries can all cause muscle pain. Some infections or tumors may also lead to muscle pain. Tendon and ligament pain: Ligaments and tendons ', NULL, 'Yes', '', '', 11, 3, '2000', '', '2021-10-25 14:20:00', 'yes', 'yes', 1, NULL, '2022-05-03 09:43:25');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (14, 1, 115, '6.2', '25', '58', '49', '85', '112', 1, 1, '', 'Yes', 'Feeling sad or down\r\nPersonality change in a way that seems different for that person.', NULL, '', NULL, '', 11, 2, '20000', '', '2021-12-02 10:00:00', 'no', 'yes', 1, NULL, '2021-12-02 09:40:33');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (21, 190, 510, '34', '50`', '200', '89', '8899', '112', 6, 3, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', NULL, '', NULL, '', 11, 3, '20000', '', '2022-02-07 16:00:00', 'yes', 'yes', 1, NULL, '2023-07-06 06:41:07');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (26, 288, 1002, '5.8', '58', '112', '98', '112', '125', 9, 1, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', NULL, '', NULL, 'Dr. Mohit', 11, 2, '20000', '', '2022-04-03 13:00:00', 'yes', 'yes', 1, NULL, '2022-08-05 04:53:42');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (31, 2, 1213, '', '', '', '', '', '', 21, 1, '', 'Yes', '', NULL, '', NULL, '', 11, 3, '20000', '', '2022-05-03 16:53:00', 'yes', 'no', 1, NULL, '2024-12-06 08:14:31');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (47, 484, 2070, '4\'5', '45kg', '72', '95', '64', '120', 13, 5, 'HAIR PROBLEM', 'Yes', 'Constant or severe abdominal pain.\r\nDiseases that affect the digestive system can also cause chronic abdominal pain. The most common are: gastroesophageal reflux disease (GERD) irritable bowel syndrom', 'Constant or severe abdominal pain.\r\nDiseases that affect the digestive system can also cause chronic abdominal pain. The most common are: gastroesophageal reflux disease (GERD) irritable bowel syndrom', '', '', '', 12, 0, '20000', '', '2022-10-03 12:50:00', 'yes', 'yes', 1, NULL, '2024-12-05 12:33:51');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (55, 578, 2541, '5\'4', '55kg', '75', '95', '56', '120', 20, 1, '', 'Yes', '', '', '', '', '', 2, 4, '20000', '', '2022-12-05 07:55:00', 'yes', 'yes', 1, NULL, '2024-08-02 10:07:55');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (60, 628, 2869, '4\'5', '35', '79', '97', '65', '120', 33, 5, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 4, 4, '20000', '', '2023-01-08 17:31:00', 'no', 'yes', 1, NULL, '2023-01-04 12:07:20');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (61, 629, 2876, '5\'4', '56', '74', '97', '65', '120', 41, 3, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 4, 4, '20000', '', '2023-01-12 17:50:00', 'no', 'yes', 1, NULL, '2023-01-04 12:24:31');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (62, 641, 3001, '4\'5', '45kg', '72', '95', '32', '120', 5, 4, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 11, 4, '20000', '', '2023-02-08 14:32:00', 'no', 'yes', 1, NULL, '2023-02-01 09:12:47');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (63, 642, 3005, '4\'5', '35kg', '72', '94', '65', '120', 43, 3, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 11, 0, '20000', '', '2023-02-01 15:10:00', 'no', 'yes', 1, NULL, '2023-02-01 09:54:29');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (64, 643, 3009, '4\'5', '35kg', '72', '94', '32', '120', 38, 4, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 12, 0, '20000', '', '2023-02-22 15:51:00', 'no', 'yes', 1, NULL, '2023-02-01 10:24:19');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (74, 151, 3704, '4\'5', '55kg', '75', '95', '66', '120', 44, 7, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 11, 0, '20000', '', '2023-05-29 18:37:00', 'yes', 'yes', 1, NULL, '2024-06-01 12:15:08');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (77, 781, 4131, '4\'5', '55', '75', '95', '56', '120', 52, 7, '', 'Yes', 'Feeling sad or down\r\nPersonality change in a way that seems different for that person.', 'Feeling sad or down\r\nPersonality change in a way that seems different for that person.', '', '', '', 11, 4, '20000', '', '2023-06-23 15:37:00', 'no', 'yes', 1, NULL, '2023-06-06 10:22:19');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (80, 827, 4468, '5\'6', '50', '72', '94', '62', '120', 37, 4, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 11, 4, '20000', '', '2023-08-02 17:24:00', 'yes', 'yes', 1, NULL, '2024-07-01 07:22:20');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (81, 830, 4479, '5\'4', '65kg', '72', '94', '65', '120', 7, 2, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 12, 0, '20000', '', '2023-08-22 17:47:00', 'no', 'yes', 1, NULL, '2023-08-02 12:24:44');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (82, 868, 4723, '5\'6', '65kg', '72', '94', '96', '120', 39, 4, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 11, 4, '20000', '', '2023-09-16 12:10:00', 'yes', 'yes', 1, NULL, '2024-05-02 08:16:22');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (83, 872, 4743, '4\'6', '55kg', '72', '94', '62', '120', 10, 3, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 11, 3, '20000', '', '2023-09-26 12:46:00', 'no', 'yes', 1, NULL, '2023-09-04 07:21:24');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (84, 873, 4747, '5\'6', '65kg', '72', '95', '161', '120', 26, 6, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 2, 3, '20000', '', '2023-09-28 13:03:00', 'yes', 'yes', 1, NULL, '2024-05-02 10:39:18');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (86, 886, 4896, '5\'6', '75kg', '75', '94', '96', '120', 12, 5, '', 'Yes', 'Atopic dermatitis (Eczema)\r\nAtopic dermatitis usually develops in early childhood and is more common in people who have a family history of the condition.', 'Atopic dermatitis (Eczema)\r\nAtopic dermatitis usually develops in early childhood and is more common in people who have a family history of the condition.', '', '', '', 12, 0, '20000', '', '2023-10-18 17:37:00', 'no', 'yes', 1, NULL, '2023-10-05 04:41:35');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (87, 896, 4991, '6\'5', '88kg', '75', '94', '94', '120', 6, 3, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 4, 0, '20000', '', '2023-10-28 12:26:00', 'no', 'yes', 1, NULL, '2023-10-05 06:58:42');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (88, 121, 5085, '4\'5', '66', '72', '95', '65', '120', 15, 6, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 11, 3, '20000', '', '2023-11-08 13:09:00', 'no', 'yes', 1, NULL, '2023-11-03 07:54:45');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (90, 937, 5304, '4\'6', '55kg', '72', '95', '65', '120', 17, 6, '', 'Yes', '', '', '', '', '', 2, 0, '20000', '', '2023-12-12 12:39:00', 'no', 'yes', 1, NULL, '2023-12-04 07:21:45');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (91, 939, 5307, '5\'6', '45kg', '72', '95', '', '120', 2, 2, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 2, 4, '20000', '', '2023-12-18 17:40:00', 'no', 'yes', 1, NULL, '2023-12-04 07:42:42');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (92, 493, 5456, '4\'5', '65kg', '72', '94', '15', '120', 34, 5, '', 'Yes', 'Feeling sad or down\r\nPersonality change in a way that seems different for that person.', 'Feeling sad or down\r\nPersonality change in a way that seems different for that person.', '', '', '', 11, 4, '20000', '', '2024-01-12 12:45:00', 'no', 'yes', 1, NULL, '2024-01-03 12:43:06');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (93, 990, 5709, '4\'5', '45kg', '75', '94', '61', '120', 11, 6, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 11, 4, '20000', '', '2024-02-05 15:04:00', 'no', 'yes', 1, NULL, '2024-02-01 09:43:14');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (94, 1005, 5827, '4\'6', '65kg', '75', '94', '23', '120', 1, 1, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 11, 4, '20000', '', '2024-03-01 12:48:00', 'no', 'yes', 1, NULL, '2024-03-01 07:26:13');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (95, 878, 5891, '4\'5', '65kg', '75', '94', '16', '120', 16, 6, '', 'Yes', 'Cramps and injuries\r\nMuscle pain: Muscle spasms, cramps and injuries can all cause muscle pain. Some infections or tumors may also lead to muscle pain. Tendon and ligament pain: Ligaments and tendons ', 'Cramps and injuries\r\nMuscle pain: Muscle spasms, cramps and injuries can all cause muscle pain. Some infections or tumors may also lead to muscle pain. Tendon and ligament pain: Ligaments and tendons ', '', '', '', 12, 4, '20000', '', '2024-04-12 12:30:00', 'no', 'yes', 1, NULL, '2024-04-01 11:12:42');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (96, 843, 6182, '5\'6', '65kg', '75', '94', '13', '120', 8, 1, '', 'Yes', 'Atopic dermatitis (Eczema)\r\nAtopic dermatitis usually develops in early childhood and is more common in people who have a family history of the condition.', 'Atopic dermatitis (Eczema)\r\nAtopic dermatitis usually develops in early childhood and is more common in people who have a family history of the condition.', '', '', '', 11, 3, '20000', '', '2024-05-25 11:42:00', 'no', 'yes', 1, NULL, '2024-05-02 07:07:33');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (97, 980, 6290, '5\'6', '65kg', '75', '94', '16', '120', 17, 6, '', 'Yes', '', '', '', '', '', 11, 4, '20000', '', '2024-06-15 14:51:00', 'no', 'yes', 1, NULL, '2024-06-01 12:08:06');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (98, 1084, 6457, '5\'6', '80kg', '75', '94', '15', '120', 18, 1, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', 'Thirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or excessive thirst.', '', 11, 4, '20000', '', '2024-07-10 11:53:00', 'no', 'yes', 14, NULL, '2024-07-01 09:18:32');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (99, 1103, 6604, '5\'3', '65kg', '72', '94', '15', '120', 9, 1, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', NULL, 'Yes', '', '', 4, 4, '20000', '', '2024-08-08 12:16:00', 'no', 'yes', 1, NULL, '2024-08-30 07:59:33');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (100, 1121, 6721, NULL, NULL, '', '', '', NULL, 19, 1, '', 'Yes', 'Atopic dermatitis (Eczema)\r\nAtopic dermatitis usually develops in early childhood and is more common in people who have a family history of the condition.', NULL, 'Yes', '', 'Dr. April Clinton', 2, NULL, '20000', '', '2024-10-22 17:15:00', 'no', 'yes', 1, 1, '2024-10-04 11:16:38');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (101, 1134, 6801, NULL, NULL, '', '', '', NULL, 2, 2, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or excessive thirst.', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 2, NULL, '20000', '', '2024-11-12 17:00:00', 'no', 'no', 1, 1, '2024-11-07 06:46:49');
INSERT INTO `ipd_details` (`id`, `patient_id`, `case_reference_id`, `height`, `weight`, `pulse`, `temperature`, `respiration`, `bp`, `bed`, `bed_group_id`, `case_type`, `casualty`, `symptoms`, `known_allergies`, `patient_old`, `note`, `refference`, `cons_doctor`, `organisation_id`, `credit_limit`, `payment_mode`, `date`, `discharged`, `live_consult`, `generated_by`, `is_antenatal`, `created_at`) VALUES (102, 1107, 6849, NULL, NULL, '', '', '', NULL, 3, 2, '', 'Yes', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or excessive thirst.', 'Thirst\r\nThirst is the feeling of needing to drink something. It occurs whenever the body is dehydrated for any reason. Any condition that can result in a loss of body water can lead to thirst or exces', '', '', '', 11, NULL, '20000', '', '2024-12-05 17:54:00', 'no', 'no', 1, NULL, '2024-12-05 12:31:52');


#
# TABLE STRUCTURE FOR: ipd_doctors
#


CREATE TABLE `ipd_doctors` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ipd_id` int NOT NULL,
  `consult_doctor` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ipd_id` (`ipd_id`),
  KEY `consult_doctor` (`consult_doctor`),
  CONSTRAINT `ipd_doctors_ibfk_1` FOREIGN KEY (`ipd_id`) REFERENCES `ipd_details` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ipd_doctors_ibfk_2` FOREIGN KEY (`consult_doctor`) REFERENCES `staff` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3;

INSERT INTO `ipd_doctors` (`id`, `ipd_id`, `consult_doctor`, `created_at`) VALUES (2, 7, 12, '2021-10-27 05:20:45');
INSERT INTO `ipd_doctors` (`id`, `ipd_id`, `consult_doctor`, `created_at`) VALUES (7, 55, 11, '2022-12-05 10:56:57');
INSERT INTO `ipd_doctors` (`id`, `ipd_id`, `consult_doctor`, `created_at`) VALUES (9, 61, 12, '2023-01-04 12:38:50');
INSERT INTO `ipd_doctors` (`id`, `ipd_id`, `consult_doctor`, `created_at`) VALUES (10, 63, 4, '2023-02-04 04:38:20');


#
# TABLE STRUCTURE FOR: ipd_prescription_basic
#


CREATE TABLE `ipd_prescription_basic` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ipd_id` int DEFAULT NULL,
  `visit_details_id` int DEFAULT NULL,
  `attachment` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `attachment_name` text NOT NULL,
  `header_note` text,
  `footer_note` text,
  `finding_description` text,
  `is_finding_print` varchar(100) DEFAULT NULL,
  `date` date NOT NULL,
  `generated_by` int DEFAULT NULL,
  `prescribe_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ipd_id` (`ipd_id`),
  KEY `visit_details_id` (`visit_details_id`),
  KEY `generated_by` (`generated_by`),
  KEY `index_date` (`date`),
  KEY `prescribe_by` (`prescribe_by`),
  CONSTRAINT `ipd_prescription_basic_ibfk_1` FOREIGN KEY (`ipd_id`) REFERENCES `ipd_details` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ipd_prescription_basic_ibfk_2` FOREIGN KEY (`visit_details_id`) REFERENCES `visit_details` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ipd_prescription_basic_ibfk_3` FOREIGN KEY (`generated_by`) REFERENCES `staff` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ipd_prescription_basic_ibfk_4` FOREIGN KEY (`prescribe_by`) REFERENCES `staff` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=358 DEFAULT CHARSET=utf8mb3;

INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (3, 2, NULL, '', '', '', '', 'Osteoporosis\r\nBone density problems may occur because the body loses too much bone tissue, makes too little of it, or some combination of both. It tends to be symptomless. That is, people with osteoporosis tend not to know they have it – until a bone fracture has them visiting a doctor who makes the diagnosis.', 'yes', '2021-10-25', 1, 11, '2021-10-25 12:31:11');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (9, NULL, 11, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. ', 'yes', '2021-10-26', 1, 4, '2021-10-26 12:22:20');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (11, NULL, 16, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. ', 'yes', '2021-10-26', 1, 11, '2021-10-26 12:53:19');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (13, 7, NULL, '', '', '', '', 'Refractive Errors.\r\nA refractive error is a very common eye disorder. It occurs when the eye cannot clearly focus the images from the outside world. The result of refractive errors is blurred vision, which is sometimes so severe that it causes visual impairment', 'yes', '2021-10-27', 1, 12, '2021-10-27 05:41:48');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (16, 8, NULL, '', '', '', '<p><i>﻿</i><br></p>', 'Flushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2021-10-29', 1, 11, '2021-10-29 06:23:14');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (17, 7, NULL, '', '', '', '', 'Rosacea\r\nRosacea (roe-ZAY-she-uh) is a common skin condition that causes blushing or flushing and visible blood vessels in your face. It may also produce small, pus-filled bumps. These signs and symptoms may flare up for weeks to months and then go away for a while.', 'yes', '2021-10-29', 1, 12, '2021-10-29 06:41:59');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (62, 21, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2022-02-03', 1, 11, '2022-02-03 11:35:25');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (85, 26, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.\r\n\r\nHeadache\r\nTyphoid fever and paratyphoid fever are treated with antibiotics.', 'yes', '2022-04-02', 1, 11, '2022-04-02 07:57:09');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (98, 31, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2022-05-03', 1, 11, '2022-05-03 11:27:40');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (105, 31, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2022-06-02', 14, 11, '2022-06-02 12:15:54');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (145, 47, NULL, '', '', '', '', 'Damaged Hair\r\nHair damage is more than just split ends. Extremely damaged hair develops cracks in the outside layer (cuticle). Once the cuticle lifts (opens), your hair is at risk for further damage and breakage. It may also look dull or frizzy and be difficult to manage\r\n\r\nDamaged Hair\r\n', 'yes', '2022-10-04', 1, 12, '2022-10-04 09:59:03');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (172, 55, NULL, '', '', '', '', 'Diarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2022-12-05', 1, 2, '2022-12-05 10:58:56');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (184, 60, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2023-01-04', 1, 4, '2023-01-04 12:12:48');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (186, 61, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2023-01-04', 1, 4, '2023-01-04 12:27:38');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (189, 62, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2023-02-01', 1, 11, '2023-02-01 09:30:06');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (190, NULL, 2983, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-02-01', 1, 11, '2023-02-01 09:41:02');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (191, 63, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2023-02-01', 1, 11, '2023-02-01 09:59:13');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (193, 64, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-02-01', 1, 12, '2023-02-01 10:43:36');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (220, NULL, 3682, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2023-05-04', 1, 11, '2023-05-04 06:40:09');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (221, 74, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2023-05-04', 1, 11, '2023-05-04 06:42:16');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (229, 77, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2023-06-06', 1, 11, '2023-06-06 10:23:37');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (239, NULL, 4446, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. ', 'yes', '2023-08-02', 1, 11, '2023-08-02 12:01:19');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (240, 80, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-08-02', 1, 11, '2023-08-02 12:04:18');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (242, 81, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-08-02', 1, 12, '2023-08-02 12:25:57');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (244, NULL, 4701, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2023-09-04', 1, 11, '2023-09-04 06:47:13');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (245, 82, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2023-09-04', 1, 11, '2023-09-04 07:02:42');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (246, NULL, 4721, '', '', '', '', 'Rosacea\r\nRosacea (roe-ZAY-she-uh) is a common skin condition that causes blushing or flushing and visible blood vessels in your face. It may also produce small, pus-filled bumps. These signs and symptoms may flare up for weeks to months and then go away for a while.', 'yes', '2023-09-04', 1, 11, '2023-09-04 07:20:27');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (247, 83, NULL, '', '', '', '', 'Rosacea\r\nRosacea (roe-ZAY-she-uh) is a common skin condition that causes blushing or flushing and visible blood vessels in your face. It may also produce small, pus-filled bumps. These signs and symptoms may flare up for weeks to months and then go away for a while.', 'yes', '2023-09-04', 1, 11, '2023-09-04 07:23:04');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (248, NULL, 4725, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-09-04', 1, 2, '2023-09-04 07:35:50');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (249, 84, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-09-04', 1, 2, '2023-09-04 07:39:08');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (252, NULL, 4839, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2023-10-04', 1, 2, '2023-10-04 11:55:26');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (254, NULL, 4874, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-10-05', 1, 12, '2023-10-05 04:37:37');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (255, 86, NULL, '', '', '', '', 'Eczema.\r\nEczema (atopic dermatitis) is caused by a combination of immune system activation, genetics, environmental triggers and stress. Your immune system. If you have eczema, your immune system overreacts to small irritants or allergens. This overreaction can inflame your skin.', 'yes', '2023-10-05', 1, 12, '2023-10-05 04:43:01');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (256, NULL, 4969, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2023-10-05', 1, 4, '2023-10-05 06:57:39');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (257, 87, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-10-05', 1, 4, '2023-10-05 07:06:37');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (259, NULL, 5052, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-11-03', 1, 11, '2023-11-03 06:51:31');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (260, NULL, 5063, '', '', '', '', 'Diarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-11-03', 1, 11, '2023-11-03 07:54:09');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (261, 88, NULL, '', '', '', '', 'Diarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-11-03', 1, 11, '2023-11-03 07:56:14');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (266, NULL, 5232, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2023-12-04', 1, 11, '2023-12-04 05:18:05');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (268, NULL, 5278, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-12-04', 1, 12, '2023-12-04 07:20:17');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (269, 90, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-12-04', 1, 2, '2023-12-04 07:23:40');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (270, NULL, 5285, '', '', '', '', 'Rosacea\r\nRosacea (roe-ZAY-she-uh) is a common skin condition that causes blushing or flushing and visible blood vessels in your face. It may also produce small, pus-filled bumps. These signs and symptoms may flare up for weeks to months and then go away for a while.\r\n\r\nEczema.\r\nEczema (atopic dermatitis) is caused by a combination of immune system activation, genetics, environmental triggers and stress. Your immune system. If you have eczema, your immune system overreacts to small irritants or allergens. This overreaction can inflame your skin.', 'yes', '2023-12-04', 1, 2, '2023-12-04 07:41:01');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (272, 91, NULL, '', '', '', '', 'Rosacea\r\nRosacea (roe-ZAY-she-uh) is a common skin condition that causes blushing or flushing and visible blood vessels in your face. It may also produce small, pus-filled bumps. These signs and symptoms may flare up for weeks to months and then go away for a while.\r\n\r\nEczema.\r\nEczema (atopic dermatitis) is caused by a combination of immune system activation, genetics, environmental triggers and stress. Your immune system. If you have eczema, your immune system overreacts to small irritants or allergens. This overreaction can inflame your skin.', 'yes', '2023-12-04', 1, 2, '2023-12-04 07:45:18');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (273, 14, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2023-12-04', 1, 11, '2023-12-04 07:54:06');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (274, 14, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2024-01-03', 1, 11, '2024-01-03 09:49:07');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (275, 92, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2024-01-03', 1, 11, '2024-01-03 12:44:03');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (277, NULL, 5687, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. ', 'yes', '2024-02-01', 1, 11, '2024-02-01 09:41:22');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (278, NULL, 5691, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-02-01', 1, 11, '2024-02-01 09:42:22');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (279, 93, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2024-02-01', 1, 11, '2024-02-01 09:44:16');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (280, NULL, 5700, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. ', 'yes', '2024-02-01', 1, 11, '2024-02-01 10:07:33');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (281, 94, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. ', 'yes', '2024-03-01', 1, 11, '2024-03-01 07:27:26');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (282, NULL, 5807, '', '', '', '', ' ', 'yes', '2024-03-01', 1, 2, '2024-03-01 07:45:07');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (284, 14, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2024-04-01', 1, 11, '2024-04-01 09:53:43');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (285, NULL, 5870, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2024-04-01', 1, 12, '2024-04-01 11:10:57');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (286, 95, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. ', 'yes', '2024-04-01', 1, 12, '2024-04-01 11:20:48');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (289, NULL, 5636, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-05-01', 1, 2, '2024-05-01 12:10:06');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (290, NULL, 6117, '', '', '', '', 'Rosacea\r\nRosacea (roe-ZAY-she-uh) is a common skin condition that causes blushing or flushing and visible blood vessels in your face. It may also produce small, pus-filled bumps. These signs and symptoms may flare up for weeks to months and then go away for a while.', 'yes', '2024-05-01', 1, 2, '2024-05-01 12:29:41');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (291, 96, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2024-05-02', 1, 11, '2024-05-02 07:10:02');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (292, 14, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. \r\n\r\nFlushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2024-06-01', 1, 11, '2024-06-01 07:33:38');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (293, NULL, 6281, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. ', 'yes', '2024-06-01', 1, 2, '2024-06-01 10:04:06');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (294, 97, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. ', 'yes', '2024-06-01', 1, 11, '2024-06-01 12:09:17');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (295, 98, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2024-07-01', 14, 11, '2024-07-01 09:20:18');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (296, 14, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-07-01', 14, 11, '2024-07-01 09:38:46');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (297, NULL, 6440, '', '', '', '', 'Eczema.\r\nEczema (atopic dermatitis) is caused by a combination of immune system activation, genetics, environmental triggers and stress. Your immune system. If you have eczema, your immune system overreacts to small irritants or allergens. This overreaction can inflame your skin.', 'yes', '2024-07-01', 14, 11, '2024-07-01 09:51:44');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (298, NULL, 6339, '', '', '', '', 'Rosacea\r\nRosacea (roe-ZAY-she-uh) is a common skin condition that causes blushing or flushing and visible blood vessels in your face. It may also produce small, pus-filled bumps. These signs and symptoms may flare up for weeks to months and then go away for a while.', 'yes', '2024-07-01', 14, 12, '2024-07-01 09:52:33');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (299, NULL, 6530, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-07-02', 1, 11, '2024-07-02 05:52:15');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (300, NULL, 6531, '', '', '', '', 'Diarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2024-08-01', 1, 11, '2024-08-01 08:27:29');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (301, 14, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2024-08-01', 1, 11, '2024-08-01 09:42:21');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (302, NULL, 6583, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. ', 'yes', '2024-08-02', 1, 4, '2024-08-02 07:52:12');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (303, 99, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).\r\n\r\nDiarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots. ', 'yes', '2024-08-28', 1, 4, '2024-08-28 10:37:31');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (324, 14, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-08-30', 1, 11, '2024-08-30 04:22:11');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (325, 14, NULL, '', '', '', '', 'Rosacea\r\nRosacea (roe-ZAY-she-uh) is a common skin condition that causes blushing or flushing and visible blood vessels in your face. It may also produce small, pus-filled bumps. These signs and symptoms may flare up for weeks to months and then go away for a while.', 'yes', '2024-08-31', 1, 11, '2024-08-31 05:25:01');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (326, 98, NULL, '', '', '', '', 'Flushed complexion or hot skin.\r\nFlushed skin is often a visual sign of embarrassment, anxiety, or being too hot. However, frequent flushing can sometimes indicate an underlying medical condition. Flushed skin occurs when the hundreds of tiny blood vessels just beneath the skin dilate, or widen.', 'yes', '2024-08-31', 1, 11, '2024-08-31 07:59:34');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (327, 93, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-08-31', 1, 11, '2024-08-31 08:01:05');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (328, NULL, 6612, '', '', '', '', 'Diarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2024-08-31', 1, 11, '2024-08-31 10:46:39');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (329, NULL, 6648, '', '', '', '', '', 'yes', '2024-10-04', 1, 12, '2024-10-04 11:43:11');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (330, NULL, 6709, '', '', '', '', 'Eczema.\r\nEczema (atopic dermatitis) is caused by a combination of immune system activation, genetics, environmental triggers and stress. Your immune system. If you have eczema, your immune system overreacts to small irritants or allergens. This overreaction can inflame your skin.', 'yes', '2024-10-04', 1, 12, '2024-10-04 10:07:24');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (331, NULL, 6708, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-10-04', 1, 12, '2024-10-04 10:16:57');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (332, NULL, 6700, '', '', '', '', 'Eczema.\r\nEczema (atopic dermatitis) is caused by a combination of immune system activation, genetics, environmental triggers and stress. Your immune system. If you have eczema, your immune system overreacts to small irritants or allergens. This overreaction can inflame your skin.', 'yes', '2024-10-04', 1, 2, '2024-10-04 10:50:26');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (333, NULL, 6698, '', '', '', '', 'Diarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2024-10-04', 1, 4, '2024-10-04 10:53:34');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (334, NULL, 6707, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-10-04', 1, 12, '2024-10-04 10:54:27');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (335, 100, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. ', 'yes', '2024-10-04', 1, 2, '2024-10-04 11:14:06');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (336, 14, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-10-04', 1, 11, '2024-10-04 11:32:36');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (337, NULL, 6706, '', '', '', '', 'Osteoporosis\r\nBone density problems may occur because the body loses too much bone tissue, makes too little of it, or some combination of both. It tends to be symptomless. That is, people with osteoporosis tend not to know they have it – until a bone fracture has them visiting a doctor who makes the diagnosis.', 'yes', '2024-10-04', 1, 12, '2024-10-04 12:29:22');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (338, NULL, 6694, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-10-04', 1, 4, '2024-10-04 12:32:46');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (339, NULL, 6710, '', '', '', '', 'Rosacea\r\nRosacea (roe-ZAY-she-uh) is a common skin condition that causes blushing or flushing and visible blood vessels in your face. It may also produce small, pus-filled bumps. These signs and symptoms may flare up for weeks to months and then go away for a while.', 'yes', '2024-10-05', 1, 11, '2024-10-05 04:16:30');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (340, NULL, 6705, '', '', '', '', 'Eczema.\r\nEczema (atopic dermatitis) is caused by a combination of immune system activation, genetics, environmental triggers and stress. Your immune system. If you have eczema, your immune system overreacts to small irritants or allergens. This overreaction can inflame your skin.', 'yes', '2024-10-05', 1, 12, '2024-10-05 04:45:56');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (341, NULL, 6718, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-10-05', 1, 2, '2024-10-05 05:03:19');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (342, NULL, 6717, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-10-05', 1, 4, '2024-10-05 05:03:35');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (343, NULL, 6713, '', '', '', '', 'Rosacea\r\nRosacea (roe-ZAY-she-uh) is a common skin condition that causes blushing or flushing and visible blood vessels in your face. It may also produce small, pus-filled bumps. These signs and symptoms may flare up for weeks to months and then go away for a while.', 'yes', '2024-10-05', 1, 11, '2024-10-05 05:14:40');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (344, NULL, 6711, '', '', '', '', '', 'yes', '2024-10-05', 1, 2, '2024-10-05 05:34:44');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (345, NULL, 6716, '', '', '', '', 'Damaged Hair\r\nHair damage is more than just split ends. Extremely damaged hair develops cracks in the outside layer (cuticle). Once the cuticle lifts (opens), your hair is at risk for further damage and breakage. It may also look dull or frizzy and be difficult to manage', 'yes', '2024-10-05', 1, 11, '2024-10-05 05:38:48');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (346, 14, NULL, '', '', '', '', 'Elevated temperature (above 100.4°)\r\nThe medical community generally defines a fever as a body temperature above 100.4 degrees Fahrenheit. A body temp between 100.4 and 102.2 degree is usually considered a low-grade fever. ', 'yes', '2024-11-06', 1, 11, '2024-11-06 11:21:17');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (347, NULL, 6780, '', '', '', '', 'Rosacea\r\nRosacea (roe-ZAY-she-uh) is a common skin condition that causes blushing or flushing and visible blood vessels in your face. It may also produce small, pus-filled bumps. These signs and symptoms may flare up for weeks to months and then go away for a while.', 'yes', '2024-11-07', 1, 2, '2024-11-07 06:20:56');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (348, NULL, 6779, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-11-07', 1, 4, '2024-11-07 06:26:43');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (349, NULL, 6778, '', '', '', '', 'Diarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2024-11-07', 1, 4, '2024-11-07 06:27:53');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (350, 101, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-11-07', 1, 2, '2024-11-07 06:48:03');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (351, NULL, 6719, '', '', '', '', 'Osteoporosis\r\nBone density problems may occur because the body loses too much bone tissue, makes too little of it, or some combination of both. It tends to be symptomless. That is, people with osteoporosis tend not to know they have it – until a bone fracture has them visiting a doctor who makes the diagnosis.', 'yes', '2024-11-07', 1, 11, '2024-11-07 10:32:52');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (352, 14, NULL, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-12-04', 1, 11, '2024-12-04 12:02:40');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (353, NULL, 6781, '', '', '', '', 'Rosacea\r\nRosacea (roe-ZAY-she-uh) is a common skin condition that causes blushing or flushing and visible blood vessels in your face. It may also produce small, pus-filled bumps. These signs and symptoms may flare up for weeks to months and then go away for a while.', 'yes', '2024-12-05', 1, 2, '2024-12-05 04:11:37');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (354, NULL, 6828, '', '', '', '', 'Stomach pain\r\nTyphoid fever and paratyphoid fever have similar symptoms̵. People usually have a sustained fever (one that doesn’t come and go) that can be as high as 103–104°F (39–40°C).', 'yes', '2024-12-05', 1, 11, '2024-12-05 12:31:30');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (355, 102, NULL, '', '', '', '', '', 'yes', '2024-12-06', 1, 11, '2024-12-06 05:42:28');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (356, NULL, 6838, '', '', '', '', '', 'yes', '2024-12-06', 1, 2, '2024-12-06 06:05:29');
INSERT INTO `ipd_prescription_basic` (`id`, `ipd_id`, `visit_details_id`, `attachment`, `attachment_name`, `header_note`, `footer_note`, `finding_description`, `is_finding_print`, `date`, `generated_by`, `prescribe_by`, `created_at`) VALUES (357, NULL, 6837, '', '', '', '', 'Diarrhea or constipation\r\nSome people with typhoid fever or paratyphoid fever develop a rash of flat, rose-colored spots.', 'yes', '2024-12-06', 1, 2, '2024-12-06 06:06:04');


#
# TABLE STRUCTURE FOR: ipd_prescription_details
#

