--
-- Host: apps.truebitstech.com    Database: tibanova_staging
-- ------------------------------------------------------


--
-- Table structure for table `admission`
--

CREATE TABLE `admission` (
  `Admision_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) NOT NULL,
  `Hospital_Ward_ID` int(11) DEFAULT NULL,
  `Bed_ID` int(11) DEFAULT NULL,
  `Admission_Employee_ID` int(11) DEFAULT NULL,
  `Admission_Supervisor_ID` int(11) DEFAULT NULL,
  `Discharge_Employee_ID` int(11) DEFAULT NULL,
  `Discharge_Supervisor_ID` int(11) DEFAULT NULL,
  `Admission_Date_Time` datetime DEFAULT NULL,
  `Discharge_Date_Time` datetime DEFAULT NULL,
  `Admission_Status` varchar(20) DEFAULT NULL,
  `Discharge_Clearance_Status` varchar(20) NOT NULL DEFAULT 'not cleared',
  `Clearance_Date_Time` datetime DEFAULT NULL,
  `Cash_Bill_Status` varchar(20) NOT NULL DEFAULT 'pending',
  `Credit_Bill_Status` varchar(20) NOT NULL DEFAULT 'pending',
  `Cash_Clearer_ID` int(11) DEFAULT NULL COMMENT 'Employee cleared Cash bill',
  `Credit_Clearer_ID` int(11) DEFAULT NULL COMMENT 'Employee cleared Credit bill',
  `Discharge_Reason_ID` int(11) DEFAULT NULL,
  `pending_set_time` datetime DEFAULT NULL,
  `pending_setter` int(11) DEFAULT NULL,
  `District` varchar(50) DEFAULT NULL,
  `Ward` varchar(50) NOT NULL,
  `Admission_Claim_Form_Number` varchar(30) DEFAULT NULL,
  `Discharge_Claim_Form_Number` varchar(20) DEFAULT NULL,
  `Folio_Number` int(11) NOT NULL,
  `Office_Area` varchar(50) DEFAULT NULL,
  `Office_Plot_Number` varchar(50) DEFAULT NULL,
  `Office_Street` varchar(50) DEFAULT NULL,
  `Office_Phone` varchar(50) DEFAULT NULL,
  `Kin_Name` varchar(60) NOT NULL,
  `Kin_Relationship` varchar(20) NOT NULL,
  `Kin_Phone` varchar(20) NOT NULL,
  `Kin_Area` varchar(50) DEFAULT NULL,
  `Kin_Street` varchar(30) DEFAULT NULL,
  `Kin_Plot_Number` varchar(30) DEFAULT NULL,
  `Kin_Address` varchar(30) DEFAULT NULL,
  `Check_In_ID` int(11) NOT NULL,
  `Cash_Clearance_Date_Time` datetime DEFAULT NULL,
  `Credit_Clearance_Date_Time` datetime DEFAULT NULL,
  `Approval_Date_Time` datetime DEFAULT NULL,
  `Approver_ID` int(11) DEFAULT NULL,
  `by_pass_cash_bill` varchar(1) DEFAULT '0',
  `by_pass_admission_charges` varchar(1) NOT NULL,
  PRIMARY KEY (`Admision_ID`),
  KEY `Hospital_Ward_ID` (`Hospital_Ward_ID`),
  KEY `District_ID` (`District`),
  KEY `Admission_Employee_ID` (`Admission_Employee_ID`),
  KEY `Admission_Supervisor_ID` (`Admission_Supervisor_ID`),
  KEY `Discharge_Employee_ID` (`Discharge_Employee_ID`),
  KEY `Discharge_Supervisor_ID` (`Discharge_Supervisor_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `Discharge_Reason_ID` (`Discharge_Reason_ID`),
  KEY `Hospital_Ward_ID_2` (`Hospital_Ward_ID`),
  KEY `Bed_ID` (`Bed_ID`),
  KEY `Admission_Employee_ID_2` (`Admission_Employee_ID`),
  KEY `Admission_Supervisor_ID_2` (`Admission_Supervisor_ID`),
  KEY `Discharge_Employee_ID_2` (`Discharge_Employee_ID`),
  KEY `Discharge_Supervisor_ID_2` (`Discharge_Supervisor_ID`),
  KEY `Cash_Clearer_ID` (`Cash_Clearer_ID`),
  KEY `Credit_Clearer_ID` (`Credit_Clearer_ID`),
  KEY `pending_setter` (`pending_setter`),
  KEY `admission_check_in_id_detials_foreign` (`Check_In_ID`),
  CONSTRAINT `admission_check_in_detials_id_foreign` FOREIGN KEY (`Check_In_ID`) REFERENCES `patient_visit_details` (`Check_In_ID`),
  CONSTRAINT `admission_ibfk_1` FOREIGN KEY (`Registration_ID`) REFERENCES `patient` (`Registration_ID`),
  CONSTRAINT `admission_ibfk_10` FOREIGN KEY (`Credit_Clearer_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `admission_ibfk_2` FOREIGN KEY (`Hospital_Ward_ID`) REFERENCES `ward` (`Hospital_Ward_ID`),
  CONSTRAINT `admission_ibfk_3` FOREIGN KEY (`Bed_ID`) REFERENCES `ward_bed` (`Bed_ID`),
  CONSTRAINT `admission_ibfk_4` FOREIGN KEY (`Admission_Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `admission_ibfk_5` FOREIGN KEY (`Discharge_Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `admission_ibfk_6` FOREIGN KEY (`Discharge_Supervisor_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `admission_ibfk_7` FOREIGN KEY (`Discharge_Reason_ID`) REFERENCES `discharge_reason` (`Discharge_Reason_ID`),
  CONSTRAINT `admission_ibfk_8` FOREIGN KEY (`Admission_Supervisor_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `admission_ibfk_9` FOREIGN KEY (`Cash_Clearer_ID`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Table structure for table `appointment`
--

CREATE TABLE `appointment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patient_id` int(11) NOT NULL,
  `employee_id` int(255) NOT NULL,
  `appointment_description` varchar(255) NOT NULL,
  `appointment_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `appointment_patient_id_foreign` (`patient_id`),
  KEY `appointment_employee_id_foreign` (`employee_id`),
  CONSTRAINT `appointment_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `appointment_patient_id_foreign` FOREIGN KEY (`patient_id`) REFERENCES `patient` (`Registration_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Table structure for table `approval_employee`
--

CREATE TABLE `approval_employee` (
  `Employee_ID` int(11) NOT NULL DEFAULT '0',
  `Approval_ID` int(11) NOT NULL DEFAULT '0',
  `Procurement_Type` varchar(50) NOT NULL,
  PRIMARY KEY (`Employee_ID`,`Approval_ID`),
  KEY `Approval_ID` (`Approval_ID`),
  CONSTRAINT `approval_employee_ibfk_1` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `approval_employee_ibfk_2` FOREIGN KEY (`Approval_ID`) REFERENCES `approval_level` (`Approval_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `approval_level`
--

CREATE TABLE `approval_level` (
  `Approval_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Approval_Title` varchar(30) NOT NULL,
  `Approval_Number` int(11) NOT NULL,
  `Procurement_Type` varchar(50) NOT NULL,
  PRIMARY KEY (`Approval_ID`),
  UNIQUE KEY `Approval_ID` (`Approval_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

--
-- Table structure for table `attachment`
--

CREATE TABLE `attachment` (
  `Attachment_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Description` text,
  `Check_In_Type` varchar(50) DEFAULT NULL,
  `Attachment_Url` varchar(200) DEFAULT NULL,
  `Attachment_Date` datetime DEFAULT NULL,
  `item_list_cache_id` int(11) NOT NULL,
  `payment_item_list_id` int(11) NOT NULL,
  `image_name_flag` varchar(200) NOT NULL,
  PRIMARY KEY (`Attachment_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  CONSTRAINT `attachment_ibfk_1` FOREIGN KEY (`Registration_ID`) REFERENCES `patient` (`Registration_ID`),
  CONSTRAINT `attachment_ibfk_2` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `audit_log`
--

CREATE TABLE `audit_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=995 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `audit_trail`
--

CREATE TABLE `audit_trail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `audit_log_id` int(10) unsigned NOT NULL,
  `employee_id` int(10) NOT NULL,
  `pre_data` text COLLATE utf8_unicode_ci,
  `post_data` text COLLATE utf8_unicode_ci,
  `ip_address` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mac_address` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pc_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_and_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_trail_audit_log_id_foreign` (`audit_log_id`),
  CONSTRAINT `audit_trail_audit_log_id_foreign` FOREIGN KEY (`audit_log_id`) REFERENCES `audit_log` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6533 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `baby_care`
--

CREATE TABLE `baby_care` (
  `baby_care_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `consultation_id` int(11) DEFAULT NULL,
  `babywho` varchar(50) NOT NULL,
  `dob` varchar(50) NOT NULL,
  `time_of_birth` varchar(20) NOT NULL,
  `apgarscore` varchar(50) NOT NULL,
  `sex` varchar(10) NOT NULL,
  `weight` varchar(100) NOT NULL,
  `length` varchar(100) NOT NULL,
  `type_of_delivery` varchar(100) NOT NULL,
  `head_circum_chest` varchar(100) NOT NULL,
  `saved_date` datetime DEFAULT NULL,
  `Admission_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`baby_care_id`),
  KEY `parent_id` (`parent_id`,`employee_id`,`consultation_id`),
  KEY `consultation_id` (`consultation_id`),
  KEY `employee_id` (`employee_id`),
  KEY `baby_care_admission_id_foreign` (`Admission_ID`),
  CONSTRAINT `baby_care_admission_id_foreign` FOREIGN KEY (`Admission_ID`) REFERENCES `admission` (`Admision_ID`),
  CONSTRAINT `baby_care_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `patient` (`Registration_ID`),
  CONSTRAINT `baby_care_ibfk_2` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `baby_care_ibfk_3` FOREIGN KEY (`consultation_id`) REFERENCES `clinical_note` (`consultation_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `baby_care_health`
--

CREATE TABLE `baby_care_health` (
  `baby_care_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `date_saved` datetime NOT NULL,
  `room_temp` varchar(100) NOT NULL,
  `rect_temp` varchar(100) NOT NULL,
  `bowel` varchar(100) NOT NULL,
  `urine` varchar(100) NOT NULL,
  `vomiting` varchar(100) NOT NULL,
  `feed` varchar(100) NOT NULL,
  `treatment` varchar(100) NOT NULL,
  `remarks` varchar(100) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  KEY `employee_id` (`employee_id`),
  CONSTRAINT `baby_care_health_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `branch`
--

CREATE TABLE `branch` (
  `Branch_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Branch_Name` varchar(300) NOT NULL,
  `BannerLink` varchar(200) DEFAULT NULL,
  `Company_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Branch_ID`),
  UNIQUE KEY `Branch_Name` (`Branch_Name`),
  KEY `Company_ID` (`Company_ID`),
  CONSTRAINT `branch_ibfk_2` FOREIGN KEY (`Company_ID`) REFERENCES `company` (`Company_ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Table structure for table `branch_employee`
--

CREATE TABLE `branch_employee` (
  `Employee_ID` int(11) NOT NULL DEFAULT '0',
  `Branch_ID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Employee_ID`,`Branch_ID`),
  KEY `Branch_ID` (`Branch_ID`),
  CONSTRAINT `branch_employee_ibfk_1` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `branch_employee_ibfk_2` FOREIGN KEY (`Branch_ID`) REFERENCES `branch` (`Branch_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `broadcast_message`
--

CREATE TABLE `broadcast_message` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `message` text NOT NULL,
  `status` int(1) NOT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Table structure for table `budget`
--

CREATE TABLE `budget` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `budget_name` varchar(50) NOT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `budget_items`
--

CREATE TABLE `budget_items` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Item_ID` int(11) unsigned NOT NULL,
  `Budget_ID` int(11) unsigned NOT NULL,
  `quantity` varchar(50) DEFAULT NULL,
  `price` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `budget_items_budget_id_foreign` (`Budget_ID`),
  KEY `budget_items_item_id_foreign` (`Item_ID`),
  CONSTRAINT `budget_items_budget_id_foreign` FOREIGN KEY (`Budget_ID`) REFERENCES `budget` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `cause_of_injury`
--

CREATE TABLE `cause_of_injury` (
  `hosp_course_injury_ID` int(11) NOT NULL AUTO_INCREMENT,
  `course_injury` varchar(100) NOT NULL,
  `Branch_ID` int(11) NOT NULL,
  `date_saved` datetime NOT NULL,
  `Employee_ID` int(11) NOT NULL,
  PRIMARY KEY (`hosp_course_injury_ID`),
  UNIQUE KEY `consultation_Type` (`course_injury`),
  UNIQUE KEY `consultation_Type_2` (`course_injury`),
  KEY `Branch_ID` (`Branch_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  CONSTRAINT `cause_of_injury_ibfk_1` FOREIGN KEY (`Branch_ID`) REFERENCES `branch` (`Branch_ID`),
  CONSTRAINT `cause_of_injury_ibfk_2` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `claim_batch`
--

CREATE TABLE `claim_batch` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sponsor_id` int(11) NOT NULL,
  `claim_batch` text,
  `claim_month` int(11) DEFAULT NULL,
  `claim_year` int(11) DEFAULT NULL,
  `claim_month_serial` text,
  `claim_status` varchar(1) DEFAULT '1',
  `claim_system` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `claim_batch_sponsor_id_foreign` (`sponsor_id`),
  CONSTRAINT `claim_batch_sponsor_id_foreign` FOREIGN KEY (`sponsor_id`) REFERENCES `insurer` (`Sponsor_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

--
-- Table structure for table `claim_item`
--

CREATE TABLE `claim_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sponsor_id` int(11) NOT NULL,
  `item_code` text,
  `item_name` text,
  `item_strength` varchar(100) DEFAULT NULL,
  `item_dosage` varchar(100) DEFAULT NULL,
  `need_approval` varchar(1) DEFAULT '0',
  `allow_price_override` int(1) NOT NULL,
  `category_code` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `claim_item_sponsor_id_foreign` (`sponsor_id`),
  CONSTRAINT `claim_item_sponsor_id_foreign` FOREIGN KEY (`sponsor_id`) REFERENCES `insurer` (`Sponsor_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2609 DEFAULT CHARSET=latin1;

--
-- Table structure for table `claim_item_price`
--

CREATE TABLE `claim_item_price` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `claim_item_id` int(11) NOT NULL,
  `benefit_package_code` varchar(100) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `conversion_quantity` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `claim_item__price_claim_item_id_foreign` (`claim_item_id`),
  CONSTRAINT `claim_item__price_claim_item_id_foreign` FOREIGN KEY (`claim_item_id`) REFERENCES `claim_item` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1301 DEFAULT CHARSET=latin1;

--
-- Table structure for table `claim_process_claim_progress_status`
--

CREATE TABLE `claim_process_claim_progress_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `check_in_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `progress_status` int(11) NOT NULL,
  `progress_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `claim_process_claim_progress_status_check_in_id_foreign` (`check_in_id`),
  KEY `claim_process_claim_progress_status_employee_id_foreign` (`employee_id`),
  CONSTRAINT `claim_process_claim_progress_status_check_in_id_foreign` FOREIGN KEY (`check_in_id`) REFERENCES `patient_visit` (`Check_In_ID`),
  CONSTRAINT `claim_process_claim_progress_status_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Table structure for table `claim_process_map_sponsor_items`
--

CREATE TABLE `claim_process_map_sponsor_items` (
  `sponsor_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `mapped_item_id` int(11) NOT NULL,
  KEY `claim_process_map_sponsor_items_sponsor_id_foreign` (`sponsor_id`),
  KEY `claim_process_map_sponsor_items_item_id_foreign` (`item_id`),
  CONSTRAINT `claim_process_map_sponsor_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `product` (`Item_ID`),
  CONSTRAINT `claim_process_map_sponsor_items_sponsor_id_foreign` FOREIGN KEY (`sponsor_id`) REFERENCES `insurer` (`Sponsor_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `claim_process_status_employee`
--

CREATE TABLE `claim_process_status_employee` (
  `employee_id` int(11) NOT NULL,
  `claim_process_status` int(11) NOT NULL,
  KEY `claim_process_status_employee_employee_id_foreign` (`employee_id`),
  CONSTRAINT `claim_process_status_employee_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `clinic`
--

CREATE TABLE `clinic` (
  `Clinic_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Clinic_Name` varchar(150) NOT NULL,
  `Nature_Of_Clinic` varchar(120) NOT NULL,
  `Clinic_Status` varchar(20) NOT NULL DEFAULT 'Available',
  PRIMARY KEY (`Clinic_ID`),
  UNIQUE KEY `Clinic_Name` (`Clinic_Name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Table structure for table `clinic_assign_consultation_category_fee`
--

CREATE TABLE `clinic_assign_consultation_category_fee` (
  `id` int(11) NOT NULL,
  `Clinic_ID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `clinic_employee`
--

CREATE TABLE `clinic_employee` (
  `Clinic_ID` int(11) NOT NULL DEFAULT '0',
  `Employee_ID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Clinic_ID`,`Employee_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  CONSTRAINT `clinic_employee_ibfk_1` FOREIGN KEY (`Clinic_ID`) REFERENCES `clinic` (`Clinic_ID`),
  CONSTRAINT `clinic_employee_ibfk_2` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `clinical_note`
--

CREATE TABLE `clinical_note` (
  `consultation_ID` int(11) NOT NULL AUTO_INCREMENT,
  `employee_ID` int(11) DEFAULT NULL,
  `Registration_ID` int(11) DEFAULT NULL,
  `Patient_Payment_Item_List_ID` int(11) DEFAULT NULL,
  `maincomplain` text,
  `firstsymptom_date` text,
  `history_present_illness` text,
  `review_of_other_systems` text,
  `general_observation` text,
  `systemic_observation` text,
  `provisional_diagnosis` int(11) DEFAULT NULL,
  `diferential_diagnosis` int(11) DEFAULT NULL,
  `Comment_For_Laboratory` text,
  `Comment_For_Radiology` text,
  `Comments_For_Procedure` text NOT NULL,
  `Comments_For_Surgery` text NOT NULL,
  `investigation_comments` text,
  `diagnosis` int(11) DEFAULT NULL,
  `remarks` text,
  `course_of_injuries` int(11) DEFAULT NULL,
  `Process_Status` varchar(20) NOT NULL DEFAULT 'pending',
  `Consultation_Date_And_Time` datetime DEFAULT NULL,
  `Patient_Type` varchar(20) DEFAULT NULL,
  `Payment_Cache_ID` int(11) DEFAULT NULL,
  `Comments_For_Pharmacy` text NOT NULL,
  `Require_Spectacle` varchar(2) NOT NULL,
  `Check_In_ID` int(11) DEFAULT NULL,
  `Cash_Payment_Cache_ID` int(11) DEFAULT NULL,
  `Need_Dialysis` varchar(2) DEFAULT NULL,
  `Need_ED` varchar(2) DEFAULT NULL,
  `Allergies` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`consultation_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `Patient_Payment_Item_List_ID` (`Patient_Payment_Item_List_ID`),
  KEY `employee_ID` (`employee_ID`),
  KEY `Cash_Payment_Cache_ID` (`Cash_Payment_Cache_ID`),
  KEY `Check_In_ID` (`Check_In_ID`),
  KEY `Payment_Cache_ID` (`Payment_Cache_ID`),
  CONSTRAINT `clinical_note_ibfk_1` FOREIGN KEY (`Registration_ID`) REFERENCES `patient` (`Registration_ID`),
  CONSTRAINT `clinical_note_ibfk_2` FOREIGN KEY (`Patient_Payment_Item_List_ID`) REFERENCES `sales_items` (`Patient_Payment_Item_List_ID`),
  CONSTRAINT `clinical_note_ibfk_3` FOREIGN KEY (`employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `clinical_note_ibfk_4` FOREIGN KEY (`Cash_Payment_Cache_ID`) REFERENCES `orders` (`Payment_Cache_ID`),
  CONSTRAINT `clinical_note_ibfk_5` FOREIGN KEY (`Check_In_ID`) REFERENCES `patient_visit` (`Check_In_ID`),
  CONSTRAINT `clinical_note_ibfk_6` FOREIGN KEY (`Payment_Cache_ID`) REFERENCES `orders` (`Payment_Cache_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=latin1;

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `Company_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Company_Name` varchar(300) NOT NULL,
  PRIMARY KEY (`Company_ID`),
  UNIQUE KEY `Company_Name` (`Company_Name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Table structure for table `configuration`
--

CREATE TABLE `configuration` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `modified_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `modified_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `configuration_option`
--

CREATE TABLE `configuration_option` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `option_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sort_value` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `configuration_id` int(10) unsigned NOT NULL,
  `created_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `modified_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `modified_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `configuration_option_configuration_id_foreign` (`configuration_id`),
  CONSTRAINT `configuration_option_configuration_id_foreign` FOREIGN KEY (`configuration_id`) REFERENCES `configuration` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3168 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `Country_ID` int(12) NOT NULL AUTO_INCREMENT,
  `Country_Name` varchar(100) NOT NULL,
  `Default_Status` varchar(1) DEFAULT 'N',
  `phone_code` varchar(3) DEFAULT NULL,
  `phone_prefix` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`Country_ID`),
  UNIQUE KEY `Country_ID` (`Country_ID`),
  UNIQUE KEY `Country_Name` (`Country_Name`),
  UNIQUE KEY `Country_Name_2` (`Country_Name`),
  UNIQUE KEY `Country_Name_3` (`Country_Name`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `currency_id` int(11) NOT NULL AUTO_INCREMENT,
  `currency_name` varchar(100) NOT NULL,
  `currency_code` varchar(100) NOT NULL,
  `currency_symbol` varchar(100) NOT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `date_modified` datetime NOT NULL,
  PRIMARY KEY (`currency_id`),
  UNIQUE KEY `currency_name` (`currency_name`),
  KEY `employee_id` (`employee_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Table structure for table `death_certificate`
--

CREATE TABLE `death_certificate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patient_id` int(11) NOT NULL,
  `patient_name` text NOT NULL,
  `patient_address` text NOT NULL,
  `age` varchar(10) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `death_type` varchar(2) NOT NULL DEFAULT '2',
  `date_and_time_of_death` datetime NOT NULL,
  `cause_of_death_a` text NOT NULL,
  `cause_of_death_b` text NOT NULL,
  `cause_of_death_c` text NOT NULL,
  `cause_of_death_other` text NOT NULL,
  `clinical_note_id` int(11) NOT NULL,
  `ward_round_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Table structure for table `death_remark`
--

CREATE TABLE `death_remark` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patient_id` int(11) NOT NULL,
  `death_type` varchar(2) NOT NULL DEFAULT '2',
  `date_and_time_of_death` datetime NOT NULL,
  `death_remark` text NOT NULL,
  `clinical_note_id` int(11) NOT NULL,
  `ward_round_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Table structure for table `debt`
--

CREATE TABLE `debt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sponsor_id` int(11) NOT NULL,
  `invoice_number` varchar(50) DEFAULT NULL,
  `invoice_date` date NOT NULL,
  `invoice_amount` float NOT NULL,
  `status` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `delivery_date` date DEFAULT NULL,
  `extended_due_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `debt_created_by_foreign` (`created_by`),
  KEY `debt_sponsor_id_foreign` (`sponsor_id`),
  CONSTRAINT `debt_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `debt_sponsor_id_foreign` FOREIGN KEY (`sponsor_id`) REFERENCES `insurer` (`Sponsor_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `Department_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Department_Name` varchar(100) NOT NULL,
  `Department_Location` varchar(100) NOT NULL,
  `Branch_ID` int(11) NOT NULL,
  PRIMARY KEY (`Department_ID`),
  UNIQUE KEY `Department_Name` (`Department_Name`),
  KEY `Branch_ID` (`Branch_ID`),
  KEY `Branch_ID_2` (`Branch_ID`),
  CONSTRAINT `department_ibfk_1` FOREIGN KEY (`Branch_ID`) REFERENCES `branch` (`Branch_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=latin1;

--
-- Table structure for table `dialysis_dialysis_orders`
--

CREATE TABLE `dialysis_dialysis_orders` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Employee_ID` int(11) NOT NULL,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL,
  `create_date` datetime NOT NULL,
  `dialyzer` varchar(50) NOT NULL,
  `dialysate` varchar(50) NOT NULL,
  `cannula_size` varchar(50) NOT NULL,
  `sodium_remodelling` varchar(50) NOT NULL,
  `potassium` varchar(50) NOT NULL,
  `hours_of_dialysis` varchar(50) NOT NULL,
  `weight_loss` varchar(50) NOT NULL,
  `transfusion` varchar(50) NOT NULL,
  `blood_group` varchar(50) NOT NULL,
  `no_of_units` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Payment_Item_Cache_List_ID` (`Payment_Item_Cache_List_ID`),
  CONSTRAINT `dialysis_dialysis_orders_ibfk_1` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `dialysis_dialysis_orders_ibfk_2` FOREIGN KEY (`Payment_Item_Cache_List_ID`) REFERENCES `orders_items` (`Payment_Item_Cache_List_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `dialysis_heparain`
--

CREATE TABLE `dialysis_heparain` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Employee_ID` int(11) NOT NULL,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL,
  `create_date` datetime NOT NULL,
  `type` varchar(50) NOT NULL,
  `initial_bolus_unit` varchar(50) NOT NULL,
  `unit_hr` varchar(50) NOT NULL,
  `infusion_bolus` varchar(50) NOT NULL,
  `stop_time` varchar(50) NOT NULL,
  `cvc_post_instil` varchar(50) NOT NULL,
  `arterial` varchar(50) NOT NULL,
  `venous` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Payment_Item_Cache_List_ID` (`Payment_Item_Cache_List_ID`),
  CONSTRAINT `dialysis_heparain_ibfk_1` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `dialysis_heparain_ibfk_2` FOREIGN KEY (`Payment_Item_Cache_List_ID`) REFERENCES `orders_items` (`Payment_Item_Cache_List_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `dialysis_machine_assessment`
--

CREATE TABLE `dialysis_machine_assessment` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Employee_ID` int(11) NOT NULL,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL,
  `create_date` datetime NOT NULL,
  `conductivity_machine` varchar(50) NOT NULL,
  `ph_machine` varchar(50) NOT NULL,
  `temperature_machine` varchar(50) NOT NULL,
  `positive_preference_test` varchar(50) NOT NULL,
  `negative_residual_test` varchar(50) NOT NULL,
  `dialyzer` varchar(50) NOT NULL,
  `alarm_test` varchar(50) NOT NULL,
  `air_detector_on` varchar(50) NOT NULL,
  `uf_system` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Payment_Item_Cache_List_ID` (`Payment_Item_Cache_List_ID`),
  CONSTRAINT `dialysis_machine_assessment_ibfk_1` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `dialysis_machine_assessment_ibfk_2` FOREIGN KEY (`Payment_Item_Cache_List_ID`) REFERENCES `orders_items` (`Payment_Item_Cache_List_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `dialysis_notes`
--

CREATE TABLE `dialysis_notes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL,
  `notes` text NOT NULL,
  `create_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employee_id` (`employee_id`),
  KEY `Payment_Item_Cache_List_ID` (`Payment_Item_Cache_List_ID`),
  CONSTRAINT `dialysis_notes_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `dialysis_notes_ibfk_2` FOREIGN KEY (`Payment_Item_Cache_List_ID`) REFERENCES `orders_items` (`Payment_Item_Cache_List_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `dialysis_observation_chart`
--

CREATE TABLE `dialysis_observation_chart` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Employee_id` int(11) NOT NULL,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL,
  `create_date` datetime NOT NULL,
  `time_of_observation` text,
  `bp` text,
  `ap` text,
  `vp` text,
  `pulse` text,
  `blood_flow` text,
  `res` text,
  `temp` text,
  `uf_rate` text,
  `uf_removal` text,
  `iv_po` text,
  `rbg` text,
  `spO2` text,
  `pump_speed` text,
  `volume` text,
  `heparin` text,
  `cond` text,
  `remarks` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `Employee_id` (`Employee_id`),
  KEY `Payment_Item_Cache_List_ID` (`Payment_Item_Cache_List_ID`),
  CONSTRAINT `dialysis_observation_chart_ibfk_1` FOREIGN KEY (`Employee_id`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `dialysis_observation_chart_ibfk_2` FOREIGN KEY (`Payment_Item_Cache_List_ID`) REFERENCES `orders_items` (`Payment_Item_Cache_List_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `dialysis_patient_assessment`
--

CREATE TABLE `dialysis_patient_assessment` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Employee_ID` int(11) NOT NULL,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL,
  `create_date` datetime NOT NULL,
  `pre_dialysis_dry_weight` varchar(50) NOT NULL,
  `pre_dialysis_additional_weight` varchar(50) NOT NULL,
  `pre_dialysis_pre_weight` varchar(50) NOT NULL,
  `pre_dialysis_height` varchar(50) NOT NULL,
  `pre_dialysis_standing_bp` varchar(50) NOT NULL,
  `pre_dialysis_standing_pulse_rate` varchar(50) NOT NULL,
  `pre_dialysis_resting_bp` varchar(50) NOT NULL,
  `pre_dialysis_resting_pulse_rate` varchar(50) NOT NULL,
  `pre_dialysis_resting_respiration_rate` varchar(50) NOT NULL,
  `pre_dialysis_temperature` varchar(50) NOT NULL,
  `pre_dialysis_saturation_of_oxygen` varchar(50) NOT NULL,
  `pre_dialysis_time_on` varchar(50) NOT NULL,
  `post_dialysis_post_weight` varchar(50) NOT NULL,
  `post_dialysis_weight_loss` varchar(50) NOT NULL,
  `post_dialysis_standing_bp` varchar(50) NOT NULL,
  `post_dialysis_standing_pulse_rate` varchar(50) NOT NULL,
  `post_dialysis_resting_bp` varchar(50) NOT NULL,
  `post_dialysis_resting_pulse_rate` varchar(50) NOT NULL,
  `post_dialysis_resting_respiration_rate` varchar(50) NOT NULL,
  `post_dialysis_temperature` varchar(50) NOT NULL,
  `post_dialysis_saturation_of_oxygen` varchar(50) NOT NULL,
  `post_dialysis_time_off` varchar(50) NOT NULL,
  `post_dialysis_elective_time` varchar(50) NOT NULL,
  `post_dialysis_ocm_archived` varchar(50) NOT NULL,
  `av_fistula` varchar(50) NOT NULL,
  `av_graft` varchar(50) NOT NULL,
  `temporary_catheter` varchar(50) NOT NULL,
  `permanent_catheter` varchar(50) NOT NULL,
  `iron` varchar(50) DEFAULT NULL,
  `epo` varchar(50) DEFAULT NULL,
  `calcium` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Payment_Item_Cache_List_ID` (`Payment_Item_Cache_List_ID`),
  CONSTRAINT `dialysis_patient_assessment_ibfk_1` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `dialysis_patient_assessment_ibfk_2` FOREIGN KEY (`Payment_Item_Cache_List_ID`) REFERENCES `orders_items` (`Payment_Item_Cache_List_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `directory`
--

CREATE TABLE `directory` (
  `Directory_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Office_Name` varchar(50) DEFAULT NULL,
  `Exit_No` int(11) DEFAULT NULL,
  PRIMARY KEY (`Directory_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `discharge_reason`
--

CREATE TABLE `discharge_reason` (
  `Discharge_Reason_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Discharge_Reason` varchar(200) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Date_Added` datetime NOT NULL,
  PRIMARY KEY (`Discharge_Reason_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  CONSTRAINT `discharge_reason_ibfk_1` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `discharge_summary`
--

CREATE TABLE `discharge_summary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `registration_id` int(11) NOT NULL,
  `check_in_id` int(11) NOT NULL,
  `patient_name` varchar(50) NOT NULL,
  `patient_address` varchar(255) NOT NULL,
  `company` varchar(50) DEFAULT NULL,
  `age` varchar(50) NOT NULL,
  `gender` varchar(6) NOT NULL,
  `admission_date` datetime NOT NULL,
  `discharge_date` datetime NOT NULL,
  `attending_consultant_id` int(11) DEFAULT NULL,
  `discharge_consultant_id` int(11) NOT NULL,
  `differential_diagnosis` text,
  `final_diagnosis` text NOT NULL,
  `recommendation` text NOT NULL,
  `instructions` text NOT NULL,
  `history_notes` text NOT NULL,
  `investigation_summary` text,
  `surgery_procedure_summary` text,
  `medication_summary` text,
  `discharge_need_ed` varchar(6) NOT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `discharge_summary_created_by_foreign` (`created_by`),
  KEY `discharge_summary_check_in_id_foreign` (`check_in_id`),
  KEY `discharge_summary_registration_id_foreign` (`registration_id`),
  KEY `discharge_summary_attending_consultant_id_foreign` (`attending_consultant_id`),
  KEY `discharge_summary_discharge_consultant_id_foreign` (`discharge_consultant_id`),
  CONSTRAINT `discharge_summary_attending_consultant_id_foreign` FOREIGN KEY (`attending_consultant_id`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `discharge_summary_check_in_id_foreign` FOREIGN KEY (`check_in_id`) REFERENCES `patient_visit` (`Check_In_ID`),
  CONSTRAINT `discharge_summary_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `discharge_summary_discharge_consultant_id_foreign` FOREIGN KEY (`discharge_consultant_id`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `discharge_summary_registration_id_foreign` FOREIGN KEY (`registration_id`) REFERENCES `patient` (`Registration_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `disease`
--

CREATE TABLE `disease` (
  `disease_ID` int(11) NOT NULL AUTO_INCREMENT,
  `disease_code` varchar(20) DEFAULT NULL,
  `nhif_code` varchar(20) DEFAULT NULL,
  `disease_name` varchar(120) DEFAULT NULL,
  `subcategory_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Date_And_Time` datetime DEFAULT NULL,
  `Disease_status` varchar(15) NOT NULL,
  `icd_standard` int(11) NOT NULL,
  PRIMARY KEY (`disease_ID`),
  KEY `subcategory_ID` (`subcategory_ID`),
  CONSTRAINT `disease_ibfk_1` FOREIGN KEY (`subcategory_ID`) REFERENCES `disease_sub_category` (`subcategory_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=20818 DEFAULT CHARSET=latin1;

--
-- Table structure for table `disease_category`
--

CREATE TABLE `disease_category` (
  `disease_category_ID` int(11) NOT NULL AUTO_INCREMENT,
  `category_discreption` varchar(120) DEFAULT NULL,
  `main_category_id` int(11) NOT NULL,
  PRIMARY KEY (`disease_category_ID`),
  UNIQUE KEY `category_discreption` (`category_discreption`),
  KEY `main_category_id` (`main_category_id`),
  CONSTRAINT `disease_category_ibfk_1` FOREIGN KEY (`main_category_id`) REFERENCES `disease_main_category` (`main_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Table structure for table `disease_consultation`
--

CREATE TABLE `disease_consultation` (
  `Disease_Consultation_ID` int(11) NOT NULL AUTO_INCREMENT,
  `disease_ID` int(11) DEFAULT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `employee_ID` int(11) DEFAULT NULL,
  `diagnosis_type` varchar(30) NOT NULL,
  `Disease_Consultation_Date_And_Time` datetime NOT NULL,
  PRIMARY KEY (`Disease_Consultation_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `disease_ID` (`disease_ID`),
  KEY `employee_ID` (`employee_ID`),
  CONSTRAINT `disease_consultation_ibfk_1` FOREIGN KEY (`disease_ID`) REFERENCES `disease` (`disease_ID`),
  CONSTRAINT `disease_consultation_ibfk_2` FOREIGN KEY (`consultation_ID`) REFERENCES `clinical_note` (`consultation_ID`),
  CONSTRAINT `disease_consultation_ibfk_3` FOREIGN KEY (`employee_ID`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=185 DEFAULT CHARSET=latin1;

--
-- Table structure for table `disease_group`
--

CREATE TABLE `disease_group` (
  `disease_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `Dental_disease_Form_Id` int(11) DEFAULT NULL,
  `disease_group_name` varchar(120) DEFAULT NULL,
  `Opd_disease_Form_Id` int(11) DEFAULT NULL,
  `Gender_Type` varchar(20) NOT NULL,
  `Age_60_Years_And_Above` varchar(10) NOT NULL,
  `Age_Between_1_Year_But_Below_5_Year` varchar(10) NOT NULL,
  `Five_Years_Or_Below_Sixty_Years` varchar(10) NOT NULL,
  `Age_Between_1_Month_But_Below_1_Year` varchar(10) NOT NULL,
  `Age_Below_1_Month` varchar(10) NOT NULL,
  `Opd_Report` varchar(10) NOT NULL DEFAULT 'No',
  `Ipd_Report` varchar(10) NOT NULL DEFAULT 'No',
  `Ipd_disease_Form_Id` int(11) DEFAULT NULL,
  `Dental_Report` varchar(20) NOT NULL DEFAULT 'No',
  `Weekly_Report_Form_Id` int(11) DEFAULT NULL,
  `Weekly_Report` varchar(20) NOT NULL DEFAULT 'No',
  PRIMARY KEY (`disease_group_id`),
  UNIQUE KEY `disease_group_name` (`disease_group_name`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=latin1;

--
-- Table structure for table `disease_group_mapping`
--

CREATE TABLE `disease_group_mapping` (
  `disease_group_id` int(11) NOT NULL DEFAULT '0',
  `disease_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`disease_group_id`,`disease_id`),
  KEY `disease_id` (`disease_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `disease_main_category`
--

CREATE TABLE `disease_main_category` (
  `main_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `maincategory_name` varchar(200) NOT NULL,
  PRIMARY KEY (`main_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Table structure for table `disease_sponsor_icd_standard`
--

CREATE TABLE `disease_sponsor_icd_standard` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sponsor_id` int(11) DEFAULT NULL,
  `icd_standard` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sponsor_id` (`sponsor_id`),
  CONSTRAINT `disease_sponsor_icd_standard_ibfk_1` FOREIGN KEY (`sponsor_id`) REFERENCES `insurer` (`Sponsor_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Table structure for table `disease_sub_category`
--

CREATE TABLE `disease_sub_category` (
  `subcategory_ID` int(11) NOT NULL AUTO_INCREMENT,
  `disease_category_ID` int(11) DEFAULT NULL,
  `subcategory_description` varchar(120) DEFAULT NULL,
  PRIMARY KEY (`subcategory_ID`),
  UNIQUE KEY `subcategory_description` (`subcategory_description`),
  KEY `category_ID` (`disease_category_ID`),
  CONSTRAINT `disease_sub_category_ibfk_1` FOREIGN KEY (`disease_category_ID`) REFERENCES `disease_category` (`disease_category_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1114 DEFAULT CHARSET=latin1;

--
-- Table structure for table `disposal`
--

CREATE TABLE `disposal` (
  `Disposal_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Disposal_Status` varchar(30) NOT NULL DEFAULT 'pending',
  `Sub_Department_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Created_Date` date NOT NULL,
  `Created_Date_And_Time` datetime NOT NULL,
  `Disposed_Date` date NOT NULL,
  `Supervisor_ID` int(11) DEFAULT NULL,
  `Disposal_Description` varchar(200) DEFAULT NULL,
  `Branch_ID` int(11) DEFAULT NULL,
  `Previous_Disposal_Data` text,
  PRIMARY KEY (`Disposal_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Supervisor_ID` (`Supervisor_ID`),
  KEY `Sub_Department_ID` (`Sub_Department_ID`),
  KEY `Branch_ID` (`Branch_ID`),
  CONSTRAINT `disposal_ibfk_2` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `disposal_ibfk_3` FOREIGN KEY (`Supervisor_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `disposal_ibfk_4` FOREIGN KEY (`Sub_Department_ID`) REFERENCES `sub_department` (`Sub_Department_ID`),
  CONSTRAINT `disposal_ibfk_5` FOREIGN KEY (`Branch_ID`) REFERENCES `branch` (`Branch_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `disposal_items`
--

CREATE TABLE `disposal_items` (
  `Disposal_Item_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Item_ID` int(11) NOT NULL,
  `Quantity_Disposed` int(11) NOT NULL,
  `Buying_Price` double NOT NULL DEFAULT '0',
  `Disposal_ID` int(11) NOT NULL,
  `Item_Remark` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`Disposal_Item_ID`),
  KEY `Item_ID` (`Item_ID`),
  KEY `Disposal_ID` (`Disposal_ID`),
  CONSTRAINT `disposal_items_ibfk_1` FOREIGN KEY (`Disposal_ID`) REFERENCES `disposal` (`Disposal_ID`),
  CONSTRAINT `disposal_items_ibfk_2` FOREIGN KEY (`Item_ID`) REFERENCES `product` (`Item_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `district`
--

CREATE TABLE `district` (
  `District_ID` int(11) NOT NULL AUTO_INCREMENT,
  `District_Name` varchar(70) NOT NULL,
  `Region_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`District_ID`),
  UNIQUE KEY `District_Name` (`District_Name`),
  KEY `Region_ID` (`Region_ID`),
  CONSTRAINT `district_ibfk_1` FOREIGN KEY (`Region_ID`) REFERENCES `region` (`Region_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=latin1;

--
-- Table structure for table `doctor_consultation_fee`
--

CREATE TABLE `doctor_consultation_fee` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Category_name` varchar(50) NOT NULL,
  `Item_ID` int(11) NOT NULL,
  `Consultation_Fee_Type` int(11) NOT NULL,
  `Doctor_Level` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `Item_ID` (`Item_ID`),
  CONSTRAINT `doctor_consultation_fee_ibfk_1` FOREIGN KEY (`Item_ID`) REFERENCES `product` (`Item_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Table structure for table `document_library`
--

CREATE TABLE `document_library` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `created_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `modified_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `modified_time` datetime DEFAULT NULL,
  `content_type` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `file_relevant_path` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `file_size` int(11) NOT NULL,
  `module_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `module_primary_key` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `open_field` text COLLATE utf8_unicode_ci,
  `uuid` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `email_recipient`
--

CREATE TABLE `email_recipient` (
  `Recepient_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Recepient_Name` varchar(200) NOT NULL,
  `Recepient_Email` varchar(200) NOT NULL,
  `Date_Created` datetime NOT NULL,
  `Created_By` int(11) NOT NULL,
  PRIMARY KEY (`Recepient_ID`),
  UNIQUE KEY `Recepient_Email` (`Recepient_Email`),
  KEY `Created_By` (`Created_By`),
  KEY `Created_By_2` (`Created_By`),
  CONSTRAINT `email_recipient_ibfk_1` FOREIGN KEY (`Created_By`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `Employee_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Employee_Name` varchar(300) NOT NULL,
  `Employee_Type` varchar(300) NOT NULL,
  `Employee_Number` varchar(150) NOT NULL,
  `Employee_Title` varchar(150) NOT NULL,
  `Employee_Job_Code` varchar(150) NOT NULL,
  `Employee_Branch_Name` varchar(150) NOT NULL,
  `Account_Status` varchar(40) NOT NULL DEFAULT 'active',
  `user_role_id` int(10) unsigned NOT NULL,
  `Phone_Number` varchar(30) DEFAULT NULL,
  `Registration_Number` varchar(30) DEFAULT NULL,
  `written_employee_name` int(11) DEFAULT NULL,
  `written_employee_signature` int(11) DEFAULT NULL,
  `written_employee_qualification` int(11) DEFAULT NULL,
  `written_employee_mct_registration_no` int(11) DEFAULT NULL,
  `written_employee_phone_number` int(11) DEFAULT NULL,
  PRIMARY KEY (`Employee_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;

--
-- Table structure for table `employee_access`
--

CREATE TABLE `employee_access` (
  `given_username` varchar(150) NOT NULL,
  `given_password` varchar(150) NOT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `last_modified_by` int(11) DEFAULT NULL,
  `last_password_change` date NOT NULL,
  `change_password_on_first_login` varchar(10) NOT NULL DEFAULT 'no',
  `session_id` text,
  `last_logged_in_computer` text,
  `last_login_date` datetime DEFAULT NULL,
  UNIQUE KEY `Given_Username` (`given_username`),
  UNIQUE KEY `Employee_ID` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `employee_assign_consultation_category_fee`
--

CREATE TABLE `employee_assign_consultation_category_fee` (
  `id` int(11) unsigned NOT NULL,
  `Employee_ID` int(11) NOT NULL,
  KEY `Employee_ID` (`Employee_ID`),
  KEY `id` (`id`),
  CONSTRAINT `employee_assign_consultation_category_fee_ibfk_1` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `employee_assign_consultation_category_fee_ibfk_2` FOREIGN KEY (`id`) REFERENCES `doctor_consultation_fee` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `employee_document`
--

CREATE TABLE `employee_document` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `document_type` int(11) NOT NULL,
  `document_id` bigint(20) NOT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `employee_document_employee_id_foreign` (`employee_id`),
  KEY `employee_document_document_id_foreign` (`document_id`),
  CONSTRAINT `employee_document_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `document_library` (`id`),
  CONSTRAINT `employee_document_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `employee_sub_department`
--

CREATE TABLE `employee_sub_department` (
  `Employee_ID` int(11) NOT NULL DEFAULT '0',
  `Sub_Department_ID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Employee_ID`,`Sub_Department_ID`),
  KEY `Sub_Department_ID` (`Sub_Department_ID`),
  CONSTRAINT `employee_sub_department_ibfk_1` FOREIGN KEY (`Sub_Department_ID`) REFERENCES `sub_department` (`Sub_Department_ID`),
  CONSTRAINT `employee_sub_department_ibfk_2` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `employee_sub_department_ibfk_3` FOREIGN KEY (`Sub_Department_ID`) REFERENCES `sub_department` (`Sub_Department_ID`),
  CONSTRAINT `employee_sub_department_ibfk_4` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `employee_sub_department_ibfk_5` FOREIGN KEY (`Sub_Department_ID`) REFERENCES `sub_department` (`Sub_Department_ID`),
  CONSTRAINT `employee_sub_department_ibfk_6` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `employee_type`
--

CREATE TABLE `employee_type` (
  `Type_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Type_Name` varchar(100) NOT NULL,
  PRIMARY KEY (`Type_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `excuse_of_duty`
--

CREATE TABLE `excuse_of_duty` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) NOT NULL,
  `Patient_Name` text NOT NULL,
  `Patient_Address` text NOT NULL,
  `Company` text,
  `Age` varchar(10) NOT NULL,
  `Gender` varchar(10) NOT NULL,
  `Number_Of_Days` int(11) NOT NULL,
  `Reasons` text NOT NULL,
  `Consultation_ID` int(11) NOT NULL,
  `Round_ID` int(11) NOT NULL,
  `Employee_ID` int(11) NOT NULL,
  `ed_date` date NOT NULL,
  `created_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Table structure for table `family_social_history`
--

CREATE TABLE `family_social_history` (
  `Family_social_history_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Family_social_history` text,
  `Family_social_history_date` datetime DEFAULT NULL,
  `Employee_ID` int(11) NOT NULL,
  `Registration_ID` int(11) NOT NULL,
  PRIMARY KEY (`Family_social_history_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  CONSTRAINT `family_social_history_ibfk_1` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `family_social_history_ibfk_2` FOREIGN KEY (`Registration_ID`) REFERENCES `patient` (`Registration_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `folio`
--

CREATE TABLE `folio` (
  `Folio_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Folio_Number` int(11) NOT NULL,
  `Folio_date` date DEFAULT NULL,
  `Sponsor_ID` int(11) DEFAULT NULL,
  `Branch_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Folio_ID`),
  KEY `Sponsor_ID` (`Sponsor_ID`),
  KEY `Branch_ID` (`Branch_ID`),
  CONSTRAINT `folio_ibfk_1` FOREIGN KEY (`Sponsor_ID`) REFERENCES `insurer` (`Sponsor_ID`),
  CONSTRAINT `folio_ibfk_2` FOREIGN KEY (`Branch_ID`) REFERENCES `branch` (`Branch_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `folio_number`
--

CREATE TABLE `folio_number` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `month_year` varchar(6) NOT NULL,
  `folio_number` int(11) NOT NULL,
  `sponsor_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `branch_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `form_data`
--

CREATE TABLE `form_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `registration_id` int(11) NOT NULL,
  `check_in_id` int(11) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `form_type` int(11) NOT NULL,
  `form_status` int(11) NOT NULL,
  `form_data` text NOT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `form_data_registration_id_foreign` (`registration_id`),
  KEY `form_data_check_in_id_foreign` (`check_in_id`),
  KEY `form_data_created_by_foreign` (`created_by`),
  KEY `form_data_item_id_foreign` (`item_id`),
  CONSTRAINT `form_data_check_in_id_foreign` FOREIGN KEY (`check_in_id`) REFERENCES `patient_visit` (`Check_In_ID`),
  CONSTRAINT `form_data_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `form_data_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `product` (`Item_ID`),
  CONSTRAINT `form_data_registration_id_foreign` FOREIGN KEY (`registration_id`) REFERENCES `patient` (`Registration_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `frequent_prescription`
--

CREATE TABLE `frequent_prescription` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `dosage_quantity` int(11) NOT NULL,
  `frequency` varchar(3) NOT NULL,
  `duration` int(11) NOT NULL,
  `description` text NOT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `frequent_prescription_product_id_foreign` (`product_id`),
  CONSTRAINT `frequent_prescription_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `product` (`Item_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Table structure for table `git_post_operative_note`
--

CREATE TABLE `git_post_operative_note` (
  `Git_Post_operative_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL COMMENT 'foreign key from tbl_item_list_cache',
  `Surgery_Date` date NOT NULL,
  `Surgery_Date_Time` datetime DEFAULT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `Registration_ID` int(11) NOT NULL,
  `Employee_ID` int(11) NOT NULL COMMENT 'Doctor ID',
  `Indication_Of_Procedure` varchar(200) DEFAULT NULL,
  `Others` text NOT NULL,
  `Comorbidities` varchar(100) DEFAULT NULL,
  `Management` varchar(255) DEFAULT NULL,
  `Recommendations` text,
  `Medication_Used` varchar(50) DEFAULT NULL,
  `Biopsy_Tailen` varchar(255) DEFAULT NULL,
  `Upper_Point` text,
  `Middle_Point` text NOT NULL,
  `OG_Junction` text,
  `Hiatus_Hernia` text,
  `Other_Lesson` text,
  `Cardia` text,
  `Fundus` text,
  `Body` text,
  `Antrum` text,
  `Pyloms` text,
  `D1` text,
  `D2` text,
  `D3` text,
  PRIMARY KEY (`Git_Post_operative_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `Payment_Item_Cache_List_ID` (`Payment_Item_Cache_List_ID`),
  KEY `Registration_ID` (`Registration_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Table structure for table `git_post_operative_participant`
--

CREATE TABLE `git_post_operative_participant` (
  `Participant_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Git_Post_operative_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Employee_Type` varchar(50) DEFAULT NULL,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL,
  PRIMARY KEY (`Participant_ID`),
  KEY `Git_Post_operative_ID` (`Git_Post_operative_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  CONSTRAINT `git_post_operative_participant_ibfk_1` FOREIGN KEY (`Git_Post_operative_ID`) REFERENCES `git_post_operative_note` (`Git_Post_operative_ID`),
  CONSTRAINT `git_post_operative_participant_ibfk_2` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `home_care`
--

CREATE TABLE `home_care` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patient_visit_id` int(11) NOT NULL,
  `status` int(2) NOT NULL,
  `kin_name` varchar(255) NOT NULL,
  `kin_relationship` varchar(50) NOT NULL,
  `kin_phone` varchar(25) NOT NULL,
  `kin_address` varchar(255) NOT NULL,
  `created_at` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `ended_at` date DEFAULT NULL,
  `ended_by` int(11) DEFAULT NULL,
  `cash_cleared_status` int(1) NOT NULL,
  `cash_cleared_by` int(11) DEFAULT NULL,
  `cash_cleared_at` datetime DEFAULT NULL,
  `credit_cleared_status` int(1) NOT NULL,
  `credit_cleared_by` int(11) DEFAULT NULL,
  `credit_cleared_at` datetime DEFAULT NULL,
  `bill_approved_at` datetime DEFAULT NULL,
  `bill_approved_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `home_care_patient_visit_id_foreign` (`patient_visit_id`),
  KEY `home_care_created_by_foreign` (`created_by`),
  KEY `home_care_ended_by_foreign` (`ended_by`),
  KEY `home_care_cash_cleared_by_foreign` (`cash_cleared_by`),
  KEY `home_care_credit_cleared_by_foreign` (`credit_cleared_by`),
  KEY `home_care_bill_approved_by_foreign` (`bill_approved_by`),
  CONSTRAINT `home_care_bill_approved_by_foreign` FOREIGN KEY (`bill_approved_by`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `home_care_cash_cleared_by_foreign` FOREIGN KEY (`cash_cleared_by`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `home_care_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `home_care_credit_cleared_by_foreign` FOREIGN KEY (`credit_cleared_by`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `home_care_ended_by_foreign` FOREIGN KEY (`ended_by`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `home_care_patient_visit_id_foreign` FOREIGN KEY (`patient_visit_id`) REFERENCES `patient_visit` (`Check_In_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `insurer`
--

CREATE TABLE `insurer` (
  `Sponsor_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Sponsor_Name` varchar(150) NOT NULL,
  `Postal_Address` varchar(100) DEFAULT NULL,
  `Region` varchar(100) DEFAULT NULL,
  `District` varchar(100) DEFAULT NULL,
  `Ward` varchar(100) DEFAULT NULL,
  `Phone_Number` varchar(40) DEFAULT NULL,
  `Membership_Id_Number_Status` varchar(50) DEFAULT NULL,
  `Claim_Number_Status` varchar(50) DEFAULT NULL,
  `Folio_Number_Status` varchar(50) DEFAULT NULL,
  `Require_Document_To_Sign_At_receiption` varchar(50) DEFAULT NULL,
  `Benefit_Limit` int(11) DEFAULT NULL,
  `Support_Patient_From_Outside` varchar(10) NOT NULL DEFAULT 'no',
  `HasAccountacy` enum('0','1') DEFAULT '0',
  `consult_per_day` int(11) DEFAULT NULL,
  `enab_auto_billing` varchar(10) NOT NULL DEFAULT 'no',
  `Exemption` varchar(5) NOT NULL DEFAULT 'no',
  `Billing_Type_Mode` varchar(15) NOT NULL,
  `Verification_System` varchar(100) DEFAULT NULL,
  `Employee_Vote_Number` varchar(15) DEFAULT 'Not Mandatory',
  `Currency_ID` int(11) DEFAULT NULL,
  `Status` varchar(10) DEFAULT 'ACTIVE',
  `benefit_package_code` varchar(100) DEFAULT NULL,
  `scheme_code` varchar(100) DEFAULT NULL,
  `parent_sponsor_id` int(11) DEFAULT NULL,
  `Claim_System` varchar(100) DEFAULT NULL,
  `invoice_allowed_due_days` varchar(3) DEFAULT '30',
  `invoice_notification_emails` text,
  `sponsor_scheme` varchar(3) DEFAULT NULL,
  `sort` int(11) DEFAULT '100',
  `enab_copay_every_invoice` varchar(100) NOT NULL DEFAULT 'no',
  `rate_copay_every_invoice` int(11) DEFAULT '0',
  `gen_claim_number` varchar(100) NOT NULL DEFAULT 'no',
  `add_facility_code_on_serial_no` varchar(100) NOT NULL DEFAULT 'no',
  `default_priority` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`Sponsor_ID`),
  UNIQUE KEY `Guarantor_Name` (`Sponsor_Name`),
  KEY `sponsor_parent_sponsor_id_foreign` (`parent_sponsor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Table structure for table `insurer_allow_zero_items`
--

CREATE TABLE `insurer_allow_zero_items` (
  `sponsor_id` int(11) NOT NULL DEFAULT '0',
  `item_ID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sponsor_id`,`item_ID`),
  UNIQUE KEY `sponsor_id` (`sponsor_id`,`item_ID`),
  KEY `item_ID` (`item_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `insurer_non_supported_items`
--

CREATE TABLE `insurer_non_supported_items` (
  `sponsor_id` int(11) NOT NULL DEFAULT '0',
  `item_ID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sponsor_id`,`item_ID`),
  UNIQUE KEY `sponsor_id` (`sponsor_id`,`item_ID`),
  KEY `item_ID` (`item_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `insurer_pre_approval_items`
--

CREATE TABLE `insurer_pre_approval_items` (
  `sponsor_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  KEY `sponsor_pre_approval_items_item_id_foreign` (`sponsor_id`),
  KEY `sponsor_pre_approval_items_sponsor_id_foreign` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `insurer_verification_details`
--

CREATE TABLE `insurer_verification_details` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) NOT NULL,
  `Sponsor_ID` int(11) NOT NULL,
  `auth_date` datetime NOT NULL,
  `auth_status` varchar(100) NOT NULL,
  `auth_number` varchar(100) NOT NULL,
  `auth_remark` text,
  `member_card_no` varchar(100) DEFAULT NULL,
  `auth_visit_type` varchar(100) DEFAULT NULL,
  `auth_referral_no` varchar(100) DEFAULT NULL,
  `Check_In_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `Sponsor_ID` (`Sponsor_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=latin1;

--
-- Table structure for table `issue_note`
--

CREATE TABLE `issue_note` (
  `Issue_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Requisition_ID` int(11) DEFAULT NULL,
  `Issue_Date_And_Time` datetime NOT NULL,
  `Issue_Date` date NOT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Issue_Status` varchar(30) DEFAULT 'pending',
  `Issue_Description` varchar(200) DEFAULT NULL,
  `Branch_ID` int(11) DEFAULT NULL,
  `Receiving_Officer` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Issue_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Requisition_ID` (`Requisition_ID`),
  CONSTRAINT `issue_note_ibfk_1` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `issue_note_ibfk_2` FOREIGN KEY (`Requisition_ID`) REFERENCES `requisition` (`Requisition_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `issue_note_manual`
--

CREATE TABLE `issue_note_manual` (
  `Issue_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Issue_Date_And_Time` datetime NOT NULL,
  `Employee_Issuing` int(11) DEFAULT NULL,
  `Employee_Receiving` int(11) DEFAULT NULL,
  `Store_Issuing` int(11) DEFAULT NULL,
  `Store_Need` int(11) DEFAULT NULL,
  `Branch_ID` int(11) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'pending',
  `Created_Date_And_Time` datetime NOT NULL,
  `Previous_Issue_Note_Manual_Data` text,
  `Reference_No` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`Issue_ID`),
  KEY `Employee_ID` (`Employee_Issuing`),
  KEY `Employee_Receiving` (`Employee_Receiving`),
  KEY `Employee_Issuing` (`Employee_Issuing`),
  KEY `Store_Issuing` (`Store_Issuing`),
  KEY `Store_Need` (`Store_Need`),
  KEY `Employee_Receiving_2` (`Employee_Receiving`),
  KEY `Employee_Issuing_2` (`Employee_Issuing`),
  KEY `Branch_ID` (`Branch_ID`),
  CONSTRAINT `issue_note_manual_ibfk_1` FOREIGN KEY (`Employee_Issuing`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `issue_note_manual_ibfk_2` FOREIGN KEY (`Employee_Receiving`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `issue_note_manual_ibfk_3` FOREIGN KEY (`Store_Issuing`) REFERENCES `sub_department` (`Sub_Department_ID`),
  CONSTRAINT `issue_note_manual_ibfk_4` FOREIGN KEY (`Store_Need`) REFERENCES `sub_department` (`Sub_Department_ID`),
  CONSTRAINT `issue_note_manual_ibfk_5` FOREIGN KEY (`Branch_ID`) REFERENCES `branch` (`Branch_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Table structure for table `issue_note_manual_item`
--

CREATE TABLE `issue_note_manual_item` (
  `Requisition_Item_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Quantity_Required` int(11) NOT NULL,
  `Item_Remark` varchar(60) DEFAULT NULL,
  `Balance_Before_Issue` int(11) DEFAULT NULL,
  `Item_ID` int(11) DEFAULT NULL,
  `Quantity_Issued` int(11) NOT NULL,
  `Buying_Price` double NOT NULL DEFAULT '0',
  `Issue_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Requisition_Item_ID`),
  KEY `item_id` (`Item_ID`),
  KEY `Issue_ID` (`Issue_ID`),
  KEY `Item_ID_2` (`Item_ID`),
  KEY `Issue_ID_2` (`Issue_ID`),
  CONSTRAINT `issue_note_manual_item_ibfk_1` FOREIGN KEY (`Item_ID`) REFERENCES `product` (`Item_ID`),
  CONSTRAINT `issue_note_manual_item_ibfk_2` FOREIGN KEY (`Issue_ID`) REFERENCES `issue_note_manual` (`Issue_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Table structure for table `item_report`
--

CREATE TABLE `item_report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `payment_item_cache_list_id` int(11) NOT NULL,
  `consultation_type` varchar(100) NOT NULL,
  `item_report_template_id` int(11) DEFAULT NULL,
  `item_report` text,
  `created_by` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_item_cache_list_id` (`payment_item_cache_list_id`),
  KEY `item_report_item_report_template_id_foreign` (`item_report_template_id`),
  KEY `item_report_created_by_foreign` (`created_by`),
  KEY `item_report_modified_by_foreign` (`modified_by`),
  KEY `item_report_item_id_foreign` (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Table structure for table `item_report_template`
--

CREATE TABLE `item_report_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `item_report_template` text,
  `template_name` varchar(100) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `template_name` (`template_name`),
  KEY `item_report_template_created_by_foreign` (`created_by`),
  KEY `item_report_template_modified_by_foreign` (`modified_by`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Table structure for table `item_sub_category`
--

CREATE TABLE `item_sub_category` (
  `Item_Subcategory_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Item_Subcategory_Name` varchar(150) NOT NULL,
  `Item_category_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Item_Subcategory_ID`),
  UNIQUE KEY `Item_Subcategory_Name` (`Item_Subcategory_Name`),
  KEY `Item_category_ID` (`Item_category_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1;

--
-- Table structure for table `item_template`
--

CREATE TABLE `item_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Item_ID` int(11) NOT NULL,
  `Template_Number` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `item_template_result`
--

CREATE TABLE `item_template_result` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL,
  `Template_Number` int(2) NOT NULL,
  `Template_Field` int(2) NOT NULL,
  `Result` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `lab_investigation_parameter`
--

CREATE TABLE `lab_investigation_parameter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `param_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `param_id` (`param_id`,`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=356 DEFAULT CHARSET=latin1;

--
-- Table structure for table `lab_investigation_parameter_result`
--

CREATE TABLE `lab_investigation_parameter_result` (
  `ref_test_result_ID` int(11) NOT NULL,
  `parameter` int(11) NOT NULL,
  `result` varchar(50) NOT NULL,
  `modified` varchar(10) NOT NULL DEFAULT 'No',
  `Validated` varchar(10) NOT NULL DEFAULT 'No',
  `Submitted` varchar(10) NOT NULL DEFAULT 'No',
  `status` varchar(30) NOT NULL,
  `Saved` varchar(10) NOT NULL DEFAULT 'No',
  `TimeSubmitted` datetime DEFAULT NULL,
  `TimeValidate` datetime DEFAULT NULL,
  `SavedBy` int(11) DEFAULT '0',
  `ValidatedBy` int(11) DEFAULT '0',
  `results_description` text,
  PRIMARY KEY (`ref_test_result_ID`,`parameter`),
  KEY `parameter` (`parameter`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `lab_investigation_result`
--

CREATE TABLE `lab_investigation_result` (
  `test_result_ID` int(11) NOT NULL AUTO_INCREMENT,
  `payment_item_ID` int(11) NOT NULL,
  `Employee_ID` int(11) NOT NULL,
  `TimeSubmitted` datetime NOT NULL,
  `organismName` varchar(100) NOT NULL,
  `reagentUsed` varchar(100) NOT NULL,
  `resultType` varchar(30) NOT NULL,
  `datesaved` datetime NOT NULL,
  `remarks` text NOT NULL,
  `date_removed` datetime DEFAULT NULL,
  `staff_removed` int(11) DEFAULT NULL,
  `removed_status` varchar(10) NOT NULL DEFAULT 'No',
  `labTechn` int(11) NOT NULL,
  PRIMARY KEY (`test_result_ID`),
  KEY `staff_removed` (`staff_removed`),
  KEY `payment_item_ID` (`payment_item_ID`),
  KEY `Employee_ID` (`Employee_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=latin1;

--
-- Table structure for table `lab_investigation_specimen`
--

CREATE TABLE `lab_investigation_specimen` (
  `tests_specimen_ID` int(11) NOT NULL AUTO_INCREMENT,
  `tests_item_ID` int(11) NOT NULL,
  `ref_specimen_ID` int(11) NOT NULL,
  PRIMARY KEY (`tests_specimen_ID`),
  KEY `tests_item_ID` (`tests_item_ID`),
  KEY `ref_specimen_ID` (`ref_specimen_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=309 DEFAULT CHARSET=latin1;

--
-- Table structure for table `lab_investigation_specimen_result`
--

CREATE TABLE `lab_investigation_specimen_result` (
  `result_ID` int(11) NOT NULL AUTO_INCREMENT,
  `payment_item_ID` int(11) NOT NULL,
  `Specimen_ID` int(11) NOT NULL,
  `collection_Status` varchar(30) NOT NULL,
  `specimen_results_Employee_ID` int(11) NOT NULL,
  `TimeCollected` datetime NOT NULL,
  `BarCode` varchar(50) NOT NULL,
  `rejected_reason` varchar(100) NOT NULL,
  `rejected_by` int(11) DEFAULT NULL,
  `Date_Rejected` datetime NOT NULL,
  `Rejection_Status` varchar(20) NOT NULL,
  `remark` text,
  PRIMARY KEY (`result_ID`),
  KEY `payment_item_ID` (`payment_item_ID`,`Specimen_ID`,`specimen_results_Employee_ID`),
  KEY `specimen_results_Employee_ID` (`specimen_results_Employee_ID`),
  KEY `collection_Status` (`collection_Status`),
  KEY `Specimen_ID` (`Specimen_ID`),
  KEY `collection_Status_2` (`collection_Status`),
  KEY `payment_item_ID_2` (`payment_item_ID`),
  KEY `specimen_results_Employee_ID_2` (`specimen_results_Employee_ID`),
  KEY `collection_Status_3` (`collection_Status`),
  KEY `rejected_by` (`rejected_by`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1;

--
-- Table structure for table `lab_parameter`
--

CREATE TABLE `lab_parameter` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `uom` int(11) NOT NULL,
  `lower_value` varchar(100) NOT NULL,
  `operator` varchar(10) NOT NULL,
  `higher_value` varchar(100) NOT NULL,
  `result_type` varchar(60) NOT NULL,
  `normal_value` varchar(50) NOT NULL,
  `show_status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `Parameter_Name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `lab_specimen`
--

CREATE TABLE `lab_specimen` (
  `Specimen_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Specimen_Name` varchar(45) DEFAULT NULL,
  `Sample_Container` varchar(100) NOT NULL,
  `Status` varchar(50) NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`Specimen_ID`),
  UNIQUE KEY `Sample_Name_2` (`Specimen_Name`),
  KEY `Sample_Name` (`Specimen_Name`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Table structure for table `labour_ward_notes`
--

CREATE TABLE `labour_ward_notes` (
  `Note_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Consultation_ID` int(11) DEFAULT NULL,
  `Admision_ID` int(11) DEFAULT NULL,
  `Note_Date_Time` datetime DEFAULT NULL,
  `Palpation` varchar(20) NOT NULL,
  `Presentation` varchar(20) NOT NULL,
  `Position` varchar(20) NOT NULL,
  `Contraction` varchar(20) NOT NULL,
  `Liquir` varchar(20) NOT NULL,
  `Colour` varchar(30) DEFAULT NULL,
  `Pv_Examination` varchar(60) NOT NULL,
  `OS` varchar(20) NOT NULL,
  `Membrane` varchar(20) NOT NULL,
  `Temperature` double DEFAULT NULL,
  `Purse` double DEFAULT NULL,
  `Respiration` double DEFAULT NULL,
  `BP` double DEFAULT NULL,
  `FHR` double DEFAULT NULL,
  `BMI` varchar(10) DEFAULT NULL,
  `Exp` text,
  `Remarks` text,
  PRIMARY KEY (`Note_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Consultation_ID` (`Consultation_ID`),
  KEY `Admision_ID` (`Admision_ID`),
  KEY `Registration_ID` (`Registration_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `license`
--

CREATE TABLE `license` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `license` varchar(200) NOT NULL,
  `license_description` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `license` (`license`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

--
-- Table structure for table `malnutrition_observation`
--

CREATE TABLE `malnutrition_observation` (
  `mulnutrition_observation_id` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) DEFAULT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `employee_ID` int(11) DEFAULT NULL,
  `date_time` datetime NOT NULL,
  `temp` int(11) NOT NULL,
  `Pr` int(11) NOT NULL,
  `Resp` int(11) NOT NULL,
  `So` int(11) NOT NULL,
  `daily_bwt` varchar(100) NOT NULL,
  `feed_amount` varchar(100) NOT NULL,
  `cup_Amount` varchar(100) NOT NULL,
  `oral_taken` varchar(100) NOT NULL,
  `ngt_taken` varchar(100) NOT NULL,
  `vomitted_mls` varchar(100) NOT NULL,
  `diarrhoea` varchar(100) NOT NULL,
  `Remarks` varchar(200) NOT NULL,
  PRIMARY KEY (`mulnutrition_observation_id`),
  KEY `Registration_ID` (`Registration_ID`,`consultation_ID`,`employee_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `employee_ID` (`employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `message_type` int(11) NOT NULL,
  `message` text NOT NULL,
  `message_date` datetime NOT NULL,
  `check_in_id` int(11) DEFAULT NULL,
  `registration_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `message_check_in_id_foreign` (`check_in_id`),
  KEY `message_employee_id_foreign` (`employee_id`),
  KEY `message_registration_id_foreign` (`registration_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `created_by` int(11) DEFAULT NULL,
  `template_id` int(11) DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `message` text,
  `title` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `notification_template`
--

CREATE TABLE `notification_template` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `created_by` int(11) DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  `template` text,
  `title` varchar(50) DEFAULT NULL,
  `template_type` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `notification_user`
--

CREATE TABLE `notification_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) DEFAULT NULL,
  `registration_id` int(11) DEFAULT NULL,
  `notification_id` int(11) DEFAULT NULL,
  `read_flag` int(11) DEFAULT NULL,
  `send_flag` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employee_id` (`employee_id`),
  KEY `registration_id` (`registration_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `nurse_notes`
--

CREATE TABLE `nurse_notes` (
  `Notes_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Admision_ID` int(11) DEFAULT NULL,
  `Consultation_ID` int(11) DEFAULT NULL,
  `Notes_Date_Time` datetime DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Notes` text NOT NULL,
  `Registration_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Notes_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Admision_ID` (`Admision_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `Consultation_ID` (`Consultation_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `nurse_observation`
--

CREATE TABLE `nurse_observation` (
  `Observation_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) DEFAULT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `employee_ID` int(11) DEFAULT NULL,
  `date` datetime NOT NULL,
  `Blood_Pressure` varchar(20) NOT NULL,
  `Pulse_Blood` varchar(20) NOT NULL,
  `Temperature` varchar(20) NOT NULL,
  `Resp_Bpressure` varchar(20) NOT NULL,
  `Fluid_Drug` varchar(20) NOT NULL,
  `Oral_Fluid` varchar(20) NOT NULL,
  `Drainage` varchar(20) NOT NULL,
  `Gas_Tric` varchar(20) NOT NULL,
  `Urine` varchar(20) NOT NULL,
  PRIMARY KEY (`Observation_ID`),
  KEY `consultation_ID` (`consultation_ID`,`employee_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `employee_ID` (`employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `optical_order_item`
--

CREATE TABLE `optical_order_item` (
  `Item_Cache_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Claim_Form_Number` varchar(50) DEFAULT NULL,
  `Billing_Type` varchar(50) NOT NULL,
  `Type_Of_Check_In` varchar(30) NOT NULL,
  `Folio_Number` int(11) DEFAULT NULL,
  `Sponsor_Name` varchar(100) NOT NULL,
  `Sponsor_ID` int(11) NOT NULL,
  `Sub_Department_ID` int(11) DEFAULT NULL,
  `Item_ID` int(11) DEFAULT NULL,
  `Discount` int(11) NOT NULL DEFAULT '0',
  `Price` float NOT NULL DEFAULT '0',
  `Quantity` int(11) NOT NULL DEFAULT '0',
  `Comment` varchar(500) DEFAULT NULL,
  `Patient_Direction` varchar(150) DEFAULT NULL,
  `Consultant_ID` int(11) NOT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Registration_ID` int(11) DEFAULT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `Transaction_Date_Time` datetime DEFAULT NULL,
  PRIMARY KEY (`Item_Cache_ID`),
  KEY `Item_ID` (`Item_ID`),
  KEY `tbl_optical_items_list_cache_ibfk_1` (`Registration_ID`),
  KEY `tbl_optical_items_list_cache_ibfk_2` (`Employee_ID`),
  KEY `tbl_optical_items_list_cache_ibfk_3` (`Consultant_ID`),
  KEY `tbl_optical_items_list_cache_ibfk_4` (`Sponsor_ID`),
  KEY `tbl_optical_items_list_cache_ibfk_5` (`Sub_Department_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `Payment_Cache_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `consultation_id` int(11) DEFAULT NULL,
  `Round_ID` int(11) DEFAULT NULL,
  `Payment_Date_And_Time` datetime DEFAULT NULL,
  `Folio_Number` int(11) DEFAULT NULL,
  `Sponsor_ID` int(11) DEFAULT NULL,
  `Sponsor_Name` varchar(150) DEFAULT NULL,
  `Billing_Type` varchar(50) NOT NULL,
  `Receipt_Date` date NOT NULL,
  `Transaction_status` varchar(20) NOT NULL DEFAULT 'active',
  `Transaction_type` varchar(20) NOT NULL DEFAULT 'indirect cash',
  `Fast_Track` enum('1','0') NOT NULL DEFAULT '0',
  `Order_Type` enum('normal','post operative') NOT NULL DEFAULT 'normal',
  `branch_id` int(11) DEFAULT NULL,
  `Check_In_ID` int(11) DEFAULT NULL,
  `Consultant_ID` int(11) DEFAULT NULL,
  `Credit_Bill_Patient_Payment_ID` int(11) DEFAULT NULL,
  `Cash_Bill_Patient_Payment_ID` int(11) DEFAULT NULL,
  `Currency_ID` varchar(11) DEFAULT NULL,
  `tracking_number` int(11) DEFAULT NULL,
  PRIMARY KEY (`Payment_Cache_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `Sponsor_ID` (`Sponsor_ID`),
  KEY `branch_id` (`branch_id`),
  KEY `consultation_id` (`consultation_id`),
  KEY `Round_ID` (`Round_ID`),
  KEY `Consultant_ID` (`Consultant_ID`),
  KEY `Check_In_ID` (`Check_In_ID`),
  KEY `Credit_Bill_Patient_Payment_ID` (`Credit_Bill_Patient_Payment_ID`),
  KEY `Cash_Bill_Patient_Payment_ID` (`Cash_Bill_Patient_Payment_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=316 DEFAULT CHARSET=latin1;

--
-- Table structure for table `orders_items`
--

CREATE TABLE `orders_items` (
  `Payment_Item_Cache_List_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Check_In_Type` varchar(60) DEFAULT NULL,
  `Category` varchar(100) DEFAULT 'indirect cash',
  `Item_ID` int(11) DEFAULT NULL,
  `Item_Name` varchar(200) DEFAULT NULL,
  `Discount` int(11) DEFAULT NULL,
  `Price` float DEFAULT NULL,
  `Quantity` int(11) DEFAULT NULL,
  `Patient_Direction` varchar(150) DEFAULT NULL,
  `Consultant` varchar(100) DEFAULT NULL,
  `Consultant_ID` int(11) DEFAULT NULL,
  `Status` varchar(40) DEFAULT 'active',
  `Employee_Created` int(11) DEFAULT NULL COMMENT 'Employee Added Item',
  `Created_Date_Time` datetime DEFAULT NULL,
  `Approved_By` int(11) DEFAULT NULL,
  `Approval_Date_Time` datetime DEFAULT NULL,
  `Dispensor` int(11) DEFAULT NULL,
  `Dispense_Date_Time` datetime DEFAULT NULL,
  `Payment_Cache_ID` int(11) DEFAULT NULL,
  `Transaction_Date_And_Time` datetime NOT NULL,
  `Process_Status` varchar(40) NOT NULL DEFAULT 'not served',
  `Doctor_Comment` varchar(500) DEFAULT NULL,
  `Sub_Department_ID` int(11) DEFAULT NULL,
  `Transaction_Type` varchar(10) DEFAULT NULL,
  `payment_type` enum('post','pre') NOT NULL DEFAULT 'post',
  `Service_Date_And_Time` datetime DEFAULT NULL,
  `Edited_Quantity` int(11) NOT NULL DEFAULT '0',
  `Patient_Payment_ID` int(50) DEFAULT NULL,
  `Payment_Date_And_Time` date DEFAULT NULL,
  `Employee_Remove` int(11) DEFAULT NULL,
  `Remove_Date` datetime DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL COMMENT 'Department Employee ID where Patient was saved',
  `Priority` varchar(20) DEFAULT NULL,
  `romoving_staff` int(11) DEFAULT NULL,
  `removing_status` varchar(20) NOT NULL DEFAULT 'No',
  `removing_date` datetime DEFAULT NULL,
  `remarks` varchar(200) DEFAULT NULL,
  `ServedDateTime` datetime DEFAULT NULL,
  `ServedBy` int(11) DEFAULT NULL,
  `Surgery_hour` int(11) DEFAULT NULL,
  `Surgery_min` int(11) DEFAULT NULL,
  `Procedure_Location` varchar(10) DEFAULT 'Others',
  `Transaction_ID` int(11) NOT NULL DEFAULT '0',
  `ePayment_Status` varchar(15) NOT NULL DEFAULT 'pending',
  `Payment_Status` int(1) DEFAULT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `Round_ID` int(11) DEFAULT NULL,
  `previous_payment_status` int(1) DEFAULT NULL,
  `previous_process_status` int(1) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `dosage_quantity` int(11) DEFAULT NULL,
  `final_quantity` int(11) DEFAULT NULL,
  `frequency` varchar(3) DEFAULT NULL,
  `approval_number` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Payment_Item_Cache_List_ID`),
  KEY `Patient_Payment_ID` (`Payment_Cache_ID`),
  KEY `Item_ID` (`Item_ID`),
  KEY `Item_ID_2` (`Item_ID`),
  KEY `Payment_Cache_ID` (`Payment_Cache_ID`),
  KEY `Dispensor` (`Dispensor`),
  KEY `romoving_staff` (`romoving_staff`),
  KEY `Sub_Department_ID` (`Sub_Department_ID`),
  KEY `Consultant_ID` (`Consultant_ID`),
  KEY `Employee_Remove` (`Employee_Remove`),
  KEY `Dispensor_2` (`Dispensor`),
  KEY `Payment_Cache_ID_2` (`Payment_Cache_ID`),
  KEY `Employee_Created` (`Employee_Created`),
  KEY `Patient_Payment_ID_2` (`Patient_Payment_ID`) USING BTREE,
  KEY `item_list_cache_consultation_id_foreign` (`consultation_ID`),
  KEY `item_list_cache_round_id_foreign` (`Round_ID`),
  KEY `idx_doctor_orders` (`Transaction_Date_And_Time`,`Payment_Cache_ID`,`Check_In_Type`,`Item_ID`,`Consultant`,`Priority`)
) ENGINE=InnoDB AUTO_INCREMENT=472 DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient`
--

CREATE TABLE `patient` (
  `Registration_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Old_Registration_Number` varchar(100) DEFAULT NULL,
  `Title` varchar(120) DEFAULT NULL,
  `Patient_Name` varchar(200) NOT NULL,
  `Date_Of_Birth` date NOT NULL,
  `Gender` varchar(7) NOT NULL,
  `Country` varchar(50) NOT NULL,
  `Region` varchar(70) NOT NULL,
  `District` varchar(40) NOT NULL,
  `Ward` varchar(50) NOT NULL,
  `Sponsor_ID` int(11) DEFAULT NULL,
  `Member_Number` varchar(100) DEFAULT NULL,
  `Member_Card_Expire_Date` date DEFAULT NULL,
  `Phone_Number` varchar(30) DEFAULT NULL,
  `Email_Address` varchar(60) DEFAULT NULL,
  `Occupation` varchar(100) DEFAULT NULL,
  `Employee_Vote_Number` varchar(150) DEFAULT NULL,
  `Emergence_Contact_Name` varchar(150) DEFAULT NULL,
  `Emergence_Contact_Number` varchar(30) DEFAULT NULL,
  `Company` varchar(150) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Registration_Date_And_Time` datetime NOT NULL,
  `Patient_Picture` varchar(15) NOT NULL DEFAULT 'default.png',
  `District_ID` int(11) DEFAULT NULL,
  `Registration_Date` date DEFAULT NULL,
  `Status` varchar(200) NOT NULL,
  `Tribe` varchar(30) NOT NULL,
  `Diseased` varchar(10) NOT NULL DEFAULT 'no',
  `Country_ID` int(11) NOT NULL,
  `Region_ID` int(11) NOT NULL,
  `Name_Prefix_ID` int(11) DEFAULT NULL,
  `Emergency_Contact_Name` varchar(150) DEFAULT NULL,
  `Emergency_Contact_Number` varchar(30) DEFAULT NULL,
  `Patient_Profile_Picture` bigint(20) DEFAULT NULL,
  `national_id` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`Registration_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Sponsor_ID` (`Sponsor_ID`),
  KEY `Region_ID` (`Region`),
  KEY `District_ID` (`District_ID`),
  KEY `Member_Number` (`Member_Number`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_bill`
--

CREATE TABLE `patient_bill` (
  `Patient_Bill_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) DEFAULT NULL,
  `Patient_Status` varchar(30) NOT NULL DEFAULT 'Outpatient',
  `Date_Time` datetime NOT NULL,
  `Status` varchar(15) DEFAULT 'active',
  PRIMARY KEY (`Patient_Bill_ID`),
  KEY `Registration_ID` (`Registration_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_blood_glucose`
--

CREATE TABLE `patient_blood_glucose` (
  `Testing_record_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) NOT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `employee_ID` int(11) DEFAULT NULL,
  `Days` varchar(25) NOT NULL,
  `date` datetime NOT NULL,
  `type` varchar(25) NOT NULL,
  `meal` varchar(25) NOT NULL,
  `notes` varchar(500) NOT NULL,
  `Glucose` varchar(25) NOT NULL,
  PRIMARY KEY (`Testing_record_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `employee_ID` (`employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_disease`
--

CREATE TABLE `patient_disease` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `record_date` datetime NOT NULL,
  `disease_id` int(11) NOT NULL,
  `disease_form` int(11) NOT NULL,
  `diagnosis_type` int(11) NOT NULL,
  `check_in_id` int(11) NOT NULL,
  `registration_id` int(11) DEFAULT NULL,
  `consultation_id` int(11) DEFAULT NULL,
  `round_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `patient_disease_check_in_id_foreign` (`check_in_id`),
  KEY `patient_disease_employee_id_foreign` (`employee_id`),
  KEY `patient_disease_registration_id_foreign` (`registration_id`),
  KEY `patient_disease_disease_id_foreign` (`disease_id`),
  KEY `patient_disease_consultation_id_foreign` (`consultation_id`),
  KEY `patient_disease_round_id_foreign` (`round_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_file_view`
--

CREATE TABLE `patient_file_view` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Registration_ID` int(11) DEFAULT NULL,
  `view_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Registration_ID` (`Registration_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_insurer`
--

CREATE TABLE `patient_insurer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patient_id` int(11) NOT NULL,
  `insurer_id` int(11) NOT NULL,
  `is_active` int(1) NOT NULL DEFAULT '1',
  `active_card_for_visit` int(1) NOT NULL DEFAULT '0',
  `card_no` varchar(255) DEFAULT NULL,
  `card_expire_date` datetime DEFAULT NULL,
  `employer_vote_no` varchar(255) DEFAULT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `patient_insurer_patient_id_foreign` (`patient_id`),
  KEY `patient_insurer_insurer_id_foreign` (`insurer_id`),
  CONSTRAINT `patient_insurer_insurer_id_foreign` FOREIGN KEY (`insurer_id`) REFERENCES `insurer` (`Sponsor_ID`),
  CONSTRAINT `patient_insurer_patient_id_foreign` FOREIGN KEY (`patient_id`) REFERENCES `patient` (`Registration_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_intake_output`
--

CREATE TABLE `patient_intake_output` (
  `inputOutput_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) NOT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `employee_ID` int(11) DEFAULT NULL,
  `Date` datetime NOT NULL,
  `Day_Fluid` varchar(25) NOT NULL,
  `Amount_Fluid` varchar(25) NOT NULL,
  `Amount_Oral` varchar(25) NOT NULL,
  `Urine` varchar(25) NOT NULL,
  `Stool` varchar(25) NOT NULL,
  `Vomit` varchar(25) NOT NULL,
  `Remarks` varchar(25) NOT NULL,
  PRIMARY KEY (`inputOutput_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `employee_ID` (`employee_ID`),
  CONSTRAINT `patient_intake_output_ibfk_1` FOREIGN KEY (`Registration_ID`) REFERENCES `patient` (`Registration_ID`),
  CONSTRAINT `patient_intake_output_ibfk_2` FOREIGN KEY (`consultation_ID`) REFERENCES `clinical_note` (`consultation_ID`),
  CONSTRAINT `patient_intake_output_ibfk_3` FOREIGN KEY (`employee_ID`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_medicine_given`
--

CREATE TABLE `patient_medicine_given` (
  `Given_Service_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) DEFAULT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `Payment_Item_Cache_List_ID` int(11) DEFAULT NULL,
  `Item_ID` int(11) DEFAULT NULL,
  `Time_Given` datetime NOT NULL,
  `Date_Given` date NOT NULL,
  `Amount_Given` int(10) NOT NULL,
  `Discontinue_Status` varchar(10) NOT NULL DEFAULT 'no',
  `Discontinue_Time` datetime DEFAULT NULL,
  `Discontinue_Reason` varchar(255) DEFAULT NULL,
  `Nurse_Remarks` varchar(255) NOT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Round_ID` int(11) DEFAULT NULL,
  `Medication_type` varchar(50) NOT NULL,
  `Admission_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Given_Service_ID`),
  KEY `Round_ID` (`Round_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `Payment_Item_Cache_List_ID` (`Payment_Item_Cache_List_ID`),
  KEY `Item_ID` (`Item_ID`),
  KEY `Admission_ID` (`Admission_ID`),
  CONSTRAINT `patient_medicine_given_ibfk_1` FOREIGN KEY (`Registration_ID`) REFERENCES `patient` (`Registration_ID`),
  CONSTRAINT `patient_medicine_given_ibfk_2` FOREIGN KEY (`consultation_ID`) REFERENCES `clinical_note` (`consultation_ID`),
  CONSTRAINT `patient_medicine_given_ibfk_4` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `patient_medicine_given_ibfk_5` FOREIGN KEY (`Round_ID`) REFERENCES `ward_round` (`Round_ID`),
  CONSTRAINT `patient_medicine_given_ibfk_6` FOREIGN KEY (`Payment_Item_Cache_List_ID`) REFERENCES `orders_items` (`Payment_Item_Cache_List_ID`),
  CONSTRAINT `patient_medicine_given_ibfk_7` FOREIGN KEY (`Item_ID`) REFERENCES `product` (`Item_ID`),
  CONSTRAINT `patient_medicine_given_ibfk_8` FOREIGN KEY (`Admission_ID`) REFERENCES `admission` (`Admision_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_nurse_care`
--

CREATE TABLE `patient_nurse_care` (
  `Nursecare_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) NOT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `employee_ID` int(11) DEFAULT NULL,
  `Days` datetime NOT NULL,
  `Nurse_Care` varchar(500) NOT NULL,
  `Objective_Care` varchar(500) NOT NULL,
  `Expect_Outcome` varchar(500) NOT NULL,
  `Nursing_Intervate` varchar(500) NOT NULL,
  `Evaluation` varchar(500) NOT NULL,
  PRIMARY KEY (`Nursecare_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `employee_ID` (`employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_paediatric_history`
--

CREATE TABLE `patient_paediatric_history` (
  `Paediatric_history_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Paediatric_history` text,
  `Paediatric_date` datetime DEFAULT NULL,
  `Employee_ID` int(11) NOT NULL,
  `Registration_ID` int(11) NOT NULL,
  PRIMARY KEY (`Paediatric_history_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Registration_ID` (`Registration_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_paediatric_observation`
--

CREATE TABLE `patient_paediatric_observation` (
  `paediatric_observation_Id` int(11) NOT NULL AUTO_INCREMENT,
  `observation_admission_Id` int(11) NOT NULL,
  `date_time` datetime NOT NULL,
  `temp` varchar(50) NOT NULL,
  `Pr` varchar(50) NOT NULL,
  `Resp` varchar(50) NOT NULL,
  `So` varchar(50) NOT NULL,
  `problem` varchar(50) NOT NULL,
  `diagnosis` varchar(50) NOT NULL,
  `exp_outcome` varchar(50) NOT NULL,
  `implememntation` varchar(50) NOT NULL,
  `outcome` varchar(50) NOT NULL,
  `investigation` varchar(50) NOT NULL,
  `remarks` varchar(50) NOT NULL,
  `Employee_ID` int(11) NOT NULL,
  `Registration_ID` int(11) NOT NULL,
  PRIMARY KEY (`paediatric_observation_Id`),
  KEY `paediatric_observation_employee_id_foreign` (`Employee_ID`),
  KEY `paediatric_observation_registration_id_foreign` (`Registration_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_past_medical_history`
--

CREATE TABLE `patient_past_medical_history` (
  `Medical_history_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) NOT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `Past_Illness` text NOT NULL,
  `Hospitalization` text NOT NULL,
  `Surgical_History` text NOT NULL,
  `Current_Medication` text NOT NULL,
  `Allergies` text NOT NULL,
  `Obsetric_Gynaecology` text NOT NULL,
  `Immunization_Democology` text NOT NULL,
  `Dental` text,
  `Others` text,
  PRIMARY KEY (`Medical_history_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `Employee_ID` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_progress`
--

CREATE TABLE `patient_progress` (
  `Progress_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Admision_ID` int(11) DEFAULT NULL,
  `Consultation_ID` int(11) DEFAULT NULL,
  `Checked_Date_Time` datetime DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Assessment` text,
  `Nursing_Diagnosis` text,
  `Goal` text,
  `Nursing_Interverntion` text,
  `Evaluation` text,
  `Registration_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Progress_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Admision_ID` (`Admision_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `Consultation_ID` (`Consultation_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_service_given`
--

CREATE TABLE `patient_service_given` (
  `Given_Service_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) DEFAULT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `Service_ID` int(11) DEFAULT NULL,
  `Time_Given` datetime NOT NULL,
  `Discontinue_Status` varchar(10) NOT NULL DEFAULT 'no',
  `Discontinue_Time` datetime DEFAULT NULL,
  `Discontinue_Reason` varchar(500) DEFAULT NULL,
  `Nurse_Remarks` varchar(500) NOT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Patient_Payment_ID` int(11) DEFAULT NULL,
  `Admision_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Given_Service_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `Patient_Payment_ID` (`Patient_Payment_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Service_ID` (`Service_ID`),
  KEY `consultation_ID_2` (`consultation_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `Admision_ID` (`Admision_ID`),
  CONSTRAINT `patient_service_given_ibfk_1` FOREIGN KEY (`Registration_ID`) REFERENCES `patient` (`Registration_ID`),
  CONSTRAINT `patient_service_given_ibfk_2` FOREIGN KEY (`consultation_ID`) REFERENCES `clinical_note` (`consultation_ID`),
  CONSTRAINT `patient_service_given_ibfk_3` FOREIGN KEY (`Service_ID`) REFERENCES `product` (`Item_ID`),
  CONSTRAINT `patient_service_given_ibfk_4` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `patient_service_given_ibfk_5` FOREIGN KEY (`Patient_Payment_ID`) REFERENCES `sales` (`Patient_Payment_ID`),
  CONSTRAINT `patient_service_given_ibfk_6` FOREIGN KEY (`Admision_ID`) REFERENCES `admission` (`Admision_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_transfer`
--

CREATE TABLE `patient_transfer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `check_in_id` int(11) NOT NULL,
  `from_consultant_id` int(11) NOT NULL,
  `to_consultant_id` int(11) NOT NULL,
  `transfer_date` datetime NOT NULL,
  `employee_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `patient_transfer_check_in_id_foreign` (`check_in_id`),
  KEY `patient_transfer_from_consultant_id_foreign` (`from_consultant_id`),
  KEY `patient_transfer_to_consultant_id_foreign` (`to_consultant_id`),
  KEY `patient_transfer_employee_id_foreign` (`employee_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_visit`
--

CREATE TABLE `patient_visit` (
  `Check_In_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) DEFAULT NULL,
  `Visit_Date` date DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Check_In_Date_And_Time` datetime DEFAULT NULL,
  `Check_In_Status` varchar(50) DEFAULT 'pending',
  `Branch_ID` int(11) DEFAULT NULL,
  `Saved_Date_And_Time` datetime DEFAULT NULL,
  `Check_In_Date` date NOT NULL,
  `Type_Of_Check_In` varchar(20) NOT NULL,
  `Folio_Status` varchar(15) DEFAULT 'pending',
  `AuthorizationNo` varchar(50) DEFAULT NULL,
  `CardStatus` varchar(50) DEFAULT NULL,
  `Sub_Department_ID` int(10) unsigned DEFAULT NULL,
  `Patient_File_Status` int(11) DEFAULT '1',
  `track_number_status` int(2) DEFAULT '1',
  `admitting_doctor` int(11) DEFAULT NULL,
  PRIMARY KEY (`Check_In_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Branch_ID` (`Branch_ID`),
  KEY `patient_visit_admitting_doctor_foreign` (`admitting_doctor`),
  CONSTRAINT `patient_visit_admitting_doctor_foreign` FOREIGN KEY (`admitting_doctor`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `patient_visit_ibfk_1` FOREIGN KEY (`Registration_ID`) REFERENCES `patient` (`Registration_ID`),
  CONSTRAINT `patient_visit_ibfk_2` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `patient_visit_ibfk_3` FOREIGN KEY (`Branch_ID`) REFERENCES `branch` (`Branch_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_visit_details`
--

CREATE TABLE `patient_visit_details` (
  `Check_In_Details_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) NOT NULL,
  `Check_In_ID` int(11) DEFAULT NULL,
  `Claim_Form_Number` varchar(100) NOT NULL,
  `Folio_Number` int(11) DEFAULT NULL,
  `Sponsor_ID` int(11) NOT NULL,
  `ToBe_Admitted` varchar(10) NOT NULL DEFAULT 'no',
  `Admission_ID` int(11) DEFAULT NULL,
  `Admit_Status` varchar(20) NOT NULL DEFAULT 'not admitted',
  `ToBe_Admitted_Reason` varchar(255) NOT NULL,
  `Employee_ID` int(11) NOT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `Employee_Cancel` int(11) DEFAULT NULL COMMENT 'Employee cancel admission',
  `Date_Cancelled` datetime DEFAULT NULL,
  `Consultant_ID` int(11) DEFAULT NULL,
  `Check_In_Type` int(1) DEFAULT NULL,
  `Payment_Cache_ID` int(11) DEFAULT NULL,
  `Patient_Direction` varchar(15) DEFAULT NULL,
  `auth_referral_no` varchar(255) DEFAULT NULL,
  `auth_number` varchar(255) DEFAULT NULL,
  `remarks` text,
  `auth_status` varchar(255) DEFAULT NULL,
  `auth_remark` text,
  `member_card_no` varchar(255) DEFAULT NULL,
  `auth_visit_type` varchar(255) DEFAULT NULL,
  `tracking_number` int(11) DEFAULT NULL,
  `claim_status` int(11) DEFAULT '1',
  `claim_progress_status` int(11) DEFAULT '0',
  `claim_progress_final` int(11) DEFAULT '0',
  `claim_id` varchar(255) DEFAULT NULL,
  `claim_batch_id` int(11) DEFAULT NULL,
  `claim_reference_no` varchar(255) DEFAULT NULL,
  `claim_valid_scheme` varchar(2) DEFAULT '1',
  `claim_patient_signature` int(11) DEFAULT NULL,
  `claim_clinician` int(11) DEFAULT NULL,
  `claim_clinician_signature` int(11) DEFAULT NULL,
  `priority` int(1) NOT NULL DEFAULT '1',
  `nurse_vital_recorded` varchar(1) DEFAULT 'N',
  PRIMARY KEY (`Check_In_Details_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `Sponsor_ID` (`Sponsor_ID`),
  KEY `Check_In_ID` (`Check_In_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `Employee_Cancel` (`Employee_Cancel`),
  KEY `Admission_ID` (`Admission_ID`),
  KEY `check_in_details_claim_batch_id_foreign` (`claim_batch_id`),
  CONSTRAINT `check_in_details_claim_batch_id_foreign` FOREIGN KEY (`claim_batch_id`) REFERENCES `claim_batch` (`id`),
  CONSTRAINT `patient_visit_details_ibfk_1` FOREIGN KEY (`Registration_ID`) REFERENCES `patient` (`Registration_ID`),
  CONSTRAINT `patient_visit_details_ibfk_2` FOREIGN KEY (`Sponsor_ID`) REFERENCES `insurer` (`Sponsor_ID`),
  CONSTRAINT `patient_visit_details_ibfk_3` FOREIGN KEY (`consultation_ID`) REFERENCES `clinical_note` (`consultation_ID`),
  CONSTRAINT `patient_visit_details_ibfk_4` FOREIGN KEY (`Check_In_ID`) REFERENCES `patient_visit` (`Check_In_ID`),
  CONSTRAINT `patient_visit_details_ibfk_5` FOREIGN KEY (`Employee_Cancel`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `patient_visit_details_ibfk_6` FOREIGN KEY (`Admission_ID`) REFERENCES `admission` (`Admision_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=180 DEFAULT CHARSET=latin1;

--
-- Table structure for table `patient_vital`
--

CREATE TABLE `patient_vital` (
  `patient_vital_id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `registration_id` int(11) NOT NULL,
  `taken_date` datetime NOT NULL,
  PRIMARY KEY (`patient_vital_id`),
  KEY `patient_vital_employee_id_foreign` (`employee_id`),
  KEY `patient_vital_registration_id_foreign` (`registration_id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `patient_vital_value`
--

CREATE TABLE `patient_vital_value` (
  `patient_vital_value_id` int(11) NOT NULL AUTO_INCREMENT,
  `patient_vital_id` int(11) NOT NULL,
  `vital_id` int(11) NOT NULL,
  `vital_value` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`patient_vital_value_id`),
  KEY `patient_vital_value_patient_vital_id_foreign` (`patient_vital_id`),
  KEY `patient_vital_value_vital_id_foreign` (`vital_id`)
) ENGINE=InnoDB AUTO_INCREMENT=277 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `pending_purchase_order_item`
--

CREATE TABLE `pending_purchase_order_item` (
  `Order_Item_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Purchase_Order_ID` int(11) NOT NULL,
  `Quantity_Required` int(11) NOT NULL,
  `Containers_Required` int(11) NOT NULL DEFAULT '0',
  `Items_Per_Container_Required` int(11) NOT NULL DEFAULT '0',
  `Price` double DEFAULT NULL,
  `Remark` varchar(120) DEFAULT NULL,
  `Item_ID` int(11) DEFAULT NULL,
  `Quantity_Supplied` int(11) DEFAULT NULL,
  `Quantity_Received` int(11) DEFAULT NULL,
  `Containers_Received` int(11) NOT NULL DEFAULT '0',
  `Items_Per_Container` int(11) NOT NULL DEFAULT '0',
  `Buying_Price` decimal(63,2) DEFAULT NULL,
  `Grn_Purchase_Order_ID` int(11) DEFAULT NULL,
  `Item_Status` varchar(30) NOT NULL DEFAULT 'active',
  `Expire_Date` date DEFAULT NULL,
  `Grn_Status` varchar(20) DEFAULT NULL,
  `Pending_Purchase_Order_ID` int(11) NOT NULL,
  `was_pending` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`Order_Item_ID`),
  KEY `order_id` (`Purchase_Order_ID`,`Item_ID`),
  KEY `Item_ID` (`Item_ID`),
  KEY `Pending_Purchase_Order_ID` (`Pending_Purchase_Order_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `pf3_patients`
--

CREATE TABLE `pf3_patients` (
  `pf3_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) NOT NULL,
  `Check_In_ID` int(11) NOT NULL,
  `pf3_attachment_file` varchar(100) NOT NULL,
  `pf3_Date_And_Time` datetime NOT NULL,
  `pf3_Description` varchar(500) NOT NULL,
  `Police_Station` varchar(50) NOT NULL,
  `Pf3_Number` varchar(50) NOT NULL,
  `Relative` varchar(50) NOT NULL,
  `Phone_No_Relative` int(20) NOT NULL,
  `Reason_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`pf3_ID`),
  KEY `Reason_ID` (`Reason_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `post_operative_note`
--

CREATE TABLE `post_operative_note` (
  `Post_operative_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL COMMENT 'foreign key from tbl_item_list_cache',
  `Surgery_Date` date NOT NULL,
  `Surgery_Date_Time` datetime DEFAULT NULL,
  `Incision` varchar(100) NOT NULL,
  `Position` varchar(100) NOT NULL,
  `Type_Of_Anesthetic` varchar(30) DEFAULT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `Registration_ID` int(11) NOT NULL,
  `Employee_ID` int(11) NOT NULL COMMENT 'Doctor ID',
  `Procedure_Description` text,
  `Identification_Of_Prosthesis` text,
  `Estimated_Blood_loss` text,
  `Complications` text,
  `Drains` text,
  `Specimen_sent` text,
  `Postoperative_Orders` text,
  `Recommendations` text,
  `Post_Operative_Status` varchar(20) NOT NULL DEFAULT 'pending',
  PRIMARY KEY (`Post_operative_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `Payment_Item_Cache_List_ID` (`Payment_Item_Cache_List_ID`),
  KEY `Registration_ID` (`Registration_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `post_operative_note_diagnosis`
--

CREATE TABLE `post_operative_note_diagnosis` (
  `Diagnosis_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Disease_ID` int(11) DEFAULT NULL,
  `Diagnosis_Type` varchar(50) DEFAULT NULL,
  `Post_operative_ID` int(11) DEFAULT NULL,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL,
  PRIMARY KEY (`Diagnosis_ID`),
  KEY `Post_operative_ID` (`Post_operative_ID`),
  KEY `Disease_ID` (`Disease_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `post_operative_participant`
--

CREATE TABLE `post_operative_participant` (
  `Participant_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Post_operative_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Employee_Type` varchar(50) DEFAULT NULL,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL,
  PRIMARY KEY (`Participant_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Post_operative_ID` (`Post_operative_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `procedure_post_operative_note`
--

CREATE TABLE `procedure_post_operative_note` (
  `Post_operative_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Procedure_Date` datetime DEFAULT NULL,
  `Procedure_Date_Time` datetime DEFAULT NULL,
  `Incision` varchar(50) DEFAULT NULL,
  `Position` varchar(50) DEFAULT NULL,
  `Type_Of_Anesthetic` int(11) DEFAULT NULL,
  `Employee_ID` int(11) NOT NULL,
  `Procedure_Description` text,
  `Identification_Of_Prosthesis` varchar(50) DEFAULT NULL,
  `Estimated_Blood_loss` varchar(50) DEFAULT NULL,
  `Complications` varchar(50) DEFAULT NULL,
  `Drains` varchar(50) DEFAULT NULL,
  `Specimen_sent` text,
  `Postoperative_Orders` varchar(50) DEFAULT NULL,
  `Recommendations` text,
  `Post_Operative_Status` int(11) DEFAULT NULL,
  `Payment_Item_Cache_List_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Post_operative_ID`),
  KEY `Employee_ID` (`Employee_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `Item_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Item_Type` varchar(100) NOT NULL,
  `code` varchar(100) DEFAULT NULL,
  `uom` varchar(700) NOT NULL,
  `name` varchar(700) NOT NULL,
  `Item_Subcategory_ID` int(11) DEFAULT NULL,
  `Status` varchar(30) DEFAULT NULL,
  `reorder_level` varchar(50) DEFAULT NULL,
  `Consultation_Type` varchar(30) NOT NULL,
  `Last_Buy_Price` int(11) NOT NULL DEFAULT '0',
  `Classification` varchar(50) NOT NULL,
  `can_be_sold` int(1) NOT NULL,
  `can_be_stocked` int(1) NOT NULL,
  `allow_zero_price` bit(1) NOT NULL DEFAULT b'0',
  `ct_scan_item` int(1) NOT NULL,
  `consultation_Item` varchar(10) NOT NULL,
  `particular_type` varchar(15) NOT NULL,
  `special_appointment_item` int(1) NOT NULL,
  `branch_id` int(11) NOT NULL,
  `description_type` int(1) NOT NULL,
  `can_be_purchased` int(1) NOT NULL,
  `can_expire` int(1) NOT NULL,
  PRIMARY KEY (`Item_ID`),
  UNIQUE KEY `Product_Name` (`name`),
  KEY `Item_Subcategory_ID` (`Item_Subcategory_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=8920 DEFAULT CHARSET=latin1;

--
-- Table structure for table `product_balance`
--

CREATE TABLE `product_balance` (
  `Item_ID` int(11) NOT NULL DEFAULT '0',
  `Item_Balance` int(11) NOT NULL DEFAULT '0',
  `Item_Temporary_Balance` int(11) NOT NULL DEFAULT '0',
  `Sub_Department_ID` int(11) NOT NULL DEFAULT '0',
  `Sub_Department_Type` varchar(40) DEFAULT NULL,
  `Reorder_Level` int(11) NOT NULL DEFAULT '0',
  `Reorder_Level_Status` varchar(20) NOT NULL DEFAULT 'normal',
  PRIMARY KEY (`Item_ID`,`Sub_Department_ID`),
  KEY `Item_ID` (`Item_ID`),
  KEY `Sub_Department_ID` (`Sub_Department_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `product_category`
--

CREATE TABLE `product_category` (
  `Item_Category_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Item_Category_Name` varchar(150) NOT NULL,
  `Category_Type` varchar(20) NOT NULL DEFAULT 'Service',
  `Revenue_Category` varchar(3) NOT NULL DEFAULT 'no',
  PRIMARY KEY (`Item_Category_ID`),
  UNIQUE KEY `Item_Category_Name` (`Item_Category_Name`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Table structure for table `product_general_price`
--

CREATE TABLE `product_general_price` (
  `Item_ID` int(11) NOT NULL DEFAULT '0',
  `Items_Price` float DEFAULT NULL,
  `Currency_ID` varchar(11) DEFAULT '3166',
  `comparison_price` float DEFAULT NULL,
  KEY `Item_ID` (`Item_ID`),
  CONSTRAINT `product_general_price_ibfk_1` FOREIGN KEY (`Item_ID`) REFERENCES `product` (`Item_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `product_price`
--

CREATE TABLE `product_price` (
  `Sponsor_ID` int(11) NOT NULL DEFAULT '0',
  `Item_ID` int(11) NOT NULL DEFAULT '0',
  `Items_Price` float DEFAULT NULL,
  `Currency_ID` varchar(11) DEFAULT '3166',
  `comparison_price` float DEFAULT NULL,
  PRIMARY KEY (`Sponsor_ID`,`Item_ID`),
  KEY `Item_ID` (`Item_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `purchase_cache`
--

CREATE TABLE `purchase_cache` (
  `Purchase_Cache_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Quantity_Required` int(11) NOT NULL DEFAULT '0',
  `Item_Remark` varchar(200) DEFAULT NULL,
  `Item_ID` int(11) DEFAULT NULL,
  `Container_Qty` int(11) NOT NULL DEFAULT '0',
  `Items_Per_Container` int(11) NOT NULL DEFAULT '0',
  `Price` double NOT NULL DEFAULT '0',
  `Store_Need` int(11) NOT NULL,
  `Requisition_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `is_store_order` varchar(5) NOT NULL DEFAULT 'no',
  `Store_Order_Id` int(11) DEFAULT NULL,
  `Supplier_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Purchase_Cache_ID`),
  KEY `item_id` (`Item_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Store_Need` (`Store_Need`),
  KEY `Supplier_ID` (`Supplier_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;

--
-- Table structure for table `purchase_order`
--

CREATE TABLE `purchase_order` (
  `Purchase_Order_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Order_Description` varchar(200) DEFAULT NULL,
  `Created_Date` datetime NOT NULL,
  `Sent_Date` datetime DEFAULT NULL,
  `Sub_Department_ID` int(11) DEFAULT NULL,
  `Supplier_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Order_Status` varchar(30) DEFAULT 'pending',
  `Branch_ID` int(11) DEFAULT NULL,
  `Grn_Purchase_Order_ID` int(11) NOT NULL,
  `Approval_Level` int(11) NOT NULL DEFAULT '1',
  `Approvals` int(11) NOT NULL DEFAULT '2' COMMENT 'Number of approval steps',
  `Store_Order_ID` int(11) DEFAULT NULL,
  `Previous_Purchase_Order_Data` text,
  `Purchase_Order_Type` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Purchase_Order_ID`),
  KEY `store_need` (`Sub_Department_ID`),
  KEY `store_need_2` (`Sub_Department_ID`),
  KEY `supplier_id` (`Supplier_ID`),
  KEY `Store_Need_3` (`Sub_Department_ID`),
  KEY `Sub_Department_ID` (`Sub_Department_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Branch_ID` (`Branch_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;

--
-- Table structure for table `purchase_order_approval_process`
--

CREATE TABLE `purchase_order_approval_process` (
  `Purchase_Approval_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Purchase_Order_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Approval_ID` int(11) DEFAULT NULL,
  `Approval_Date_Time` datetime NOT NULL,
  `Approval_Title` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`Purchase_Approval_ID`),
  KEY `Purchase_Order_ID` (`Purchase_Order_ID`),
  KEY `Employee_ID` (`Employee_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Table structure for table `purchase_order_item`
--

CREATE TABLE `purchase_order_item` (
  `Order_Item_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Purchase_Order_ID` int(11) NOT NULL,
  `Quantity_Required` int(11) NOT NULL,
  `Containers_Required` int(11) NOT NULL DEFAULT '0',
  `Items_Per_Container_Required` int(11) NOT NULL DEFAULT '0',
  `Price` double DEFAULT NULL,
  `Remark` varchar(120) DEFAULT NULL,
  `Item_ID` int(11) DEFAULT NULL,
  `Quantity_Supplied` int(11) DEFAULT NULL,
  `Quantity_Received` int(11) DEFAULT NULL,
  `Containers_Received` int(11) NOT NULL DEFAULT '0',
  `Items_Per_Container` int(11) NOT NULL DEFAULT '0',
  `Buying_Price` double DEFAULT NULL,
  `Grn_Purchase_Order_ID` int(11) DEFAULT NULL,
  `Item_Status` varchar(30) NOT NULL DEFAULT 'active',
  `Expire_Date` date DEFAULT NULL,
  `Grn_Status` varchar(20) DEFAULT NULL,
  `was_pending` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`Order_Item_ID`),
  KEY `order_id` (`Purchase_Order_ID`,`Item_ID`),
  KEY `Item_ID` (`Item_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

--
-- Table structure for table `radiology_discription`
--

CREATE TABLE `radiology_discription` (
  `Radiology_Description_ID` int(30) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) NOT NULL,
  `Item_ID` int(11) NOT NULL,
  `Parameter_ID` int(11) DEFAULT NULL,
  `Patient_Payment_Item_List_ID` int(11) NOT NULL,
  `comments` text NOT NULL,
  `Radiology_Date` date NOT NULL,
  `Status` varchar(15) NOT NULL,
  PRIMARY KEY (`Radiology_Description_ID`),
  KEY `Parameter_ID` (`Parameter_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `radiology_parameter`
--

CREATE TABLE `radiology_parameter` (
  `Parameter_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Parameter_Name` varchar(30) NOT NULL,
  `Item_ID` int(11) NOT NULL,
  PRIMARY KEY (`Parameter_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=372 DEFAULT CHARSET=latin1;

--
-- Table structure for table `radiology_patient_test`
--

CREATE TABLE `radiology_patient_test` (
  `Radiology_Test_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Item_ID` int(11) NOT NULL COMMENT 'Radiology Item ID',
  `Patient_Payment_Item_List_ID` int(11) NOT NULL,
  `Registration_ID` int(11) NOT NULL,
  `Status` varchar(50) NOT NULL,
  `Results_Status` varchar(20) NOT NULL,
  `Remarks` varchar(50) NOT NULL,
  `Classification` varchar(50) NOT NULL,
  `Sonographer_ID` int(11) DEFAULT NULL,
  `Radiologist_ID` int(11) DEFAULT NULL,
  `Reporteur` int(11) DEFAULT NULL,
  `Date_Time` datetime NOT NULL,
  `PatientOrigin` varchar(50) NOT NULL DEFAULT 'Doctor',
  PRIMARY KEY (`Radiology_Test_ID`),
  KEY `Reporteur` (`Reporteur`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `referral_hospital`
--

CREATE TABLE `referral_hospital` (
  `hosp_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ref_hosp_name` varchar(150) NOT NULL,
  PRIMARY KEY (`hosp_ID`),
  UNIQUE KEY `Vital` (`ref_hosp_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `region`
--

CREATE TABLE `region` (
  `Region_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Region_Name` varchar(100) NOT NULL,
  `Country_ID` int(11) NOT NULL,
  `Region_Status` varchar(20) NOT NULL DEFAULT 'Not Selected' COMMENT 'Control initial region to display during registration process',
  PRIMARY KEY (`Region_ID`),
  UNIQUE KEY `Region_Name` (`Region_Name`),
  KEY `Country_ID` (`Country_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

--
-- Table structure for table `requisition`
--

CREATE TABLE `requisition` (
  `Requisition_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Requisition_Description` varchar(150) DEFAULT NULL,
  `Created_Date_Time` datetime DEFAULT NULL,
  `Created_Date` date NOT NULL,
  `Sent_Date_Time` datetime DEFAULT NULL COMMENT 'Submitted date',
  `Store_Need` int(11) DEFAULT NULL COMMENT 'foreign key (sub_department_id)',
  `Store_Issue` int(11) DEFAULT NULL COMMENT 'foreign key (sub_department_id)',
  `Employee_ID` int(11) DEFAULT NULL,
  `Supervisor_ID` int(11) DEFAULT NULL,
  `Approval_Date_Time` datetime DEFAULT NULL,
  `Supervisor_Comment` varchar(500) DEFAULT NULL,
  `Requisition_Status` varchar(40) DEFAULT 'pending',
  `Branch_ID` int(11) NOT NULL,
  `Previous_Requisition_Data` text,
  PRIMARY KEY (`Requisition_ID`),
  KEY `Store_Need` (`Store_Need`),
  KEY `Store_Issue` (`Store_Issue`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Branch_ID` (`Branch_ID`),
  KEY `Supervisor_ID` (`Supervisor_ID`),
  CONSTRAINT `requisition_ibfk_1` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `requisition_ibfk_2` FOREIGN KEY (`Store_Need`) REFERENCES `sub_department` (`Sub_Department_ID`),
  CONSTRAINT `requisition_ibfk_3` FOREIGN KEY (`Store_Issue`) REFERENCES `sub_department` (`Sub_Department_ID`),
  CONSTRAINT `requisition_ibfk_4` FOREIGN KEY (`Branch_ID`) REFERENCES `branch` (`Branch_ID`),
  CONSTRAINT `requisition_ibfk_5` FOREIGN KEY (`Branch_ID`) REFERENCES `branch` (`Branch_ID`),
  CONSTRAINT `requisition_ibfk_6` FOREIGN KEY (`Supervisor_ID`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `requisition_item`
--

CREATE TABLE `requisition_item` (
  `Requisition_Item_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Requisition_ID` int(11) DEFAULT NULL,
  `Quantity_Required` int(11) NOT NULL,
  `Container_Qty` int(11) NOT NULL DEFAULT '0',
  `Items_Qty` int(11) NOT NULL DEFAULT '0',
  `Items_Per_Container` int(11) NOT NULL DEFAULT '0' COMMENT 'Items per containers issued',
  `Item_Remark` varchar(60) DEFAULT NULL,
  `Item_ID` int(11) DEFAULT NULL,
  `Quantity_Issued` int(11) NOT NULL DEFAULT '0',
  `Container_Issued` int(11) NOT NULL DEFAULT '0',
  `Quantity_Received` int(11) NOT NULL DEFAULT '0',
  `Last_Buying_Price` double NOT NULL DEFAULT '0',
  `Issue_ID` int(11) DEFAULT NULL,
  `Item_Status` varchar(20) NOT NULL DEFAULT 'active',
  `Status` varchar(10) NOT NULL DEFAULT 'active',
  `Procurement_Status` varchar(20) NOT NULL DEFAULT 'active',
  PRIMARY KEY (`Requisition_Item_ID`),
  KEY `Requizition_ID` (`Requisition_ID`),
  KEY `item_id` (`Item_ID`),
  KEY `Issue_ID` (`Issue_ID`),
  CONSTRAINT `requisition_item_ibfk_2` FOREIGN KEY (`Item_ID`) REFERENCES `product` (`Item_ID`),
  CONSTRAINT `requisition_item_ibfk_3` FOREIGN KEY (`Item_ID`) REFERENCES `product` (`Item_ID`),
  CONSTRAINT `requisition_item_ibfk_4` FOREIGN KEY (`Item_ID`) REFERENCES `product` (`Item_ID`),
  CONSTRAINT `requisition_item_ibfk_5` FOREIGN KEY (`Requisition_ID`) REFERENCES `requisition` (`Requisition_ID`),
  CONSTRAINT `requisition_item_ibfk_6` FOREIGN KEY (`Issue_ID`) REFERENCES `issue_note` (`Issue_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `return_inward`
--

CREATE TABLE `return_inward` (
  `Inward_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Inward_Date` date DEFAULT NULL,
  `Store_Sub_Department_ID` int(11) NOT NULL,
  `Return_Sub_Department_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Inward_Status` varchar(20) NOT NULL DEFAULT 'pending',
  `Created_Date_And_Time` datetime DEFAULT NULL,
  `Previous_Return_Inward_Data` text,
  PRIMARY KEY (`Inward_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Supplier_ID` (`Return_Sub_Department_ID`),
  KEY `Sub_Department_ID` (`Store_Sub_Department_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `return_inward_item`
--

CREATE TABLE `return_inward_item` (
  `Inward_Item_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Inward_ID` int(11) DEFAULT NULL,
  `Item_ID` int(11) DEFAULT NULL,
  `Quantity_Returned` int(11) DEFAULT NULL,
  `Item_Remark` varchar(250) DEFAULT NULL,
  `Buying_Price` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`Inward_Item_ID`),
  KEY `Outward_ID` (`Inward_ID`),
  KEY `Item_ID` (`Item_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `return_outward`
--

CREATE TABLE `return_outward` (
  `Outward_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Outward_Date` date DEFAULT NULL,
  `Sub_Department_ID` int(11) NOT NULL,
  `Supplier_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Outward_Status` varchar(20) NOT NULL DEFAULT 'pending',
  `Created_Date_And_Time` datetime DEFAULT NULL,
  `Previous_Return_Outward_Data` text,
  PRIMARY KEY (`Outward_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Supplier_ID` (`Supplier_ID`),
  KEY `Sub_Department_ID` (`Sub_Department_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `return_outward_item`
--

CREATE TABLE `return_outward_item` (
  `Outward_Item_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Outward_ID` int(11) DEFAULT NULL,
  `Item_ID` int(11) DEFAULT NULL,
  `Quantity_Returned` int(11) DEFAULT NULL,
  `Item_Remark` varchar(250) DEFAULT NULL,
  `Buying_Price` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`Outward_Item_ID`),
  KEY `Outward_ID` (`Outward_ID`),
  KEY `Item_ID` (`Item_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `Patient_Payment_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) DEFAULT NULL,
  `Supervisor_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Payment_Date_And_Time` datetime DEFAULT NULL,
  `Folio_Number` int(11) DEFAULT NULL,
  `Check_In_ID` int(11) DEFAULT NULL,
  `Claim_Form_Number` varchar(50) DEFAULT NULL,
  `Sponsor_ID` int(11) DEFAULT NULL,
  `Sponsor_Name` varchar(150) DEFAULT NULL,
  `Billing_Type` varchar(50) NOT NULL,
  `Receipt_Date` date NOT NULL,
  `Transaction_status` varchar(20) NOT NULL DEFAULT 'active',
  `Transaction_type` varchar(20) NOT NULL DEFAULT 'indirect cash',
  `payment_type` enum('post','pre') NOT NULL DEFAULT 'post',
  `Fast_Track` enum('1','0') NOT NULL DEFAULT '0',
  `branch_id` int(11) DEFAULT NULL,
  `Billing_Process_Status` varchar(50) DEFAULT NULL,
  `Billing_Process_Employee_ID` int(11) DEFAULT NULL COMMENT 'Employee who approved transaction',
  `Billing_Process_Date` date DEFAULT NULL COMMENT 'Date The transaction approved',
  `Bill_ID` int(11) NOT NULL DEFAULT '0' COMMENT 'foreign key referenced from tbl_bills',
  `payment_mode` varchar(20) NOT NULL DEFAULT 'normal',
  `Patient_Bill_ID` int(11) NOT NULL DEFAULT '0',
  `Transaction_Ref` varchar(150) DEFAULT NULL,
  `Transaction_Date` datetime DEFAULT NULL,
  `Payment_Code` varchar(100) DEFAULT NULL,
  `Currency_ID` int(11) DEFAULT NULL,
  `cancelation_reasons` text,
  `Sub_Department_ID` int(10) unsigned DEFAULT NULL,
  `previous_transaction_status` int(1) DEFAULT NULL,
  `tracking_number` int(11) DEFAULT NULL,
  `tin_number` varchar(9) DEFAULT NULL,
  PRIMARY KEY (`Patient_Payment_ID`),
  KEY `Supervisor_ID` (`Supervisor_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `Sponsor_ID` (`Sponsor_ID`),
  KEY `branch_id` (`branch_id`),
  KEY `Folio_Number` (`Folio_Number`),
  KEY `Check_In_ID` (`Check_In_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=296 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Table structure for table `sales_items`
--

CREATE TABLE `sales_items` (
  `Patient_Payment_Item_List_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Check_In_Type` varchar(60) DEFAULT NULL,
  `Category` varchar(100) DEFAULT 'indirect cash',
  `Item_ID` int(11) DEFAULT NULL,
  `Item_Name` varchar(200) DEFAULT NULL,
  `Discount` int(11) NOT NULL DEFAULT '0',
  `Price` float NOT NULL DEFAULT '0',
  `Quantity` int(11) NOT NULL DEFAULT '0',
  `Patient_Direction` varchar(150) DEFAULT NULL,
  `Consultant` varchar(100) DEFAULT NULL,
  `Consultant_ID` int(11) DEFAULT NULL,
  `Clinic_ID` int(11) DEFAULT NULL,
  `Status` varchar(40) DEFAULT 'active',
  `Patient_Payment_ID` int(11) DEFAULT NULL,
  `Transaction_Date_And_Time` datetime NOT NULL,
  `Process_Status` varchar(40) NOT NULL DEFAULT 'not served',
  `Nursing_Status` varchar(10) NOT NULL DEFAULT 'not served',
  `Sub_Department_ID` int(11) NOT NULL,
  `Signedoff_Date_And_Time` datetime DEFAULT NULL,
  `Record_Status` varchar(50) DEFAULT NULL,
  `Employee_Edited_ID` int(11) DEFAULT NULL,
  `remarks` varchar(200) DEFAULT NULL,
  `ServedDateTime` datetime DEFAULT NULL,
  `ServedBy` int(11) DEFAULT NULL,
  `ItemOrigin` varchar(20) NOT NULL DEFAULT 'Reception',
  `changed_By` int(11) DEFAULT NULL,
  `changed_Reasons` tinytext,
  `changed_Date` datetime DEFAULT NULL,
  `payment_type` varchar(9) NOT NULL,
  `Payment_Status` int(11) DEFAULT NULL,
  `approval_number` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Patient_Payment_Item_List_ID`),
  KEY `Patient_Payment_ID` (`Patient_Payment_ID`),
  KEY `Item_ID` (`Item_ID`),
  KEY `ServedBy` (`ServedBy`),
  KEY `Consultant_ID` (`Consultant_ID`),
  KEY `Clinic_ID` (`Clinic_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=339 DEFAULT CHARSET=latin1;

--
-- Table structure for table `scheduler`
--

CREATE TABLE `scheduler` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `last_run` datetime DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT '0',
  `current_key` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Table structure for table `spectacle`
--

CREATE TABLE `spectacle` (
  `Spectacle_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) DEFAULT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `Date_Time` datetime DEFAULT NULL,
  `Patient_Type` varchar(20) NOT NULL DEFAULT 'Outpatient',
  `Spectacle_Status` varchar(20) NOT NULL DEFAULT 'pending',
  `Employee_ID` int(11) DEFAULT NULL,
  `Round_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Spectacle_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `Round_ID` (`Round_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `Employee_ID` (`Employee_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Table structure for table `stock_balance_sub_department`
--

CREATE TABLE `stock_balance_sub_department` (
  `Stock_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Sub_Department_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Stock_ID`),
  KEY `Sub_Department_ID` (`Sub_Department_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Table structure for table `stock_count`
--

CREATE TABLE `stock_count` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` text NOT NULL,
  `status` int(1) NOT NULL,
  `date` date NOT NULL,
  `sub_department_id` int(11) NOT NULL,
  `supervised_by` int(11) DEFAULT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `previous_data` text,
  PRIMARY KEY (`id`),
  KEY `stock_count_sub_department_id_foreign` (`sub_department_id`),
  KEY `stock_count_created_by_foreign` (`created_by`),
  CONSTRAINT `stock_count_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `stock_count_sub_department_id_foreign` FOREIGN KEY (`sub_department_id`) REFERENCES `sub_department` (`Sub_Department_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `stock_count_item`
--

CREATE TABLE `stock_count_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stock_count_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `stock_count` int(11) NOT NULL,
  `stock_expired` int(11) DEFAULT NULL,
  `stock_damaged` int(11) DEFAULT NULL,
  `stock_obsolute` int(11) DEFAULT NULL,
  `stock_with_other_reasons` int(11) DEFAULT NULL,
  `system_balance` int(11) NOT NULL,
  `stock_variance` int(11) NOT NULL,
  `stock_condition` int(1) NOT NULL,
  `remark` text,
  `stock_room_id` int(11) DEFAULT NULL,
  `stock_room_shelf_id` int(11) DEFAULT NULL,
  `counted_by` int(11) DEFAULT NULL,
  `verified_by` int(11) DEFAULT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `stock_count_item_stock_count_id_foreign` (`stock_count_id`),
  KEY `stock_count_item_product_id_foreign` (`product_id`),
  KEY `stock_count_item_created_by_foreign` (`created_by`),
  KEY `stock_count_item_counted_by_foreign` (`counted_by`),
  KEY `stock_count_item_verified_by_foreign` (`verified_by`),
  KEY `stock_count_item_stock_room_id_foreign` (`stock_room_id`),
  KEY `stock_count_item_stock_room_shelf_id_foreign` (`stock_room_shelf_id`),
  CONSTRAINT `stock_count_item_counted_by_foreign` FOREIGN KEY (`counted_by`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `stock_count_item_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `stock_count_item_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `product` (`Item_ID`),
  CONSTRAINT `stock_count_item_stock_count_id_foreign` FOREIGN KEY (`stock_count_id`) REFERENCES `stock_count` (`id`),
  CONSTRAINT `stock_count_item_stock_room_id_foreign` FOREIGN KEY (`stock_room_id`) REFERENCES `stock_room` (`id`),
  CONSTRAINT `stock_count_item_stock_room_shelf_id_foreign` FOREIGN KEY (`stock_room_shelf_id`) REFERENCES `stock_room_shelf` (`id`),
  CONSTRAINT `stock_count_item_verified_by_foreign` FOREIGN KEY (`verified_by`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `stock_ledger_controller`
--

CREATE TABLE `stock_ledger_controller` (
  `Controler_ID` int(50) NOT NULL AUTO_INCREMENT,
  `Item_ID` int(11) DEFAULT NULL,
  `Sub_Department_ID` int(11) DEFAULT NULL,
  `Movement_Type` varchar(50) NOT NULL,
  `Internal_Destination` int(11) DEFAULT NULL COMMENT 'Sub department that requested',
  `External_Source` int(11) DEFAULT NULL COMMENT 'Item Supplier',
  `Registration_ID` int(11) DEFAULT NULL,
  `Pre_Balance` int(11) DEFAULT NULL,
  `Post_Balance` int(11) NOT NULL,
  `Movement_Date` date NOT NULL,
  `Document_Number` int(11) DEFAULT NULL,
  `Movement_Date_Time` datetime NOT NULL,
  `Buying_Price` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`Controler_ID`),
  KEY `Sub_Department_ID` (`Sub_Department_ID`),
  KEY `Internal_Destination` (`Internal_Destination`),
  KEY `Item_ID` (`Item_ID`),
  KEY `External_Source` (`External_Source`),
  KEY `Registration_ID` (`Registration_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=347 DEFAULT CHARSET=latin1;

--
-- Table structure for table `stock_room`
--

CREATE TABLE `stock_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sub_department_id` int(11) DEFAULT NULL,
  `description` text NOT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `stock_room_sub_department_id_foreign` (`sub_department_id`),
  CONSTRAINT `stock_room_sub_department_id_foreign` FOREIGN KEY (`sub_department_id`) REFERENCES `sub_department` (`Sub_Department_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `stock_room_shelf`
--

CREATE TABLE `stock_room_shelf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stock_room_id` int(11) DEFAULT NULL,
  `description` text NOT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `stock_room_shelf_stock_room_id_foreign` (`stock_room_id`),
  CONSTRAINT `stock_room_shelf_stock_room_id_foreign` FOREIGN KEY (`stock_room_id`) REFERENCES `stock_room` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `stock_taking`
--

CREATE TABLE `stock_taking` (
  `Stock_Taking_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Stock_Taking_Status` varchar(30) NOT NULL DEFAULT 'pending',
  `Stock_Taking_Date` date NOT NULL,
  `Stock_Taking_Description` varchar(200) DEFAULT NULL,
  `Sub_Department_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Created_Date` date NOT NULL,
  `Created_Date_And_Time` datetime NOT NULL,
  `Supervisor_ID` int(11) DEFAULT NULL,
  `Branch_ID` int(11) DEFAULT NULL,
  `Previous_Stock_Taking_Data` text,
  PRIMARY KEY (`Stock_Taking_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Supervisor_ID` (`Supervisor_ID`),
  KEY `Sub_Department_ID` (`Sub_Department_ID`),
  KEY `Branch_ID` (`Branch_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- Table structure for table `stock_taking_item`
--

CREATE TABLE `stock_taking_item` (
  `Stock_Taking_Item_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Item_ID` int(11) NOT NULL,
  `Over_Quantity` int(11) DEFAULT NULL,
  `Under_Quantity` int(11) DEFAULT NULL,
  `Item_Remark` varchar(200) DEFAULT NULL,
  `Stock_Taking_ID` int(11) NOT NULL,
  `Buying_Price` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`Stock_Taking_Item_ID`),
  KEY `Item_ID` (`Item_ID`),
  KEY `Stock_Taking_ID` (`Stock_Taking_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=368 DEFAULT CHARSET=utf8;

--
-- Table structure for table `store_order`
--

CREATE TABLE `store_order` (
  `Store_Order_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Order_Description` varchar(150) DEFAULT NULL,
  `Created_Date_Time` datetime DEFAULT NULL,
  `Created_Date` date NOT NULL,
  `Sent_Date_Time` datetime DEFAULT NULL COMMENT 'Submitted date',
  `Sub_Department_ID` int(11) DEFAULT NULL COMMENT 'Store Need / Requested',
  `Employee_ID` int(11) DEFAULT NULL,
  `Order_Status` varchar(40) DEFAULT 'pending',
  `Control_Status` varchar(20) NOT NULL DEFAULT 'available',
  `Branch_ID` int(11) NOT NULL,
  `Store_Order_Type` varchar(50) DEFAULT NULL,
  `Approval_Level` int(11) DEFAULT NULL,
  `Approvals` int(11) DEFAULT NULL,
  PRIMARY KEY (`Store_Order_ID`),
  KEY `Store_Need` (`Sub_Department_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Branch_ID` (`Branch_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Table structure for table `store_order_approval_process`
--

CREATE TABLE `store_order_approval_process` (
  `Store_Approval_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Store_Order_ID` int(11) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Approval_ID` int(11) DEFAULT NULL,
  `Approval_Date_Time` datetime NOT NULL,
  `Approval_Title` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`Store_Approval_ID`),
  KEY `Store_Order_ID` (`Store_Order_ID`),
  KEY `Employee_ID` (`Employee_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;

--
-- Table structure for table `store_order_item`
--

CREATE TABLE `store_order_item` (
  `Order_Item_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Store_Order_ID` int(11) DEFAULT NULL,
  `Quantity_Required` int(11) NOT NULL,
  `Container_Qty` int(11) NOT NULL DEFAULT '0',
  `Items_Qty` int(11) NOT NULL DEFAULT '0',
  `Items_Per_Container` int(11) NOT NULL DEFAULT '0' COMMENT 'Items per containers issued',
  `Last_Buying_Price` int(11) NOT NULL DEFAULT '0',
  `Item_Remark` varchar(60) DEFAULT NULL,
  `Item_ID` int(11) DEFAULT NULL,
  `Quantity_Issued` int(11) NOT NULL,
  `Container_Issued` int(11) NOT NULL DEFAULT '0',
  `Quantity_Received` int(11) NOT NULL,
  `Issue_ID` int(11) DEFAULT NULL,
  `Item_Status` varchar(20) NOT NULL DEFAULT 'active',
  `Status` varchar(10) NOT NULL DEFAULT 'active',
  `Procurement_Status` varchar(20) NOT NULL DEFAULT 'active',
  PRIMARY KEY (`Order_Item_ID`),
  KEY `Requizition_ID` (`Store_Order_ID`),
  KEY `item_id` (`Item_ID`),
  KEY `Issue_ID` (`Issue_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=latin1;

--
-- Table structure for table `sub_department`
--

CREATE TABLE `sub_department` (
  `Sub_Department_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Department_ID` int(11) DEFAULT NULL,
  `Sub_Department_Name` varchar(150) NOT NULL,
  PRIMARY KEY (`Sub_Department_ID`),
  UNIQUE KEY `Sub_Department_Name` (`Sub_Department_Name`),
  KEY `Department_ID` (`Department_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=latin1;

--
-- Table structure for table `supplier`
--

CREATE TABLE `supplier` (
  `Supplier_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Supplier_Name` varchar(120) NOT NULL,
  `Supplier_Address` varchar(200) DEFAULT NULL,
  `Mobile_Number` varchar(40) DEFAULT NULL,
  `Supplier_Email` varchar(100) DEFAULT NULL,
  `Physical_Address` text,
  `Postal_Address` text,
  `Telephone` varchar(255) DEFAULT NULL,
  `Fax` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Supplier_ID`),
  UNIQUE KEY `Supplier_Name` (`Supplier_Name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Table structure for table `system_notification`
--

CREATE TABLE `system_notification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `system_notification_employee`
--

CREATE TABLE `system_notification_employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `system_notification_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `system_notification_employee_employee_id_foreign` (`employee_id`),
  KEY `system_notification_employee_system_notification_id_foreign` (`system_notification_id`),
  CONSTRAINT `system_notification_employee_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `system_notification_employee_system_notification_id_foreign` FOREIGN KEY (`system_notification_id`) REFERENCES `system_notification` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `system_setting`
--

CREATE TABLE `system_setting` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `property_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `property_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `modified_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `modified_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=208 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `system_version`
--

CREATE TABLE `system_version` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_grn_issue_note`
--

CREATE TABLE `tbl_grn_issue_note` (
  `Grn_Issue_Note_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Created_Date` date NOT NULL,
  `Created_Date_Time` datetime NOT NULL,
  `Employee_ID` int(45) NOT NULL,
  `Issue_ID` int(11) NOT NULL,
  `Issue_Description` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`Grn_Issue_Note_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Purchase_Order_ID` (`Issue_Description`),
  KEY `Issue_ID` (`Issue_ID`),
  CONSTRAINT `tbl_grn_issue_note_ibfk_1` FOREIGN KEY (`Issue_ID`) REFERENCES `issue_note` (`Issue_ID`),
  CONSTRAINT `tbl_grn_issue_note_ibfk_2` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_grn_open_balance`
--

CREATE TABLE `tbl_grn_open_balance` (
  `Grn_Open_Balance_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Employee_ID` int(11) NOT NULL,
  `Branch_ID` int(11) NOT NULL,
  `Created_Date_Time` datetime NOT NULL,
  `Sub_Department_ID` int(11) NOT NULL COMMENT 'Receiver',
  `Grn_Open_Balance_Status` varchar(20) NOT NULL DEFAULT 'pending',
  `Saved_Date_Time` datetime DEFAULT NULL,
  `Grn_Open_Balance_Description` varchar(200) DEFAULT NULL,
  `Supervisor_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Grn_Open_Balance_ID`),
  KEY `receiver` (`Sub_Department_ID`),
  KEY `Supervisor_ID` (`Supervisor_ID`),
  KEY `tbl_grn_open_balance_ibfk_1` (`Employee_ID`),
  CONSTRAINT `tbl_grn_open_balance_ibfk_1` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `tbl_grn_open_balance_ibfk_2` FOREIGN KEY (`Supervisor_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `tbl_grn_open_balance_ibfk_3` FOREIGN KEY (`Sub_Department_ID`) REFERENCES `sub_department` (`Sub_Department_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_grn_open_balance_items`
--

CREATE TABLE `tbl_grn_open_balance_items` (
  `Open_Balance_Item_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Grn_Open_Balance_ID` int(11) NOT NULL,
  `Item_ID` int(11) NOT NULL,
  `Items_Per_Container` int(11) NOT NULL DEFAULT '0',
  `Container_Qty` int(11) NOT NULL DEFAULT '0',
  `Item_Quantity` int(11) NOT NULL,
  `Buying_Price` float DEFAULT NULL,
  `Item_Remark` varchar(100) DEFAULT NULL,
  `Manufacture_Date` date DEFAULT NULL,
  `Expire_Date` date DEFAULT NULL,
  PRIMARY KEY (`Open_Balance_Item_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_grn_purchase_order`
--

CREATE TABLE `tbl_grn_purchase_order` (
  `Grn_Purchase_Order_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Created_Date` date NOT NULL,
  `Created_Date_Time` datetime NOT NULL,
  `Employee_ID` int(45) NOT NULL,
  `Purchase_Order_ID` int(11) NOT NULL,
  `Debit_Note_Number` varchar(255) DEFAULT NULL,
  `Invoice_Number` varchar(255) DEFAULT NULL,
  `Delivery_Date` date DEFAULT NULL,
  `Delivery_Person` varchar(255) DEFAULT NULL,
  `Grn_Description` varchar(255) NOT NULL,
  PRIMARY KEY (`Grn_Purchase_Order_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Purchase_Order_ID` (`Purchase_Order_ID`),
  CONSTRAINT `tbl_grn_purchase_order_ibfk_1` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `tbl_grn_purchase_order_ibfk_2` FOREIGN KEY (`Purchase_Order_ID`) REFERENCES `purchase_order` (`Purchase_Order_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_grn_without_purchase_order`
--

CREATE TABLE `tbl_grn_without_purchase_order` (
  `Grn_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Grn_Date_And_Time` datetime NOT NULL,
  `Supervisor_ID` int(11) DEFAULT NULL,
  `Supervisor_Comment` varchar(300) DEFAULT NULL,
  `Employee_ID` int(11) DEFAULT NULL,
  `Sub_Department_ID` int(11) DEFAULT NULL,
  `Supplier_ID` int(11) DEFAULT NULL,
  `Debit_Note_Number` varchar(255) DEFAULT NULL,
  `Invoice_Number` varchar(255) DEFAULT NULL,
  `Delivery_Date` date DEFAULT NULL,
  `Grn_Status` varchar(50) NOT NULL,
  `Grn_Description` varchar(255) NOT NULL,
  PRIMARY KEY (`Grn_ID`),
  KEY `Supplier_ID` (`Supplier_ID`),
  KEY `Sub_Department_ID` (`Sub_Department_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Supervisor_ID` (`Supervisor_ID`),
  CONSTRAINT `tbl_grn_without_purchase_order_ibfk_1` FOREIGN KEY (`Supplier_ID`) REFERENCES `supplier` (`Supplier_ID`),
  CONSTRAINT `tbl_grn_without_purchase_order_ibfk_2` FOREIGN KEY (`Sub_Department_ID`) REFERENCES `sub_department` (`Sub_Department_ID`),
  CONSTRAINT `tbl_grn_without_purchase_order_ibfk_3` FOREIGN KEY (`Employee_ID`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `tbl_grn_without_purchase_order_ibfk_4` FOREIGN KEY (`Supervisor_ID`) REFERENCES `employee` (`Employee_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_grn_without_purchase_order_items`
--

CREATE TABLE `tbl_grn_without_purchase_order_items` (
  `Purchase_Order_Item_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Grn_ID` int(11) DEFAULT NULL,
  `Item_ID` int(11) NOT NULL,
  `Quantity_Required` int(11) DEFAULT NULL,
  `Container_Qty` int(11) DEFAULT NULL,
  `Items_Per_Container` int(11) DEFAULT NULL,
  `Price` double DEFAULT NULL,
  `Expire_Date` date DEFAULT NULL,
  `Item_Remark` varchar(150) NOT NULL,
  PRIMARY KEY (`Purchase_Order_Item_ID`),
  KEY `Item_ID` (`Item_ID`),
  KEY `Grn_ID` (`Grn_ID`),
  CONSTRAINT `tbl_grn_without_purchase_order_items_ibfk_1` FOREIGN KEY (`Item_ID`) REFERENCES `product` (`Item_ID`),
  CONSTRAINT `tbl_grn_without_purchase_order_items_ibfk_2` FOREIGN KEY (`Grn_ID`) REFERENCES `tbl_grn_without_purchase_order` (`Grn_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_gti_post_operative_diagnosis`
--

CREATE TABLE `tbl_gti_post_operative_diagnosis` (
  `Diagnosis_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Disease_ID` int(11) DEFAULT NULL,
  `Git_Post_operative_ID` int(11) DEFAULT NULL,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL,
  PRIMARY KEY (`Diagnosis_ID`),
  KEY `Disease_ID` (`Disease_ID`),
  KEY `Git_Post_operative_ID` (`Git_Post_operative_ID`),
  CONSTRAINT `tbl_gti_post_operative_diagnosis_ibfk_1` FOREIGN KEY (`Disease_ID`) REFERENCES `disease` (`disease_ID`),
  CONSTRAINT `tbl_gti_post_operative_diagnosis_ibfk_2` FOREIGN KEY (`Git_Post_operative_ID`) REFERENCES `git_post_operative_note` (`Git_Post_operative_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_ogd_post_operative_diagnosis`
--

CREATE TABLE `tbl_ogd_post_operative_diagnosis` (
  `Diagnosis_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Disease_ID` int(11) DEFAULT NULL,
  `Ogd_Post_operative_ID` int(11) DEFAULT NULL,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL,
  PRIMARY KEY (`Diagnosis_ID`),
  KEY `Post_operative_ID` (`Ogd_Post_operative_ID`),
  KEY `Disease_ID` (`Disease_ID`),
  KEY `Payment_Item_Cache_List_ID` (`Payment_Item_Cache_List_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_ogd_post_operative_notes`
--

CREATE TABLE `tbl_ogd_post_operative_notes` (
  `Ogd_Post_operative_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Payment_Item_Cache_List_ID` int(11) NOT NULL COMMENT 'foreign key from tbl_item_list_cache',
  `Surgery_Date` date NOT NULL,
  `Surgery_Date_Time` datetime DEFAULT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `Registration_ID` int(11) NOT NULL,
  `Employee_ID` int(11) NOT NULL COMMENT 'Doctor ID',
  `Indication_Of_Procedure` varchar(100) DEFAULT NULL,
  `Others` text NOT NULL,
  `Quality_Of_Bowel` varchar(20) DEFAULT NULL,
  `Endoscorpic_Internvention` varchar(255) DEFAULT NULL,
  `Type_And_Dose` varchar(100) DEFAULT NULL,
  `Adverse_Event_Resulting` varchar(100) DEFAULT NULL,
  `Management_Recommendation` varchar(500) DEFAULT NULL,
  `Extent_Of_Examination` varchar(100) DEFAULT NULL,
  `Commobility` varchar(100) DEFAULT NULL,
  `Anal_lessor` text,
  `Haemoral` text,
  `PR` text,
  `Symd` text,
  `Dex_colon` text,
  `Splenic` text,
  `Ple_Tran_Col` text,
  `Status` varchar(10) NOT NULL DEFAULT 'pending',
  `Hepatic_Flexure` text,
  `Ascending_Colon` text,
  `Caecum` text,
  `Terminal_Ileum` text,
  `rectum` text NOT NULL,
  PRIMARY KEY (`Ogd_Post_operative_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `Payment_Item_Cache_List_ID` (`Payment_Item_Cache_List_ID`),
  KEY `Registration_ID` (`Registration_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_permission`
--

CREATE TABLE `tbl_permission` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `only_for_administrator` tinyint(1) NOT NULL DEFAULT '0',
  `permission_group_id` int(10) unsigned NOT NULL,
  `created_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `modified_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `modified_time` datetime DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `sort` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `permission_permission_group_id_foreign` (`permission_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1808 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `tbl_permission_block`
--

CREATE TABLE `tbl_permission_block` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `only_for_administrator` tinyint(1) NOT NULL DEFAULT '0',
  `created_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `modified_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `modified_time` datetime DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `sort` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `tbl_permission_group`
--

CREATE TABLE `tbl_permission_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `only_for_administrator` tinyint(1) NOT NULL DEFAULT '0',
  `permission_block_id` int(10) unsigned NOT NULL,
  `created_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `modified_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `modified_time` datetime DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `sort` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `permission_group_permission_block_id_foreign` (`permission_block_id`)
) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `tbl_pf3_reasons`
--

CREATE TABLE `tbl_pf3_reasons` (
  `Reason_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Reason_Name` varchar(100) NOT NULL,
  PRIMARY KEY (`Reason_ID`),
  UNIQUE KEY `Reason_Name` (`Reason_Name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_pre_operative_checklist`
--

CREATE TABLE `tbl_pre_operative_checklist` (
  `Pre_Operative_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Employee_ID` int(11) NOT NULL,
  `Registration_ID` int(11) NOT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `Theatre_Time` time NOT NULL,
  `Ward_Signature` varchar(100) NOT NULL,
  `Theatre_Signature` varchar(100) NOT NULL,
  `Special_Information` varchar(100) NOT NULL,
  `Operative_Date_Time` datetime NOT NULL,
  PRIMARY KEY (`Pre_Operative_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `Registration_ID_2` (`Registration_ID`),
  KEY `Employee_ID_2` (`Employee_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_pre_operative_checklist_items`
--

CREATE TABLE `tbl_pre_operative_checklist_items` (
  `Task_Name` varchar(50) NOT NULL,
  `Task_Value` varchar(50) NOT NULL,
  `Remark` varchar(100) NOT NULL,
  `Pre_Operative_ID` int(11) NOT NULL,
  KEY `Pre-Operative_ID` (`Pre_Operative_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_radiology_discription_old`
--

CREATE TABLE `tbl_radiology_discription_old` (
  `Radiology_Description_ID` int(30) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) NOT NULL,
  `Parameter_ID` int(11) DEFAULT NULL,
  `Patient_Payment_Item_List_ID` int(11) NOT NULL,
  `comments` varchar(250) NOT NULL,
  `Radiology_Date` date NOT NULL,
  PRIMARY KEY (`Radiology_Description_ID`),
  KEY `Parameter_ID` (`Parameter_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_radiology_image`
--

CREATE TABLE `tbl_radiology_image` (
  `Pic_ID` int(30) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) NOT NULL,
  `Item_ID` int(11) NOT NULL,
  `Radiology_Image` varchar(255) NOT NULL,
  `Patient_Payment_Item_List_ID` int(11) NOT NULL,
  `Upload_Date` datetime NOT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Pic_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_radiology_image_old`
--

CREATE TABLE `tbl_radiology_image_old` (
  `Pic_ID` int(30) NOT NULL AUTO_INCREMENT,
  `Registration_ID` int(11) NOT NULL,
  `Radiology_Image` varchar(255) NOT NULL,
  `Patient_Payment_Item_List_ID` int(11) NOT NULL,
  `Upload_Date` datetime NOT NULL,
  PRIMARY KEY (`Pic_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_radiology_parameter_cache`
--

CREATE TABLE `tbl_radiology_parameter_cache` (
  `Parameter_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Parameter_Name` varchar(30) NOT NULL,
  `Item_ID` int(11) NOT NULL,
  PRIMARY KEY (`Parameter_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_radiology_parameter_old`
--

CREATE TABLE `tbl_radiology_parameter_old` (
  `Parameter_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Parameter_Name` varchar(30) NOT NULL,
  PRIMARY KEY (`Parameter_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_removed_specimen_patients`
--

CREATE TABLE `tbl_removed_specimen_patients` (
  `removed_Specimen_Patients_Id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `Payment_id` int(11) NOT NULL,
  `time_removed` datetime NOT NULL,
  PRIMARY KEY (`removed_Specimen_Patients_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tbl_test_result_modification`
--

CREATE TABLE `tbl_test_result_modification` (
  `result_modification_ID` int(11) NOT NULL AUTO_INCREMENT,
  `test_result_ID` int(11) NOT NULL,
  `Parameter` int(11) NOT NULL,
  `employee_ID` int(11) NOT NULL,
  `result` varchar(50) NOT NULL,
  `timeModified` datetime NOT NULL,
  PRIMARY KEY (`result_modification_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tibanova_invoice`
--

CREATE TABLE `tibanova_invoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_number` varchar(50) DEFAULT NULL,
  `invoice_client_id` varchar(50) NOT NULL,
  `invoice_client` varchar(250) DEFAULT NULL,
  `month_serial` varchar(50) NOT NULL,
  `invoice_date` date NOT NULL,
  `invoice_patient_rate` int(11) NOT NULL,
  `invoice_total_patient_visit` int(11) NOT NULL,
  `invoice_amount` float NOT NULL,
  `invoice_email` text NOT NULL,
  `status` int(11) NOT NULL,
  `extended_due_date` date DEFAULT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `invoice_minimum_patient_visit` int(11) NOT NULL,
  `invoice_summary_patient_visit` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Table structure for table `tracking_number`
--

CREATE TABLE `tracking_number` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `month_year` varchar(6) NOT NULL,
  `tracking_number` int(11) NOT NULL,
  `sponsor_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `branch_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tracking_number_employee_id_foreign` (`employee_id`),
  KEY `tracking_number_sponsor_id_foreign` (`sponsor_id`),
  KEY `tracking_number_branch_id_foreign` (`branch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=latin1;

--
-- Table structure for table `user_role`
--

CREATE TABLE `user_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `modified_by` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `modified_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `user_role_permission`
--

CREATE TABLE `user_role_permission` (
  `user_role_id` int(10) unsigned NOT NULL,
  `permission_id` int(10) unsigned NOT NULL,
  KEY `user_role_permission_user_role_id_foreign` (`user_role_id`),
  KEY `user_role_permission_permission_id_foreign` (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `vital`
--

CREATE TABLE `vital` (
  `vital_id` int(11) NOT NULL AUTO_INCREMENT,
  `vital` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `unit_of_measure` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`vital_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `vital_record`
--

CREATE TABLE `vital_record` (
  `vital_id` int(11) NOT NULL AUTO_INCREMENT,
  `height` varchar(50) DEFAULT NULL,
  `weight` varchar(50) NOT NULL,
  `bmi` varchar(50) NOT NULL,
  `body_temperature` varchar(50) NOT NULL,
  `pulse_rate` varchar(50) NOT NULL,
  `respiratory_rate` varchar(50) NOT NULL,
  `blood_pressure` varchar(50) NOT NULL,
  `sp02` varchar(50) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `patient_visit_id` int(11) NOT NULL,
  PRIMARY KEY (`vital_id`),
  KEY `vital_record_employee_id_foreign` (`employee_id`),
  KEY `vital_record_patient_id_foreign` (`patient_id`),
  KEY `vital_record_patient_visit_id_foreign` (`patient_visit_id`),
  CONSTRAINT `vital_record_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`Employee_ID`),
  CONSTRAINT `vital_record_patient_id_foreign` FOREIGN KEY (`patient_id`) REFERENCES `patient` (`Registration_ID`),
  CONSTRAINT `vital_record_patient_visit_id_foreign` FOREIGN KEY (`patient_visit_id`) REFERENCES `patient_visit` (`Check_In_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `ward`
--

CREATE TABLE `ward` (
  `Hospital_Ward_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ward_name` varchar(50) DEFAULT NULL,
  `number_of_beds` int(11) NOT NULL DEFAULT '30',
  `Branch_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Hospital_Ward_ID`),
  KEY `Branch_ID` (`Branch_ID`),
  CONSTRAINT `ward_ibfk_1` FOREIGN KEY (`Branch_ID`) REFERENCES `branch` (`Branch_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Table structure for table `ward_bed`
--

CREATE TABLE `ward_bed` (
  `Bed_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Bed_Name` varchar(50) NOT NULL,
  `Status` varchar(30) NOT NULL DEFAULT 'available',
  `Ward_ID` int(11) NOT NULL COMMENT 'Hospital Ward ID',
  PRIMARY KEY (`Bed_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Table structure for table `ward_round`
--

CREATE TABLE `ward_round` (
  `Round_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Employee_ID` int(11) NOT NULL,
  `Registration_ID` int(11) NOT NULL,
  `consultation_ID` int(11) DEFAULT NULL,
  `Patient_Payment_ID` int(11) DEFAULT NULL,
  `Findings` longtext,
  `Comment_For_Laboratory` mediumtext,
  `Comment_For_Radiology` mediumtext,
  `Comment_For_Procedure` varchar(200) DEFAULT NULL,
  `Comment_For_Surgery` varchar(200) DEFAULT NULL,
  `investigation_comments` varchar(45) DEFAULT NULL,
  `remarks` text,
  `Process_Status` varchar(45) DEFAULT NULL,
  `Ward_Round_Date_And_Time` datetime DEFAULT NULL,
  `Patient_Type` varchar(45) DEFAULT NULL,
  `Comment_For_Pharmacy` int(1) DEFAULT NULL,
  `Admision_ID` int(11) DEFAULT NULL,
  `Payment_Cache_ID` int(11) NOT NULL,
  `Cash_Payment_Cache_ID` int(11) DEFAULT NULL,
  `Comments_For_Pharmacy` text,
  `Comments_For_Procedure` text,
  `Comments_For_Surgery` text,
  `Require_Spectacle` varchar(2) DEFAULT NULL,
  `Need_Dialysis` varchar(2) DEFAULT NULL,
  `Need_ED` varchar(2) DEFAULT NULL,
  `home_care_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`Round_ID`),
  KEY `consultation_ID` (`consultation_ID`),
  KEY `Registration_ID` (`Registration_ID`),
  KEY `Employee_ID` (`Employee_ID`),
  KEY `Patient_Payment_ID` (`Patient_Payment_ID`),
  KEY `ward_round_admision_id_foreign` (`Admision_ID`),
  KEY `ward_round_payment_cache_id_foreign` (`Payment_Cache_ID`),
  KEY `Cash_Payment_Cache_ID` (`Cash_Payment_Cache_ID`),
  KEY `ward_round_home_care_id_foreign` (`home_care_id`),
  CONSTRAINT `ward_round_home_care_id_foreign` FOREIGN KEY (`home_care_id`) REFERENCES `home_care` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Table structure for table `ward_round_disease`
--

CREATE TABLE `ward_round_disease` (
  `Ward_Round_Disease_ID` int(11) NOT NULL AUTO_INCREMENT,
  `disease_ID` int(11) NOT NULL,
  `Round_ID` int(11) NOT NULL,
  `diagnosis_type` varchar(45) DEFAULT NULL,
  `Round_Disease_Date_And_Time` datetime DEFAULT NULL,
  PRIMARY KEY (`Ward_Round_Disease_ID`),
  KEY `disease_ID` (`disease_ID`),
  KEY `Round_ID` (`Round_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;


--
-- Host: apps.truebitstech.com    Database: tibanova_staging
-- ------------------------------------------------------


--
-- Dumping data for table `audit_log`
--

INSERT INTO `audit_log` VALUES (1,'country.create','Add New Country','jeremi16us','2016-11-21 00:00:00'),(2,'country.edit','Edit Country','jeremi16us','2016-11-21 00:00:00'),(3,'country.delete','Delete Country','jeremi16us','2016-11-21 00:00:00'),(11,'region.create','Add New Region','jeremi16us','2016-11-21 00:00:00'),(12,'region.edit','Edit Region','jeremi16us','2016-11-21 00:00:00'),(13,'region.delete','Delete Region','jeremi16us','2016-11-21 00:00:00'),(14,'region.set.default','Set Default Region','jeremi16us','2016-11-21 00:00:00'),(21,'district.create','Add New District','jeremi16us','2016-11-21 00:00:00'),(22,'district.edit','Edit District','jeremi16us','2016-11-21 00:00:00'),(23,'district.delete','Delete District','jeremi16us','2016-11-21 00:00:00'),(31,'supplier.create','Add New Supplier','jeremi16us','2016-11-21 00:00:00'),(32,'supplier.edit','Edit Supplier','jeremi16us','2016-11-21 00:00:00'),(33,'supplier.delete','Delete Supplier','jeremi16us','2016-11-21 00:00:00'),(41,'currency.create','Add New Currency','jeremi16us','2016-11-21 00:00:00'),(42,'currency.edit','Edit Currency','jeremi16us','2016-11-21 00:00:00'),(43,'currency.delete','Delete Currency','jeremi16us','2016-11-21 00:00:00'),(51,'vital.create','Add New Vital','jeremi16us','2016-11-21 00:00:00'),(52,'vital.edit','Edit Vital','jeremi16us','2016-11-21 00:00:00'),(53,'vital.delete','Delete Vital','jeremi16us','2016-11-21 00:00:00'),(61,'courseOfInjury.create','Add New Course Of Injury','jeremi16us','2016-11-21 00:00:00'),(62,'courseOfInjury.edit','Edit Course Of Injury','jeremi16us','2016-11-21 00:00:00'),(63,'courseOfInjury.delete','Delete Course Of Injury','jeremi16us','2016-11-21 00:00:00'),(71,'refferalHospital.create','Add New Refferal Hospital','jeremi16us','2016-11-21 00:00:00'),(72,'refferalHospital.edit','Edit Refferal Hospital','jeremi16us','2016-11-21 00:00:00'),(73,'refferalHospital.delete','Delete Refferal Hospital','jeremi16us','2016-11-21 00:00:00'),(81,'emailRecepient.create','Add New Email Recepient','jeremi16us','2016-11-21 00:00:00'),(82,'emailRecepient.edit','Edit Email Recepient','jeremi16us','2016-11-21 00:00:00'),(83,'emailRecepient.delete','Delete Email Recepient','jeremi16us','2016-11-21 00:00:00'),(91,'company.create','Add New Company','jeremi16us','2016-11-21 00:00:00'),(92,'company.edit','Edit Company','jeremi16us','2016-11-21 00:00:00'),(93,'company.delete','Delete Company','jeremi16us','2016-11-21 00:00:00'),(101,'branch.create','Add New Branch','jeremi16us','2016-11-21 00:00:00'),(102,'branch.edit','Edit Branch','jeremi16us','2016-11-21 00:00:00'),(103,'branch.delete','Delete Branch','jeremi16us','2016-11-21 00:00:00'),(111,'department.create','Add New Department','jeremi16us','2016-11-21 00:00:00'),(112,'department.edit','Edit Department','jeremi16us','2016-11-21 00:00:00'),(113,'department.delete','Delete Department','jeremi16us','2016-11-21 00:00:00'),(121,'subDepartment.create','Add New Sub Department','jeremi16us','2016-11-21 00:00:00'),(122,'subDepartment.edit','Edit Sub Department','jeremi16us','2016-11-21 00:00:00'),(123,'subDepartment.delete','Delete Sub Department','jeremi16us','2016-11-21 00:00:00'),(131,'sponsor.create','Add New Sponsor','jeremi16us','2016-11-21 00:00:00'),(132,'sponsor.edit','Edit Sponsor','jeremi16us','2016-11-21 00:00:00'),(133,'sponsor.delete','Delete Sponsor','jeremi16us','2016-11-21 00:00:00'),(141,'clinic.create','Add New Clinic','jeremi16us','2016-11-21 00:00:00'),(142,'clinic.edit','Edit Clinic','jeremi16us','2016-11-21 00:00:00'),(143,'clinic.delete','Delete Clinic','jeremi16us','2016-11-21 00:00:00'),(151,'dischargeReason.create','Add New Discharge Reason','jeremi16us','2016-11-21 00:00:00'),(152,'dischargeReason.edit','Edit Discharge Reason','jeremi16us','2016-11-21 00:00:00'),(153,'dischargeReason.delete','Delete Discharge Reason','jeremi16us','2016-11-21 00:00:00'),(161,'hospitalWard.create','Add New Ward','jeremi16us','2016-11-21 00:00:00'),(162,'hospitalWard.edit','Edit Ward','jeremi16us','2016-11-21 00:00:00'),(163,'hospitalWard.delete','Delete Ward','jeremi16us','2016-11-21 00:00:00'),(171,'userRole.create','Add New User Role','jeremi16us','2016-11-21 00:00:00'),(172,'userRole.edit','Edit User Role','jeremi16us','2016-11-21 00:00:00'),(173,'userRole.delete','Delete User Role','jeremi16us','2016-11-21 00:00:00'),(174,'userRole.duplicate','Duplicate User Role','jeremi16us','2018-01-10 00:00:00'),(181,'employee.create','Add New Employee','jeremi16us','2016-11-21 00:00:00'),(182,'employee.edit','Edit Employee','jeremi16us','2016-11-21 00:00:00'),(183,'employee.delete','Delete Employee','jeremi16us','2016-11-21 00:00:00'),(184,'employee.assign.branch','Employee Assign Branch','jeremi16us','2016-11-21 00:00:00'),(185,'employee.assign.clinic','Employee Assign Clinic','jeremi16us','2016-11-21 00:00:00'),(186,'employee.assign.subDepartment','Employee Assign Sub Department','jeremi16us','2016-11-21 00:00:00'),(189,'employee.assign.userRole','Employee Assign User Role','jeremi16us','2018-04-25 00:00:00'),(190,'employee.block.userAccount','Employee Block User Account','jeremi16us','2019-03-15 00:00:00'),(191,'procurement.approvalLevele.assignEmployee','Procument Approval Level Assign Employee','jeremi16us','2016-11-21 00:00:00'),(192,'procurement.approvalLevele.removeEmployee','Procument Approval Level Remove Employee','jeremi16us','2016-11-21 00:00:00'),(200,'logoff.from.system','Logoff From System','jeremi16us','2016-11-21 00:00:00'),(201,'login.to.system','Login To System','jeremi16us','2016-11-21 00:00:00'),(211,'itemsCategory.create','Add New Items Category','jeremi16us','2016-11-21 00:00:00'),(212,'itemsCategory.edit','Edit Items Category','jeremi16us','2016-11-21 00:00:00'),(213,'itemsCategory.delete','Delete Items Category','jeremi16us','2016-11-21 00:00:00'),(221,'itemsSubCategory.create','Add New Items Sub Category','jeremi16us','2016-11-21 00:00:00'),(222,'itemsSubCategory.edit','Edit Items Sub Category','jeremi16us','2016-11-21 00:00:00'),(223,'itemsSubCategory.delete','Delete Items Sub Category','jeremi16us','2016-11-21 00:00:00'),(231,'items.create','Add New Item','jeremi16us','2016-11-24 00:00:00'),(232,'items.edit','Edit Item','jeremi16us','2016-11-24 00:00:00'),(233,'items.delete','Delete Item','jeremi16us','2016-11-24 00:00:00'),(235,'items.updateField','Item Update Field','jeremi16us','2016-11-24 00:00:00'),(241,'itemsPriceList.create','Create New Item Price','jeremi16us','2016-11-25 00:00:00'),(242,'itemsPriceList.update','Update Price List','jeremi16us','2016-11-25 00:00:00'),(243,'itemsPriceList.delete','Delete Item Price','jeremi16us','2016-11-25 00:00:00'),(244,'itemsPriceList.updatePriceListFromAnother','Update Price List From Another','jeremi16us','2016-11-25 00:00:00'),(245,'itemsPriceList.newPriceListByCopy','New Price List By Copy','jeremi16us','2016-11-25 00:00:00'),(246,'sponsorNonSupportedItems.addOrRemove','Change Sponsor Non Supported Item','jeremi16us','2016-11-25 00:00:00'),(247,'sponsorAllowZeroPrice.addOrRemove','Change Sponsor Allow Zero Price','jeremi16us','2016-11-25 00:00:00'),(251,'itemsReorderLevel.create','Create Reorder Level','jeremi16us','2016-11-26 00:00:00'),(252,'itemsReorderLevel.update','Update Reorder Level','jeremi16us','2016-11-26 00:00:00'),(253,'itemsReorderLevel.delete','Delete Reorder Level','jeremi16us','2016-11-26 00:00:00'),(261,'storageDisposal.create','Create Storage Disposal','jeremi16us','2016-12-16 00:00:00'),(262,'storageDisposal.submit','Submit Storage Disposal','jeremi16us','2016-12-16 00:00:00'),(263,'storageDisposal.edit','Edit Storage Disposal','jeremi16us','2016-12-16 00:00:00'),(264,'storageDisposal.cancel','Cancel Storage Disposal','jeremi16us','2016-12-16 00:00:00'),(265,'storageDisposal.cancelPending','Cancel Pending Storage Disposal','jeremi16us','2016-12-16 00:00:00'),(271,'storageReturnInward.create','Create Storage Return Inward','jeremi16us','2016-12-25 00:00:00'),(272,'storageReturnInward.submit','Submit Storage Return Inward','jeremi16us','2016-12-25 00:00:00'),(273,'storageReturnInward.edit','Edit Storage Return Inward','jeremi16us','2016-12-25 00:00:00'),(274,'storageReturnInward.cancel','Cancel Storage Return Inward','jeremi16us','2016-12-25 00:00:00'),(275,'storageReturnInward.cancelPending','Cancel Pending Storage Return Inward','jeremi16us','2016-12-25 00:00:00'),(281,'storageReturnOutward.create','Create Storage Return Outward','jeremi16us','2016-12-31 00:00:00'),(282,'storageReturnOutward.submit','Submit Storage Return Outward','jeremi16us','2016-12-31 00:00:00'),(283,'storageReturnOutward.edit','Edit Storage Return Outward','jeremi16us','2016-12-31 00:00:00'),(284,'storageReturnOutward.cancel','Cancel Storage Return Outward','jeremi16us','2016-12-31 00:00:00'),(285,'storageReturnOutward.cancelPending','Cancel Pending Storage Return Outward','jeremi16us','2016-12-31 00:00:00'),(291,'storageRequisition.create','Create Storage Requisition','jeremi16us','2017-01-02 00:00:00'),(292,'storageRequisition.submit','Submit Storage Requisition','jeremi16us','2017-01-02 00:00:00'),(293,'storageRequisition.edit','Edit Storage Requisition','jeremi16us','2017-01-02 00:00:00'),(294,'storageRequisition.cancel','Cancel Storage Requisition','jeremi16us','2017-01-02 00:00:00'),(295,'storageRequisition.cancelPending','Cancel Pending Storage Requisition','jeremi16us','2017-01-02 00:00:00'),(301,'storageIssueManual.create','Create Storage Issue Note Manual','jeremi16us','2017-01-02 00:00:00'),(302,'storageIssueManual.submit','Submit Storage Issue Note Manual','jeremi16us','2017-01-02 00:00:00'),(303,'storageIssueManual.edit','Edit Storage Issue Note Manual','jeremi16us','2017-01-02 00:00:00'),(304,'storageIssueManual.cancel','Cancel Storage Issue Note Manual','jeremi16us','2017-01-02 00:00:00'),(305,'storageIssueManual.cancelPending','Cancel Pending Storage Issue Note Manual','jeremi16us','2017-01-02 00:00:00'),(311,'storageIssue.create','Create Storage Issue Note','jeremi16us','2017-01-02 00:00:00'),(312,'storageIssue.submit','Submit Storage Issue Note','jeremi16us','2017-01-02 00:00:00'),(313,'storageIssue.edit','Edit Storage Issue Note','jeremi16us','2017-01-02 00:00:00'),(314,'storageIssue.cancel','Cancel Storage Issue Note','jeremi16us','2017-01-02 00:00:00'),(315,'storageIssue.cancelPending','Cancel Pending Storage Issue Note','jeremi16us','2017-01-02 00:00:00'),(321,'storageStoreOrder.create','Create Storage Store Order','jeremi16us','2017-01-06 00:00:00'),(322,'storageStoreOrder.submit','Submit Storage Store Order','jeremi16us','2017-01-06 00:00:00'),(323,'storageStoreOrder.edit','Edit Storage Store Order','jeremi16us','2017-01-06 00:00:00'),(324,'storageStoreOrder.cancel','Cancel Storage Store Order','jeremi16us','2017-01-06 00:00:00'),(325,'storageStoreOrder.cancelPending','Cancel Pending Storage Store Order','jeremi16us','2017-01-06 00:00:00'),(326,'storageStoreOrder.approve','Approve Storage Store Order','jeremi16us','2017-01-06 00:00:00'),(331,'storageGrnIssueNote.receive','Receive Storage GRN Against Issue Note','jeremi16us','2017-01-06 00:00:00'),(332,'storageGrnIssueNote.cancel','Cancel Storage GRN Against Issue Note','jeremi16us','2017-01-06 00:00:00'),(341,'storageStockTaking.create','Create Storage Stock Taking','jeremi16us','2017-01-09 00:00:00'),(342,'storageStockTaking.submit','Submit Storage Stock Taking','jeremi16us','2017-01-09 00:00:00'),(343,'storageStockTaking.edit','Edit Storage Stock Taking','jeremi16us','2017-01-09 00:00:00'),(344,'storageStockTaking.cancel','Cancel Storage Stock Taking','jeremi16us','2017-01-09 00:00:00'),(345,'storageStockTaking.cancelPending','Cancel Pending Storage Stock Taking','jeremi16us','2017-01-09 00:00:00'),(346,'storageStockTaking.approve','Approve Storage Stock Taking','jeremi16us','2017-01-09 00:00:00'),(351,'storageGrnWithoutPurchaseOrder.create','Create Storage GRN Without Purchase Order','jeremi16us','2017-01-10 00:00:00'),(352,'storageGrnWithoutPurchaseOrder.submit','Submit Storage GRN Without Purchase Order','jeremi16us','2017-01-10 00:00:00'),(353,'storageGrnWithoutPurchaseOrder.edit','Edit Storage GRN Without Purchase Order','jeremi16us','2017-01-10 00:00:00'),(354,'storageGrnWithoutPurchaseOrder.cancel','Cancel Storage GRN Without Purchase Order','jeremi16us','2017-01-10 00:00:00'),(355,'storageGrnWithoutPurchaseOrder.cancelPending','Cancel Pending Storage GRN Without Purchase Order','jeremi16us','2017-01-10 00:00:00'),(356,'storageGrnWithoutPurchaseOrder.approve','Approve Storage GRN Without Purchase Order','jeremi16us','2017-01-10 00:00:00'),(361,'storageGrnWithPurchaseOrder.create','Create Storage GRN With Purchase Order','jeremi16us','2017-01-10 00:00:00'),(362,'storageGrnWithPurchaseOrder.submit','Submit Storage GRN With Purchase Order','jeremi16us','2017-01-10 00:00:00'),(363,'storageGrnWithPurchaseOrder.edit','Edit Storage GRN With Purchase Order','jeremi16us','2017-01-10 00:00:00'),(364,'storageGrnWithPurchaseOrder.cancel','Cancel Storage GRN With Purchase Order','jeremi16us','2017-01-10 00:00:00'),(365,'storageGrnWithPurchaseOrder.cancelPending','Cancel Pending Storage GRN With Purchase Order','jeremi16us','2017-01-10 00:00:00'),(366,'storageGrnWithPurchaseOrder.approve','Approve Storage GRN With Purchase Order','jeremi16us','2017-01-10 00:00:00'),(371,'procurementPurchaseOrder.create','Create Procurement Purchase Order','jeremi16us','2017-01-25 00:00:00'),(372,'procurementPurchaseOrder.submit','Submit Procurement Purchase Order','jeremi16us','2017-01-25 00:00:00'),(373,'procurementPurchaseOrder.edit','Edit Procurement Purchase Order','jeremi16us','2017-01-25 00:00:00'),(374,'procurementPurchaseOrder.cancel','Cancel Procurement Purchase Order','jeremi16us','2017-01-25 00:00:00'),(375,'procurementPurchaseOrder.cancelPending','Cancel Pending Procurement Purchase Order','jeremi16us','2017-01-25 00:00:00'),(376,'procurementPurchaseOrder.approve','Approve Procurement Purchase Order','jeremi16us','2017-01-25 00:00:00'),(377,'procurementPurchaseOrder.updateStatus','Update Order Status - Purchase Order','jeremi16us','2020-03-18 00:00:00'),(381,'backendChange.rebalanceItem','Rebalance Item','jeremi16us','2017-02-06 00:00:00'),(382,'backendChange.rebalanceItemIssueNote','Rebalance Items Using Issue Note','jeremi16us','2017-02-06 00:00:00'),(383,'backendChange.rebalanceItemIssueNoteManual','Rebalance Items Using Issue Note Manual','jeremi16us','2017-02-06 00:00:00'),(391,'patient.create','Add New Patient','jeremi16us','2017-03-16 00:00:00'),(392,'patient.edit','Edit Patient','jeremi16us','2017-03-16 00:00:00'),(393,'patient.delete','Delete Patient','jeremi16us','2017-03-16 00:00:00'),(394,'patient.mergePatientFile','Merge Patient File','jeremi16us','2018-01-03 00:00:00'),(395,'patient.patientFileChangeCheckInStatus','Patient File Change Check In Status','jeremi16us','2018-02-28 00:00:00'),(396,'patient.patientFileReview','Patient File Review','jeremi16us','2018-02-28 00:00:00'),(397,'patient.patientFilePatientResults','Patient File Patient Results','jeremi16us','2018-02-28 00:00:00'),(398,'patient.patientFileReviewFailed','Patient File Review Failed Attempt','jeremi16us','2018-02-28 00:00:00'),(399,'patient.patientFileUpdateStatus','Patient Update Status','jeremi16us','2018-02-28 00:00:00'),(400,'patient.patientFileUpdateCaptureSignature','Patient Update Capture Signature','jeremi16us','2020-09-18 00:00:00'),(401,'systemSetting.create','Add New System Setting','jeremi16us','2017-03-16 00:00:00'),(402,'systemSetting.edit','Edit System Setting','jeremi16us','2017-03-16 00:00:00'),(403,'systemSetting.delete','Delete System Setting','jeremi16us','2017-03-16 00:00:00'),(406,'patient.splitClaim','Patient Split Claim','jeremi16us','2018-02-28 00:00:00'),(450,'configuration.create','Add New configuration','jeremi16us','2017-03-16 00:00:00'),(451,'configuration.edit','Edit configuration','jeremi16us','2017-03-16 00:00:00'),(452,'configuration.delete','Delete configuration','jeremi16us','2017-03-16 00:00:00'),(460,'configurationOption.create','Add New configuration Option','jeremi16us','2017-03-16 00:00:00'),(461,'configurationOption.edit','Edit configuration Option','jeremi16us','2017-03-16 00:00:00'),(462,'configurationOption.delete','Delete configuration Option','jeremi16us','2017-03-16 00:00:00'),(470,'diseaseCategory.create','Add new Disease Category','jeremi16us','2017-03-16 00:00:00'),(471,'diseaseCategory.edit','Edit Disease Category','jeremi16us','2017-03-16 00:00:00'),(480,'diseaseMainCategory.create','Add new Disease Main Category','jeremi16us','2017-03-16 00:00:00'),(481,'diseaseMainCategory.edit','Edit Disease Main Category','jeremi16us','2017-03-16 00:00:00'),(490,'diseaseSubCategory.create','Add new Disease SubCategory','jeremi16us','2017-05-29 00:00:00'),(491,'diseaseSubCategory.edit','Edit Disease SubCategory','jeremi16us','2017-05-29 00:00:00'),(500,'diseaseGroup.create','Add new Disease Group','jeremi16us','2017-05-30 00:00:00'),(501,'diseaseGroup.edit','Edit Disease Group','jeremi16us','2017-05-30 00:00:00'),(510,'disease.create','Add new Disease','jeremi16us','2017-06-01 00:00:00'),(511,'disease.edit','Edit Disease','jeremi16us','2017-06-01 00:00:00'),(520,'laboratoryParameter.create','Add new Laboratory Parameter','jeremi16us','2017-06-09 00:00:00'),(521,'laboratoryParameter.edit','Edit Laboratory Parameter','jeremi16us','2017-05-09 00:00:00'),(530,'laboratorySpecimen.create','Add new Laboratory Specimen','jeremi16us','2017-06-11 00:00:00'),(531,'laboratorySpecimen.edit','Edit Laboratory Specimen','jeremi16us','2017-06-11 00:00:00'),(540,'laboratoryTestSetup.addParameterToTest','Add Paramter To Laboratory Investigation Test','jeremi16us','2017-06-11 00:00:00'),(541,'laboratoryTestSetup.removeParameterFromTest','Remove Paramter From Laboratory Investigation Test','jeremi16us','2017-06-11 00:00:00'),(542,'laboratoryTestSetup.addSpecimenToTest','Add Specimen To Laboratory Investigation Test','jeremi16us','2017-06-11 00:00:00'),(543,'laboratoryTestSetup.removeSpecimenFromTest','Remove Specimen From Laboratory Investigation Test','jeremi16us','2017-06-11 00:00:00'),(544,'laboratoryTestSetup.changedAvailabilityOfTest','Changed Availability Of Laboratory Investigation Test','jeremi16us','2017-06-11 00:00:00'),(545,'laboratoryTestSetup.sortLabInvestigationParameter','Sort Laboratory Investigation Parameter','jeremi16us','2020-10-23 00:00:00'),(551,'broadcastMessage.create','Add New Broadcast Message','jeremi16us','2017-06-29 00:00:00'),(552,'broadcastMessage.edit','Edit Broadcast Message','jeremi16us','2017-06-29 00:00:00'),(553,'broadcastMessage.delete','Delete Broadcast Message','jeremi16us','2017-06-29 00:00:00'),(561,'patientCheckIn.create','Create Patient Check In','jeremi16us','2017-07-12 00:00:00'),(562,'patientCheckIn.submit','Submit Patient Check In','jeremi16us','2017-07-12 00:00:00'),(563,'patientCheckIn.edit','Edit Patient Check In','jeremi16us','2017-07-12 00:00:00'),(564,'patientCheckIn.cancel','Cancel Patient Check In','jeremi16us','2017-07-12 00:00:00'),(565,'patientCheckIn.cancelSignOff','Cancel Sign Off','jeremi16us','2017-07-12 00:00:00'),(566,'patientCheckIn.cancelNoShow','Cancel No Show','jeremi16us','2017-07-12 00:00:00'),(567,'patientCheckIn.transfer','Patient Transfer','jeremi16us','2017-07-12 00:00:00'),(568,'patientCheckIn.makeBill','Revenue Cycle - Make Bill','jeremi16us','2017-07-12 00:00:00'),(569,'patientCheckIn.makeCashPayment','Revenue Cycle - Make Cash Payment','jeremi16us','2017-07-12 00:00:00'),(570,'patientCheckIn.changeToCash','Change Check In to CASH','jeremi16us','2019-05-29 00:00:00'),(571,'dialysisNotes.create','Create Dialysis Notes','jeremi16us','2017-07-19 00:00:00'),(572,'dialysisNotes.submit','Submit Dialysis Notes','jeremi16us','2017-07-19 00:00:00'),(573,'dialysisNotes.edit','Edit Dialysis Notes','jeremi16us','2017-07-19 00:00:00'),(574,'dialysisNotes.delete','Delete Dialysis Notes','jeremi16us','2017-07-19 00:00:00'),(581,'dialysisPatientAssessment.create','Create Dialysis Patient Assessment','jeremi16us','2017-07-20 00:00:00'),(582,'dialysisPatientAssessment.submit','Submit Dialysis Patient Assessment','jeremi16us','2017-07-20 00:00:00'),(583,'dialysisPatientAssessment.edit','Edit Dialysis Patient Assessment','jeremi16us','2017-07-20 00:00:00'),(584,'dialysisPatientAssessment.delete','Delete Dialysis Patient Assessment','jeremi16us','2017-07-20 00:00:00'),(591,'dialysisMachineAssessment.create','Create Dialysis Machine Assessment','jeremi16us','2017-07-20 00:00:00'),(592,'dialysisMachineAssessment.submit','Submit Dialysis Machine Assessment','jeremi16us','2017-07-20 00:00:00'),(593,'dialysisMachineAssessment.edit','Edit Dialysis Machine Assessment','jeremi16us','2017-07-20 00:00:00'),(594,'dialysisMachineAssessment.delete','Delete Dialysis Machine Assessment','jeremi16us','2017-07-20 00:00:00'),(601,'dialysisDialysisOrders.create','Create Dialysis Dialysis  Orders ','jeremi16us','2017-07-21 00:00:00'),(602,'dialysisDialysisOrders.submit','Submit Dialysis Dialysis Orders ','jeremi16us','2017-07-21 00:00:00'),(603,'dialysisDialysisOrders.edit','Edit Dialysis Dialysis Orders ','jeremi16us','2017-07-21 00:00:00'),(604,'dialysisDialysisOrders.delete','Delete Dialysis Dialysis Orders ','jeremi16us','2017-07-21 00:00:00'),(611,'dialysisHeparain.create','Create Dialysis Heparain ','jeremi16us','2017-07-21 00:00:00'),(612,'dialysisHeparain.submit','Submit Dialysis Heparain','jeremi16us','2017-07-21 00:00:00'),(613,'dialysisHeparain.edit','Edit Dialysis Heparain ','jeremi16us','2017-07-21 00:00:00'),(614,'dialysisHeparain.delete','Delete Dialysis Heparain ','jeremi16us','2017-07-21 00:00:00'),(621,'surgeryPostOperativeNotes.create','Create Surgery Post Operative Notes ','jeremi16us','2017-07-26 00:00:00'),(622,'surgeryPostOperativeNotes.submit','Submit Surgery Post Operative Notes','jeremi16us','2017-07-26 00:00:00'),(623,'surgeryPostOperativeNotes.edit','Edit Surgery Post Operative Notes ','jeremi16us','2017-07-26 00:00:00'),(624,'surgeryPostOperativeNotes.delete','Delete Surgery Post Operative Notes ','jeremi16us','2017-07-26 00:00:00'),(631,'doctorsOutpatientClinicalNotes.create','Create Doctors Outpatient Clinical Notes ','jeremi16us','2017-08-03 00:00:00'),(632,'doctorsOutpatientClinicalNotes.submit','Submit Doctors Outpatient Clinical Notes','jeremi16us','2017-08-03 00:00:00'),(633,'doctorsOutpatientClinicalNotes.edit','Edit Doctors Outpatient Clinical Notes ','jeremi16us','2017-08-03 00:00:00'),(634,'doctorsOutpatientClinicalNotes.delete','Delete Doctors Outpatient Clinical Notes ','jeremi16us','2017-08-03 00:00:00'),(641,'patientAdmission.create','Create Patient Admission ','jeremi16us','2017-08-04 00:00:00'),(642,'patientAdmission.submit','Submit Patient Admission','jeremi16us','2017-08-04 00:00:00'),(643,'patientAdmission.edit','Edit Patient Admission ','jeremi16us','2017-08-04 00:00:00'),(644,'patientAdmission.delete','Delete Patient Admission ','jeremi16us','2017-08-04 00:00:00'),(651,'nurseAction.cancelAdmission','Cancel Admission Nurse Action ','jeremi16us','2017-08-05 00:00:00'),(652,'nurseAction.wardTransfer','Ward Transfer Nurse Action','jeremi16us','2017-08-05 00:00:00'),(653,'nurseAction.cancelDischarge','Cancel Discharge Nurse Action ','jeremi16us','2017-08-05 00:00:00'),(654,'nurseAction.delete','Delete Nurse Action ','jeremi16us','2017-08-05 00:00:00'),(661,'patientProgress.create','Create Patient Progress ','jeremi16us','2017-08-09 00:00:00'),(662,'patientProgress.submit','Submit Patient Progress','jeremi16us','2017-08-09 00:00:00'),(663,'patientProgress.edit','Edit Patient Progress ','jeremi16us','2017-08-09 00:00:00'),(664,'patientProgress.delete','Delete Patient Progress ','jeremi16us','2017-08-09 00:00:00'),(671,'patientBloodGlucose.create','Create Patient Blood Glucose ','jeremi16us','2017-08-09 00:00:00'),(672,'patientBloodGlucose.submit','Submit Patient Blood Glucose','jeremi16us','2017-08-09 00:00:00'),(673,'patientBloodGlucose.edit','Edit Patient Blood Glucose ','jeremi16us','2017-08-09 00:00:00'),(674,'patientBloodGlucose.delete','Delete Patient Blood Glucose ','jeremi16us','2017-08-09 00:00:00'),(681,'patientIntakeOutput.create','Create Patient Intake and Output ','jeremi16us','2017-08-10 00:00:00'),(682,'patientIntakeOutput.submit','Submit Patient Intake and Output','jeremi16us','2017-08-10 00:00:00'),(683,'patientIntakeOutput.edit','Edit Patient Intake and Output ','jeremi16us','2017-08-10 00:00:00'),(684,'patientIntakeOutput.delete','Delete Patient Intake and Output ','jeremi16us','2017-08-10 00:00:00'),(691,'patientObservation.create','Create Patient Observation ','jeremi16us','2017-08-10 00:00:00'),(692,'patientObservation.submit','Submit Patient Observation','jeremi16us','2017-08-10 00:00:00'),(693,'patientObservation.edit','Edit Patient Observation ','jeremi16us','2017-08-10 00:00:00'),(694,'patientObservation.delete','Delete Patient Observation ','jeremi16us','2017-08-10 00:00:00'),(701,'nurseCarePlan.create','Create Nurse Care Plan ','jeremi16us','2017-08-10 00:00:00'),(702,'nurseCarePlan.submit','Submit Nurse Care Plan','jeremi16us','2017-08-10 00:00:00'),(703,'nurseCarePlan.edit','Edit Nurse Care Plan ','jeremi16us','2017-08-10 00:00:00'),(704,'nurseCarePlan.delete','Delete Nurse Care Plan ','jeremi16us','2017-08-10 00:00:00'),(711,'patientMalnutritionObservation.create','Create Patient Malnutrition Observation ','jeremi16us','2017-08-10 00:00:00'),(712,'patientMalnutritionObservation.submit','Submit Patient Malnutrition Observation','jeremi16us','2017-08-10 00:00:00'),(713,'patientMalnutritionObservation.edit','Edit Patient Malnutrition Observation ','jeremi16us','2017-08-10 00:00:00'),(714,'patientMalnutritionObservation.delete','Delete Patient Malnutrition Observation ','jeremi16us','2017-08-10 00:00:00'),(721,'pediatricObservation.create','Create Pediatric Observation ','jeremi16us','2017-08-10 00:00:00'),(722,'pediatricObservation.submit','Submit Pediatric Observation','jeremi16us','2017-08-10 00:00:00'),(723,'pediatricObservation.edit','Edit Pediatric Observation ','jeremi16us','2017-08-10 00:00:00'),(724,'pediatricObservation.delete','Delete Pediatric Observation ','jeremi16us','2017-08-10 00:00:00'),(731,'patientPreoperativeChecklist.create','Create Patient Pre-operative Checklist ','jeremi16us','2017-08-14 00:00:00'),(732,'patientPreoperativeChecklist.submit','Submit Patient Pre-operative Checklist','jeremi16us','2017-08-14 00:00:00'),(733,'patientPreoperativeChecklist.edit','Edit Patient Pre-operative Checklist ','jeremi16us','2017-08-14 00:00:00'),(734,'patientPreoperativeChecklist.delete','Delete Patient Pre-operative Checklist ','jeremi16us','2017-08-14 00:00:00'),(741,'storageGrnAsOpenBalance.create','Create Storage Grn As Open Balance','jeremi16us','2017-08-23 00:00:00'),(742,'storageGrnAsOpenBalance.submit','Submit Storage Grn As Open Balance','jeremi16us','2017-08-23 00:00:00'),(743,'storageGrnAsOpenBalance.edit','Edit Storage Grn As Open Balance','jeremi16us','2017-08-23 00:00:00'),(744,'storageGrnAsOpenBalance.cancel','Cancel Storage Grn As Open Balance','jeremi16us','2017-08-23 00:00:00'),(745,'storageGrnAsOpenBalance.cancelPending','Cancel Pending Storage Grn As Open Balance','jeremi16us','2017-08-23 00:00:00'),(746,'storageGrnAsOpenBalance.approve','Approve Storage Grn As Open Balance','jeremi16us','2017-08-23 00:00:00'),(751,'doctorConsultationFee.create','Create Doctor Consultation Fee ','jeremi16us','2017-09-12 00:00:00'),(752,'doctorConsultationFee.edit','Edit Doctor Consultation Fee ','jeremi16us','2017-09-12 00:00:00'),(753,'doctorConsultationFee.delete','Delete Doctor Consultation Fee ','jeremi16us','2017-09-12 00:00:00'),(761,'pharmacy.dispense','Dispense Pharmacy','jeremi16us','2017-09-22 00:00:00'),(762,'pharmacy.edit','Edit Pharmacy','jeremi16us','2017-09-22 00:00:00'),(763,'pharmacy.delete','Delete Pharmacy','jeremi16us','2017-09-22 00:00:00'),(764,'pharmacy.sendToCashier','Send To Cashier - Pharmacy','jeremi16us','2017-09-22 00:00:00'),(765,'pharmacy.cashierMakePayment','Cashier Make Payment for Pharmacy','jeremi16us','2017-09-22 00:00:00'),(771,'laboratory.submitSample','Submit Sample Specimen','jeremi16us','2017-09-22 00:00:00'),(772,'laboratory.edit','Edit Doctor Consultation Fee ','jeremi16us','2017-09-22 00:00:00'),(773,'laboratory.delete','Delete Doctor Consultation Fee ','jeremi16us','2017-09-22 00:00:00'),(774,'laboratory.sampleCollection','Sample Collection','jeremi16us','2018-05-03 00:00:00'),(781,'patientBilling.zeroBillItem','Zero Bill Item','jeremi16us','2017-09-22 00:00:00'),(782,'patientBilling.clearBill','Clear Bill','jeremi16us','2017-09-22 00:00:00'),(783,'patientBilling.approveBill','Approve Bill','jeremi16us','2017-09-22 00:00:00'),(784,'patientBilling.removeCreditBillItem','Remove Credit Bill Item','jeremi16us','2017-09-22 00:00:00'),(785,'patientBilling.removeCashBillItem','Remove Cash Bill Item','jeremi16us','2017-09-22 00:00:00'),(786,'patientBilling.byPassAdmissionCharge','By Pass Admission Charges','jeremi16us','2019-10-08 00:00:00'),(787,'patientBilling.byPassCashBill','By Pass Cash Bill','jeremi16us','2020-05-06 00:00:00'),(791,'editTransaction.cancelReceipt','Cancel Receipt','jeremi16us','2017-09-22 00:00:00'),(792,'editTransaction.removeTransactionItem','Remove Transaction Item','jeremi16us','2017-09-22 00:00:00'),(793,'editTransaction.changeTransactionItem','Change Transaction Item','jeremi16us','2017-09-22 00:00:00'),(794,'editTransaction.editeTransactionItem','Edit Transaction Item','jeremi16us','2017-09-22 00:00:00'),(795,'editTransaction.changeBillingType','Change Billing Type','jeremi16us','2017-09-22 00:00:00'),(796,'editTransaction.addItemToDocument','Add Transaction Item','jeremi16us','2017-09-22 00:00:00'),(797,'editTransaction.changeSponsor','Change Sponsor','jeremi16us','2017-09-22 00:00:00'),(798,'editTransaction.reinstateCancelReceipt','Reinstate Cancel Receipt','jeremi16us','2019-04-01 00:00:00'),(801,'patientCheckinAction.transfterPatient','Transfer Patient','jeremi16us','2017-09-22 00:00:00'),(802,'patientCheckinAction.signOffPatient','Sign Off Patient','jeremi16us','2017-09-22 00:00:00'),(803,'patientCheckinAction.noShowPatient','No Show Patient','jeremi16us','2017-09-22 00:00:00'),(804,'patientCheckinAction.multiSignOffPatient','Multiple Sign Off Patient','jeremi16us','2017-09-22 00:00:00'),(805,'patientCheckinAction.multiNoShowPatient','Multiple No Show Patient','jeremi16us','2017-09-22 00:00:00'),(806,'patientCheckinAction.transfterPatientAtDoctor','Transfer Patient at Doctors Page','jeremi16us','2019-02-27 00:00:00'),(807,'patientCheckinAction.multiTransferPatientAtDoctor','Multiple Transfer Patient at Doctors Page','jeremi16us','2019-02-27 00:00:00'),(811,'patientBabyCare.create','Create Patient Baby Care ','jeremi16us','2017-08-09 00:00:00'),(812,'patientBabyCare.submit','Submit Patient Baby Care','jeremi16us','2017-08-09 00:00:00'),(813,'patientBabyCare.edit','Edit Patient Baby Care ','jeremi16us','2017-08-09 00:00:00'),(814,'patientBabyCare.delete','Delete Patient Baby Care ','jeremi16us','2017-08-09 00:00:00'),(815,'pharamacyMedicine.swap','Swap Medicine','jeremi16us','2018-04-30 00:00:00'),(816,'generalLedgerReceipt.edit','Update Receipt','jeremi16us','2018-04-30 00:00:00'),(821,'editOrder.removeItem.atRevenueCycle','Remove Item RevenueCycle','jeremi16us','2017-09-22 00:00:00'),(822,'editOrder.removeItem.atOrderForm','Remove Item OrderForm','jeremi16us','2017-09-22 00:00:00'),(823,'editOrder.changeItem','Change Item','jeremi16us','2017-09-22 00:00:00'),(831,'activeUserLogin.logoutEmployee','Logout Employee','jeremi16us','2017-09-22 00:00:00'),(841,'debt.create','Add New Debt','jeremi16us','2019-03-18 00:00:00'),(842,'debt.edit','Edit Debt','jeremi16us','2019-03-18 00:00:00'),(843,'debt.delete','Delete Debt','jeremi16us','2019-03-18 00:00:00'),(851,'patientDischargeSummary.create','Create Patient Discharge Summary ','jeremi16us','2017-08-09 00:00:00'),(852,'patientDischargeSummary.submit','Submit Patient Discharge Summary','jeremi16us','2017-08-09 00:00:00'),(853,'patientDischargeSummary.edit','Edit Patient Discharge Summary ','jeremi16us','2017-08-09 00:00:00'),(854,'patientDischargeSummary.delete','Delete Patient Discharge Summary ','jeremi16us','2017-08-09 00:00:00'),(861,'revenueCycle.patientDiscountCash','Revenue Cycle - Discount Cash','jeremi16us','2019-04-11 00:00:00'),(862,'revenueCycle.patientDiscountCredit','Revenue Cycle - Discount Credit','jeremi16us','2019-04-11 00:00:00'),(863,'revenueCycle.patientCheckInOther','Revenue Cycle - Other Check In','jeremi16us','2019-04-11 00:00:00'),(871,'claimProcessing.processPendingClaim','Claim Processing - Process Pending Claim','jeremi16us','2019-04-29 00:00:00'),(872,'claimProcessing.mapItems.add','Claim Processing - Map Items - ADD','jeremi16us','2019-04-29 00:00:00'),(873,'claimProcessing.mapItems.remove','Claim Processing - Map Items - REMOVE','jeremi16us','2019-04-29 00:00:00'),(874,'claimProcessing.reinstateFailedClaim','Claim Processing - Reinstate Failed Claim','jeremi16us','2019-04-29 00:00:00'),(881,'message.create','Add New Message','jeremi16us','2019-05-04 00:00:00'),(882,'message.edit','Edit Message','jeremi16us','2019-05-04 00:00:00'),(883,'message.delete','Delete Message','jeremi16us','2019-05-04 00:00:00'),(891,'claimProcessing.claimFolio.success','Claiming Folio - Success','jeremi16us','2019-05-22 00:00:00'),(892,'claimProcessing.claimFolio.failed','Claiming Folio - Failed','jeremi16us','2019-05-22 00:00:00'),(893,'claimProcessing.claimFolio.remove','Claiming Folio - Remove','jeremi16us','2019-06-05 00:00:00'),(894,'claimProcessing.validateInsurerScheme.valid','Claiming Validate Sponsor Scheme - Valid','jeremi16us','2019-11-01 00:00:00'),(895,'claimProcessing.validateInsurerScheme.invalid','Claiming Validate Sponsor Scheme - Invalid','jeremi16us','2019-11-01 00:00:00'),(901,'claimBatch.create','Create Claim Batch ','jeremi16us','2018-05-31 00:00:00'),(902,'claimBatch.submit','Submit Claim Batch','jeremi16us','2018-05-31 00:00:00'),(903,'claimBatch.edit','Edit Claim Batch ','jeremi16us','2018-05-31 00:00:00'),(904,'claimBatch.delete','Delete Claim Batch ','jeremi16us','2018-05-31 00:00:00'),(911,'claimItem.create','Create Claim Item ','jeremi16us','2019-06-14 00:00:00'),(912,'claimItem.submit','Submit Claim Item','jeremi16us','2019-06-14 00:00:00'),(913,'claimItem.edit','Edit Claim Item ','jeremi16us','2019-06-14 00:00:00'),(914,'claimItem.delete','Delete Claim Item ','jeremi16us','2019-06-14 00:00:00'),(921,'itemReport.create','Create Item Report ','jeremi16us','2019-10-13 00:00:00'),(922,'itemReport.submit','Submit Item Report','jeremi16us','2019-10-13 00:00:00'),(923,'itemReport.edit','Edit Item Report ','jeremi16us','2019-10-13 00:00:00'),(924,'itemReport.delete','Delete Item Report ','jeremi16us','2019-10-13 00:00:00'),(931,'itemReportTemplate.create','Create Item Report Template ','jeremi16us','2019-10-13 00:00:00'),(932,'itemReportTemplate.submit','Submit Item Report Template','jeremi16us','2019-10-13 00:00:00'),(933,'itemReportTemplate.edit','Edit Item Report Template ','jeremi16us','2019-10-13 00:00:00'),(934,'itemReportTemplate.delete','Delete Item Report Template ','jeremi16us','2019-10-13 00:00:00'),(941,'scheduler.create','Create Scheduler ','jeremi16us','2019-10-17 00:00:00'),(942,'scheduler.submit','Submit Scheduler','jeremi16us','2019-10-17 00:00:00'),(943,'scheduler.edit','Edit Scheduler ','jeremi16us','2019-10-17 00:00:00'),(944,'scheduler.delete','Delete Scheduler ','jeremi16us','2019-10-17 00:00:00'),(951,'orderItem.create','Create Order Item ','jeremi16us','2019-11-05 00:00:00'),(952,'orderItem.submit','Submit Order Item','jeremi16us','2019-11-05 00:00:00'),(953,'orderItem.edit','Edit Order Item ','jeremi16us','2019-11-05 00:00:00'),(954,'orderItem.delete','Delete Order Item ','jeremi16us','2019-11-05 00:00:00'),(961,'patientAnaesthesiaRecord.create','Create Patient Baby Care ','jeremi16us','2017-08-09 00:00:00'),(962,'patientAnaesthesiaRecord.submit','Submit Patient Baby Care','jeremi16us','2017-08-09 00:00:00'),(963,'patientAnaesthesiaRecord.edit','Edit Patient Baby Care ','jeremi16us','2017-08-09 00:00:00'),(964,'patientAnaesthesiaRecord.delete','Delete Patient Baby Care ','jeremi16us','2017-08-09 00:00:00'),(971,'systemNotification.create','Create System Notification ','jeremi16us','2020-06-02 00:00:00'),(972,'systemNotification.submit','Submit System Notification','jeremi16us','2020-06-02 00:00:00'),(973,'systemNotification.edit','Edit System Notification ','jeremi16us','2020-06-02 00:00:00'),(974,'systemNotification.delete','Delete System Notification ','jeremi16us','2020-06-02 00:00:00'),(975,'systemNotification.updateSystem','Update System ','jeremi16us','2020-06-12 00:00:00'),(981,'tibanovaPortal.uploadItemList','Tibanova Portal - Upload Item List','jeremi16us','2020-07-14 00:00:00'),(982,'tibanovaPortal.error','Tibanova Portal - Error','jeremi16us','2020-07-14 00:00:00'),(991,'patientAppointment.create','Create Patient Appointment','jeremi16us','2017-08-09 00:00:00'),(992,'patientAppointment.submit','Submit Patient Appointment','jeremi16us','2017-08-09 00:00:00'),(993,'patientAppointment.edit','Edit Patient Appointment','jeremi16us','2017-08-09 00:00:00'),(994,'patientAppointment.delete','Delete Patient Appointment','jeremi16us','2017-08-09 00:00:00');

--
-- Dumping data for table `cause_of_injury`
--


--
-- Dumping data for table `configuration`
--

INSERT INTO `configuration` VALUES (1,'config.employeeType','Employee Type','jeremi16us','2016-10-31 00:00:00',NULL,NULL),(2,'config.employeeJobCode','Employee Job Code','jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3,'config.departmentLocation','Nature of Department','jeremi16us','2016-11-03 00:00:00',NULL,NULL),(4,'config.natureOfClinic','Nature of Clinic','jeremi16us','2016-11-03 00:00:00',NULL,NULL),(5,'config.itemsCategoryType','Items Category Type','jeremi16us','2016-11-03 00:00:00',NULL,NULL),(6,'config.itemType','Item Type','jeremi16us','2016-11-23 00:00:00',NULL,NULL),(7,'config.nhifItemType','Item Type','jeremi16us','2016-11-23 00:00:00',NULL,NULL),(8,'config.unitOfMeasure','Item Type','jeremi16us','2016-11-23 00:00:00',NULL,NULL),(9,'config.itemClassification','Item Classification','jeremi16us','2016-11-23 00:00:00',NULL,NULL),(10,'config.itemStatus','Item Status','jeremi16us','2016-11-23 00:00:00',NULL,NULL),(11,'config.itemParticularType','Item Particular Type','jeremi16us','2016-11-23 00:00:00',NULL,NULL),(12,'config.itemConsultationType','Item Consultation Type','jeremi16us','2016-11-23 00:00:00',NULL,NULL),(13,'config.itemPriceOrderBy','Item Price ORDER BY','jeremi16us','2016-11-26 00:00:00',NULL,NULL),(14,'config.namePrefix','Item Consultation Type','jeremi16us','2017-03-16 00:00:00',NULL,NULL),(15,'config.currency','Currency','jeremi16us','2017-03-16 00:00:00',NULL,NULL);

--
-- Dumping data for table `configuration_option`
--

INSERT INTO `configuration_option` VALUES (2999,'Doctor','1','Doctor',1,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3000,'Accountant','2','Accountant',2,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3001,'Billing Personnel','3','Billing Personnel',3,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3002,'Cashier','4','Cashier',4,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3003,'Doctor','5','Doctor',5,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3004,'Food Personnel','6','Food Personnel',6,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3005,'Hospital Admin','7','Hospital Admin',7,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3006,'IT Personnel','8','IT Personnel',8,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3007,'Laboratory Technician','9','Laboratory Technician',9,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3008,'Laundry Personnel','10','Laundry Personnel',10,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3009,'Nurse','11','Nurse',11,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3010,'Pharmacist','12','Pharmacist',12,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3011,'Procurement','13','Procurement',13,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3012,'Radiologist','14','Radiologist',14,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3013,'Receptionist','15','Receptionist',15,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3014,'Record Personnel','16','Record Personnel',16,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3015,'Security Personnel','17','Security Personnel',17,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3016,'Storekeeper','18','Storekeeper',18,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3017,'Others','19','Others',19,1,1,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3018,'Anaesthesiologist','1','Anaesthesiologist',1,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3019,'Dentist','2','Dentist',2,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3020,'Gynecologist','3','Gynecologist',3,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3021,'Nurse','4','Nurse',4,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3022,'Scrub Nurse','5','Scrub Nurse',5,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3023,'Optician','6','Optician',6,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3024,'Paedetrician','7','Paedetrician',7,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3025,'Radiographer','8','Radiographer',8,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3026,'Radiologist','9','Radiologist',9,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3027,'Sonographer','10','Sonographer',10,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3028,'Surgeon','11','Surgeon',11,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3029,'Sonographer/Radiographer','12','Sonographer/Radiographer',12,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3030,'Sonographer/Radiolographer/Radiologist','13','Sonographer/Radiolographer/Radiologist',13,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3031,'Others','14','Others',14,1,2,'jeremi16us','2016-10-31 00:00:00',NULL,NULL),(3032,'Laboratory','1','Laboratory',1,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3033,'Admission','2','Admission',2,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3034,'Blood Bank','3','Blood Bank',3,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3035,'Cecap','4','Cecap',4,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3036,'Dental','5','Dental',5,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3037,'Dialysis','6','Dialysis',6,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3038,'Dressing','7','Dressing',7,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3039,'Eram','8','Eram',8,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3040,'Ear','9','Ear',9,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3041,'Optical','10','Optical',10,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3042,'Family Planning','11','Family Planning',11,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3043,'Finance','12','Finance',12,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3044,'HIV','13','HIV',13,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3045,'Laboratory','14','Laboratory',14,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3046,'Management','15','Management',15,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3047,'Maternity','16','Maternity',16,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3048,'Nurse Station','17','Nurse Station',17,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3049,'Physiotherapy','18','Physiotherapy',18,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3050,'Pharmacy','19','Pharmacy',19,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3051,'Procedure','20','Procedure',20,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3052,'Procurement','21','Procurement',21,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3053,'Quality Assuarance','22','Quality Assuarance',22,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3054,'RCH','23','RCH',23,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3055,'Radiology','24','Radiology',24,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3056,'Reception','25','Reception',25,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3057,'Revenue Center','26','Revenue Center',26,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3058,'Setup And Configuration','27','Setup And Configuration',27,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3059,'Storage And Supply','28','Storage And Supply',28,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3060,'Surgery','29','Surgery',29,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3061,'Theater','30','Theater',30,1,3,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3062,'Doctor','31','Doctor',31,1,3,'jeremi16us','2016-12-07 00:00:00',NULL,NULL),(3063,'Cecap','1','Cecap',1,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3064,'Dental','2','Dental',2,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3065,'Dialysis','3','Dialysis',3,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3066,'Doctor\'s Room','4','Doctor\'s Room',4,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3067,'Dressing','5','Dressing',5,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3068,'Ear','6','Ear',6,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3069,'HIV','7','HIV',7,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3070,'Laboratory','8','Laboratory',8,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3071,'Matenity','9','Matenity',9,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3072,'Optical','10','Optical',10,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3073,'Pharmacy','11','Pharmacy',11,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3074,'Physiotherapy','12','Physiotherapy',12,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3075,'Radiology','13','Radiology',13,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3076,'RCH','14','RCH',14,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3077,'Theater','15','Theater',15,1,4,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3078,'Service','1','Service',1,1,5,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3079,'Pharmacy','2','Pharmacy',2,1,5,'jeremi16us','2016-11-03 00:00:00',NULL,NULL),(3080,'Service','1','Serviced Item',1,1,6,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3081,'Pharmacy','2','Pharmaceutical Item',2,1,6,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3082,'Others','3','Other Item',2,1,6,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3083,'Registration/Consultation Charges','1','Registration/Consultation Charges',1,1,7,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3084,'Inpatient Charges','2','Inpatient Charges',2,1,7,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3085,'Medicine and Consumables','3','Medicine and Consumables',2,1,7,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3086,'Surgical Charges','4','Surgical Charges',4,1,7,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3087,'Diagnostic Examinations','5','Diagnostic Examinations',5,1,7,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3088,'Procedural Charges','6','Procedural Charges',6,1,7,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3089,'Other Charges','7','Other Charges',7,1,7,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3090,'btl','1','BTL',1,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3091,'pc','2','PC',2,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3092,'vial','3','VIAL',3,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3093,'tube','4','TUBE',4,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3094,'kit','5','KIT',5,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3095,'nill','6','NILL',6,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3096,'box','7','BOX',7,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3097,'cap','8','CAP',8,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3098,'tab','9','TAB',9,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3099,'tin','10','TIN',10,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3100,'LIST519','11','LIST519',11,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3101,'amp','12','AMP',12,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3102,'bag','13','BAG',13,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3103,'vl','14','VL',14,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3104,'pky','15','PKT',15,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3105,'caps','16','CAPS',16,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3106,'supp','17','SUPP',17,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3107,'tabs','18','TABS',18,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3108,'25g','19','25g',19,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3109,'ltr','20','LTR',20,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3110,'pair','21','PAIR',21,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3111,'20lt','22','20LT',22,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3112,'pct','23','PCT',23,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3113,'disc','24','DISC',24,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3114,'100','25','100',25,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3115,'cnt','26','CNT',26,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3116,'roll','27','ROLL',27,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3117,'25','28','25',28,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3118,'doz','29','DOZ',29,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3119,'each','30','EACH',30,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3120,'soln','31','SOLN',31,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3121,'inj','32','INJ',32,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3122,'mt','33','MT',33,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3123,'stchts','34','STCHTS',34,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3124,'Pieces','35','PIECES',35,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3125,'bundle','36','BUNDLE',36,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3126,'book','36','BOOK',36,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3127,'ream','36','REAM',36,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3128,'pad','36','PAD',36,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3129,'bottle','36','BOTTOLE',36,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3130,'bundle','36','BUNDLE',36,1,8,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3131,'Pharmaceuticals','PHARMACEUTICALS','Pharmaceuticals',1,1,9,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3132,'Disposables','PHARMACEUTICALS','Disposables',2,1,9,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3133,'Dental Materials','PHARMACEUTICALS','Dental Materials',3,1,9,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3134,'Radiology Materials','PHARMACEUTICALS','Radiology Materials',4,1,9,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3135,'Laboratory Materials','PHARMACEUTICALS','Laboratory Materials',5,1,9,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3136,'Stationaries','STATIONARIES','Stationaries',6,1,9,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3137,'Others','OTHERS','Others',6,1,9,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3138,'Available','1','Available',1,1,10,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3139,'Not Available','2','Not Available',2,1,10,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3140,'Others','1','Others',1,1,11,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3141,'Cost Sharing','2','Cost Sharing',2,1,11,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3142,'DRF','3','DRF',3,1,11,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3143,'Fast Track','4','Fast Track',4,1,11,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3144,'Pharmacy','1','Pharmacy',1,1,12,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3145,'Laboratory','2','Laboratory',2,1,12,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3146,'Radiology','3','Radiology',3,1,12,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3147,'Surgery','4','Surgery',4,1,12,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3148,'Procedure','5','Procedure',5,1,12,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3149,'Optical','6','Optical',6,1,12,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3150,'Others','7','Others',7,1,12,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3151,'Dialysis','8','Dialysis',8,1,12,'jeremi16us','2016-11-23 00:00:00',NULL,NULL),(3152,'ITEM_PRICE_ASC','{\"COLUMN\":\"Item_Price\",\"DIRECTION\":\"ASC\"}','Item Price - Asc',1,1,13,'jeremi16us','2016-11-26 00:00:00',NULL,NULL),(3153,'ITEM_PRICE_DESC','{\"COLUMN\":\"Item_Price\",\"DIRECTION\":\"DESC\"}','Item Price - Desc',2,1,13,'jeremi16us','2016-11-26 00:00:00',NULL,NULL),(3154,'SPONSOR_SUPPORT_ASC','{\"COLUMN\":\"Is_Not_Supported\",\"DIRECTION\":\"ASC\"}','Sponsor Support - Asc',3,1,13,'jeremi16us','2016-11-26 00:00:00',NULL,NULL),(3155,'SPONSOR_SUPPORT_DESC','{\"COLUMN\":\"Is_Not_Supported\",\"DIRECTION\":\"DESC\"}','Sponsor Support - Desc',4,1,13,'jeremi16us','2016-11-26 00:00:00',NULL,NULL),(3156,'SPONSOR_ALLOWED_ZERO_PRICE_ASC','{\"COLUMN\":\"Is_Allow_Zero_Price\",\"DIRECTION\":\"ASC\"}','Sponsor Allowed Zero Price - Asc',5,1,13,'jeremi16us','2016-11-26 00:00:00',NULL,NULL),(3157,'SPONSOR_ALLOWED_ZERO_PRICE_DESC','{\"COLUMN\":\"Is_Allow_Zero_Price\",\"DIRECTION\":\"DESC\"}','Sponsor Allowed Zero Price - Desc',6,1,13,'jeremi16us','2016-11-26 00:00:00',NULL,NULL),(3158,'Mr','1','Mr',1,1,14,'jeremi16us','2017-03-16 00:00:00',NULL,NULL),(3159,'Mrs','2','Mrs',2,1,14,'jeremi16us','2017-03-16 00:00:00',NULL,NULL),(3160,'Miss','3','Miss',3,1,14,'jeremi16us','2017-03-16 00:00:00',NULL,NULL),(3161,'Master','4','Master',4,1,14,'jeremi16us','2017-03-16 00:00:00',NULL,NULL),(3162,'Dr','5','Dr',5,1,14,'jeremi16us','2017-03-16 00:00:00',NULL,NULL),(3163,'Prof','6','Prof',6,1,14,'jeremi16us','2017-03-16 00:00:00',NULL,NULL),(3164,'Ms','7','Ms',7,1,14,'jeremi16us','2017-03-16 00:00:00',NULL,NULL),(3165,'Hon','8','Honarable',8,1,14,'jeremi16us','2017-03-16 00:00:00',NULL,NULL),(3166,'TSH','1','TSH',1,1,15,'jeremi16us','2017-03-16 00:00:00',NULL,NULL),(3167,'USD','2','USD',2,1,15,'jeremi16us','2017-03-16 00:00:00',NULL,NULL);

--
-- Dumping data for table `country`
--

INSERT INTO `country` VALUES (1,'Tanzania','Y','TZ','255'),(2,'Kenya','N','KE','254'),(3,'Afghanistan','N','AF','93'),(4,'Alabama','N',NULL,NULL),(5,'Algeria','N','DZ','213'),(6,'Andorra','N','AD','376'),(7,'Angola','N','AO','244'),(8,'Antigua and Barbuda','N','AG','1-268'),(9,'Argentina','N','AR','54'),(10,'Armenia','N','AM','374'),(11,'Aruba','N','AW','297'),(12,'Australia','N','AU','61'),(13,'Austria','N','AT','43'),(14,'Azerbaijan','N','AZ','994'),(15,'Bahamas, The','N','BS','1-242'),(16,'Bahrain','N','BH','973'),(17,'Bangladesh','N','BD','880'),(18,'Barbados','N','BB','1-246'),(19,'Belarus','N','BY','375'),(20,'Belgium','N','BE','32'),(21,'Belize','N','BZ','501'),(22,'Benin','N','BJ','229'),(23,'Bhutan','N','BT','975'),(24,'Bolivia','N','BO','591'),(25,'Bosnia and Herzegovina','N','BA','387'),(26,'Botswana','N','BW','267'),(27,'Brazil','N','BR','55'),(28,'Brunei ','N','BN','673'),(29,'Bulgaria','N','BG','359'),(30,'Burkina Faso','N','BF','226'),(31,'Burma','N',NULL,NULL),(32,'Burundi','N','BI','257'),(33,'Dominica ','N','DM','1-767'),(36,'USA','N',NULL,NULL),(37,'Comoro','N',NULL,NULL);

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` VALUES (1,'Tanzania shilling','TZS','',32,'2015-12-19 17:33:30'),(3,'United States dollar','USD','',32,'2015-12-19 17:34:41'),(6,'Kenya shilling','KES','',32,'2015-12-19 17:36:58'),(8,'Uganda shilling','UGX','',32,'2015-12-19 17:38:00'),(9,'Burundi franc','BIF','',32,'2015-12-19 17:39:18'),(10,'Rwanda franc','RWAF','',32,'2015-12-19 17:40:17');

--
