-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `holy_family`
--

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1);

-- --------------------------------------------------------

--
-- Table structure for table `mst_about`
--

CREATE TABLE `mst_about` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_about`
--

INSERT INTO `mst_about` (`id`, `title`, `short_description`, `image`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'About Holy Family Hospital', '<p>Holy Family hospital is among the top best Mumbai hospitals. The hospital has its roots in a 10-bed private nursing home that catered to suburban Bandra in 1942. Over the decades, this nursing home was converted into a general hospital for the community, first administered by the Medical Mission Sisters and then by the Congregation of the&nbsp;<a href=\"https://mbihosting.in/holy-family-hospital/demo/ursuline-sisters.html\">Ursuline Sisters</a>&nbsp;of Mary Immaculate.</p>\r\n\r\n<p>Constantly raising the bar, we achieved significant milestones in 2002 when we inaugurated the&nbsp;Holy Family Heart Institute&nbsp;and in 2010 with the Hybrid CathLab.</p>', '906.jpg', 1, 1, '2023-12-16 06:36:10', 1, '2024-02-13', NULL, NULL),
(2, 'fdgdfhfg', 'dfdfhfgh', '619.jpg', 1, 1, '2023-12-16 06:37:39', NULL, NULL, NULL, '2023-12-16');

-- --------------------------------------------------------

--
-- Table structure for table `mst_about_count_detail`
--

CREATE TABLE `mst_about_count_detail` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `count` text DEFAULT NULL,
  `about_image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_about_count_detail`
--

INSERT INTO `mst_about_count_detail` (`id`, `title`, `description`, `count`, `about_image`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Years of Experience', NULL, '45', '935.png', 1, 1, '2024-02-13 12:50:26', NULL, NULL, NULL, NULL),
(2, 'Clinics', NULL, '10,000', '491.png', 1, 1, '2024-02-13 13:12:05', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_about_detail`
--

CREATE TABLE `mst_about_detail` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `year_count` text DEFAULT NULL,
  `about_image` text DEFAULT NULL,
  `operator` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_about_detail`
--

INSERT INTO `mst_about_detail` (`id`, `title`, `description`, `year_count`, `about_image`, `operator`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'About Hospital', '<p>Holy Family hospital is among the top best Mumbai hospitals. The hospital has its roots in a 10-bed private nursing home that catered to suburban Bandra in 1942. Over the decades, this nursing home was converted into a general hospital for the community, first administered by the Medical Mission Sisters and then by the Congregation of the Ursuline Sisters of Mary Immaculate.</p>\r\n\r\n<p>Constantly raising the bar, we achieved significant milestones in 2002 when we inaugurated the Holy Family Heart Institute and in 2010 with the Hybrid CathLab. With its cutting edge cardiac catheterisation laboratory, MRI, Cardiac CT Scan, CT Scan and other medical facilities, the hospital is a pioneer in cardiac diagnostics, treatment and research.</p>\r\n\r\n<p>Holy Family Hospital, Bombay, is a 268-bed public charitable, trust-run hospital and a centre of medical excellence today.</p>', '45', '647.jpg', '+', 1, 1, '2024-02-12 13:01:17', 1, '2024-02-13', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_about_info`
--

CREATE TABLE `mst_about_info` (
  `id` int(11) NOT NULL,
  `image` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_about_info`
--

INSERT INTO `mst_about_info` (`id`, `image`, `description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, '881.jpg', '<p>Holy Family Hospital, Mumbai, also has a strong research and teaching culture. Setting the tone for this fine tradition is The Bandra Holy Family Medical Research Society, which was set up in 1987.</p>\r\n\r\n<p>While spearheading basic research, clinical drug trials and engaging in Continuing Medical Education, the Medical Research Centre contributes to the efficient delivery of clinical diagnostics, treatment and patient care within the latest guidelines and evidence-based medicine. It also enhances the quality of teaching available to post-graduate students at the hospital.</p>\r\n\r\n<p>However, we have never lost sight of our original mission &ndash; to serve the needs of a multi-layered community that once had little access to quality healthcare. Just as illness is blind to social and economic considerations, we believe that affordable healthcare is a basic right of everyone.</p>', 1, 1, '2024-02-15 04:49:38', 1, '2024-02-15', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_about_medical_records`
--

CREATE TABLE `mst_about_medical_records` (
  `id` int(11) NOT NULL,
  `first_title` text DEFAULT NULL,
  `first_description` text DEFAULT NULL,
  `second_title` text DEFAULT NULL,
  `second_description` text DEFAULT NULL,
  `third_title` text DEFAULT NULL,
  `third_description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_about_medical_records`
--

INSERT INTO `mst_about_medical_records` (`id`, `first_title`, `first_description`, `second_title`, `second_description`, `third_title`, `third_description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Why you need to visit the Medical Records Dept', '<p><strong>To obtain:</strong>&nbsp;Photocopies (attested) of Indoor Case Papers (kindly download Form A or Form B as required, fill them out and submit them to the MRD for processing).</p>\r\n\r\n<p>Form A is for patients who are discharged from the hospital. It must be signed by the patient.</p>\r\n\r\n<p>Form B is to be filled out on the death of a patient and signed by the individual who claims the body.</p>', 'Hospital Registration', '<p>The hospital&rsquo;s registration number is 761409799 (with H West, Brihanmumbai Municipal Corporation).</p>', 'Authorisation', '<p>Medical records of patients are confidential and are handed over only to authorised individuals. If the patient / signatory (in the case of deceased patients) whose records are sought is unable to collect the requested documents in person, then he / she must provide a signed authorisation letter to the individual who collects them on his / her behalf.</p>', 0, 1, '2024-02-01 09:41:40', 1, '2024-02-01', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_about_medical_service`
--

CREATE TABLE `mst_about_medical_service` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_about_medical_service`
--

INSERT INTO `mst_about_medical_service` (`id`, `title`, `description`, `image`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Records / Services Provided', '<ul>\r\n	<li>Attested photocopies of Indoor Case Papers.</li>\r\n	<li>Medical Summary / Death Summary.</li>\r\n	<li>Birth Record (photocopy of birth record certificate / time of birth).</li>\r\n	<li>Correction / change of patient&#39;s personal data (name, age, sex, address etc).</li>\r\n	<li>Attestation of medical documents of the hospital.</li>\r\n	<li>Certifying Insurance Claim Forms through the Medical Records Department for reimbursement of bill (the claim form must be brought by patient).</li>\r\n	<li>Certificate of the treating doctor through the Medical Records Department (ie, doctor&#39;s answers / remarks to queries of insurance company, injury or disability certificate). For this, patients need to present the insurance company&rsquo;s query letter.</li>\r\n	<li>Signature / counter-signature of Medical Director / Medical Superintendent.</li>\r\n	<li>Signature / counter-signature of Medical Director / Medical Superintendent on claim forms of state or central government.</li>\r\n</ul>', '350.jpg', 1, 1, '2024-02-01 10:27:16', 1, '2024-02-01', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_about_newsletter`
--

CREATE TABLE `mst_about_newsletter` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `sub_title` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) NOT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_about_newsletter`
--

INSERT INTO `mst_about_newsletter` (`id`, `title`, `sub_title`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'The Quarterly Newsletter', 'Vol 1 Issue 1', 1, 1, '2024-02-08 12:35:52', 1, '2024-02-08', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_about_other_services`
--

CREATE TABLE `mst_about_other_services` (
  `id` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_about_other_services`
--

INSERT INTO `mst_about_other_services` (`id`, `description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, '<p>Holy Family Hospital goes above and beyond the call of duty to serve the community in the best way we can. We offer Spiritual Services for everyone regardless of caste and creed. We also conduct a comprehensive Patient Education programme across specialties to acquaint patients and the community at large with various aspects of their health.</p>', 1, 1, '2024-02-01 11:25:52', NULL, NULL, NULL, NULL),
(3, '<p>dfgdgfgh</p>', 1, 1, '2024-02-01 11:45:59', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_accommodation_description`
--

CREATE TABLE `mst_accommodation_description` (
  `id` int(11) NOT NULL,
  `header_description` text DEFAULT NULL,
  `footer_description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_accommodation_description`
--

INSERT INTO `mst_accommodation_description` (`id`, `header_description`, `footer_description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, '<p>Our rooms / wards are well-equipped and designed to facilitate excellent medical treatment and patient comfort. We pay special attention to hygiene, which is maintained across the board by trained housekeeping staff. In the interest of our patients, we request visitors to follow hygienic practices while in the hospital.</p>', '<p>A semi-private room taken on single-patient occupancy will attract full room charges.</p>\r\n\r\n<p>Booking is subject to availability.</p>', 1, 1, '2023-12-21 06:59:55', 1, '2023-12-21', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_accommodation_slider`
--

CREATE TABLE `mst_accommodation_slider` (
  `id` int(11) NOT NULL,
  `image` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_accommodation_slider`
--

INSERT INTO `mst_accommodation_slider` (`id`, `image`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, '903.png', 1, '2023-12-21 07:18:39', 1, '2023-12-21', NULL, NULL),
(2, '875.jpg', 1, '2023-12-21 07:24:28', NULL, NULL, NULL, '2023-12-21');

-- --------------------------------------------------------

--
-- Table structure for table `mst_accreditation_awards`
--

CREATE TABLE `mst_accreditation_awards` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_accreditation_awards`
--

INSERT INTO `mst_accreditation_awards` (`id`, `title`, `description`, `image`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'eterter11', '<p>srt</p>', '791.png', 1, 1, '2023-12-18 10:01:16', 1, '2023-12-21', NULL, '2023-12-21'),
(2, 'fgdfgds', '<p>fghfgfg</p>', '317.png', 1, 1, '2023-12-21 06:18:55', NULL, NULL, NULL, NULL),
(3, 'fgdfgds', '<p>fghfgfg</p>', '683.png', 1, 1, '2023-12-21 06:19:44', NULL, NULL, NULL, '2023-12-21');

-- --------------------------------------------------------

--
-- Table structure for table `mst_accreditation_description`
--

CREATE TABLE `mst_accreditation_description` (
  `id` int(11) NOT NULL,
  `highlight` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_accreditation_description`
--

INSERT INTO `mst_accreditation_description` (`id`, `highlight`, `description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Accreditation & Awards1', '<p>Accreditation adds value to a hospital&rsquo;s services and is a quality assurance in patient care, patient services and safety standards. Holy Family Hospital is proud to state that it has earned some of the most sought-after accreditations available in India.</p>\r\n\r\n<p><img src=\"https://mbihosting.in/holy-family-hospital/demo/images/about/accreditation/nabh-logo.webp\" /></p>\r\n\r\n<p>NABH Accreditation</p>\r\n\r\n<p>The hospital celebrated a red-letter day when it was awarded a Certificate of Accreditation from the National Accreditation Board for Hospitals and Healthcare Providers (NABH).</p>\r\n\r\n<p>The NABH falls under the purview of the Quality Council of India, an autonomous body of the Government of India to establish and operate accreditation programmes for healthcare organisations.</p>\r\n\r\n<p>The board is also a member of the International Society for Quality in Healthcare (ISQUA), which grants approval to accreditation bodies in the field of healthcare as a mark of equivalence of an accreditation programme in a member-country.</p>\r\n\r\n<p>Holy Family Hospital, which received its accreditation on October 27, 2010, is only one of two Catholic hospitals in Mumbai and eleven in the city to have received the NABH accreditation.</p>\r\n\r\n<p>NABH accreditation translates into excellence in patient care as the hospital is bound to adhere to stringent standards in all areas including hygiene, patient services, laboratory quality, management of medication, facility management, antibiotic policy, infection control etc. NABH accreditation also certifies that all consultants with the hospital regularly update their knowledge and expertise and maintain the highest standards in their qualifications and practice.</p>\r\n\r\n<p>While awarding the certificate of accreditation, Dr Girdhar J Gyani, Secretary-General of the Quality Council of India, said that although the hospital is not a corporate hospital, it has nearly all necessary health services, including a specialised Heart Institute, to fulfil its mission in the delivery of healthcare services.</p>\r\n\r\n<p>NABH Re-Accreditation</p>\r\n\r\n<p>On 26th October, 2013, Holy Family Hospital became one of the few hospitals in the city which received re-accreditation by NABH. The hospital complied with the stipulated 102 standards and 636 objective elements. It is regularly audited by external auditors.</p>', 1, 1, '2023-12-21 05:51:00', 1, '2023-12-21', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_banner`
--

CREATE TABLE `mst_banner` (
  `id` int(11) NOT NULL,
  `page_id` int(11) DEFAULT NULL,
  `banner` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) NOT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_banner`
--

INSERT INTO `mst_banner` (`id`, `page_id`, `banner`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 4, '740.jpg', 1, 1, '2023-12-16 05:33:35', 1, '2023-12-16', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_books_periodicals`
--

CREATE TABLE `mst_books_periodicals` (
  `id` int(11) NOT NULL,
  `icon` text DEFAULT NULL,
  `count` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_books_periodicals`
--

INSERT INTO `mst_books_periodicals` (`id`, `icon`, `count`, `title`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, '409.png', '90', 'srt', 1, 1, '2024-02-03 10:24:34', 1, '2024-02-03', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_committee`
--

CREATE TABLE `mst_committee` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_committee`
--

INSERT INTO `mst_committee` (`id`, `name`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'adfgdfg12', 1, 1, '2023-12-20 13:04:46', 1, '2023-12-20', NULL, '2023-12-20'),
(2, 'dsgdf', 1, 1, '2023-12-20 13:04:59', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_committee_description`
--

CREATE TABLE `mst_committee_description` (
  `id` int(11) NOT NULL,
  `highlight` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_committee_description`
--

INSERT INTO `mst_committee_description` (`id`, `highlight`, `description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Committees for Prevention of Sexual Harrasment at the Workplace', '<p>In accordance with The Sexual Harassment at Workplace (Prevention, Prohibition and Redressal) Act, 2013, Holy Family Hospital has framed a Committee to deal with complaints related to sexual harassment.</p>\r\n\r\n<p>The policy on sexual harassment at workplace is to ensure safety of all our employees (females and males) within our premises. This policy also covers third parties associated with Holy Family Hospital.</p>\r\n\r\n<p>Contact:&nbsp;<a href=\"mailto:internalcomplaints.hfh@gmail.com\">internalcomplaints.hfh@gmail.com</a></p>', 1, 1, '2023-12-21 05:18:50', 1, '2023-12-21', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_contact_us`
--

CREATE TABLE `mst_contact_us` (
  `id` int(11) NOT NULL,
  `contact_number` text DEFAULT NULL,
  `email` text DEFAULT NULL,
  `location` text DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_contact_us`
--

INSERT INTO `mst_contact_us` (`id`, `contact_number`, `email`, `location`, `short_description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, '+ 022 62670555', 'info@holyfamilyhospital.in', '<p>Holy Family Hospital<br />\r\nSt Andrew&rsquo;s Road, Bandra (West),<br />\r\nMumbai &ndash; 400 050. India.</p>', NULL, 1, 1, '2024-02-16 13:24:59', 1, '2024-02-16', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_empannelled_insurance`
--

CREATE TABLE `mst_empannelled_insurance` (
  `id` int(11) NOT NULL,
  `insurance_type` text NOT NULL,
  `title` text NOT NULL,
  `image` text NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_empannelled_insurance`
--

INSERT INTO `mst_empannelled_insurance` (`id`, `insurance_type`, `title`, `image`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'direct-insurance', 'dgdf', '733.jpg', 1, 1, '2023-12-21 11:04:18', NULL, NULL, NULL, '2023-12-21'),
(2, 'TPA-corporate-only', 'fghfgh1', '176.jpg', 1, 1, '2023-12-21 11:23:50', 1, '2023-12-21', NULL, '2023-12-21'),
(3, 'TPA-corporate-only', 'fghfg', '527.jpg', 1, 1, '2023-12-21 11:58:10', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_empannelled_insurance_description`
--

CREATE TABLE `mst_empannelled_insurance_description` (
  `id` int(11) NOT NULL,
  `header_title` text DEFAULT NULL,
  `header_sub_title` text DEFAULT NULL,
  `header_description` text DEFAULT NULL,
  `footer_description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_empannelled_insurance_description`
--

INSERT INTO `mst_empannelled_insurance_description` (`id`, `header_title`, `header_sub_title`, `header_description`, `footer_description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'List Of Empanelled Companies', 'Introduction', '<p>We are empaneled with most of the Reputed Insurance and TPA Service providers in India, for both Direct and Corporate Entities. Patients can avail the benefit of Cashless hospitalization at Holy Family Hospital, Bandra if the TPA / Insurance co. has a tie up with the hospital (List Updated Below).</p>', '<p>For further enquiries, Reach us at</p>\r\n\r\n<p><a href=\"mailto:preauth.hfh@gmail.com\">preauth.hfh@gmail.com</a></p>', 1, 1, '2023-12-21 10:12:34', 1, '2023-12-21', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_general_hospital`
--

CREATE TABLE `mst_general_hospital` (
  `id` int(11) NOT NULL,
  `bed_count` text DEFAULT NULL,
  `location` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_general_hospital`
--

INSERT INTO `mst_general_hospital` (`id`, `bed_count`, `location`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, '300', 'mumbai1', 1, 1, '2023-12-20 04:58:41', 1, '2023-12-20', NULL, NULL),
(2, 'gghj', 'ghjgj', 1, 1, '2023-12-20 05:01:45', NULL, NULL, NULL, '2023-12-20');

-- --------------------------------------------------------

--
-- Table structure for table `mst_health_centers_services`
--

CREATE TABLE `mst_health_centers_services` (
  `id` int(11) NOT NULL,
  `short_description` text DEFAULT NULL,
  `first_feature_title` text DEFAULT NULL,
  `first_feature_description` text DEFAULT NULL,
  `second_feature_title` text DEFAULT NULL,
  `second_feature_description` text DEFAULT NULL,
  `third_feature_title` text DEFAULT NULL,
  `third_feature_description` text DEFAULT NULL,
  `first_icon` text DEFAULT NULL,
  `second_icon` text DEFAULT NULL,
  `third_icon` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_health_centers_services`
--

INSERT INTO `mst_health_centers_services` (`id`, `short_description`, `first_feature_title`, `first_feature_description`, `second_feature_title`, `second_feature_description`, `third_feature_title`, `third_feature_description`, `first_icon`, `second_icon`, `third_icon`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'sgdfgh', 'fghgfh', 'ghjgh', 'ghjgh', 'gjghj', 'ghgh', 'ghgf', NULL, NULL, NULL, 1, 1, '2023-12-20 06:16:16', NULL, NULL, NULL, '2023-12-20'),
(2, 'The Congregation runs health centres in villages across the country. They also run urban clinics targeted at slum populations through vaccination, healthcare projects and daily clinics.', 'Education', 'Apart from medical services, the UMI also serves the community through educational and socio-pastoral activities. It runs many schools in different parts of the country, in both English and local languages as the medium of instruction. Most of these schools extend to the higher secondary level and junior colleges as well.', 'Outreach', 'To serve the needs of communities more comprehensively, the Congregation conducts numerous community outreach programmes. It manages homes for senior citizens and orphanages, rehabilitation centres, free boarding houses to educate socially disadvantaged young women and prison ministries as well.', 'Navjeet Community Health Centre', 'Navjeet Community Health Centre, the Congregation\'s community outreach programme in Mumbai, was started soon after they took over the administration of Holy Family Hospital. Its main objective is to meet the diverse needs of socially disadvantaged residents of Mumbai.', '8996.png', '9618.png', '8432.png', 1, 1, '2023-12-20 06:17:02', 1, '2023-12-20', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_hospital_multi_specialty`
--

CREATE TABLE `mst_hospital_multi_specialty` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `sub_title` text DEFAULT NULL,
  `bed_count` text DEFAULT NULL,
  `location` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_hospital_multi_specialty`
--

INSERT INTO `mst_hospital_multi_specialty` (`id`, `title`, `sub_title`, `bed_count`, `location`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(2, NULL, NULL, '268', 'Holy Family Hospital, Mumbai', 1, 1, '2023-12-20 04:37:48', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_infrastructure`
--

CREATE TABLE `mst_infrastructure` (
  `id` int(11) NOT NULL,
  `image` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mst_library_services`
--

CREATE TABLE `mst_library_services` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `sub_title` text DEFAULT NULL,
  `icon` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_library_services`
--

INSERT INTO `mst_library_services` (`id`, `title`, `sub_title`, `icon`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Location', '6th floor', '<i class=\"fa fa-map-marker\"></i>', 1, 1, '2024-02-01 11:57:35', 1, '2024-02-01', NULL, NULL),
(2, 'Timing', '8 am to 8 pm', '<i class=\"fa fa-clock-o\"></i>', 1, 1, '2024-02-01 12:05:05', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_library_services_description`
--

CREATE TABLE `mst_library_services_description` (
  `id` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_library_services_description`
--

INSERT INTO `mst_library_services_description` (`id`, `description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, '<p>Holy Family Hospital, has a well-stocked library whose literature is updated regularly. The library has comfortable open and well-lit spaces, with networked PCs distributed throughout. The facility is not open to the public and is specifically meant for DNB students, Consultants, RMOs, nurses and administrative staff.</p>', 1, 1, '2024-02-03 06:14:00', 1, '2024-02-03', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_library_service_description`
--

CREATE TABLE `mst_library_service_description` (
  `id` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `status` text NOT NULL DEFAULT '1',
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_library_service_description`
--

INSERT INTO `mst_library_service_description` (`id`, `description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, '<p>srt</p>\r\n\r\n<p>&nbsp;</p>', '1', 1, '2024-02-03 05:57:01', 1, '2024-02-03', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_management_committee`
--

CREATE TABLE `mst_management_committee` (
  `id` int(11) NOT NULL,
  `type` text DEFAULT NULL,
  `name` text DEFAULT NULL,
  `designation` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_management_committee`
--

INSERT INTO `mst_management_committee` (`id`, `type`, `name`, `designation`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Dr.(Sr)', 'dfgdfhfd', 'fghfg', 1, 1, '2023-12-20 12:23:24', 1, '2023-12-20', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_medical_contact_description`
--

CREATE TABLE `mst_medical_contact_description` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) NOT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_medical_contact_description`
--

INSERT INTO `mst_medical_contact_description` (`id`, `title`, `description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'How To Reach Us', '<p>Patients often need to comply with post-hospitalisation procedures that require certain documents and certificates from the hospital. This is usually the case with patients who file claims for medical insurance, on the death of a relative or for legal purposes.</p>\r\n\r\n<p>Our Medical Records Department meticulously logs all documents required by patients and their relatives and provides copies of the same on compliance with stipulated procedures. Our staff is courteous, efficient and will walk you through the procedures.</p>', 1, 1, '2024-02-01 08:59:14', 1, '2024-02-01', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_medical_contact_details`
--

CREATE TABLE `mst_medical_contact_details` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `sub_title` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_medical_contact_details`
--

INSERT INTO `mst_medical_contact_details` (`id`, `title`, `sub_title`, `image`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Location', 'Basement', '<i class=\"fa fa-map-marker\"></i>', 1, 1, '2024-02-01 07:25:44', 1, '2024-02-01', NULL, NULL),
(2, 'Timings', '9 am to 5 pm (except Sundays and public holidays)', '<i class=\"fa fa-clock-o\"></i>', 1, 1, '2024-02-01 07:39:40', 1, '2024-02-01', NULL, NULL),
(3, 'Phone', '022-62670437', '<i class=\"fa fa-phone\"></i>', 1, 1, '2024-02-01 07:40:56', NULL, NULL, NULL, NULL),
(4, 'Fax No', '022-26403219', '<i class=\"fa fa-fax\"></i>', 1, 1, '2024-02-01 07:41:45', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_news`
--

CREATE TABLE `mst_news` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `sub_title` text DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `long_description` text DEFAULT NULL,
  `date` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_news`
--

INSERT INTO `mst_news` (`id`, `title`, `sub_title`, `short_description`, `long_description`, `date`, `image`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'gfgfdfdfg', 'rthgh', 'fghgfhg', 'gfh', NULL, '570.jpg', 1, 1, '2023-12-16 08:58:23', 1, '2023-12-16', NULL, NULL),
(2, 'erertert1', 'rthgh', 'fghgfhg 11', 'gfh1', NULL, '115.jpg', 1, 1, '2023-12-16 09:00:17', 1, '2023-12-16', NULL, '2023-12-16'),
(3, 'srt', 'fgfg1', 'fgfgh123', 'fghfggdf111', '2023-12-16', '842.jpg', 1, 1, '2023-12-16 09:25:50', 1, '2023-12-16', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_newsletter`
--

CREATE TABLE `mst_newsletter` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `pdf` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_newsletter`
--

INSERT INTO `mst_newsletter` (`id`, `title`, `pdf`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'srt', '246.pdf', 1, 1, '2024-02-09 05:02:01', 1, '2024-02-09', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_opd_schedule`
--

CREATE TABLE `mst_opd_schedule` (
  `id` int(11) NOT NULL,
  `opd_pdf` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) NOT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mst_our_values`
--

CREATE TABLE `mst_our_values` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `icon` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_our_values`
--

INSERT INTO `mst_our_values` (`id`, `title`, `icon`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Compassion and competent care.', '857.png', 1, 1, '2023-12-19 09:29:08', 1, '2023-12-19', NULL, NULL),
(2, 'Respect for life in all its stages.', '721.png', 1, 1, '2023-12-19 09:30:05', 1, '2023-12-19', NULL, NULL),
(3, 'A close partnership between medical staff, employees and religious Sisters in our mission to reach out to patients and the community.', '740.png', 1, 1, '2023-12-19 09:30:12', 1, '2023-12-19', NULL, NULL),
(4, 'Responsible management of resources.', '802.png', 1, 1, '2023-12-19 09:49:06', 1, '2023-12-19', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_pages`
--

CREATE TABLE `mst_pages` (
  `id` int(11) NOT NULL,
  `page_name` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_pages`
--

INSERT INTO `mst_pages` (`id`, `page_name`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'home', 1, NULL, '2023-12-15 13:07:20', NULL, NULL, NULL, NULL),
(2, 'about', 1, NULL, '2023-12-15 13:07:37', NULL, NULL, NULL, NULL),
(3, 'profile-and-history', 1, NULL, '2023-12-15 13:08:36', NULL, NULL, NULL, NULL),
(4, 'vision-mission-motto', 1, NULL, '2023-12-15 13:08:36', NULL, NULL, NULL, NULL),
(5, 'ursuline-sisters', 1, NULL, '2023-12-15 13:09:24', NULL, NULL, NULL, NULL),
(6, 'society', 1, NULL, '2023-12-15 13:09:24', NULL, NULL, NULL, NULL),
(7, 'management-committee', 1, NULL, '2023-12-15 13:09:47', NULL, NULL, NULL, NULL),
(8, 'committees', 1, NULL, '2023-12-15 13:09:47', NULL, NULL, NULL, NULL),
(9, 'accreditation', 1, NULL, '2023-12-15 13:10:06', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_patients_facility`
--

CREATE TABLE `mst_patients_facility` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `icon` text DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` text DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_patients_facility`
--

INSERT INTO `mst_patients_facility` (`id`, `title`, `description`, `image`, `icon`, `slug`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Health Checkup Packages', NULL, '877.jpg', '603.png', 'health-checkup-packages', 1, 1, '2023-12-16 07:21:46', 1, '2024-02-12', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_profile_history`
--

CREATE TABLE `mst_profile_history` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `long_description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_profile_history`
--

INSERT INTO `mst_profile_history` (`id`, `title`, `short_description`, `long_description`, `image`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'History Of Holy Family Hospital', 'Holy Family Hospital, Mumbai, evolved purely out of the need to serve the complex and growing needs of Mumbai’s suburbs. What started as a private nursing home has since developed into a multi-specialty hospital and medical research centre under the stewardship of two religious congregations.\r\n\r\nThe hospital’s humble beginnings date back to 1942, when Dr Austin Da Silva opened a 10-bed private nursing home called ‘Silverene’ in suburban Bandra. Over the next decade, the healthcare needs of suburban Mumbai grew manifold, and to fill the void for a professional hospital, ‘Silverene’ was handed over to the Medical Mission Sisters in 1953.\r\n\r\nThe congregation expanded the nursing home to accommodate 22 beds and rechristened it as the ‘Holy Family Hospital’. The congregation embraced its new mission with zeal and set a fine tradition in community healthcare with a special emphasis on maternity care. The hospital thus grew from a local, need-based clinic to a modest institution that catered to the general medical needs of Mumbai’s extended suburbs.', 'Over the next two and a half decades, the demographics of Mumbai’s suburbs changed dramatically. They became more complex and as the population grew, so did healthcare requirements.\r\n\r\nAlso, at this juncture, the Medical Mission Sisters preferred to focus on rural rather than urban healthcare. It was time to take another leap of faith. Thus, along with a detailed survey of community health needs, the Medical Mission Sisters passed the baton to the Congregation of the Ursuline Sisters of Mary Immaculate in 1978.\r\n\r\nFunds were raised both locally and abroad under the aegis of Dr (Sr) Maria Giovanna Alberoni, affectionately called ‘Mother Giovanna’. This opened a critical chapter in the institution’s history, marking the transition from a modest nursing home to a hospital that delivered state-of-the-art diagnostics & treatment, emergency care, preventive medicine, and teaching and research initiatives.\r\n\r\nAs the new dream took shape, the foundation stone of a four-storey building was laid in 1982. It was inaugurated on November 17, 1985, as a 120-bed hospital.\r\n\r\nMother Giovanna, a doctor herself, realised that efficient medical care as well as scientific evaluation were prerequisites to maintaining professional standards. She therefore embraced the idea of a research centre, and it was with great pride that she presided over the opening of this prestigious arm of the hospital in 1987.\r\n\r\nProjects undertaken by the Medical Research Centre extend from fertility awareness and natural family planning to the evaluation of hospital facilities such as the value of endoscopic surgery, its pros and cons, as well as studies on hospital post-operative infection and prevalence of dementia in the community.\r\n\r\nApart from the main divisions, the hospital also added more and more specialties and patient facilities, continuously expanding its reach and services to the community. These include high-quality endoscopy, paediatrics, cardiology, respiratory medicine, psychiatry, neurology and neurosurgery. With an eye on holistic medicine, the hospital also opened a special homeopathic clinic with highly qualified doctors.\r\n\r\nSimultaneously, infrastructure and medical technology were upgraded and the hospital building expanded to become the 268-bed institution it is today.\r\n\r\nDuring its journey, the hospital has achieved several milestones. One of these was the setting up of The Holy Family Heart Institute in 2002, a pioneer in cardiac diagnostics, treatment and research.\r\n\r\nRapidly going from strength to strength, the hospital flagged off three more red-letter days. In April 2005, we inaugurated the Holy Family Institute of Nursing Education; in August 2005; we admitted our first batch of post-graduate DNB resident medical officers.', '282.png', 1, 1, '2023-12-18 11:31:31', 1, '2023-12-18', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_research_academics_about_db`
--

CREATE TABLE `mst_research_academics_about_db` (
  `id` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_research_academics_about_db`
--

INSERT INTO `mst_research_academics_about_db` (`id`, `description`, `image`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, '<p>NBE releases a state-wise list of seats available on their website.</p>\r\n\r\n<p>DNB candidate pays&nbsp;Rs 1,47,500&nbsp;to NBE directly as fees.</p>\r\n\r\n<p>Selected candidates receive a stipend of&nbsp;Rs. 63,000, Rs. 64,000 and Rs. 65,000&nbsp;during their first, second and third years, respectively, with free lodging. Candidates who are admitted to DNB Cardiology (Super Specialty &amp; Critical Care Medicine) receive a stipend of&nbsp;Rs. 70,000, Rs 71,000 and Rs. 72,000&nbsp;respectively.</p>\r\n\r\n<p>Students must stay updated on the NBE website at&nbsp;<a href=\"https://www.natboard.edu.in/\">www.natboard.edu.in</a></p>', '682.jpg', 1, 1, '2024-02-09 09:26:55', 1, '2024-02-09', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_research_academics_cps`
--

CREATE TABLE `mst_research_academics_cps` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_research_academics_cps`
--

INSERT INTO `mst_research_academics_cps` (`id`, `title`, `description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'College of Physicians & Surgeons of Mumbai (CPS) Courses', '<p>The College of Physicians &amp; Surgeons (CPS), Mumbai, holds courses for various diplomas and degrees and takes regular lectures. Holy Family Hospital was accredited by the CPS to conduct the Diploma in DCH (2010), DA and D-Ortho (2012).</p>\r\n\r\n<p>Teaching Programme at Holy Family Hospital</p>\r\n\r\n<ul>\r\n	<li>The teaching programme at Holy Family Hospital includes lectures, seminars, a journal club, clinics and case presentations.</li>\r\n	<li>The hospital conducts Grand Rounds on the third Saturday of every month with case presentations and discussions by students.</li>\r\n	<li>There are morbidity and mortality discussions, discipline-wise, on a monthly basis.</li>\r\n	<li>On the last Saturday of every month, a CME on a topic of current clinical interest by senior teachers / consultants / outside speakers of repute is held.</li>\r\n</ul>\r\n\r\n<p>Admission for DCH, DA and D-Ortho Courses</p>\r\n\r\n<p>Please follow the centralized admission procedure and NEET is compulsory. Candidates must work as full-time residents for 24 months, which includes 6 months in an allied post in community medicine. In addition, candidates must attend a series of lectures at the CPS in Parel, Mumbai, on payment of a fee.</p>\r\n\r\n<p>Students receive a stipend of Rs. 50,000 and Rs. 51,000 for first and second year respectively with free accommodation.</p>\r\n\r\n<p>For queries, contact the Medical Superintendent on Tel: 62670555 / 62670397.</p>', 1, 1, '2024-02-09 12:20:07', 1, '2024-02-09', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_research_academics_dnb_about_admission`
--

CREATE TABLE `mst_research_academics_dnb_about_admission` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_research_academics_dnb_about_admission`
--

INSERT INTO `mst_research_academics_dnb_about_admission` (`id`, `title`, `description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Admission is through centralized counseling conducted by DNB at Delhi. Available: Seat Matrix at Holy Family Hospital.', '<p>NBE releases a state-wise list of seats available on their website.</p>\r\n\r\n<p>DNB candidate pays&nbsp;Rs 1,47,500&nbsp;to NBE directly as fees.</p>\r\n\r\n<p>Selected candidates receive a stipend of&nbsp;Rs. 63,000, Rs. 64,000 and Rs. 65,000&nbsp;during their first, second and third years, respectively, with free lodging. Candidates who are admitted to DNB Cardiology (Super Specialty &amp; Critical Care Medicine) receive a stipend of&nbsp;Rs. 70,000, Rs 71,000 and Rs. 72,000&nbsp;respectively.</p>\r\n\r\n<p>Students must stay updated on the NBE website at&nbsp;<a href=\"https://www.natboard.edu.in/\">www.natboard.edu.in</a></p>', 1, 1, '2024-02-09 11:03:55', 1, '2024-02-09', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_research_academics_dnb_admission`
--

CREATE TABLE `mst_research_academics_dnb_admission` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `sub_title` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_research_academics_dnb_admission`
--

INSERT INTO `mst_research_academics_dnb_admission` (`id`, `title`, `sub_title`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'General Medicine:', '2', 1, 1, '2024-02-09 11:53:15', 1, '2024-02-08 18:30:00', NULL, '2024-02-09'),
(2, 'General Medicine:', '2', 1, 1, '2024-02-09 11:56:28', 1, '2024-02-08 18:30:00', NULL, NULL),
(3, 'General Surgery:', '1', 1, 1, '2024-02-09 11:56:37', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_research_academics_isccm`
--

CREATE TABLE `mst_research_academics_isccm` (
  `id` int(11) NOT NULL,
  `image` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_research_academics_isccm`
--

INSERT INTO `mst_research_academics_isccm` (`id`, `image`, `description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, '768.png', '<p>Holy Family Hospital, Bandra, has been approved as a training centre for the Indian Collage of Critical Care Medicine (ICCCM) and Post MBBS Certificate Course from July 2015 session onwards, through Indian College of Critical Care Medicine, which is the Educational Division of the Indian Society of Critical Care Medicine.</p>\r\n\r\n<p>The IDCCM is a one year course for MD / MS / DNB candidates and two years for DA / DTCD (Diploma in Tuberculosis and Chest Medicine). MCI recognized or equivalent candidates may apply. The base qualifications must be from a MCI recognized university.</p>\r\n\r\n<p>Two seats are available for IDCCM Course.</p>\r\n\r\n<p>Students shall be trained under their respective teachers / guides. Holy Family Hospital has 70 bedded state-of-the-art ICUs, which are managed by experienced intensivists. The teaching programme at Holy Family Hospital includes lectures, seminars, a journal club, clinics and case presentations. The hospital conducts Grand Rounds on the third Wednesday of every month with case presentations and discussions by students. There are morbidity and mortality discussions, discipline-wise, on a monthly basis. On the last Saturday of every month, a CME on a topic of current clinical interest by senior teachers / consultants / outside speakers of repute is held.</p>\r\n\r\n<p>For queries, contact the Medical Superintendent on</p>\r\n\r\n<p><strong>Tel:</strong>&nbsp;<a href=\"tel:62670555\">62670555</a>&nbsp;/&nbsp;<a href=\"tel:62670555\">62670387</a>&nbsp;(From 09:00 am to 05:00 pm)</p>\r\n\r\n<p><strong>Email:</strong>&nbsp;<a href=\"mailto:hfhacademic@gmail.com\">hfhacademic@gmail.com</a></p>', 1, 1, '2024-02-12 06:38:09', 1, '2024-02-12', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_research_academics_nursing_institute`
--

CREATE TABLE `mst_research_academics_nursing_institute` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_research_academics_nursing_institute`
--

INSERT INTO `mst_research_academics_nursing_institute` (`id`, `title`, `description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Welcome to the Holy Family Institute of Nursing Education', '<p>HFINE is one of India&rsquo;s premiere Nursing Institutes with a state-of-the-art facility located in Kurla which is a unit of Holy Family Hospital, Bandra, Mumbai a super-speciality Hospital. We groom our students in integrated healthcare practices while inculcating a spirit of caring.</p>\r\n\r\n<p>HFINE trains student-nurses with world-class infrastructure at a residential facility at premier Road, Kurla (W) Mumbai.</p>\r\n\r\n<p>We offer a Diploma in General nursing &amp; Midwifery, Basic B.Sc. nursing; Post Basic B.Sc. Nursing courses that is recognized by the Indian Nursing Council and ranks among the best in the country.</p>\r\n\r\n<p>Our student-nurses receive the best clinical training at our Hospital.</p>\r\n\r\n<p>Application for admission are accepted from across the country. HFINE is a minority institution but applicants are not assigned preference on grounds of caste, community or creed.</p>\r\n\r\n<p>For more details please visit:</p>\r\n\r\n<p><a href=\"https://holyfamilyinstituteofnursing.org/nursing_education/index.htm\">https://holyfamilyinstituteofnursing.org/nursing_education/index.htm</a></p>', 1, 1, '2024-02-09 13:15:13', 1, '2024-02-09', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_research_academics_overview`
--

CREATE TABLE `mst_research_academics_overview` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_research_academics_overview`
--

INSERT INTO `mst_research_academics_overview` (`id`, `title`, `description`, `image`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Academics Overview', '<p>Training doctors and keeping them updated on the latest developments in medicine is a priority at Holy Family Hospital. To achieve this objective, we offer two prestigious teaching programmes &ndash; the Diplomate of National Board DNB in five specialties and Diploma of College of Physicians and Surgeons of Mumbai (CPS) in three specialties.</p>\r\n\r\n<p>Both the DNB and CPS programmes are professionally run according to government regulations and include lectures, case discussions, seminars, Grand Rounds and a&nbsp;Continuing Medical Education&nbsp;Programme conducted by our&nbsp;Medical Research Society.</p>', '591.jpg', 1, 1, '2024-02-09 06:40:28', 1, '2024-02-09', NULL, NULL),
(2, 'yjh', 'ythy', '455.jpg', 1, 1, '2024-02-09 06:54:31', NULL, NULL, NULL, '2024-02-09'),
(3, 'yjh', 'ythy', '518.jpg', 1, 1, '2024-02-09 06:57:25', NULL, NULL, NULL, '2024-02-09');

-- --------------------------------------------------------

--
-- Table structure for table `mst_responsibilities`
--

CREATE TABLE `mst_responsibilities` (
  `id` int(11) NOT NULL,
  `patient_responsibilities` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) NOT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_responsibilities`
--

INSERT INTO `mst_responsibilities` (`id`, `patient_responsibilities`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'dfgdf', 1, 1, '2023-12-22 06:08:28', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_rights`
--

CREATE TABLE `mst_rights` (
  `id` int(11) NOT NULL,
  `patient_rights` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_rights`
--

INSERT INTO `mst_rights` (`id`, `patient_rights`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'ghjghj11', 1, 1, '2023-12-22 05:37:47', 1, '2023-12-22', NULL, '2023-12-22'),
(2, 'rohit tiwari', 1, 1, '2023-12-22 05:38:18', 1, '2023-12-22', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_rights_responsibilities_description`
--

CREATE TABLE `mst_rights_responsibilities_description` (
  `id` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `patients_rights_image` text DEFAULT NULL,
  `patients_responsibilities_image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_rights_responsibilities_description`
--

INSERT INTO `mst_rights_responsibilities_description` (`id`, `description`, `patients_rights_image`, `patients_responsibilities_image`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, '<p>Patient care is a two-way street and requires transparency and trust between patient and medical and other staff at the hospital. Effective treatment and patient satisfaction are therefore possible only if patients as well as the personnel treating them observe certain basic principles that foster an environment of trust.</p>\r\n\r\n<p>Also, just as every patient enjoys certain rights and privileges, he / she is obligated to fulfil certain responsibilities. A collaborative approach facilitates both medical and administrative processes.</p>', '740.png', '209.jpg', 1, 1, '2023-12-21 12:52:31', 1, '2023-12-22', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_services`
--

CREATE TABLE `mst_services` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_services`
--

INSERT INTO `mst_services` (`id`, `title`, `image`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'shikha', '446.jpg', 1, 1, '2024-02-08 11:52:25', 1, '2024-02-08', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_society_description`
--

CREATE TABLE `mst_society_description` (
  `id` int(11) NOT NULL,
  `short_description` text DEFAULT NULL,
  `first_title` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) NOT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL,
  `first_description` text DEFAULT NULL,
  `second_title` text DEFAULT NULL,
  `second_description` text DEFAULT NULL,
  `third_title` text DEFAULT NULL,
  `third_description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_society_description`
--

INSERT INTO `mst_society_description` (`id`, `short_description`, `first_title`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`, `first_description`, `second_title`, `second_description`, `third_title`, `third_description`) VALUES
(1, 'The Bandra Holy Family Hospital Society is a public charitable trust under the Public Trusts Registration Office, Greater Bombay Region, Bombay.', 'Particulars', 1, 1, '2023-12-20 07:24:15', 1, '2023-12-20', NULL, NULL, 'PTR No: E – 1077 (Bom)\r\nVide CR No: 602/67', 'Address', 'St Andrew’s Road, Bandra W,\r\nMumbai, Maharashtra.', 'Office-Bearers', 'President – Sr. Lucien\r\nSecretary – Sr. Beena\r\nTreasurer – Sr. Silji');

-- --------------------------------------------------------

--
-- Table structure for table `mst_society_details`
--

CREATE TABLE `mst_society_details` (
  `id` int(11) NOT NULL,
  `objectives_title` text DEFAULT NULL,
  `objectives_description` text DEFAULT NULL,
  `institutions_title` text DEFAULT NULL,
  `institutions_description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) NOT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_society_details`
--

INSERT INTO `mst_society_details` (`id`, `objectives_title`, `objectives_description`, `institutions_title`, `institutions_description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'ghjgh', 'ghjgh', 'ghjgh', 'ghjgh[/]ghgh[/]fhfgfg[/]fghfghfg[/]dfgjg[/]ghjgh[/]ghjgh[/]ghjgh', 1, 1, '2023-12-20 11:06:42', 1, '2023-12-20', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_specialties_category`
--

CREATE TABLE `mst_specialties_category` (
  `id` int(11) NOT NULL,
  `category` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mst_specialties_department`
--

CREATE TABLE `mst_specialties_department` (
  `id` int(11) NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `department` text DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_specialties_department`
--

INSERT INTO `mst_specialties_department` (`id`, `category_id`, `department`, `slug`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 1, 'cardiology', 'cardiology', 1, 1, '2024-02-16 13:10:20', NULL, NULL, NULL, NULL),
(2, 1, 'Dermatology', 'dermatology', 1, 1, '2024-02-17 07:50:39', NULL, NULL, NULL, NULL),
(3, 1, 'Rheumatology', 'rheumatology', 1, 1, '2024-02-17 07:51:14', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_specialties_department_category`
--

CREATE TABLE `mst_specialties_department_category` (
  `id` int(11) NOT NULL,
  `department_id` int(11) DEFAULT NULL,
  `department_category` text DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mst_specialties_department_category_details`
--

CREATE TABLE `mst_specialties_department_category_details` (
  `id` int(11) NOT NULL,
  `department_category_id` int(11) DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mst_specialties_department_details`
--

CREATE TABLE `mst_specialties_department_details` (
  `id` int(11) NOT NULL,
  `department_id` int(11) DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mst_sub_committee`
--

CREATE TABLE `mst_sub_committee` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_sub_committee`
--

INSERT INTO `mst_sub_committee` (`id`, `name`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'fghfgjhgh111', 1, 1, '2023-12-21 04:41:47', 1, '2023-12-21', NULL, '2023-12-21');

-- --------------------------------------------------------

--
-- Table structure for table `mst_testimonial`
--

CREATE TABLE `mst_testimonial` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `designation` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_testimonial`
--

INSERT INTO `mst_testimonial` (`id`, `name`, `image`, `designation`, `description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'Clay Johnson', '338.png', 'Business Director', 'Tanahair is the friendliest and most efficient company I have ever used. The whole thing takes time to introduce the product and as a result puts forward only the best opportunities that really suit you. they help from start to finish to create a great product identity for your company', 1, 1, '2023-12-18 05:26:43', 1, '2024-02-16', NULL, NULL),
(2, 'Clay Johnson', '847.png', 'Business Director', 'Tanahair is the friendliest and most efficient company I have ever used. The whole thing takes time to introduce the product and as a result puts forward only the best opportunities that really suit you. they help from start to finish to create a great product identity for your company', 1, 1, '2023-12-18 05:27:26', 1, '2024-02-16', NULL, NULL),
(3, 'adfg', '868.jpg', 'fgfgh1', 'fghfg', 1, 1, '2023-12-18 05:32:17', 1, '2023-12-18', NULL, '2023-12-18');

-- --------------------------------------------------------

--
-- Table structure for table `mst_type_accommodation`
--

CREATE TABLE `mst_type_accommodation` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_type_accommodation`
--

INSERT INTO `mst_type_accommodation` (`id`, `title`, `description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'dfgdfg', '<p>fghfg shfg sghfgh</p>', 1, 1, '2023-12-21 09:10:53', 1, '2023-12-21', NULL, NULL),
(2, 'dfgdfg', '<p>dd</p>', 1, 1, '2023-12-21 09:11:26', 1, '2023-12-21', NULL, '2023-12-21'),
(3, 'dfgdhfg', '<p>ghfgfg</p>', 1, 1, '2023-12-21 09:20:27', NULL, NULL, NULL, '2023-12-21');

-- --------------------------------------------------------

--
-- Table structure for table `mst_ursuline_sisters`
--

CREATE TABLE `mst_ursuline_sisters` (
  `id` int(11) NOT NULL,
  `short_description` text DEFAULT NULL,
  `highlight` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `first_title` text DEFAULT NULL,
  `first_description` text DEFAULT NULL,
  `second_title` text DEFAULT NULL,
  `second_description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) NOT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_ursuline_sisters`
--

INSERT INTO `mst_ursuline_sisters` (`id`, `short_description`, `highlight`, `description`, `first_title`, `first_description`, `second_title`, `second_description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'The Order of the Ursuline Sisters of Mary Immaculate (UMI), a religious congregation, took over the Holy Family Hospital in 1978. The Order was founded by Sister Brigida Morello in Piacenza, Italy, in 1649. Though it was the Congregation\'s original aim to educate young women who had no access to education, its mission expanded in India to include diverse forms of service - medical, social and pastoral.\r\n\r\nThey arrived in Kerala in 1934 to uplift weaker sections of society in the Malabar region and also ran dispensaries and visited patients at home. This was the UMI\'s foray into medical services. This new vision culminated in the setting up of the Congregation\'s first major hospital in India - Mariampur in Kanpur in Uttar Pradesh, in 1961.', 'Mother Giovanna Alberoni-\r\nLegend of Holy Family Hospital', 'While the UMI opened other medical institutions across the country, they took over the administration of the Holy Family Hospital in Bandra, Mumbai , from the Medical Mission Sisters in 1978. Overseeing this transfer of management and continuing to play a pivotal role in its growth and expansion was Mother Maria Giovanna Alberoni. She was the first UMI Sister to pursue medical studies in India. It was she, along with Sister Bernadina Poomthottam, Msgr Nereus Rodrigues, Dr Faust Pinto and Dr Eustace de Souza, who guided the hospital from a 22-bed nursing home to a full-fledged multi-specialty institution and medical research centre.', 'The Congregation runs the following institutions in India:', '<ul>\r\n	<li>8 major hospitals</li>\r\n	<li>Dispensaries for primary healthcare in remote areas</li>\r\n	<li>1 College of Nursing; 3 Schools of Nursing; 2 Schools of Laboratory Technicians (Of these, 2 major institutions are located in Mumbai: Holy Family Hospital, Mumbai, and the Holy Family Institute of Nursing Education)</li>\r\n</ul>', 'Medical Institutions', '<p>Across India, the Congregation includes many Sister-Doctors, who are engaged in medical services as nurses, pharmacists, laboratory technicians and administrators in UMI-run institutions. Following are the major medical institutions run by the UMI in India:</p>', 1, 1, '2023-12-19 10:29:09', 1, '2023-12-19', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_vision_mission_motto`
--

CREATE TABLE `mst_vision_mission_motto` (
  `id` int(11) NOT NULL,
  `short_description` text DEFAULT NULL,
  `first_title` text DEFAULT NULL,
  `first_description` text DEFAULT NULL,
  `second_title` text DEFAULT NULL,
  `second_description` text DEFAULT NULL,
  `third_title` text DEFAULT NULL,
  `third_description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_vision_mission_motto`
--

INSERT INTO `mst_vision_mission_motto` (`id`, `short_description`, `first_title`, `first_description`, `second_title`, `second_description`, `third_title`, `third_description`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, 'dfsdfsdf121', 'sadfsd', 'sadfsdf', 'dfsdf', 'asdfsdaf11', 'asdfsd', 'sdfsdfsdf111', 1, 1, '2023-12-18 13:05:20', 1, '2023-12-19', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mst_write_to_us`
--

CREATE TABLE `mst_write_to_us` (
  `id` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modify_by` int(11) DEFAULT NULL,
  `modify_dt` text DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_dt` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mst_write_to_us`
--

INSERT INTO `mst_write_to_us` (`id`, `description`, `image`, `status`, `created_by`, `created_dt`, `modify_by`, `modify_dt`, `deleted_by`, `deleted_dt`) VALUES
(1, '<p>Holy Family Hospital, Mumbai, constantly strives to provide quality patient care, personalised service and the best clinical expertise available. But we also welcome constructive criticism. So if you have a complaint &ndash; or a compliment &ndash; we&rsquo;d like to hear from you. Any information you share with us will be kept confidential.</p>\r\n\r\n<p>Our Patient Feedback Form is available with your Nurses&rsquo; Station. After filling it out, you may drop it into the Suggestion Box at the Nurse&rsquo;s Station. Alternatively, you may download the form and email it to us at&nbsp;<a href=\"mailto:feedback@holyfamilyhospital.in\">feedback@holyfamilyhospital.in</a>&nbsp;or post it to us at :</p>\r\n\r\n<p>Holy Family Hospital</p>\r\n\r\n<p>St Andrew&rsquo;s Road,<br />\r\nBandra (West),<br />\r\nMumbai &ndash; 400 050. India.</p>', '134.jpg', 1, 1, '2024-02-01 06:34:06', 1, '2024-02-01', NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_about`
--
ALTER TABLE `mst_about`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_about_count_detail`
--
ALTER TABLE `mst_about_count_detail`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_about_detail`
--
ALTER TABLE `mst_about_detail`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_about_info`
--
ALTER TABLE `mst_about_info`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_about_medical_records`
--
ALTER TABLE `mst_about_medical_records`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_about_medical_service`
--
ALTER TABLE `mst_about_medical_service`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_about_newsletter`
--
ALTER TABLE `mst_about_newsletter`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_about_other_services`
--
ALTER TABLE `mst_about_other_services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_accommodation_description`
--
ALTER TABLE `mst_accommodation_description`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_accommodation_slider`
--
ALTER TABLE `mst_accommodation_slider`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_accreditation_awards`
--
ALTER TABLE `mst_accreditation_awards`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_accreditation_description`
--
ALTER TABLE `mst_accreditation_description`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_banner`
--
ALTER TABLE `mst_banner`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_books_periodicals`
--
ALTER TABLE `mst_books_periodicals`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_committee`
--
ALTER TABLE `mst_committee`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_committee_description`
--
ALTER TABLE `mst_committee_description`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_contact_us`
--
ALTER TABLE `mst_contact_us`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_empannelled_insurance`
--
ALTER TABLE `mst_empannelled_insurance`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_empannelled_insurance_description`
--
ALTER TABLE `mst_empannelled_insurance_description`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_general_hospital`
--
ALTER TABLE `mst_general_hospital`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_health_centers_services`
--
ALTER TABLE `mst_health_centers_services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_hospital_multi_specialty`
--
ALTER TABLE `mst_hospital_multi_specialty`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_infrastructure`
--
ALTER TABLE `mst_infrastructure`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_library_services`
--
ALTER TABLE `mst_library_services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_library_services_description`
--
ALTER TABLE `mst_library_services_description`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_library_service_description`
--
ALTER TABLE `mst_library_service_description`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_management_committee`
--
ALTER TABLE `mst_management_committee`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_medical_contact_description`
--
ALTER TABLE `mst_medical_contact_description`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_medical_contact_details`
--
ALTER TABLE `mst_medical_contact_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_news`
--
ALTER TABLE `mst_news`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_newsletter`
--
ALTER TABLE `mst_newsletter`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_opd_schedule`
--
ALTER TABLE `mst_opd_schedule`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_our_values`
--
ALTER TABLE `mst_our_values`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_pages`
--
ALTER TABLE `mst_pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_patients_facility`
--
ALTER TABLE `mst_patients_facility`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_profile_history`
--
ALTER TABLE `mst_profile_history`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_research_academics_about_db`
--
ALTER TABLE `mst_research_academics_about_db`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_research_academics_cps`
--
ALTER TABLE `mst_research_academics_cps`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_research_academics_dnb_about_admission`
--
ALTER TABLE `mst_research_academics_dnb_about_admission`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_research_academics_dnb_admission`
--
ALTER TABLE `mst_research_academics_dnb_admission`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_research_academics_isccm`
--
ALTER TABLE `mst_research_academics_isccm`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_research_academics_nursing_institute`
--
ALTER TABLE `mst_research_academics_nursing_institute`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_research_academics_overview`
--
ALTER TABLE `mst_research_academics_overview`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_responsibilities`
--
ALTER TABLE `mst_responsibilities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_rights`
--
ALTER TABLE `mst_rights`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_rights_responsibilities_description`
--
ALTER TABLE `mst_rights_responsibilities_description`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_services`
--
ALTER TABLE `mst_services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_society_description`
--
ALTER TABLE `mst_society_description`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_society_details`
--
ALTER TABLE `mst_society_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_specialties_category`
--
ALTER TABLE `mst_specialties_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_specialties_department`
--
ALTER TABLE `mst_specialties_department`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_specialties_department_category`
--
ALTER TABLE `mst_specialties_department_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_specialties_department_category_details`
--
ALTER TABLE `mst_specialties_department_category_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_specialties_department_details`
--
ALTER TABLE `mst_specialties_department_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_sub_committee`
--
ALTER TABLE `mst_sub_committee`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_testimonial`
--
ALTER TABLE `mst_testimonial`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_type_accommodation`
--
ALTER TABLE `mst_type_accommodation`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_ursuline_sisters`
--
ALTER TABLE `mst_ursuline_sisters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_vision_mission_motto`
--
ALTER TABLE `mst_vision_mission_motto`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mst_write_to_us`
--
ALTER TABLE `mst_write_to_us`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `mst_about`
--
ALTER TABLE `mst_about`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_about_count_detail`
--
ALTER TABLE `mst_about_count_detail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_about_detail`
--
ALTER TABLE `mst_about_detail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_about_info`
--
ALTER TABLE `mst_about_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_about_medical_records`
--
ALTER TABLE `mst_about_medical_records`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_about_medical_service`
--
ALTER TABLE `mst_about_medical_service`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_about_newsletter`
--
ALTER TABLE `mst_about_newsletter`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_about_other_services`
--
ALTER TABLE `mst_about_other_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mst_accommodation_description`
--
ALTER TABLE `mst_accommodation_description`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mst_accommodation_slider`
--
ALTER TABLE `mst_accommodation_slider`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_accreditation_awards`
--
ALTER TABLE `mst_accreditation_awards`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mst_accreditation_description`
--
ALTER TABLE `mst_accreditation_description`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_banner`
--
ALTER TABLE `mst_banner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_books_periodicals`
--
ALTER TABLE `mst_books_periodicals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_committee`
--
ALTER TABLE `mst_committee`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_committee_description`
--
ALTER TABLE `mst_committee_description`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_contact_us`
--
ALTER TABLE `mst_contact_us`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_empannelled_insurance`
--
ALTER TABLE `mst_empannelled_insurance`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mst_empannelled_insurance_description`
--
ALTER TABLE `mst_empannelled_insurance_description`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_general_hospital`
--
ALTER TABLE `mst_general_hospital`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_health_centers_services`
--
ALTER TABLE `mst_health_centers_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_hospital_multi_specialty`
--
ALTER TABLE `mst_hospital_multi_specialty`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mst_infrastructure`
--
ALTER TABLE `mst_infrastructure`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mst_library_services`
--
ALTER TABLE `mst_library_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_library_services_description`
--
ALTER TABLE `mst_library_services_description`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_library_service_description`
--
ALTER TABLE `mst_library_service_description`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_management_committee`
--
ALTER TABLE `mst_management_committee`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_medical_contact_description`
--
ALTER TABLE `mst_medical_contact_description`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_medical_contact_details`
--
ALTER TABLE `mst_medical_contact_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `mst_news`
--
ALTER TABLE `mst_news`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mst_newsletter`
--
ALTER TABLE `mst_newsletter`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_opd_schedule`
--
ALTER TABLE `mst_opd_schedule`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mst_our_values`
--
ALTER TABLE `mst_our_values`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `mst_pages`
--
ALTER TABLE `mst_pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `mst_patients_facility`
--
ALTER TABLE `mst_patients_facility`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_profile_history`
--
ALTER TABLE `mst_profile_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_research_academics_about_db`
--
ALTER TABLE `mst_research_academics_about_db`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_research_academics_cps`
--
ALTER TABLE `mst_research_academics_cps`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_research_academics_dnb_about_admission`
--
ALTER TABLE `mst_research_academics_dnb_about_admission`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_research_academics_dnb_admission`
--
ALTER TABLE `mst_research_academics_dnb_admission`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mst_research_academics_isccm`
--
ALTER TABLE `mst_research_academics_isccm`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_research_academics_nursing_institute`
--
ALTER TABLE `mst_research_academics_nursing_institute`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_research_academics_overview`
--
ALTER TABLE `mst_research_academics_overview`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mst_responsibilities`
--
ALTER TABLE `mst_responsibilities`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_rights`
--
ALTER TABLE `mst_rights`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_rights_responsibilities_description`
--
ALTER TABLE `mst_rights_responsibilities_description`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_services`
--
ALTER TABLE `mst_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_society_description`
--
ALTER TABLE `mst_society_description`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_society_details`
--
ALTER TABLE `mst_society_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_specialties_category`
--
ALTER TABLE `mst_specialties_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mst_specialties_department`
--
ALTER TABLE `mst_specialties_department`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mst_specialties_department_category`
--
ALTER TABLE `mst_specialties_department_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mst_specialties_department_category_details`
--
ALTER TABLE `mst_specialties_department_category_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mst_specialties_department_details`
--
ALTER TABLE `mst_specialties_department_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mst_sub_committee`
--
ALTER TABLE `mst_sub_committee`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mst_testimonial`
--
ALTER TABLE `mst_testimonial`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mst_type_accommodation`
--
ALTER TABLE `mst_type_accommodation`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mst_ursuline_sisters`
--
ALTER TABLE `mst_ursuline_sisters`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mst_vision_mission_motto`
--
ALTER TABLE `mst_vision_mission_motto`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_write_to_us`
--
ALTER TABLE `mst_write_to_us`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

