-- Table structure for table `lab_setup2`
--

CREATE TABLE `lab_setup2` (
  `id` int(100) NOT NULL DEFAULT 0,
  `subhead` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `head` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `description` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `unit` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `range_from` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `range_to` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `specimen` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `price` int(100) DEFAULT NULL,
  `noOfLabels` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `facilityId` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `created_by` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `lab_setup2`
--

INSERT INTO `lab_setup2` (`id`, `subhead`, `head`, `description`, `unit`, `range_from`, `range_to`, `specimen`, `price`, `noOfLabels`, `created_at`, `updated_at`, `facilityId`, `created_by`) VALUES
(2, '', 'Optimum Diagnostics', '', NULL, NULL, NULL, '', NULL, 0, '2020-08-16 01:30:37', NULL, '966a89f6-05d8-4564-b319-2f8863821e75', ''),
(72, 'Test', 'test1', '', 'mmol/L', '1', '2', 'Blood', 500, 0, '2020-09-18 08:48:58', NULL, '966a89f6-05d8-4564-b319-2f8863821e75', 'admin');

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

--
-- Table structure for table `lab_setup3`
--

CREATE TABLE `lab_setup3` (
  `id` int(11) NOT NULL,
  `subhead` varchar(100) DEFAULT NULL,
  `head` varchar(100) DEFAULT NULL,
  `description` varchar(200) NOT NULL,
  `unit` varchar(100) DEFAULT NULL,
  `range_from` varchar(100) DEFAULT NULL,
  `range_to` varchar(100) DEFAULT NULL,
  `specimen` varchar(100) DEFAULT NULL,
  `price` int(100) DEFAULT NULL,
  `percentage` int(11) NOT NULL,
  `noOfLabels` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` varchar(100) DEFAULT NULL,
  `facilityId` varchar(50) NOT NULL,
  `created_by` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `lab_setup3`
--

INSERT INTO `lab_setup3` (`id`, `subhead`, `head`, `description`, `unit`, `range_from`, `range_to`, `specimen`, `price`, `percentage`, `noOfLabels`, `created_at`, `updated_at`, `facilityId`, `created_by`) VALUES
(1, '2000', '1000', 'Hematology', NULL, NULL, NULL, 'No specimen', NULL, 0, 0, '2020-11-15 22:55:46', NULL, '966a89f6-05d8-4564-b319-2f8863821e75', ''),
(361, '30013', '3001', 'K', 'mmol/L', '3.0', '5.6', 'Urine', 600, 0, 0, '2020-11-15 22:54:01', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'emaitee');

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

--
-- Table structure for table `lab_setup4`
--

CREATE TABLE `lab_setup4` (
  `id` int(11) NOT NULL DEFAULT 0,
  `subhead` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `head` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `description` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `unit` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `range_from` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `range_to` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `other_range` varchar(50) DEFAULT NULL,
  `specimen` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `price` int(100) DEFAULT NULL,
  `percentage` int(11) NOT NULL,
  `noOfLabels` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `facilityId` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `created_by` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `lab_setup4`
--

INSERT INTO `lab_setup4` (`id`, `subhead`, `head`, `description`, `unit`, `range_from`, `range_to`, `other_range`, `specimen`, `price`, `percentage`, `noOfLabels`, `created_at`, `updated_at`, `facilityId`, `created_by`) VALUES
(351, '1000', '', 'PSC Prime Lab', NULL, NULL, NULL, '', '', NULL, 0, 0, '0000-00-00 00:00:00', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', ''),
(292, '5136', '5000', 'hs CRP', '', '', '', '', '', 2500, 0, 1, '2020-11-17 13:24:22', '', '966a89f6-05d8-4564-b319-2f8863821e75', '');

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

--
-- Table structure for table `main_account`
--

CREATE TABLE `main_account` (
  `code` varchar(20) NOT NULL,
  `Description` varchar(50) NOT NULL,
  `type` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `main_account`
--

INSERT INTO `main_account` (`code`, `Description`, `type`) VALUES
('100010', 'Capital Account', 4),
('100020', 'Deposit Account', 4),
('100030', 'Suupliers Account', 4),
('600010', 'cash Account', 3),
('600020', 'Bank Account', 3),
('700010', 'Wages', 1),
('700020', 'Fuel', 1),
('800020', 'Drugs', 2),
('800010', 'Labs', 2);

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

--
-- Stand-in structure for view `medication_report`
-- (See below for the actual view)
--
CREATE TABLE `medication_report` (
`patient_id` int(1)
,`drug` int(1)
,`dosage` int(1)
,`route` int(1)
,`time_stamp` int(1)
,`status` int(1)
,`served_by` int(1)
,`nurse_name` int(1)
,`reason` int(1)
);

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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`name`, `email`) VALUES
('adi', 'kamal'),
('abbba', 'sanio'),
('kamilu', 'danbata'),
('abba', 'collipad'),
('sarki', 'aliyu'),
('aminu', 'salim'),
('undefined', 'undefined'),
('undefined', 'undefined'),
('undefined', 'undefined'),
('undefined', 'undefined'),
('undefined', 'mubrak@gmail.ocm');

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

--
-- Table structure for table `monthly_register`
--

CREATE TABLE `monthly_register` (
  `code` int(11) NOT NULL,
  `month` varchar(20) NOT NULL,
  `amount` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_by` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `number_generator`
--

CREATE TABLE `number_generator` (
  `description` varchar(100) NOT NULL,
  `prefix` varchar(100) NOT NULL,
  `code_no` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `number_generator`
--

INSERT INTO `number_generator` (`description`, `prefix`, `code_no`) VALUES
('Good Receive Note', 'GRN', 9551),
('invoice', 'inv', 46),
('Goods transfer', 'trn', 1);

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

--
-- Table structure for table `nursing_note`
--

CREATE TABLE `nursing_note` (
  `id` int(11) NOT NULL,
  `report` varchar(150) DEFAULT NULL,
  `patient_id` varchar(20) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `created_by` varchar(50) DEFAULT NULL,
  `facilityId` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `nursing_report`
--

CREATE TABLE `nursing_report` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_by` varchar(50) NOT NULL,
  `report` varchar(2000) NOT NULL,
  `facilityId` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `operationnotes`
--

CREATE TABLE `operationnotes` (
  `facilityId` varchar(50) DEFAULT NULL,
  `id` int(11) NOT NULL,
  `uuid` varchar(50) DEFAULT NULL,
  `date` varchar(20) DEFAULT NULL,
  `patientId` varchar(10) NOT NULL,
  `diagnosis` varchar(150) DEFAULT NULL,
  `surgeons` varchar(300) DEFAULT NULL,
  `surgery` varchar(150) DEFAULT NULL,
  `anesthetist` varchar(80) DEFAULT NULL,
  `anesthetic` varchar(20) DEFAULT NULL,
  `scrubNurse` varchar(50) DEFAULT NULL,
  `remarks` varchar(50) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `pintsGiven` varchar(10) DEFAULT NULL,
  `bloodLoss` varchar(15) DEFAULT NULL,
  `intraOpAntibiotics` varchar(20) DEFAULT NULL,
  `intraOpFindings` varchar(2000) DEFAULT NULL,
  `procedureNotes` varchar(2000) DEFAULT NULL,
  `pathologyRequest` varchar(2000) DEFAULT NULL,
  `postOpOrder` varchar(1500) DEFAULT NULL,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatedAt` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Triggers `operationnotes`
--
DELIMITER $$
CREATE TRIGGER `default_date` BEFORE INSERT ON `operationnotes` FOR EACH ROW if ( isnull(new.date) ) then
 set new.date=curdate();
end if
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `set_op_notes_updateAt` BEFORE UPDATE ON `operationnotes` FOR EACH ROW SET NEW.updatedAt = NOW()
$$
DELIMITER ;

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

--
-- Stand-in structure for view `overview`
-- (See below for the actual view)
--
CREATE TABLE `overview` (
`drug` int(1)
,`quantity_bought` int(1)
,`amount_bought` int(1)
,`quantity_in_store` int(1)
,`amount_in_store` int(1)
,`quantity_sold` int(1)
,`amount_sold` int(1)
,`quantity_in_shelf` int(1)
,`amount_in_shelf` int(1)
,`sales_date` int(1)
,`purchase_date` int(1)
,`facilityId` int(1)
);

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

--
-- Stand-in structure for view `overview_wo_store`
-- (See below for the actual view)
--
CREATE TABLE `overview_wo_store` (
`drug` int(1)
,`price` int(1)
,`quantity_in_shelf` int(1)
,`amount_in_shelf` int(1)
,`quantity_sold` int(1)
,`amount_sold` int(1)
,`expiry_date` int(1)
,`created_at` int(1)
,`facilityId` int(1)
);

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

--
-- Table structure for table `pagenavigation`
--

CREATE TABLE `pagenavigation` (
  `id` int(11) NOT NULL,
  `role` varchar(30) NOT NULL,
  `home_page` varchar(100) NOT NULL,
  `facilityId` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pagenavigation`
--

INSERT INTO `pagenavigation` (`id`, `role`, `home_page`, `facilityId`) VALUES
(1, 'Cashier', '/me/account/review', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(2, 'Receptionist', '/me/records/patients/list', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(3, 'Technician', '/me/lab/sample-collection', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(4, 'Sample Collector', '/me/lab/sample-collection', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(5, 'Doctor', '/me/doctor', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(6, 'Sample Collection', '/me/lab/sample-collection', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(7, 'Scientist', '/me/lab/patients', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(8, 'Accountant', '/me/account/report', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(9, 'Lab Scientist', '/me/lab', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(10, 'Manager', '/me/account/services', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(11, 'Admin', '/me/admin', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(12, 'IT Staff', '/me/pharmacy', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(13, 'Nurse', '/me/nurse/vital-signs', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(14, 'Neurosurgeon', '/me/doctor', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a');

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

--
-- Table structure for table `patientfileinfo`
--

CREATE TABLE `patientfileinfo` (
  `id` int(11) NOT NULL,
  `accountNo` varchar(7) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `surname` varchar(50) NOT NULL,
  `beneficiaries` int(5) NOT NULL,
  `balance` int(11) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `patientfileno`
--

CREATE TABLE `patientfileno` (
  `id` int(11) NOT NULL,
  `facilityId` varchar(50) DEFAULT NULL,
  `accountNo` int(7) DEFAULT NULL,
  `accName` varchar(50) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `accountType` varchar(50) DEFAULT NULL,
  `contactName` varchar(100) DEFAULT NULL,
  `contactAddress` varchar(500) DEFAULT NULL,
  `contactPhone` varchar(20) DEFAULT NULL,
  `contactEmail` varchar(50) DEFAULT NULL,
  `contactWebsite` varchar(50) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `surname` varchar(50) DEFAULT NULL,
  `beneficiaries` bigint(21) NOT NULL DEFAULT 0,
  `balance` int(11) NOT NULL DEFAULT 0,
  `status` varchar(50) NOT NULL DEFAULT 'approved',
  `guarantor_name` varchar(50) DEFAULT NULL,
  `guarantor_address` varchar(100) DEFAULT NULL,
  `guarantor_phone` varchar(20) DEFAULT NULL,
  `created_by` varchar(50) DEFAULT NULL,
  `approved_by` varchar(50) DEFAULT NULL,
  `createdAt` timestamp NULL DEFAULT current_timestamp(),
  `approved_at` timestamp NULL DEFAULT NULL,
  `payable_head_name` varchar(150) DEFAULT NULL,
  `payable_head` varchar(50) DEFAULT NULL,
  `receivable_head_name` varchar(150) DEFAULT NULL,
  `receivable_head` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `patientfileno`
--

INSERT INTO `patientfileno` (`id`, `facilityId`, `accountNo`, `accName`, `description`, `accountType`, `contactName`, `contactAddress`, `contactPhone`, `contactEmail`, `contactWebsite`, `firstname`, `surname`, `beneficiaries`, `balance`, `status`, `guarantor_name`, `guarantor_address`, `guarantor_phone`, `created_by`, `approved_by`, `createdAt`, `approved_at`, `payable_head_name`, `payable_head`, `receivable_head_name`, `receivable_head`) VALUES
(1, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 1, 'John Doe', NULL, 'Single', NULL, '', '09087654321', '', '', NULL, NULL, 0, -269800, 'approved', '', '', '', NULL, NULL, '2024-08-10 13:52:20', NULL, NULL, NULL, NULL, NULL),
(2, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 2, 'Marilyn Montana', NULL, 'Single', NULL, '', '09012121212', '', '', NULL, NULL, 0, 800, 'approved', '', '', '', NULL, NULL, '2024-08-12 07:46:59', NULL, NULL, NULL, NULL, NULL),
(3, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 3, 'Nazif Musa', NULL, 'Single', NULL, '', '09023232323', '', '', NULL, NULL, 0, 100, 'approved', '', '', '', NULL, NULL, '2024-08-19 13:06:11', NULL, NULL, NULL, NULL, NULL),
(4, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 4, 'Poloa Main', NULL, 'Single', NULL, '', '09090121212', '', '', NULL, NULL, 0, 7700, 'approved', '', '', '', NULL, NULL, '2024-08-19 13:11:46', NULL, NULL, NULL, NULL, NULL),
(5, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 5, 'NAF Patient', NULL, 'Single', NULL, '', '090', '', '', NULL, NULL, 0, 1000, 'approved', '', '', '', NULL, NULL, '2024-08-20 10:16:24', NULL, NULL, NULL, NULL, NULL),
(6, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 6, 'Musa Isah', NULL, 'Single', NULL, '', '09012121212', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2024-09-10 11:07:33', NULL, NULL, NULL, NULL, NULL),
(7, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 7, 'Nagudu Maibaki', NULL, 'Single', NULL, '', '09012121212', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2024-09-10 11:11:34', NULL, NULL, NULL, NULL, NULL),
(8, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 8, 'Murtala Dodo', NULL, 'Single', NULL, '', '09012121222', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2024-09-10 11:30:44', NULL, NULL, NULL, NULL, NULL),
(9, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 9, 'Kabir Ahmad', NULL, 'Insurance', NULL, 'Kurna tudun fulani', '09129513810', '', '', NULL, NULL, 0, 98000, 'approved', '', '', '', NULL, NULL, '2024-09-26 16:03:48', NULL, NULL, NULL, NULL, NULL),
(10, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 10, 'Kabir Ahmad', NULL, 'Insurance', NULL, 'Kurna tudun fulani', '09129513810', '', '', NULL, NULL, 0, 22, 'approved', '', '', '', NULL, NULL, '2024-09-27 08:28:57', NULL, NULL, NULL, NULL, NULL),
(11, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 11, 'Kabir Ahmad', NULL, 'Insurance', NULL, 'Kurna tudun fulani', '09129513810', '', '', NULL, NULL, 0, 22, 'approved', '', '', '', NULL, NULL, '2024-09-27 08:31:52', NULL, NULL, NULL, NULL, NULL),
(12, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 12, 'Kabir Ahmad', NULL, 'Single', NULL, 'Kurna tudun fulani', '09129513810', '', '', NULL, NULL, 0, 122, 'approved', '', '', '', NULL, NULL, '2024-09-30 14:32:52', NULL, NULL, NULL, NULL, NULL),
(13, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 13, 'Haruna Sadiq', NULL, 'Single', NULL, 'Kurna tudun fulani', '09129513810', '', '', NULL, NULL, 0, 22, 'approved', '', '', '', NULL, NULL, '2024-09-30 15:35:44', NULL, NULL, NULL, NULL, NULL),
(14, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 14, 'Kabir Ahmad', NULL, 'Single', NULL, 'Kurna tudun fulani', '09129513810', '', '', NULL, NULL, 0, 122, 'approved', '', '', '', NULL, NULL, '2024-09-30 15:37:25', NULL, NULL, NULL, NULL, NULL),
(15, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 15, 'Emanuela John', NULL, 'Single', NULL, 'Milky way Galaxy', '123456789', '', '', NULL, NULL, 0, 122, 'approved', '', '', '', NULL, NULL, '2024-09-30 15:45:20', NULL, NULL, NULL, NULL, NULL),
(16, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 16, 'Kabir Nurul Iman', NULL, 'Single', NULL, 'Kurna tudun fulani', '09129513810', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2024-10-01 08:46:48', NULL, NULL, NULL, NULL, NULL),
(17, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 17, 'Ss Ss', NULL, 'Single', NULL, 'Kano naibawa', '07032151593', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-01-29 14:52:14', NULL, NULL, NULL, NULL, NULL),
(18, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 18, 'Ddd Sadiq', NULL, 'Family', NULL, 'Kano', '07032151593', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-01-29 15:05:48', NULL, NULL, NULL, NULL, NULL),
(19, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 19, 'Qqq Qqq', NULL, 'Single', NULL, 'Kano naibawa', '07032151593', '', '', NULL, NULL, 0, 22, 'approved', '', '', '', NULL, NULL, '2025-01-29 15:07:40', NULL, NULL, NULL, NULL, NULL),
(20, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 20, 'Amina Amina', NULL, 'Single', NULL, 'Kano naibawa', '07032151593', '', '', NULL, NULL, 0, 22, 'approved', '', '', '', NULL, NULL, '2025-01-29 15:23:57', NULL, NULL, NULL, NULL, NULL),
(21, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 21, 'Ff Bb', NULL, 'Single', NULL, 'Kano naibawa', '07032151593', '', '', NULL, NULL, 0, 22, 'approved', '', '', '', NULL, NULL, '2025-01-29 15:25:32', NULL, NULL, NULL, NULL, NULL),
(22, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 22, 'Kks Kks', NULL, 'Single', NULL, 'Kano naibawa', '07032151593', '', '', NULL, NULL, 0, 22, 'approved', '', '', '', NULL, NULL, '2025-01-29 15:27:40', NULL, NULL, NULL, NULL, NULL),
(23, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 23, 'Zz Zz', NULL, 'Single', NULL, 'Kano naibawa', '07032151593', '', '', NULL, NULL, 0, 22, 'approved', '', '', '', NULL, NULL, '2025-01-29 16:00:20', NULL, NULL, NULL, NULL, NULL),
(24, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 24, 'Yyy Yyy', NULL, 'Single', NULL, 'Kano naibawa', '07032151593', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-01-29 16:14:47', NULL, NULL, NULL, NULL, NULL),
(25, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 25, 'Vvv Vvv', NULL, 'Single', NULL, 'Kano naibawa', '07032151593', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-01-29 16:28:21', NULL, NULL, NULL, NULL, NULL),
(26, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 26, 'Ggg Ggg', NULL, 'Single', NULL, 'Kano naibawa', '07032151593', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-01-29 16:32:29', NULL, NULL, NULL, NULL, NULL),
(27, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 27, 'Lll Lll', NULL, 'Single', NULL, 'Kano naibawa', '07032151593', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-01-30 10:02:25', NULL, NULL, NULL, NULL, NULL),
(28, '052100000000', 1, 'Hh Aa', NULL, 'Single', NULL, '', '09012340987', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-06 18:08:32', NULL, NULL, NULL, NULL, NULL),
(29, '052100000000', 2, 'Anjali Sharma', NULL, 'Single', NULL, '', '09012121212', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-06 21:59:53', NULL, NULL, NULL, NULL, NULL),
(30, '052100000000', 3, 'Rahul Nolove', NULL, 'Single', NULL, '', '090', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-06 22:10:44', NULL, NULL, NULL, NULL, NULL),
(31, '052100000000', 4, 'Alim Capital', NULL, 'Single', NULL, '', '2323', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-06 22:16:26', NULL, NULL, NULL, NULL, NULL),
(32, '052100000000', 5, 'Salla Dallam', NULL, 'Single', NULL, '', '09038420099', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-06 22:26:31', NULL, NULL, NULL, NULL, NULL),
(33, '052100000000', 6, 'Some name of pat Oher', NULL, 'Single', NULL, '', '09000990099', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 00:11:40', NULL, NULL, NULL, NULL, NULL),
(34, '052100000000', 7, 'Testing  Fullname', NULL, 'Single', NULL, '', '09023231122', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 01:32:57', NULL, NULL, NULL, NULL, NULL),
(35, '052100000000', 8, 'Other Makale', NULL, 'Single', NULL, '', '0902323', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 01:34:47', NULL, NULL, NULL, NULL, NULL),
(36, '052100000000', 9, 'New Normal', NULL, 'Single', NULL, '', '09340304', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 01:39:54', NULL, NULL, NULL, NULL, NULL),
(37, '052100000000', 10, 'Othernam Joj', NULL, 'Single', NULL, '', '09023231122', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 01:41:05', NULL, NULL, NULL, NULL, NULL),
(38, '052100000000', 11, 'Testig Otne', NULL, 'Single', NULL, '', '00023', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 01:41:58', NULL, NULL, NULL, NULL, NULL),
(39, '052100000000', 12, 'Ofeliya Samson', NULL, 'Single', NULL, '', '232', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 01:44:13', NULL, NULL, NULL, NULL, NULL),
(40, '052100000001', 1, 'Murtala Akinyemi', NULL, 'Single', NULL, '', '09012345678', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 06:53:46', NULL, NULL, NULL, NULL, NULL),
(41, '052100000000', 13, 'Olayemi Mathew', NULL, 'Single', NULL, '', '09023232322', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 11:15:31', NULL, NULL, NULL, NULL, NULL),
(42, '052100000000', 14, 'Sule Lamido', NULL, 'Single', NULL, '', '09013', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 11:17:23', NULL, NULL, NULL, NULL, NULL),
(43, '052100000000', 15, 'Yahaya Musa', NULL, 'Single', NULL, '', '09023239433', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 11:27:03', NULL, NULL, NULL, NULL, NULL),
(44, '052100000000', 16, 'Cvc Yge', NULL, 'Single', NULL, '', '12345678', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 14:08:35', NULL, NULL, NULL, NULL, NULL),
(45, '052100000000', 17, 'Maryam Musa', NULL, 'Single', NULL, '', '090121212221', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 16:10:08', NULL, NULL, NULL, NULL, NULL),
(46, '052100000000', 18, 'Isa Musa', NULL, 'Single', NULL, '', '090123455667', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 16:28:47', NULL, NULL, NULL, NULL, NULL),
(47, '052100000000', 19, 'ASDASD SFASD', NULL, 'Single', NULL, '', '0903434', '', '', NULL, NULL, 0, 0, 'approved', '', '', '', NULL, NULL, '2025-02-07 17:09:52', NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `patientfileno2`
--

CREATE TABLE `patientfileno2` (
  `id` int(11) NOT NULL DEFAULT 0,
  `facilityId` varchar(50) DEFAULT NULL,
  `accountNo` int(7) DEFAULT NULL,
  `accName` varchar(50) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `accountType` varchar(50) DEFAULT NULL,
  `contactName` varchar(100) DEFAULT NULL,
  `contactAddress` varchar(500) DEFAULT NULL,
  `contactPhone` varchar(20) DEFAULT NULL,
  `contactEmail` varchar(50) DEFAULT NULL,
  `contactWebsite` varchar(50) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `surname` varchar(50) DEFAULT NULL,
  `beneficiaries` bigint(21) NOT NULL DEFAULT 0,
  `balance` int(11) NOT NULL DEFAULT 0,
  `status` varchar(50) NOT NULL DEFAULT 'pending',
  `guarantor_name` varchar(50) DEFAULT NULL,
  `guarantor_address` varchar(100) DEFAULT NULL,
  `guarantor_phone` varchar(20) DEFAULT NULL,
  `created_by` varchar(50) DEFAULT NULL,
  `approved_by` varchar(50) DEFAULT NULL,
  `createdAt` timestamp NULL DEFAULT current_timestamp(),
  `approved_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `patientfileno2`
--

INSERT INTO `patientfileno2` (`id`, `facilityId`, `accountNo`, `accName`, `description`, `accountType`, `contactName`, `contactAddress`, `contactPhone`, `contactEmail`, `contactWebsite`, `firstname`, `surname`, `beneficiaries`, `balance`, `status`, `guarantor_name`, `guarantor_address`, `guarantor_phone`, `created_by`, `approved_by`, `createdAt`, `approved_at`) VALUES
(1, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 238, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Abba', 'Sulaiman', 2, 0, 'pending', NULL, NULL, NULL, NULL, NULL, '2019-12-19 07:29:26', NULL),
(8237, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 4678, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Salisu', 'Sani', 1, 0, 'pending', NULL, NULL, NULL, NULL, NULL, '2020-12-03 05:33:53', NULL);

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

--
-- Stand-in structure for view `patientfileno_full`
-- (See below for the actual view)
--
CREATE TABLE `patientfileno_full` (
`id` int(1)
,`acc_count` int(1)
,`accountNo` int(1)
,`beneficiaries` int(1)
,`firstname` int(1)
,`surname` int(1)
,`status` int(1)
,`createdAt` int(1)
,`accName` int(1)
,`description` int(1)
,`accountType` int(1)
,`contactName` int(1)
,`contactAddress` int(1)
,`contactPhone` int(1)
,`contactEmail` int(1)
,`contactWebsite` int(1)
,`balance` int(1)
,`guarantor_name` int(1)
,`guarantor_address` int(1)
,`guarantor_phone` int(1)
,`created_by` int(1)
,`approved_by` int(1)
,`approved_at` int(1)
);

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

--
-- Table structure for table `patientfileno_test`
--

CREATE TABLE `patientfileno_test` (
  `id` int(11) NOT NULL DEFAULT 0,
  `acc_count` bigint(21) NOT NULL DEFAULT 0,
  `accountNo` int(7) DEFAULT NULL,
  `beneficiaries` bigint(21) NOT NULL DEFAULT 0,
  `firstname` varchar(50) DEFAULT NULL,
  `surname` varchar(50) DEFAULT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'pending',
  `createdAt` timestamp NULL DEFAULT NULL,
  `accName` varchar(50) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `accountType` varchar(50) DEFAULT NULL,
  `contactName` varchar(100) DEFAULT NULL,
  `contactAddress` varchar(500) DEFAULT NULL,
  `contactPhone` varchar(20) DEFAULT NULL,
  `contactEmail` varchar(50) DEFAULT NULL,
  `contactWebsite` varchar(50) DEFAULT NULL,
  `balance` int(11) NOT NULL DEFAULT 0,
  `guarantor_name` varchar(50) DEFAULT NULL,
  `guarantor_address` varchar(100) DEFAULT NULL,
  `guarantor_phone` varchar(20) DEFAULT NULL,
  `created_by` varchar(50) DEFAULT NULL,
  `approved_by` varchar(50) DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `patientfileno_test`
--

INSERT INTO `patientfileno_test` (`id`, `acc_count`, `accountNo`, `beneficiaries`, `firstname`, `surname`, `status`, `createdAt`, `accName`, `description`, `accountType`, `contactName`, `contactAddress`, `contactPhone`, `contactEmail`, `contactWebsite`, `balance`, `guarantor_name`, `guarantor_address`, `guarantor_phone`, `created_by`, `approved_by`, `approved_at`) VALUES
(7563, 1, 1, 1, 'Hauwa', 'Musbahu', 'pending', '2020-12-03 05:33:53', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
(8237, 1, 4678, 1, 'Salisu', 'Sani', 'pending', '2020-12-03 05:33:53', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `patientrecords`
--

CREATE TABLE `patientrecords` (
  `facilityId` varchar(50) NOT NULL,
  `title` varchar(10) DEFAULT NULL,
  `accountType` varchar(50) DEFAULT NULL,
  `surname` varchar(50) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `other` varchar(50) DEFAULT NULL,
  `Gender` varchar(10) DEFAULT NULL,
  `age` int(3) DEFAULT 0,
  `maritalstatus` varchar(20) DEFAULT '0',
  `DOB` varchar(20) DEFAULT NULL,
  `dateCreated` varchar(50) DEFAULT NULL,
  `phoneNo` varchar(30) DEFAULT '',
  `email` varchar(50) DEFAULT '',
  `state` varchar(50) DEFAULT '',
  `lga` varchar(50) DEFAULT '',
  `occupation` varchar(50) DEFAULT '',
  `address` varchar(500) DEFAULT '',
  `kinName` varchar(100) DEFAULT '',
  `kinRelationship` varchar(20) DEFAULT '',
  `kinPhone` varchar(30) DEFAULT '0',
  `kinEmail` varchar(50) DEFAULT '0',
  `kinAddress` varchar(500) DEFAULT '0',
  `accountNo` int(7) DEFAULT NULL,
  `beneficiaryNo` int(3) DEFAULT NULL,
  `balance` int(11) DEFAULT 0,
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `patient_id` int(11) NOT NULL,
  `enteredBy` varchar(20) DEFAULT NULL,
  `patientStatus` varchar(50) DEFAULT NULL,
  `assigned_to` varchar(20) DEFAULT NULL,
  `createdAt` varchar(20) DEFAULT NULL,
  `date_assigned` datetime DEFAULT NULL,
  `status` varchar(50) DEFAULT 'registered',
  `hematology` varchar(20) DEFAULT NULL,
  `microbiology` varchar(20) DEFAULT NULL,
  `chem_path` varchar(20) DEFAULT NULL,
  `radiology` varchar(20) DEFAULT NULL,
  `seen_by` varchar(50) DEFAULT NULL,
  `date_seen` datetime DEFAULT NULL,
  `patient_passport` varchar(100) DEFAULT NULL,
  `enrollee_no` varchar(50) DEFAULT NULL,
  `insurance_scheme` varchar(50) DEFAULT NULL,
  `hmo` varchar(50) DEFAULT NULL,
  `organization` varchar(200) DEFAULT NULL,
  `cardno` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `patientrecords`
--

INSERT INTO `patientrecords` (`facilityId`, `title`, `accountType`, `surname`, `firstname`, `other`, `Gender`, `age`, `maritalstatus`, `DOB`, `dateCreated`, `phoneNo`, `email`, `state`, `lga`, `occupation`, `address`, `kinName`, `kinRelationship`, `kinPhone`, `kinEmail`, `kinAddress`, `accountNo`, `beneficiaryNo`, `balance`, `id`, `patient_id`, `enteredBy`, `patientStatus`, `assigned_to`, `createdAt`, `date_assigned`, `status`, `hematology`, `microbiology`, `chem_path`, `radiology`, `seen_by`, `date_seen`, `patient_passport`, `enrollee_no`, `insurance_scheme`, `hmo`, `organization`, `cardno`) VALUES
('052100000000', '', 'Single', 'Hh', 'Aa', '', 'Male', 0, 'Single', '2009-02-06', '2025-02-06', '09012340987', '', '', '', 'Driver', '', 'Kano', 'Kan', '09032413453', '', '', 1, 2, 0, '1-2', 42, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Othernam', 'Joj', '', 'Male', 0, 'Married', '2001-02-07', '2025-02-07', '09023231122', '', '', '', 'Dsaf', '', '', '', '', '', '', 10, 1, 0, '10-1', 51, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Testig', 'Otne', '', 'Male', 0, 'Single', '2002-02-07', '2025-02-07', '00023', '', '', '', '23', '', '', '', '', '', '', 11, 1, 0, '11-1', 52, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Ofeliya', 'Samson', '', 'Male', 0, 'Married', '2021-02-07', '2025-02-07', '232', '', '', '', '23', '', '', '', '', '', '', 12, 1, 0, '12-1', 53, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Olayemi', 'Mathew', '', 'Male', 0, 'Married', '1975-02-07', '2025-02-07', '09023232322', '', '', '', 'Math teacher', '', '', '', '', '', '', 13, 1, 0, '13-1', 57, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Sule', 'Lamido', '', 'Male', 0, 'Married', '1981-02-07', '2025-02-07', '09013', '', '', '', 'Mother', '', '', '', '', '', '', 14, 1, 0, '14-1', 58, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Yahaya', 'Musa', '', 'Male', 0, 'Divorce', '1970-02-07', '2025-02-07', '09023239433', '', '', '', 'Father', '', '', '', '', '', '', 15, 1, 0, '15-1', 59, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Cvc', 'Yge', '', 'Male', 0, 'Single', '1961-02-07', '2025-02-07', '12345678', '', '', '', 'Popo', '', '', '', '', '', '', 16, 1, 0, '16-1', 60, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Maryam', 'Musa', '', 'Male', 0, 'Single', '2020-02-07', '2025-02-07', '090121212221', '', '', '', 'N/A', '', '', '', '', '', '', 17, 1, 0, '17-1', 61, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Isa', 'Musa', '', 'Male', 0, 'Single', '2019-02-07', '2025-02-07', '090123455667', '', '', '', '', '', '', '', '', '', '', 18, 1, 0, '18-1', 62, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'ASDASD', 'SFASD', '', 'Male', 0, 'Married', '2021-02-07', '2025-02-07', '0903434', '', '', '', 'SDF', '', '', '', '', '', '', 19, 1, 0, '19-1', 63, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Anjali', 'Sharma', '', 'Female', 0, 'Single', '1992-02-06', '2025-02-06', '09012121212', '', '', '', 'Teacher', '', '', '', '', '', '', 2, 2, 0, '2-2', 43, NULL, NULL, NULL, NULL, '2025-02-06 23:23:21', 'waiting_pending', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Rahul', 'Nolove', '', 'Male', 0, 'Married', '1945-02-06', '2025-02-06', '090', '', '', '', '', '', '', '', '', '', '', 3, 2, 0, '3-2', 44, NULL, NULL, NULL, NULL, '2025-02-07 01:33:50', 'waiting_pending', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Alim', 'Capital', '', 'Male', 0, 'Single', '1992-02-06', '2025-02-06', '2323', '', '', '', '23', '', '', '', '', '', '', 4, 1, 0, '4-1', 45, NULL, NULL, NULL, NULL, '2025-02-06 23:17:58', 'waiting_pending', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Salla', 'Dallam', '', 'Male', 0, 'Single', '1992-02-06', '2025-02-06', '09038420099', '', '', '', 'Son', '', '', '', '', '', '', 5, 1, 0, '5-1', 46, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Some name of pat', 'Oher', '', 'Male', 0, 'Single', '1949-02-07', '2025-02-07', '09000990099', '', '', '', 'Pao', '', '', '', '', '', '', 6, 1, 0, '6-1', 47, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Testing ', 'Fullname', '', 'Female', 0, 'Single', '1992-02-07', '2025-02-07', '09023231122', '', '', '', 'Son', '', '', '', '', '', '', 7, 1, 0, '7-1', 48, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'Other', 'Makale', '', 'Female', 0, 'Married', '1993-02-07', '2025-02-07', '0902323', '', '', '', 'Other', '', '', '', '', '', '', 8, 1, 0, '8-1', 49, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', 'Single', 'New', 'Normal', '', 'Female', 0, 'Married', '2021-02-07', '2025-02-07', '09340304', '', '', '', '34', '', '', '', '', '', '', 9, 1, 0, '9-1', 50, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000000', '', '', 'Test', 'Patient', NULL, 'Male', 0, 'Divorce', '', '2025-02-08', '0902345678', '', '', '', 'Teacher', 'KL', 'TYu', 'Father', '0908765', '', 'Kano', 7865, 0, 0, 'NAS-0001', 65, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', ''),
('052100000000', '', '', 'Muhammad', 'OIsmla', NULL, 'Female', 0, 'Single', '', '2025-02-09', '0934034213', '', '', '', '4rer', '', '', '', '', '', '', 2, 0, 0, 'NAS-0002', 66, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', ''),
('052100000000', '', '', 'Sadik', 'Nai', NULL, 'Male', 0, 'Married', '', '2025-02-09', '0903424323', '', '', '', '', 'Kano', 'simeine', 'father', '09034342', '', 'kano', 3, 0, 0, 'NAS-0003', 67, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', ''),
('052100000000', '', '', 'Musa', 'Gabriel', NULL, 'Male', 0, 'Married', '', '2025-02-10', '09203', '', '', '', '', 'Kano', 'Mther', '', '000', '', '', 4, 0, 0, 'NAS-0004', 68, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123456', 'NHIS', '', '', '034'),
('052100000000', '', '', 'Yusuf', 'Maitama', NULL, 'Male', 0, 'Single', '', '2025-02-10', '090232323', '', '', '', 'other', '', '', '', '', '', '', 5, 0, 0, 'NAS-0005', 69, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '-- Choose --', '', '', ''),
('052100000000', '', '', 'Solape', 'Olalere', NULL, 'Male', 0, 'Single', '', '2025-02-10', '09023232323', '', '', '', 'Teacher', 'Kano', 'Kabir', 'Father', '090', '', 'Kano', 6, 0, 0, 'NAS-0006', 70, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', ''),
('052100000000', '', '', 'Ngozi ', 'Emmanuel', NULL, 'Male', 0, 'Single', '', '2025-02-10', '09023232323', '', '', '', 'Tailor', '', '', '', '', '', '', 7, 0, 0, 'NAS-0007', 71, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', ''),
('052100000000', '', '', 'Self A', 'Accounting', NULL, 'Male', 0, '', '', '2025-02-10', 'XCVP              ', '', '', '', '', '', '', '', '', '', '', 8, 0, 0, 'NAS-0008', 72, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', ''),
('052100000000', '', '', 'Doe', 'John', NULL, 'Male', 0, 'Married', '', '2025-02-10', '23', '', '', '', '232', 'Kano', '', '', '', '', '', 9, 0, 0, 'NAS-0009', 73, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '12345', 'NHIS', '', '', ''),
('052100000000', '', '', 'Pamalesh', 'Mandela', NULL, 'Male', 0, 'Single', '', '2025-02-10', '09023232311', '', '', '', 'Teacher', 'Kano', 'Murtala', 'Enemy', '419', '', 'Sambisa', 10, 0, 0, 'NAS-0010', 74, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '984'),
('052100000000', '', '', 'Musa', 'Accountant', NULL, 'Male', 0, 'Single', '', '2025-02-13', '9023122312', '', '', '', 'Driver', 'Kano', 'Father', '', '', '', '', 11, 0, 0, 'NAS-0011', 75, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '4343'),
('052100000000', '', '', '', '', NULL, '', 0, '', '', '2025-02-16', '', '', '', '', '', '', '', '', '', '', '', 12, 0, 0, 'NAS-0012', 79, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', ''),
('052100000000', '', '', '', '', NULL, '', 0, '', '', '2025-02-16', '', '', '', '', '', '', '', '', '', '', '', 13, 0, 0, 'NAS-0013', 80, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', ''),
('052100000000', '', '', '', '', NULL, '', 0, '', '', '2025-02-16', '', '', '', '', '', '', '', '', '', '', '', 14, 0, 0, 'NAS-0014', 81, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', ''),
('052100000000', '', '', 'Tijjani', 'Pharmacy', NULL, 'Male', 0, 'Married', '', '2025-02-16', '09012121212', '', '', '', '12', '', '', '', '', '', '', 15, 0, 0, 'NAS-0015', 82, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', ''),
('052100000000', '', '', 'Tijjani', 'Muhammad', NULL, 'Male', 0, 'Single', '', '2025-02-16', '09017901953', '', '', '', 'Tacher', '', '', '', '', '', '', 16, 0, 0, 'NAS-0016', 83, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '7984'),
('052100000000', '', '', 'sadiq', 'sadiq', NULL, '', 0, 'Married', '', '2025-02-16', '09032151519', '', '', '', '', 'kano', 'sadiqsadiq', 'dad', 'sadiq', '', 'kano', 17, 0, 0, 'NAS-0017', 84, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '33223'),
('052100000000', '', '', 'frank', 'frank', NULL, 'Male', 0, 'Married', '', '2025-02-16', '09067676767', '', '', '', 'developer', 'kano', 'umar', 'dad', '09078787868', '', 'umar', 18, 0, 0, 'NAS-0018', 85, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '4343'),
('052100000000', '', '', 'sad', 'sad', NULL, 'Male', 0, 'Married', '', '2025-02-16', '', '', '', '', 'deleloper', '', '', '', '', '', '', 19, 0, 0, 'NAS-0019', 86, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '009'),
('052100000000', '', '', 'usman', 'usman', NULL, 'Male', 0, 'Married', '', '2025-02-16', '09088823323', '', '', '', 'developer', 'kano', 'usman', 'dad', '090323223777', '', 'kano', 20, 0, 0, 'NAS-0020', 87, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '4343'),
('052100000000', '', '', 'Musa', 'Dangana', NULL, 'Male', 0, 'Married', '', '2025-02-16', '09023231212', '', '', '', 'Teacher', 'Kano', 'Musa Isah', 'Brother', '09023233434', '', 'Kano', 21, 0, 0, 'NAS-0021', 88, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', ''),
('052100000001', '', 'Single', 'Murtala', 'Akinyemi', '', 'Male', 0, 'Married', '1965-02-07', '2025-02-07', '09012345678', '', '', '', 'Teacher', '', '', '', '', '', '', 1, 3, 0, '1-3', 54, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('052100000003', '', '', 'Tijjani', 'Muhammad', NULL, 'Male', 0, 'Single', '', '2025-02-15', '09017901953', '', '', '', '12', '1F Airport road, Kano', '', '', '', '', '', 1, 0, 0, 'SMB-0001', 76, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '12'),
('052100000003', '', '', '', '', NULL, '', 0, '', '', '2025-02-16', '', '', '', '', '', '', '', '', '', '', '', 2, 0, 0, 'SMB-0002', 77, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', ''),
('052100000003', '', '', '', '', NULL, '', 0, '', '', '2025-02-16', '', '', '', '', '', '', '', '', '', '', '', 3, 0, 0, 'SMB-0003', 78, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', ''),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 'Single', 'Sadiq', 'Haruna', '', 'Male', 0, 'Married', '2024-12-26', '2025-02-03', '07032151593', 'Harunakadiri702@gmail.com', '', '', 'Director', 'Kano naibawa', '', '', '', '', '', 1, 1, 0, '1-1', 39, NULL, NULL, 'Hassan', NULL, '2025-02-03 13:14:31', 'waiting_pending', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 'Single', 'Sss', 'Sss', '', 'Male', 0, 'Married', '2025-01-24', '2025-02-05', '07032151593', 'Harunakadiri702@gmail.com', '', '', 'Developer', 'Kano naibawa', '', '', '', '', '', 2, 1, 0, '2-1', 40, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 'Single', 'RT', 'RT', '', 'Male', 0, 'Married', '2025-01-04', '2025-02-05', '07032151593', 'Harunakadiri702@gmail.com', '', '', 'Director', 'Kano naibawa', '', '', '', '', '', 3, 1, 0, '3-1', 41, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 'Single', 'Saddiku', 'Mola', '', 'Male', 0, 'Single', '1975-02-07', '2025-02-07', '09012121212', '', '', '', '', '', '', '', '', '', '', 4, 2, 0, '4-2', 55, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 'Single', 'Sdfsadf', 'Dasf', '', 'Male', 0, 'Single', '1991-02-07', '2025-02-07', '090', '', '', '', 'Sf', '', '', '', '', '', '', 5, 2, 0, '5-2', 56, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, 'undefined', '', 'undefined', 'undefined', 'undefined', ''),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', '', 'Isa', 'musa', NULL, 'Male', 0, 'Married', '', '2025-02-08', '09042145213', '', '', '', 'Teacher', 'Kano', 'Kin', 'Father', '1243', '', 'Kano', 43, 0, 0, 'PSC-0001', 64, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '');

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

--
-- Table structure for table `patientrecords_bkp`
--

CREATE TABLE `patientrecords_bkp` (
  `facilityId` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `title` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `accountType` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `surname` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `firstname` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `other` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `Gender` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `age` int(3) DEFAULT 0,
  `maritalstatus` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `DOB` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `dateCreated` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `phoneNo` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `email` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `state` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `lga` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `occupation` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `address` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `kinName` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `kinRelationship` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `kinPhone` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `kinEmail` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `kinAddress` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `accountNo` int(7) DEFAULT NULL,
  `beneficiaryNo` int(3) DEFAULT NULL,
  `balance` int(11) DEFAULT 0,
  `id` varchar(10) NOT NULL,
  `patient_id` int(11) NOT NULL DEFAULT 0,
  `enteredBy` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `patientStatus` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `assigned_to` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `createdAt` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `date_assigned` datetime DEFAULT NULL,
  `status` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'registered',
  `hematology` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `microbiology` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `chem_path` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `radiology` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `seen_by` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `date_seen` datetime DEFAULT NULL,
  `patient_passport` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Stand-in structure for view `patient_bed`
-- (See below for the actual view)
--
CREATE TABLE `patient_bed` (
`allocation_id` int(1)
,`bed_id` int(1)
,`allocated` int(1)
,`allocated_by` int(1)
,`allocation_status` int(1)
,`patient_name` int(1)
,`patient_id` int(1)
,`accountNo` int(1)
,`facilityId` int(1)
);

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

--
-- Table structure for table `patient_history`
--

CREATE TABLE `patient_history` (
  `id` int(11) NOT NULL,
  `patient_id` varchar(50) NOT NULL,
  `request_id` int(11) NOT NULL,
  `history` varchar(1000) NOT NULL,
  `file` varchar(200) NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `facilityId` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `patient_history`
--

INSERT INTO `patient_history` (`id`, `patient_id`, `request_id`, `history`, `file`, `createdAt`, `facilityId`) VALUES
(0, '1-1', 2147483647, '', '', '2024-08-10 14:04:39', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a');

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

--
-- Table structure for table `pending_lab_txn`
--

CREATE TABLE `pending_lab_txn` (
  `account` int(11) NOT NULL,
  `description` varchar(100) NOT NULL,
  `group_head` varchar(20) NOT NULL,
  `price` int(11) NOT NULL,
  `test` varchar(50) NOT NULL,
  `request_id` varchar(50) NOT NULL,
  `status` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pending_lab_txn`
--

INSERT INTO `pending_lab_txn` (`account`, `description`, `group_head`, `price`, `test`, `request_id`, `status`) VALUES
(20001, 'Full Blood Count', '2021', 2200, '2021', 'a8c6aa2e-98cc-411f-a202-82dcf9ea430a', 'pending'),
(20002, 'URINE ELECTROLYTE', '0', 3000, '30088', 'a8c6aa2e-98cc-411f-a202-82dcf9ea430a', 'pending'),
(20003, 'HBs Ag', '0', 1400, '4012', 'a8c6aa2e-98cc-411f-a202-82dcf9ea430a', 'pending'),
(20003, 'HIV Viral Load', '0', 25000, '4014', 'a8c6aa2e-98cc-411f-a202-82dcf9ea430a', 'pending'),
(20002, 'RPG/RBS', '0', 800, '30072', 'a8c6aa2e-98cc-411f-a202-82dcf9ea430a', 'pending'),
(20001, 'Clothing Profile', '2019', 5000, '2019', 'a8c6aa2e-98cc-411f-a202-82dcf9ea430a', 'pending'),
(20003, 'HCV Ab', '0', 1400, '4013', 'a8c6aa2e-98cc-411f-a202-82dcf9ea430a', 'pending'),
(20001, 'Full Blood Count', '2021', 2200, '2021', '7670d011-e56b-48c6-a79e-1ca55a00f7f0', 'pending'),
(20002, 'Urea, Electrolyte & Creatinine', '30095', 3000, '30095', '7670d011-e56b-48c6-a79e-1ca55a00f7f0', 'pending'),
(20002, 'PSA', '0', 5500, '30066', '7670d011-e56b-48c6-a79e-1ca55a00f7f0', 'pending'),
(20003, 'MALARIA PARASITES', '0', 700, '4020', '7670d011-e56b-48c6-a79e-1ca55a00f7f0', 'pending'),
(20001, 'ESR', '0', 1200, '2009', '7670d011-e56b-48c6-a79e-1ca55a00f7f0', 'pending'),
(20002, 'RPG/RBS', '0', 800, '30072', '7670d011-e56b-48c6-a79e-1ca55a00f7f0', 'pending'),
(20002, 'Calcium', '0', 800, '30027', 'ce88aea7-a50b-40a1-9394-224a0b9f28c8', 'pending'),
(20002, 'Uric Acid', '0', 1000, '30092', 'ce88aea7-a50b-40a1-9394-224a0b9f28c8', 'pending'),
(20001, 'PCV', '0', 700, '2001', 'b809144a-6a30-40da-922e-3326bd1987da', 'pending'),
(20002, 'Urea, Electrolyte & Creatinine', '30095', 3000, '30095', '1329b5ea-7af9-41ea-8110-fc045495447e', 'pending'),
(20001, 'Full Blood Count', '2021', 2200, '2021', '1329b5ea-7af9-41ea-8110-fc045495447e', 'pending'),
(20003, 'Urinalysis', '0', 700, '4038', '1329b5ea-7af9-41ea-8110-fc045495447e', 'pending'),
(20002, 'Lipids Profile.', '30096', 3300, '30096', '1329b5ea-7af9-41ea-8110-fc045495447e', 'pending'),
(20002, 'Uric Acid', '0', 1000, '30092', '1329b5ea-7af9-41ea-8110-fc045495447e', 'pending'),
(20002, 'Albumin', '0', 1000, '300978', '1329b5ea-7af9-41ea-8110-fc045495447e', 'pending'),
(20002, 'Inorganic Phosphorus', '0', 700, '30048', '1329b5ea-7af9-41ea-8110-fc045495447e', 'pending'),
(20002, 'Calcium', '0', 800, '30027', '1329b5ea-7af9-41ea-8110-fc045495447e', 'pending'),
(20001, 'Full Blood Count', '2021', 2200, '2021', '8a68022f-7d36-4f03-bb9d-eab160b1216c', 'pending'),
(20002, 'Urea, Electrolyte & Creatinine', '30095', 3000, '30095', '8a68022f-7d36-4f03-bb9d-eab160b1216c', 'pending'),
(20003, 'MALARIA PARASITES', '0', 700, '4020', '8a68022f-7d36-4f03-bb9d-eab160b1216c', 'pending'),
(20003, 'Urinalysis', '0', 700, '4038', '8a68022f-7d36-4f03-bb9d-eab160b1216c', 'pending'),
(20001, 'ESR', '0', 1200, '2009', '8a68022f-7d36-4f03-bb9d-eab160b1216c', 'pending'),
(20002, 'Calcium', '0', 800, '30027', '8a68022f-7d36-4f03-bb9d-eab160b1216c', 'pending'),
(20003, 'Urine M/C/S', '0', 3000, '4039', '8a68022f-7d36-4f03-bb9d-eab160b1216c', 'pending'),
(20001, 'Full Blood Count', '2021', 2200, '2021', '56cfeb9b-bb3c-492b-995e-bb8c7bff65ca', 'pending'),
(20002, 'Urea, Electrolyte & Creatinine', '30095', 3000, '30095', '56cfeb9b-bb3c-492b-995e-bb8c7bff65ca', 'pending'),
(20003, 'MALARIA PARASITES', '0', 700, '4020', '56cfeb9b-bb3c-492b-995e-bb8c7bff65ca', 'pending'),
(20003, 'Urinalysis', '0', 700, '4038', '56cfeb9b-bb3c-492b-995e-bb8c7bff65ca', 'pending'),
(20001, 'Full Blood Count', '2021', 2200, '2021', '76850440-5608-4719-8ba2-5a20453193ce', 'pending'),
(20003, 'MALARIA PARASITES', '0', 700, '4020', '76850440-5608-4719-8ba2-5a20453193ce', 'pending'),
(20001, 'ESR', '0', 1200, '2009', '76850440-5608-4719-8ba2-5a20453193ce', 'pending'),
(20002, 'Calcium', '0', 800, '30027', '8d60223a-3336-495a-a36b-e35d1b904b8c', 'pending'),
(20003, 'Urinalysis', '0', 700, '4038', '63a3fd64-7aa3-4b8e-a9ad-278a3dd9a35e', 'pending'),
(20003, 'Urine M/C/S', '0', 3000, '4039', '63a3fd64-7aa3-4b8e-a9ad-278a3dd9a35e', 'pending'),
(20002, 'Calcium', '0', 800, '30027', '63a3fd64-7aa3-4b8e-a9ad-278a3dd9a35e', 'pending'),
(20002, 'C - REACTIVE PROTEIN (CRP)', '0', 6000, '3001007', '63a3fd64-7aa3-4b8e-a9ad-278a3dd9a35e', 'pending');

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

--
-- Table structure for table `pending_txn`
--

CREATE TABLE `pending_txn` (
  `id` int(11) NOT NULL,
  `transaction_id` varchar(50) DEFAULT NULL,
  `description` varchar(200) NOT NULL,
  `head` varchar(10) NOT NULL,
  `subhead` varchar(10) NOT NULL,
  `amount` int(11) NOT NULL,
  `service_type` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `patient_name` varchar(150) NOT NULL,
  `patient_id` varchar(50) NOT NULL,
  `patient_type` varchar(50) NOT NULL,
  `total_amount` int(11) NOT NULL,
  `client_acc` varchar(45) NOT NULL DEFAULT 'pending',
  `tx_status` varchar(45) NOT NULL DEFAULT 'pending',
  `facilityId` varchar(50) NOT NULL,
  `created_by` varchar(50) NOT NULL,
  `updated_by` varchar(50) DEFAULT NULL,
  `transaction_date` datetime DEFAULT NULL,
  `igr_amount` int(11) DEFAULT NULL,
  `igr` varchar(50) DEFAULT NULL,
  `billing_unit` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pending_txn`
--

INSERT INTO `pending_txn` (`id`, `transaction_id`, `description`, `head`, `subhead`, `amount`, `service_type`, `created_at`, `patient_name`, `patient_id`, `patient_type`, `total_amount`, `client_acc`, `tx_status`, `facilityId`, `created_by`, `updated_by`, `transaction_date`, `igr_amount`, `igr`, `billing_unit`) VALUES
(2, '202500026', 'Laboratory: Esr', '', '20000', 200, 'GENERAL', '2025-02-13 12:58:43', 'Muhammad OIsmla', 'NAS-0002', 'undefined', 0, 'NAS', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-13 01:00:00', 20, 'IGR', '6'),
(3, '202500026', 'Laboratory: Fbs', '', '20000', 300, 'GENERAL', '2025-02-13 12:58:43', 'Muhammad OIsmla', 'NAS-0002', 'undefined', 0, 'NAS', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-13 01:00:00', 30, 'IGR', '6'),
(4, '202500026', 'Laboratory: Bleeding Time', '', '20000', 300, 'GENERAL', '2025-02-13 12:58:43', 'Muhammad OIsmla', 'NAS-0002', 'undefined', 0, 'NAS', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-13 01:00:00', 30, 'IGR', '6'),
(5, '202500007', 'Phathology: Lft', '', '20000', 500, 'GENERAL', '2025-02-11 13:02:57', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-13 01:03:10', 50, 'IGR', '8'),
(6, '202500027', 'Phathology: Uric Acid', '', '20000', 300, 'GENERAL', '2025-02-13 13:02:57', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-13 01:03:10', 30, 'IGR', '8'),
(7, '202500027', 'Phathology: Fbs', '', '20000', 150, 'GENERAL', '2025-02-13 13:02:57', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-13 01:03:10', 15, 'IGR', '8'),
(8, '202500028', 'Laboratory: Prothrombin Time', '', '20000', 600, 'GENERAL', '2025-02-13 13:58:01', 'Sadik Nai', 'NAS-0003', 'undefined', 0, 'NAS', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-13 01:59:18', 60, 'IGR', '6'),
(9, '202500013', 'Laboratory: Lft', '', '20000', 51000, 'GENERAL', '2024-09-18 13:58:01', 'Sadik Nai', 'NAS-0003', 'undefined', 0, 'NAS', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2024-09-18 14:58:01', 50, 'IGR', '6'),
(10, '202500011', 'Digital X-Ray: Paranasal Sinus (Pns', '', '20000', 120000, 'GENERAL', '2024-11-13 13:58:01', 'Sadik Nai', 'NAS-0003', 'undefined', 0, 'NAS', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2024-11-13 14:58:01', 12000, 'NO IGR', '6'),
(11, '202500012', 'Laboratory: U/E/C', '', '20000', 600, 'GENERAL', '2025-02-09 13:58:01', 'Sadik Nai', 'NAS-0003', 'undefined', 0, 'NAS', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-09 14:58:01', 60, 'IGR', '6'),
(12, '202500028', 'Laboratory: Pttk', '', '20000', 600, 'GENERAL', '2025-02-13 13:58:01', 'Sadik Nai', 'NAS-0003', 'undefined', 0, 'NAS', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-13 01:59:18', 60, 'IGR', '6'),
(13, '202500008', 'Digital X-Ray: Skull Ap View', '', '20000', 240000, 'GENERAL', '2025-02-10 13:58:01', 'Sadik Nai', 'NAS-0003', 'undefined', 0, 'NAS', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-10 01:59:18', 24000, 'NO IGR', '6'),
(14, '202500009', 'Digital X-Ray: Both Mandibles (L) Oblqs', '', '20000', 120000, 'GENERAL', '2025-02-05 13:58:01', 'Sadik Nai', 'NAS-0003', 'undefined', 0, 'NAS', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-05 01:59:18', 12000, 'NO IGR', '6'),
(15, '202500010', 'Digital X-Ray: Right (R) S And M', '', '20000', 120000, 'GENERAL', '2024-12-17 13:58:01', 'Sadik Nai', 'NAS-0003', 'undefined', 0, 'NAS', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2024-12-17 14:58:01', 12000, 'NO IGR', '6'),
(16, '202500029', 'Ent: Tracheotomy', '', '20000', 20000, 'GENERAL', '2025-02-13 13:58:34', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-13 01:58:57', 2000, 'NO IGR', '8'),
(17, '202500029', 'Ent: Ramua Excision', '', '20000', 20000, 'GENERAL', '2025-02-13 13:58:34', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-13 01:58:57', 2000, 'NO IGR', '8'),
(18, '202500029', 'Ent: Nasal Polypectomy', '', '20000', 20000, 'GENERAL', '2025-02-13 13:58:34', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-13 01:58:57', 2000, 'NO IGR', '8'),
(19, '202500004', 'Laboratory: Pttk', '', '20000', 600, 'GENERAL', '2025-02-04 14:03:37', 'Anjali Sharma', '2-2', 'undefined', 0, '2', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-12 02:04:43', 60, 'IGR', '6'),
(20, '202500030', 'Laboratory: Clotting Time', '', '20000', 300, 'GENERAL', '2025-02-12 14:03:37', 'Anjali Sharma', '2-2', 'undefined', 0, '2', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-12 02:04:43', 30, 'IGR', '6'),
(21, '202500030', 'Laboratory: Bleeding Time', '', '20000', 300, 'GENERAL', '2025-02-12 14:03:37', 'Anjali Sharma', '2-2', 'undefined', 0, '2', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-12 02:04:43', 30, 'IGR', '6'),
(22, '202500030', 'Laboratory: Prothrombin Time', '', '20000', 600, 'GENERAL', '2025-02-12 14:03:37', 'Anjali Sharma', '2-2', 'undefined', 0, '2', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-12 02:04:43', 60, 'IGR', '6'),
(23, '202500031', 'Admission: Ordinary Room', '', '20000', 720000, 'GENERAL', '2025-02-11 14:06:06', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-11 15:06:06', 72000, 'NO IGR', '6'),
(24, '202500001', 'Admission: Double Room', '', '20000', 560000, 'GENERAL', '2025-02-01 14:06:06', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-01 02:06:42', 56000, 'NO IGR', '6'),
(25, '202500032', 'Laboratory: Fbs', '', '20000', 300, 'GENERAL', '2025-02-13 17:09:58', 'Ofeliya Samson', '12-1', 'undefined', 0, '12', 'Paid', '052100000000', 'neq', 'admin', '2025-02-14 06:54:09', 30, 'IGR', '11'),
(26, '202500032', 'Laboratory: Prothrombin Time', '', '20000', 600, 'GENERAL', '2025-02-13 17:09:58', 'Ofeliya Samson', '12-1', 'undefined', 0, '12', 'Paid', '052100000000', 'neq', 'admin', '2025-02-14 06:54:09', 60, 'IGR', '11'),
(27, '202500032', 'Laboratory: U/E/C', '', '20000', 600, 'GENERAL', '2025-02-13 17:09:58', 'Ofeliya Samson', '12-1', 'undefined', 0, '12', 'Paid', '052100000000', 'neq', 'admin', '2025-02-14 06:54:09', 60, 'IGR', '11'),
(28, '202500032', 'Digital X-Ray: Elbow Joint', '', '20000', 120000, 'GENERAL', '2025-02-13 17:09:58', 'Ofeliya Samson', '12-1', 'undefined', 0, '12', 'Paid', '052100000000', 'neq', 'admin', '2025-02-14 06:54:09', 12000, 'NO IGR', '11'),
(29, '202500032', 'Digital X-Ray: Humerus (Arm) Ap/L', '', '20000', 120000, 'GENERAL', '2025-02-13 17:09:58', 'Ofeliya Samson', '12-1', 'undefined', 0, '12', 'Paid', '052100000000', 'neq', 'admin', '2025-02-14 06:54:09', 12000, 'NO IGR', '11'),
(30, '202500033', 'Analog X-Ray: Both Mandibles (L) Oblqs', '', '20000', 200000, 'GENERAL', '2025-02-01 07:10:21', 'Ofeliya Samson', '12-1', 'undefined', 0, '12', 'Paid', '052100000000', 'admin', 'admin', '2025-02-01 07:11:44', 20000, 'NO IGR', '6'),
(31, '202500034', 'Analog X-Ray: Chest X-Ray Ap/Lat', '', '20000', 200000, 'GENERAL', '2025-02-02 07:10:58', 'Rahul Nolove', '3-2', 'undefined', 0, '3', 'Paid', '052100000000', 'admin', 'admin', '2025-02-02 07:11:39', 20000, 'NO IGR', '6'),
(32, '202500034', 'Analog X-Ray: Plain Abdomen', '', '20000', 100000, 'GENERAL', '2025-02-02 07:10:58', 'Rahul Nolove', '3-2', 'undefined', 0, '3', 'Paid', '052100000000', 'admin', 'admin', '2025-02-02 07:11:39', 10000, 'NO IGR', '6'),
(33, '202500035', 'Laboratory: Lipid Profile', '', '20000', 150000, 'GENERAL', '2025-02-03 07:13:39', 'Testig Otne', '11-1', 'undefined', 0, '11', 'Paid', '052100000000', 'admin', 'admin', '2025-02-03 07:14:10', 15000, 'IGR', '6'),
(34, '202500035', 'Digital X-Ray: Femur (Thigh) Ap/Lat', '', '20000', 240000, 'GENERAL', '2025-02-03 07:13:39', 'Testig Otne', '11-1', 'undefined', 0, '11', 'Paid', '052100000000', 'admin', 'admin', '2025-02-03 07:14:10', 24000, 'NO IGR', '6'),
(35, '202500036', 'Laboratory: U/E/C', '', '20000', 600, 'GENERAL', '2025-02-14 10:45:33', 'Sule Lamido', '14-1', 'undefined', 0, '14', 'pending', '052100000000', 'nasarawa', '', NULL, 60, 'IGR', '6'),
(36, '202500036', 'Laboratory: Pttk', '', '20000', 600, 'GENERAL', '2025-02-14 10:45:33', 'Sule Lamido', '14-1', 'undefined', 0, '14', 'pending', '052100000000', 'nasarawa', '', NULL, 60, 'IGR', '6'),
(37, '202500037', 'FBC', '', '20000', 1000, 'GENERAL', '2025-02-15 14:09:09', 'undefined', 'undefined', 'undefined', 0, '1', 'Paid', '052100000003', 'card', 'card', '2025-02-15 02:39:41', 100, 'IGR', '12'),
(38, '202500037', 'Consultation', '', '20000', 10000, 'GENERAL', '2025-02-15 14:09:09', 'undefined', 'undefined', 'undefined', 0, '1', 'Paid', '052100000003', 'card', 'card', '2025-02-15 02:39:41', 1000, 'IGR', '12'),
(39, '202500037', 'Admission', '', '20000', 15000, 'GENERAL', '2025-02-15 14:09:09', 'undefined', 'undefined', 'undefined', 0, '1', 'Paid', '052100000003', 'card', 'card', '2025-02-15 02:39:41', 1500, 'IGR', '12'),
(40, '202500037', 'Registration', '', '20000', 1000, 'GENERAL', '2025-02-15 14:09:09', 'undefined', 'undefined', 'undefined', 0, '1', 'Paid', '052100000003', 'card', 'card', '2025-02-15 02:39:41', 100, 'IGR', '12'),
(41, '202500037', 'Eye surgery', '', '20000', 100000, 'GENERAL', '2025-02-15 14:09:09', 'undefined', 'undefined', 'undefined', 0, '1', 'Paid', '052100000003', 'card', 'card', '2025-02-15 02:39:41', 10000, 'IGR', '12'),
(42, '202500038', 'Consultation', '', '20000', 10000, 'GENERAL', '2025-02-15 14:39:23', 'Tijjani Muhammad', 'SMB-0001', 'undefined', 0, 'SMB', 'Paid', '052100000003', 'card', 'card', '2025-02-15 02:39:38', 1000, 'IGR', '12'),
(43, '202500038', 'Registration', '', '20000', 1000, 'GENERAL', '2025-02-15 14:39:23', 'Tijjani Muhammad', 'SMB-0001', 'undefined', 0, 'SMB', 'Paid', '052100000003', 'card', 'card', '2025-02-15 02:39:38', 100, 'IGR', '12'),
(44, '202500039', 'No IGR', '', '20000', 4000, 'GENERAL', '2025-02-15 15:57:51', 'Tijjani Muhammad', 'SMB-0001', 'undefined', 0, 'SMB', 'Paid', '052100000003', 'buhari', 'buhari', '2025-02-15 04:01:19', 0, 'NO IGR', ''),
(45, '202500039', 'FBC', '', '20000', 1000, 'GENERAL', '2025-02-15 15:57:51', 'Tijjani Muhammad', 'SMB-0001', 'undefined', 0, 'SMB', 'Paid', '052100000003', 'buhari', 'buhari', '2025-02-15 04:01:19', 100, 'IGR', ''),
(46, '202500040', 'No IGR', '', '20000', 20000, 'GENERAL', '2025-02-15 15:59:27', 'Tijjani Muhammad', 'SMB-0001', 'undefined', 0, 'SMB', 'Paid', '052100000003', 'buhari', 'buhari', '2025-02-15 04:01:21', 0, 'NO IGR', ''),
(47, '202500041', 'Registration', '', '20000', 1000, 'GENERAL', '2025-02-15 16:06:34', 'Tijjani Muhammad', 'SMB-0001', 'undefined', 0, 'SMB', 'Paid', '052100000003', 'lab', 'buhari', '2025-02-15 04:09:08', 100, 'IGR', '13'),
(48, '202500041', 'Admission', '', '20000', 15000, 'GENERAL', '2025-02-15 16:06:34', 'Tijjani Muhammad', 'SMB-0001', 'undefined', 0, 'SMB', 'Paid', '052100000003', 'lab', 'buhari', '2025-02-15 04:09:08', 1500, 'IGR', '13'),
(49, '202500041', 'No IGR', '', '20000', 16000, 'GENERAL', '2025-02-15 16:06:34', 'Tijjani Muhammad', 'SMB-0001', 'undefined', 0, 'SMB', 'Paid', '052100000003', 'lab', 'buhari', '2025-02-15 04:09:08', 0, 'NO IGR', '13'),
(50, '202500041', 'Eye surgery', '', '20000', 100000, 'GENERAL', '2025-02-15 16:06:34', 'Tijjani Muhammad', 'SMB-0001', 'undefined', 0, 'SMB', 'Paid', '052100000003', 'lab', 'buhari', '2025-02-15 04:09:08', 10000, 'IGR', '13'),
(51, 'Both Mandibles (L) Oblqs', 'Both Mandibles (L) Oblqs', 'MAWSH.55', '20000', 120000, 'LAB', '2025-02-16 11:30:17', 'undefined', 'undefined', 'undefined', 120000, 'undefined', 'pending', '052100000000', 'undefined', NULL, NULL, NULL, NULL, NULL),
(52, 'Cervico - Thoracic', 'Cervico - Thoracic', 'MAWSH.63', '20000', 240000, 'LAB', '2025-02-16 11:30:17', 'undefined', 'undefined', 'undefined', 240000, 'undefined', 'pending', '052100000000', 'undefined', NULL, NULL, NULL, NULL, NULL),
(53, '202500042', 'Pbs/Rbs', '', '20000', 800, 'GENERAL', '2025-02-16 12:31:27', 'Isa Musa', '18-1', 'undefined', 0, '18', 'pending', '052100000000', 'nasarawa', '', NULL, 80, 'IGR', '6'),
(54, 'Paranasal Sinus (Pns)', 'Paranasal Sinus (Pns)', 'MAWSH.111', '20000', 100000, 'LAB', '2025-02-16 11:32:19', 'undefined', 'undefined', 'undefined', 100000, 'undefined', 'pending', '052100000000', 'undefined', NULL, NULL, NULL, NULL, NULL),
(55, '202500043', 'Isoflurane', '100001', '20000', 900, 'PHARMACY', '2025-02-16 13:11:59', 'ASDASD SFASD', '19-1', 'undefined', 0, '1', 'pending', '052100000000', 'nasarawa', '', NULL, 0, '', ''),
(56, '202500044', 'Mp', '', '20000', 100, 'GENERAL', '2025-02-16 13:16:23', 'ASDASD SFASD', '19-1', 'undefined', 0, '19', 'pending', '052100000000', 'nasarawa', '', NULL, 10, 'IGR', '6'),
(57, '202500044', 'Pcv', '', '20000', 100, 'GENERAL', '2025-02-16 13:16:23', 'ASDASD SFASD', '19-1', 'undefined', 0, '19', 'pending', '052100000000', 'nasarawa', '', NULL, 10, 'IGR', '6'),
(58, '202500044', 'Esr', '', '20000', 200, 'GENERAL', '2025-02-16 13:16:23', 'ASDASD SFASD', '19-1', 'undefined', 0, '19', 'pending', '052100000000', 'nasarawa', '', NULL, 20, 'IGR', '6'),
(59, '202500045', 'Flagyl 150mg', '100001', '20000', 600, 'PHARMACY', '2025-02-16 13:20:46', 'Sule Lamido', '14-1', 'undefined', 0, '1', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-16 01:21:22', 0, '', ''),
(60, '202500045', 'neostgimin iv', '100001', '20000', 2700, 'PHARMACY', '2025-02-16 13:20:46', 'Sule Lamido', '14-1', 'undefined', 0, '1', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-16 01:21:22', 0, '', ''),
(61, '202500045', 'Isoflurane', '100001', '20000', 1800, 'PHARMACY', '2025-02-16 13:20:46', 'Sule Lamido', '14-1', 'undefined', 0, '1', 'Paid', '052100000000', 'nasarawa', 'nasarawa', '2025-02-16 01:21:22', 0, '', ''),
(62, '202500046', 'Isoflurane', '100001', '20000', 900, 'PHARMACY', '2025-02-16 15:44:34', 'Musa Dangana', 'NAS-0021', 'undefined', 0, '1', 'pending', '052100000000', 'nasarawa', '', NULL, 0, '', '');

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

--
-- Table structure for table `pending_txn2`
--

CREATE TABLE `pending_txn2` (
  `id` int(11) NOT NULL DEFAULT 0,
  `transaction_id` varchar(50) DEFAULT NULL,
  `description` varchar(200) NOT NULL,
  `head` varchar(10) NOT NULL,
  `subhead` varchar(10) NOT NULL,
  `amount` int(11) NOT NULL,
  `service_type` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `patient_name` varchar(150) NOT NULL,
  `patient_id` varchar(50) NOT NULL,
  `patient_type` varchar(50) NOT NULL,
  `total_amount` int(11) NOT NULL,
  `client_acc` varchar(45) NOT NULL DEFAULT 'pending',
  `tx_status` varchar(45) NOT NULL DEFAULT 'pending',
  `facilityId` varchar(50) NOT NULL,
  `created_by` varchar(50) NOT NULL,
  `updated_by` varchar(50) DEFAULT NULL,
  `transaction_date` datetime DEFAULT NULL,
  `igr_amount` int(11) DEFAULT NULL,
  `igr` varchar(50) DEFAULT NULL,
  `billing_unit` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pending_txn2`
--

INSERT INTO `pending_txn2` (`id`, `transaction_id`, `description`, `head`, `subhead`, `amount`, `service_type`, `created_at`, `patient_name`, `patient_id`, `patient_type`, `total_amount`, `client_acc`, `tx_status`, `facilityId`, `created_by`, `updated_by`, `transaction_date`, `igr_amount`, `igr`, `billing_unit`) VALUES
(4, '20250206112631', 'Laboratory: Clotting Time', 'MAWSH.8', '20000', 300, 'REGISTRATION', '2025-02-06 23:26:31', 'Dallam Salla', '5-1', 'Single', 0, '5', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 30, 'IGR', '6'),
(12, '25020700904', 'Isoflurane', '100001', '100000', 1800, 'PHARMACY', '2025-02-07 00:09:04', 'Rahul Nolove', '3-2', 'Single', 0, '3', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 180, 'IGR', '10'),
(13, '20250207122321', 'Laboratory: Skin Snif', 'MAWSH.25', '20000', 800, 'CONSULTATION', '2025-02-07 00:23:21', 'Anjali Sharma', '2-2', 'Single', 0, '2', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 80, 'IGR', '6'),
(15, '20250207011140', 'Laboratory: Pttk', 'MAWSH.6', '20000', 600, 'REGISTRATION', '2025-02-07 01:11:40', 'Oher Some name of pat', '6-1', 'Single', 0, '6', 'pending', '052100000000', '', '', '2025-01-13 15:35:24', 60, 'IGR', '6'),
(16, '20250207012241', 'Laboratory: Pttk', 'MAWSH.6', '20000', 600, 'GENERAL', '2025-02-07 01:22:41', 'undefined', '2-2', 'undefined', 0, '2', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 60, 'IGR', '6'),
(17, '20250207022029', 'Laboratory: Lft', 'MAWSH.10', '20000', 500, 'GENERAL', '2025-02-07 02:20:29', 'undefined', '5-1', 'undefined', 0, '5', 'pending', '052100000000', '', '', '2025-02-04 15:35:24', 50, 'NO IGR', '6'),
(18, '20250207022029', 'Laboratory: Mp', 'MAWSH.2', '20000', 100, 'GENERAL', '2025-02-07 02:20:29', 'undefined', '5-1', 'undefined', 0, '5', 'pending', '052100000000', '', '', '2025-02-05 15:35:24', 10, 'IGR', '6'),
(19, '20250207022029', 'Laboratory: Esr', 'MAWSH.3', '20000', 200, 'GENERAL', '2025-02-07 02:20:29', 'undefined', '5-1', 'undefined', 0, '5', 'pending', '052100000000', '', '', '2025-02-06 15:35:24', 20, 'IGR', '6'),
(20, '25020722733', 'Isoflurane', '100001', '100000', 900, 'PHARMACY', '2025-02-07 02:27:33', 'Salla Dallam', '5-1', 'Single', 0, '5', 'pending', '052100000000', '', '', '2025-02-08 15:35:24', 90, 'IGR', '10'),
(21, '25020722828', 'Isoflurane', '100001', '100000', 900, 'PHARMACY', '2025-02-07 02:28:28', 'Some name of pat Oher', '6-1', 'Single', 0, '6', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 90, 'IGR', '10'),
(22, '25020723209', 'Isoflurane', '100001', '100000', 900, 'PHARMACY', '2025-02-07 02:32:09', 'Salla Dallam', '5-1', 'Single', 0, '5', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 90, 'IGR', '10'),
(23, '20250207023257', 'Laboratory: Bleeding Time', 'MAWSH.7', '20000', 300, 'REGISTRATION', '2025-02-07 02:32:57', 'Fullname Testing ', '7-1', 'Single', 0, '7', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 30, 'IGR', '6'),
(24, '20250207023350', 'Laboratory: Lft', 'MAWSH.10', '20000', 500, 'CONSULTATION', '2025-02-07 02:33:50', 'Rahul Nolove', '3-2', 'Single', 0, '3', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 50, 'IGR', '6'),
(25, '20250207023447', 'Laboratory: Afbx I', 'MAWSH.34', '20000', 200, 'REGISTRATION', '2025-02-07 02:34:47', 'Makale Other', '8-1', 'Single', 0, '8', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 20, 'NO IGR', '6'),
(26, '20250207023954', 'Laboratory: Pcv', 'MAWSH.4', '20000', 100, 'REGISTRATION', '2025-02-07 02:39:54', 'Normal New', '9-1', 'Single', 0, '9', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 10, 'IGR', '6'),
(27, '20250207024105', 'Laboratory: Prothrombin Time', 'MAWSH.5', '20000', 600, 'REGISTRATION', '2025-02-07 02:41:05', 'Joj Othernam', '10-1', 'Single', 0, '10', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 60, 'IGR', '6'),
(28, '20250207024158', 'Laboratory: Fbs', 'MAWSH.1', '20000', 300, 'REGISTRATION', '2025-02-07 02:41:58', 'Otne Testig', '11-1', 'Single', 0, '11', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 30, 'IGR', '6'),
(29, '20250207024413', 'Laboratory: Lft', 'MAWSH.10', '20000', 500, 'REGISTRATION', '2025-02-07 02:44:13', 'Samson Ofeliya', '12-1', 'Single', 0, '12', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 50, 'IGR', '6'),
(30, '20250207075346', 'Phathology: Rbs', 'ZONE 6.4', '20000', 150, 'REGISTRATION', '2025-02-07 07:53:46', 'Akinyemi Murtala', '1-3', 'Single', 0, '1', 'pending', '052100000001', '', '', '2025-02-07 15:35:24', 15, 'IGR', '8'),
(31, '20250207080449', 'Phathology: Wound Swab M/C/S', 'ZONE 6.44', '20000', 700, 'GENERAL', '2025-02-07 08:04:49', 'undefined', '1-3', 'undefined', 0, '1', 'pending', '052100000001', '', '', '2025-02-07 15:35:24', 70, 'NO IGR', '8'),
(32, '20250207080449', 'X-Ray Of Head And Neck: Man Dible (Jaws)', 'ZONE 6.70', '20000', 7500, 'GENERAL', '2025-02-07 08:04:49', 'undefined', '1-3', 'undefined', 0, '1', 'pending', '052100000001', '', '', '2024-12-16 15:35:24', 750, 'IGR', '8'),
(33, '20250207080449', 'Uss Services: Renal Uss', 'ZONE 6.99', '20000', 3000, 'GENERAL', '2025-02-07 08:04:49', 'undefined', '1-3', 'undefined', 0, '1', 'pending', '052100000001', '', '', '2024-12-23 15:35:24', 300, 'IGR', '8'),
(38, '20250207111600', 'Regular Consultation', '20003', '20000', 6000, 'REGISTRATION', '2025-02-07 11:16:00', 'Dasf Sdfsadf', '5-2', 'Single', 0, '5', 'pending', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', '', '2024-11-03 15:35:24', 600, 'IGR', ''),
(39, '20250207111815', 'Regular Consultation', '20003', '20000', 6000, 'GENERAL', '2025-02-07 11:18:15', 'undefined', '3-1', 'undefined', 0, '3', 'pending', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', '', '2025-02-07 15:35:24', 600, 'IGR', ''),
(40, '20250207121531', 'Laboratory: Mp', 'MAWSH.2', '20000', 100, 'REGISTRATION', '2025-02-07 12:15:31', 'Mathew Olayemi', '13-1', 'Single', 0, '13', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 10, 'IGR', '6'),
(41, '20250207121723', 'Laboratory: Pcv', 'MAWSH.4', '20000', 100, 'REGISTRATION', '2025-02-07 12:17:23', 'Lamido Sule', '14-1', 'Single', 0, '14', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 10, 'IGR', '6'),
(42, '20250207122703', 'Laboratory: Pcv', 'MAWSH.4', '20000', 100, 'REGISTRATION', '2025-02-07 12:27:03', 'Musa Yahaya', '15-1', 'Single', 0, '15', 'pending', '052100000000', 'nasarawa', 'nasarawa', '2025-02-07 15:35:24', 10, 'IGR', '6'),
(43, '250207122744', 'Isoflurane', '100001', '100000', 3600, 'PHARMACY', '2025-02-07 12:27:44', 'Sule Lamido', '14-1', 'Single', 0, '14', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 360, 'IGR', '10'),
(44, '20250207123535', 'Laboratory: Pcv', 'MAWSH.4', '20000', 100, 'GENERAL', '2025-02-07 12:35:36', 'undefined', '10-1', 'undefined', 0, '10', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 10, 'IGR', '6'),
(45, '20250207014001', 'Laboratory: Pcv', 'MAWSH.4', '20000', 100, 'GENERAL', '2025-02-07 13:40:01', 'undefined', '7-1', 'undefined', 0, '7', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 10, 'IGR', '6'),
(46, '20250207014120', 'Laboratory: Pttk', 'MAWSH.6', '20000', 600, 'GENERAL', '2025-02-07 13:41:20', 'undefined', '9-1', 'undefined', 0, '9', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 60, 'IGR', '6'),
(47, '20250207021801', 'Registration ( Family )', '20002', '20000', 10000, 'GENERAL', '2025-02-07 14:18:01', 'undefined', '4-2', 'undefined', 0, '4', 'pending', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', '', '2025-02-07 15:35:24', 1000, 'IGR', ''),
(48, '20250207030835', 'Laboratory: Afbx I', 'MAWSH.34', '20000', 200, 'REGISTRATION', '2025-02-07 15:08:35', 'Yge Cvc', '16-1', 'Single', 0, '16', 'pending', '052100000000', 'nasarawa', 'nasarawa', '2025-02-07 15:35:24', 20, 'IGR', '6'),
(49, '20250207030939', 'Laboratory: Semen Analysis', 'MAWSH.30', '20000', 200, 'GENERAL', '2025-02-07 15:09:39', 'undefined', '10-1', 'undefined', 0, '10', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 20, 'IGR', '6'),
(50, '20250207030939', 'Digital X-Ray: Paranasal Sinus (Pns', 'MAWSH.51', '20000', 120000, 'GENERAL', '2025-02-07 15:09:39', 'undefined', '10-1', 'undefined', 0, '10', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 12000, 'IGR', '6'),
(51, '20250207040258', 'Private ( 1, 2, Yellow )', '20006', '20000', 25000, 'GENERAL', '2025-02-07 16:02:58', 'undefined', '4-2', 'undefined', 0, '4', 'pending', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', '', '2025-02-07 15:35:24', 2500, 'IGR', ''),
(52, '20250207051008', 'Admission: Card Fee', 'MAWSH.295', '20000', 300, 'REGISTRATION', '2025-02-07 17:10:08', 'Musa Maryam', '17-1', 'Single', 0, '17', 'pending', '052100000000', 'nasarawa', 'nasarawa', '2025-02-07 15:35:24', 30, 'IGR', '6'),
(53, '20250207051117', 'Laboratory: Pbs/Rbs', 'MAWSH.13', '20000', 800, 'GENERAL', '2025-02-07 17:11:17', 'undefined', '17-1', 'undefined', 0, '17', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 80, 'IGR', '6'),
(54, '250207171151', 'Isoflurane', '100001', '100000', 3600, 'PHARMACY', '2025-02-07 17:11:51', 'Maryam Musa', '17-1', 'Single', 0, '17', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 360, 'IGR', '10'),
(55, '20250207052846', 'Ent: Ear Dressing', 'MAWSH.238', '20000', 500, 'REGISTRATION', '2025-02-07 17:28:47', 'Musa Isa', '18-1', 'Single', 0, '18', 'pending', '052100000000', 'nasarawa', 'nasarawa', '2025-02-07 15:35:24', 50, 'IGR', '6'),
(56, '20250207052846', 'Admission: Card Fee', 'MAWSH.295', '20000', 300, 'REGISTRATION', '2025-02-07 17:28:47', 'Musa Isa', '18-1', 'Single', 0, '18', 'pending', '052100000000', 'nasarawa', 'nasarawa', '2025-02-07 15:35:24', 30, 'IGR', '6'),
(57, '20250207052846', 'Laboratory: Prothrombin Time', 'MAWSH.5', '20000', 600, 'REGISTRATION', '2025-02-07 17:28:47', 'Musa Isa', '18-1', 'Single', 0, '18', 'pending', '052100000000', 'nasarawa', 'nasarawa', '2025-02-07 15:35:24', 60, 'IGR', '6'),
(58, '20250207053143', 'Laboratory: Prothrombin Time', 'MAWSH.5', '20000', 600, 'GENERAL', '2025-02-07 17:31:43', 'undefined', '18-1', 'undefined', 0, '18', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 60, 'IGR', '6'),
(59, '250207174340', 'Isoflurane', '100001', '100000', 2700, 'PHARMACY', '2025-02-07 17:43:40', 'Isa Musa', '18-1', 'Single', 0, '18', 'pending', '052100000000', '', '', '2025-02-07 15:35:24', 270, 'IGR', '10'),
(60, '20250207060952', 'Laboratory: Prothrombin Time', 'MAWSH.5', '20000', 600, 'REGISTRATION', '2025-02-07 18:09:52', 'SFASD ASDASD', '19-1', 'Single', 0, '19', 'pending', '052100000000', 'nasarawa', 'nasarawa', '2025-02-07 15:35:24', 60, 'IGR', '6'),
(61, '20250208102039', 'Laboratory: Mp', 'MAWSH.2', '20000', 100, 'GENERAL', '2025-02-08 10:20:39', 'undefined', '18-1', 'undefined', 0, '18', 'pending', '052100000000', '', '', '2025-02-08 15:35:24', 10, 'IGR', '6'),
(62, '20250208120737', 'Registration ( Family )', '20002', '20000', 20000, 'GENERAL', '2025-02-08 12:07:37', 'undefined', '3-1', 'undefined', 0, '3', 'pending', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', '', '2025-02-08 15:35:24', 2000, 'IGR', ''),
(63, '20250208120737', 'Houses ( White, Blue, Green, Annex Double )', '20008', '20000', 40000, 'GENERAL', '2025-02-08 12:07:37', 'undefined', '3-1', 'undefined', 0, '3', 'pending', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', '', '2025-02-08 15:35:24', 4000, 'IGR', ''),
(64, '20250208120737', 'Specialist F/up', '20034', '20000', 16000, 'GENERAL', '2025-02-08 12:07:37', 'undefined', '3-1', 'undefined', 0, '3', 'pending', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', '', '2025-02-08 15:35:24', 1600, 'IGR', ''),
(65, '20250208023140', 'Registration ( Family )', '20002', '20000', 10000, 'GENERAL', '2025-02-08 14:31:40', 'undefined', '3-1', 'undefined', 0, '3', 'pending', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', '', '2025-02-08 15:35:24', 1000, 'IGR', ''),
(66, '20250208024630', 'Registration ( Family )', '20002', '20000', 10000, 'GENERAL', '2025-02-08 14:46:30', 'Mola Saddiku', '4-2', 'undefined', 0, '4', 'pending', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', '', '2025-02-08 15:35:24', 1000, 'IGR', ''),
(67, '202500002', 'Laboratory: Mp', 'MAWSH.2', '20000', 100, 'GENERAL', '2025-02-08 17:43:22', 'SFASD ASDASD', '19-1', 'undefined', 0, '19', 'pending', '052100000000', '', '', '2025-02-08 15:35:24', 10, 'IGR', '6'),
(68, '202500002', 'Laboratory: Clotting Time', 'MAWSH.8', '20000', 300, 'GENERAL', '2025-02-08 17:43:22', 'SFASD ASDASD', '19-1', 'undefined', 0, '19', 'pending', '052100000000', '', '', '2025-02-08 15:35:24', 30, 'IGR', '6'),
(69, '202500003', 'Laboratory: Mp', 'MAWSH.2', '20000', 100, 'GENERAL', '2025-02-08 17:44:35', 'Patient Test', 'KIRS/NAS/0001', 'undefined', 0, 'KIRS/NAS/0001', 'pending', '052100000000', '', '', '2025-02-08 15:35:24', 10, 'IGR', '6'),
(70, '202500003', 'Laboratory: Bleeding Time', 'MAWSH.7', '20000', 300, 'GENERAL', '2025-02-08 17:44:35', 'Patient Test', 'KIRS/NAS/0001', 'undefined', 0, 'KIRS/NAS/0001', 'pending', '052100000000', '', '', '2025-02-08 15:35:24', 30, 'IGR', '6'),
(71, '202500004', 'Laboratory: Semen M/C/S', 'MAWSH.29', '20000', 400, 'GENERAL', '2025-02-08 17:47:37', 'Musa Maryam', '17-1', 'undefined', 0, '17', 'pending', '052100000000', '', '', '2025-02-08 15:35:24', 40, 'IGR', '6'),
(72, '202500004', 'Laboratory: R. Factor', 'MAWSH.44', '20000', 100000, 'GENERAL', '2025-02-08 17:47:37', 'Musa Maryam', '17-1', 'undefined', 0, '17', 'pending', '052100000000', '', '', '2025-02-08 15:35:24', 10000, 'IGR', '6'),
(73, '202500004', 'Laboratory: Lipid Profile', 'MAWSH.11', '20000', 150000, 'GENERAL', '2025-02-08 17:47:37', 'Musa Maryam', '17-1', 'undefined', 0, '17', 'pending', '052100000000', '', '', '2025-02-08 15:35:24', 15000, 'IGR', '6'),
(74, '202500005', 'Laboratory: Mp', 'MAWSH.2', '20000', 100, 'GENERAL', '2025-02-08 18:27:10', 'SFASD ASDASD', '19-1', 'undefined', 0, '19', 'pending', '052100000000', '', '', '2025-02-08 15:35:24', 10, 'IGR', '6'),
(75, '202500006', 'Laboratory: Mp', 'MAWSH.2', '20000', 100, 'GENERAL', '2025-02-09 10:16:29', 'SFASD ASDASD', '19-1', 'undefined', 0, '19', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 10, 'IGR', '6'),
(76, '202500007', 'Isoflurane', '100001', '100000', 5400, 'PHARMACY', '2025-02-09 12:37:07', 'General File', '17-1', '', 0, 'undefined', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 540, 'IGR', '10'),
(77, '202500008', 'Laboratory: Esr', 'MAWSH.2', '20000', 200, 'GENERAL', '2025-02-09 13:54:11', 'undefined', '17-1', 'undefined', 0, '1', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 20, 'IGR', '6'),
(78, '202500008', 'Laboratory: Bleeding Time', 'MAWSH.2', '20000', 300, 'GENERAL', '2025-02-09 13:54:11', 'undefined', '17-1', 'undefined', 0, '1', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 30, 'IGR', '6'),
(79, '202500009', 'Laboratory: Bleeding Time', 'MAWSH.2', '20000', 300, 'GENERAL', '2025-02-09 13:54:32', 'undefined', '17-1', 'undefined', 0, '1', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 30, 'IGR', '6'),
(80, '202500009', 'Laboratory: Lipid Profile', 'MAWSH.2', '20000', 150000, 'GENERAL', '2025-02-09 13:54:32', 'undefined', '17-1', 'undefined', 0, '1', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 15000, 'IGR', '6'),
(81, '202500010', 'Laboratory: Esr', 'MAWSH.2', '20000', 200, 'GENERAL', '2025-02-09 13:55:11', 'undefined', '17-1', 'undefined', 0, '1', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 20, 'IGR', '6'),
(82, '202500011', 'Laboratory: Mp', 'MAWSH.2', '20000', 100, 'GENERAL', '2025-02-09 13:57:37', 'undefined', '17-1', 'undefined', 0, '1', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 10, 'IGR', '6'),
(83, '202500011', 'Laboratory: Esr', 'MAWSH.2', '20000', 200, 'GENERAL', '2025-02-09 13:57:37', 'undefined', '17-1', 'undefined', 0, '1', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 20, 'IGR', '6'),
(84, '202500012', 'Laboratory: Fbs', 'MAWSH.2', '20000', 300, 'GENERAL', '2025-02-09 13:58:13', 'undefined', '17-1', 'undefined', 0, '1', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 30, 'IGR', '6'),
(85, '202500013', 'Laboratory: Mp', 'MAWSH.2', '20000', 100, 'GENERAL', '2025-02-09 14:08:15', 'Maryam Musa', '17-1', 'undefined', 0, '17', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 10, 'IGR', '6'),
(86, '202500013', 'Laboratory: Esr', 'MAWSH.2', '20000', 200, 'GENERAL', '2025-02-09 14:08:15', 'Maryam Musa', '17-1', 'undefined', 0, '17', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 20, 'IGR', '6'),
(87, '202500014', 'Laboratory: Bleeding Time', 'MAWSH.2', '20000', 300, 'GENERAL', '2025-02-09 14:47:04', 'Muhammad OIsmla', 'KIRS/NAS/0002', 'undefined', 0, 'KIRS/NAS/0002', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 30, 'IGR', '6'),
(88, '202500014', 'Laboratory: Pttk', 'MAWSH.2', '20000', 600, 'GENERAL', '2025-02-09 14:47:04', 'Muhammad OIsmla', 'KIRS/NAS/0002', 'undefined', 0, 'KIRS/NAS/0002', 'pending', '052100000000', '', '', '2025-02-09 15:35:24', 60, 'IGR', '6'),
(89, '202500015', 'Laboratory: Mp', 'MAWSH.2', '20000', 100, 'GENERAL', '2025-02-09 15:14:17', 'Muhammad OIsmla', 'KIRS/NAS/0002', 'undefined', 0, 'KIRS/NAS/0002', 'pending', '052100000000', '', '', '2025-01-12 15:35:24', 10, 'IGR', '6'),
(90, '202500015', 'Laboratory: Pttk', 'MAWSH.2', '20000', 600, 'GENERAL', '2025-02-09 15:14:17', 'Muhammad OIsmla', 'KIRS/NAS/0002', 'undefined', 0, 'KIRS/NAS/0002', 'pending', '052100000000', '', '', '2025-01-20 15:35:24', 60, 'IGR', '6'),
(91, '202500015', 'Laboratory: Lft', 'MAWSH.2', '20000', 500, 'GENERAL', '2025-02-09 15:14:17', 'Muhammad OIsmla', 'KIRS/NAS/0002', 'undefined', 0, 'KIRS/NAS/0002', 'pending', '052100000000', '', '', '2025-01-28 15:35:24', 50, 'IGR', '6'),
(92, '202500016', 'Laboratory: Lft', 'MAWSH.2', '20000', 500, 'GENERAL', '2025-02-10 10:10:59', 'Cvc Yge', '16-1', 'undefined', 0, '16', 'Paid', '052100000000', '', '', '2025-02-10 02:47:34', 50, NULL, NULL),
(93, '202500016', 'Laboratory: Lipid Profile', 'MAWSH.2', '20000', 150000, 'GENERAL', '2025-02-10 10:10:59', 'Cvc Yge', '16-1', 'undefined', 0, '16', 'Paid', '052100000000', '', '', '2025-02-10 02:47:34', 15000, NULL, NULL),
(94, '202500017', 'Laboratory: Fbs', 'MAWSH.2', '20000', 300, 'GENERAL', '2025-02-10 10:16:12', 'Ngozi  Emmanuel', 'KIRS/NAS/0007', 'undefined', 0, 'KIRS/NAS/0007', 'pending', '052100000000', '', '', NULL, 30, NULL, NULL),
(95, '202500017', 'Laboratory: Prothrombin Time', 'MAWSH.2', '20000', 600, 'GENERAL', '2025-02-10 10:16:12', 'Ngozi  Emmanuel', 'KIRS/NAS/0007', 'undefined', 0, 'KIRS/NAS/0007', 'pending', '052100000000', '', '', NULL, 60, NULL, NULL),
(96, '202500018', 'Laboratory: Mp', 'MAWSH.2', '20000', 100, 'GENERAL', '2025-02-10 10:25:15', 'Test Patient', 'NAS-0001', 'undefined', 0, 'NAS', 'Paid', '052100000000', 'nasarawa', '', '2025-02-10 02:47:07', 10, NULL, '6'),
(97, '202500018', 'Laboratory: Pttk', 'MAWSH.2', '20000', 600, 'GENERAL', '2025-02-10 10:25:15', 'Test Patient', 'NAS-0001', 'undefined', 0, 'NAS', 'Paid', '052100000000', 'nasarawa', '', '2025-02-10 02:47:07', 60, NULL, '6'),
(98, '202500019', 'Isoflurane', '100001', '100000', 900, 'PHARMACY', '2025-02-10 10:27:49', 'Maryam Musa', '17-1', 'Single', 0, '17', 'pending', '052100000000', 'nasarawa', '', NULL, 90, NULL, ''),
(99, '202500019', 'neostgimin iv', '100001', '100000', 1800, 'PHARMACY', '2025-02-10 10:27:49', 'Maryam Musa', '17-1', 'Single', 0, '17', 'pending', '052100000000', 'nasarawa', '', NULL, 180, NULL, ''),
(100, '202500020', 'Laboratory: Pttk', 'MAWSH.2', '20000', 1200, 'GENERAL', '2025-02-10 13:53:49', 'Yahaya Musa', '15-1', 'undefined', 0, '15', 'pending', '052100000000', 'nasarawa', '', NULL, 120, NULL, '6'),
(101, '202500020', 'Laboratory: Bleeding Time', 'MAWSH.2', '20000', 900, 'GENERAL', '2025-02-10 13:53:49', 'Yahaya Musa', '15-1', 'undefined', 0, '15', 'pending', '052100000000', 'nasarawa', '', NULL, 90, NULL, '6'),
(102, '202500021', 'Testese', '', '20000', 500, 'GENERAL', '2025-02-10 19:42:03', 'Cvc Yge', '16-1', 'undefined', 0, '16', 'pending', '052100000000', 'nasarawa', '', NULL, NULL, NULL, '6'),
(103, '202500022', 'NewRev', '', '20000', 400, 'GENERAL', '2025-02-11 11:11:23', 'Isa Musa', '18-1', 'undefined', 0, '18', 'pending', '052100000000', 'nasarawa', '', NULL, 80, 'IGR', '6'),
(104, '202500023', 'Laboratory: Lipid Profile', '', '20000', 750000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'IGR', '6'),
(105, '202500023', 'Laboratory: Genotype', '', '20000', 100000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'IGR', '6'),
(106, '202500023', 'Laboratory: Albumen', '', '20000', 900000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'IGR', '6'),
(107, '202500023', 'Laboratory: R. Factor', '', '20000', 100000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'IGR', '6'),
(108, '202500023', 'Laboratory: Pap Smear', '', '20000', 100000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'IGR', '6'),
(109, '202500023', 'Laboratory: Exfo Cyto', '', '20000', 100000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'IGR', '6'),
(110, '202500023', 'Laboratory: Trau Cyto', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'IGR', '6'),
(111, '202500023', 'Digital X-Ray: Paranasal Sinus (Pns', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(112, '202500023', 'Digital X-Ray: Skull Ap View', '', '20000', 240000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(113, '202500023', 'Digital X-Ray: Skull Ap And Lat', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(114, '202500023', 'Digital X-Ray: Mandible Ap View', '', '20000', 240000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(115, '202500023', 'Digital X-Ray: Both Mandibles (L) Oblqs', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(116, '202500023', 'Digital X-Ray: Right (R) S And M', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(117, '202500023', 'Digital X-Ray: Left (L) S And M', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(118, '202500023', 'Digital X-Ray: Temporo-Mandibular Joint', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(119, '202500023', 'Digital X-Ray: Nasal Bones', '', '20000', 240000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(120, '202500023', 'Digital X-Ray: Base Of Skull (Smv)', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(121, '202500023', 'Digital X-Ray: Lumbo - Sacrae', '', '20000', 240000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(122, '202500023', 'Digital X-Ray: Lumbar-Spine Ap View', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(123, '202500023', 'Digital X-Ray: Sacrum And Coccyx', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(124, '202500023', 'Digital X-Ray: Shoulder/Scapula Ap', '', '20000', 0, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(125, '202500023', 'Digital X-Ray: Shoulder/Scapula Ap/Lat', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(126, '202500023', 'Digital X-Ray: Acromio-Clavicula Joint', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6f'),
(127, '202500023', 'Digital X-Ray: Right (R) Clavicle', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(128, '202500023', 'Digital X-Ray: Left (L) Clavicle', '', '20000', 120000, 'GENERAL', '2025-02-12 10:03:58', 'Olayemi Mathew', '13-1', 'undefined', 0, '13', 'pending', '052100000000', 'admin', '', '2025-02-12 00:00:00', 0, 'NO IGR', '6'),
(129, '202500024', 'Phathology: Blood Transfusion, Screening Only', '', '20000', 1500, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'IGR', ''),
(130, '202500024', 'Radiology: Thoraco Lumber', '', '20000', 1500, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(131, '202500024', 'Uss Services: Muscular/Skeletol', '', '20000', 2000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(132, '202500024', 'Obstertic & Gynaecology: Myomectomy', '', '20000', 300000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(133, '202500024', 'Obstertic & Gynaecology: Uterine/Cervical Polype', '', '20000', 330000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(134, '202500024', 'Obstertic & Gynaecology: Prolapse', '', '20000', 180000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(135, '202500024', 'Obstertic & Gynaecology: Ant. Colphoraphy', '', '20000', 240000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(136, '202500024', 'Obstertic & Gynaecology: Vaginal Hysterectomy', '', '20000', 105000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(137, '202500024', 'Ent: Tonsillectomy', '', '20000', 120000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(138, '202500024', 'Ent: Adenoidectomy', '', '20000', 105000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(139, '202500024', 'Ent: Adeno Tonsillectomy', '', '20000', 180000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(140, '202500024', 'Ent: Nasal Polypectomy', '', '20000', 220000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(141, '202500024', 'Ent: Aural Polypectomy', '', '20000', 180000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(142, '202500024', 'Ent: Mastidectomy', '', '20000', 330000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(143, '202500024', 'Ent: Foreign Body In The Oesoglapus', '', '20000', 240000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(144, '202500024', 'Ent: Tracheotomy', '', '20000', 20000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(145, '202500024', 'Ent: Foreign Body In The Airways', '', '20000', 200000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(146, '202500024', 'Ent: Ramua Excision', '', '20000', 340000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(147, '202500024', 'Ent: Repair Of Palatal Laceration', '', '20000', 15000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(148, '202500024', 'Ent: Intra Nasal Antrostomy', '', '20000', 340000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(149, '202500024', 'Eye Clinic: Trabeculectomy', '', '20000', 190000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(150, '202500024', 'Eye Clinic: Cornea Repair', '', '20000', 102000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(151, '202500024', 'Phathology : Blood Transfusion Screen Ng Only', '', '20000', 10500, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(152, '202500024', 'Phathology : Pcv', '', '20000', 200, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(153, '202500024', 'Phathology : Clotting Time', '', '20000', 400, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(154, '202500024', 'Phathology : Urinalys S', '', '20000', 400, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(155, '202500024', 'Phathology : Stoolmanalys S', '', '20000', 400, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(156, '202500024', 'Phathology : Sputum Mcs', '', '20000', 7700, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(157, '202500024', 'Phathology : Blood Mcs', '', '20000', 9100, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(158, '202500024', 'Phathology : Wound Swab M/C/S', '', '20000', 11900, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(159, '202500024', 'Uss Services: Small Partis Uss', '', '20000', 8000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(160, '202500024', 'Uss Services: Obstetr Cs + 4d', '', '20000', 12000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', ''),
(161, '202500024', 'Uss Services: Pelv Cs Uss', '', '20000', 5000, 'GENERAL', '2025-02-12 10:08:29', 'Murtala Akinyemi', '1-3', 'undefined', 0, '1', 'Paid', '052100000001', 'murtala', 'murtala', '2025-02-12 10:33:30', 0, 'NO IGR', '');

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

--
-- Table structure for table `pharm_branches`
--

CREATE TABLE `pharm_branches` (
  `id` int(11) NOT NULL,
  `branch_name` varchar(50) NOT NULL,
  `location` varchar(50) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `crm` varchar(50) DEFAULT NULL,
  `created_time` timestamp NULL DEFAULT current_timestamp(),
  `facilityId` varchar(50) NOT NULL,
  `store_type` varchar(100) NOT NULL,
  `admin_name` varchar(50) NOT NULL,
  `created_by` varchar(50) NOT NULL,
  `manage_by` varchar(100) NOT NULL,
  `store_code` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pharm_branches`
--

INSERT INTO `pharm_branches` (`id`, `branch_name`, `location`, `address`, `phone`, `crm`, `created_time`, `facilityId`, `store_type`, `admin_name`, `created_by`, `manage_by`, `store_code`) VALUES
(1, 'Prime Pharmacy', 'PSC Prime', '2 Lamido Crescent , Kano', '', NULL, '2022-09-20 04:42:48', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Store', 'abdurrahman', '5', '5', '13bc4489-4807-4ad5-aa55-4b13ed697074'),
(2, 'Nursing Station', 'PSC Prime', '', '', NULL, '2022-09-21 12:01:42', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Store', 'abdurrahman', '5', '5', 'c449bdaf-413a-4c53-94ee-7743c5e4c4e5'),
(3, 'Theater Store', 'Theater', '', '', NULL, '2022-10-08 06:57:25', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Store', 'Maryam', '825', '825', 'a6631135-54bd-44d7-aff9-328d5bb5badf'),
(4, 'Laboratory Store', 'Laboratory', '', NULL, NULL, '2022-11-08 06:57:25', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Store', 'Suliaman', '825', '825', 'a6631135-54bd-44d7-aff9-32899bb5badf'),
(5, 'RECEPTION ', 'PRIME HOSPITAL', '', '', NULL, '2022-12-16 05:28:34', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Store', 'Suleiman', '11', '11', '7e25c08d-6dbe-4587-b169-637da7c304ab'),
(6, 'Main Store', 'Kano', 'Kano', '', NULL, '2025-02-06 22:32:24', '052100000000', 'Point Of Sales', 'nasarawa', '878', '878', 'f3e29231-2cf4-46b4-925c-a47049a02244'),
(7, 'Defaukt', 'Kano', 'Kano', '', NULL, '2025-02-07 06:57:47', '052100000001', 'Point Of Sales', 'murtala', '879', '879', '103d7a9a-0312-4307-ad6a-ccd49b9805ec'),
(8, 'Main Store', '', 'No 10 Sokoto Road, Kano', '', NULL, '2025-02-15 15:26:43', '052100000003', 'Point Of Sales', 'pharmacy', '886', '886', 'cd24b428-cf1a-49fe-a3a9-691f57ef62f0'),
(9, 'Nasarawa Hospital Main Store', '', '', '09012121212', NULL, '2025-02-16 14:34:20', '052100000000', 'Store', 'nasarawa', '881', '881', '16770944-f46a-4afc-987c-0f38f5554cd4');

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

--
-- Table structure for table `pharm_store`
--

CREATE TABLE `pharm_store` (
  `balance` int(11) DEFAULT 0,
  `drug_name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `price` float DEFAULT NULL,
  `prefix` varchar(50) DEFAULT NULL,
  `item_code` varchar(50) NOT NULL,
  `group_code` varchar(50) DEFAULT NULL,
  `specification` varchar(50) DEFAULT NULL,
  `facilityId` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `expired_status` varchar(50) DEFAULT 'false',
  `expiry_date` date NOT NULL DEFAULT '1111-11-11',
  `store` varchar(50) NOT NULL,
  `selling_price` float NOT NULL,
  `supplier_name` varchar(100) DEFAULT NULL,
  `supplier_code` varchar(100) DEFAULT NULL,
  `store_location` varchar(50) DEFAULT NULL,
  `generic_name` varchar(50) DEFAULT NULL,
  `insert_date` datetime DEFAULT NULL,
  `reoder_level` int(50) DEFAULT NULL,
  `uom` varchar(100) DEFAULT NULL,
  `drug_category` varchar(100) DEFAULT NULL,
  `item_id` varchar(60) DEFAULT NULL,
  `barcode` varchar(100) DEFAULT NULL,
  `grn_no` varchar(20) DEFAULT NULL,
  `drug_type` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pharm_store`
--

INSERT INTO `pharm_store` (`balance`, `drug_name`, `price`, `prefix`, `item_code`, `group_code`, `specification`, `facilityId`, `expired_status`, `expiry_date`, `store`, `selling_price`, `supplier_name`, `supplier_code`, `store_location`, `generic_name`, `insert_date`, `reoder_level`, `uom`, `drug_category`, `item_id`, `barcode`, `grn_no`, `drug_type`) VALUES
(0, 'Aminophylline inj 250mg', 0, NULL, '229', NULL, NULL, '052100000000', 'false', '2025-02-12', 'Main Store', 600, 'Default', 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', NULL, 'New Drug', '2025-02-14 14:41:01', 90, '', '', NULL, '', '9548', 'DRF'),
(50, 'Flagyl 150mg', 500, NULL, '244', NULL, NULL, '052100000000', 'false', '2027-02-21', 'Main Store', 600, 'Default', 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', NULL, 'Flagyl', '2025-02-14 14:41:59', 23, '50', 'ooo', NULL, '', '9549', 'DRF'),
(90, 'Paracetamol tab', 10000, NULL, '269', NULL, NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'false', '2025-02-07', 'Prime Pharmacy', 15000, 'Pfizer', '2e2b599c-1fbf-4727-8965-b43b3935a592', NULL, 'Paracetamol', '2025-01-31 12:32:52', 212112, 'per annum', 'PPT', NULL, '23434', '9541', ''),
(110, 'Amoxicillin + Clav 625mg syr', 400, NULL, '282', NULL, NULL, '052100000000', 'false', '2027-02-14', 'Nasarawa Hospital Main Store', 500, 'New Supplier', '4b9720e3-f46d-48aa-9fd5-3da356b9945c', NULL, 'Amoxicillin', '2025-02-16 14:37:04', 0, 'Card', '', NULL, '1324', '9551', 'DRF'),
(40, 'Flagyl syr', 500, NULL, '310', NULL, NULL, '052100000003', 'false', '2025-02-15', 'Main Store', 1000, 'Drug Management Agency', 'dcdc3a08-06cd-4341-a288-5c32e907ef81', NULL, 'Flagyl', '2025-02-15 15:32:24', 10, 'Card', 'ooo', NULL, '', '9550', 'DRF'),
(44, 'neostgimin iv', 600, NULL, '318', NULL, NULL, '052100000000', 'false', '2026-02-09', 'Main Store', 900, 'Default', 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', NULL, '', '2025-02-09 12:00:35', 34, 'rr', '', NULL, '34', '9547', ''),
(100, 'ETT', 1000, NULL, '321', NULL, NULL, '052100000000', 'false', '2026-02-08', 'Prime Pharmacy', 1200, 'Default', 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', NULL, 'ETT', '2025-02-08 09:33:50', 34, 'sf', '', NULL, '', '9546', ''),
(200, 'Ceftazidime', 600, NULL, '322', NULL, NULL, '052100000001', 'false', '2025-02-06', 'Defaukt', 1000, 'Default', 'f4d670b1-65f5-489b-b171-d4df9be44ab7', NULL, 'Ceftazidime', '2025-02-07 07:00:05', 10, '', '', NULL, '', '9543', ''),
(50, 'Ceftazidime', 300, NULL, '322', NULL, NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'false', '2026-09-10', 'Prime Pharmacy', 500, 'Pfizer', '2e2b599c-1fbf-4727-8965-b43b3935a592', NULL, 'Ceftazidime', '2024-08-10 14:27:11', 10, 'tabs', '', NULL, '', '9540', ''),
(60, 'Pentazocine', 700, NULL, '323', NULL, NULL, '052100000000', 'false', '2026-02-09', 'Prime Pharmacy', 1000, 'Default', 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', NULL, 'Pentazocine', '2025-02-08 09:32:01', 9, '', '', NULL, '', '9545', ''),
(50, 'Pentazocine', 400, NULL, '323', NULL, NULL, '052100000003', 'false', '2025-02-14', 'Main Store', 1000, 'Drug Management Agency', 'dcdc3a08-06cd-4341-a288-5c32e907ef81', NULL, 'Pentazocine', '2025-02-15 15:32:24', 10, 'Card', 'ooo', NULL, '', '9550', 'DRF'),
(40, 'Pentazocine', 500, NULL, '323', NULL, NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'false', '2024-09-05', 'Prime Pharmacy', 1000, 'Pfizer', '2e2b599c-1fbf-4727-8965-b43b3935a592', NULL, 'Pentazocine', '2024-08-10 14:27:11', 10, 'tabs', '', NULL, '', '9540', ''),
(50, 'Isoflurane', 600, NULL, '324', NULL, NULL, '052100000000', 'false', '2027-02-06', 'Main Store', 900, 'Default', 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', NULL, 'Isoflurane', '2025-02-06 22:34:36', 10, 'Sacchet', 'General', NULL, '234', '9542', ''),
(700, 'Midazolam', 500, NULL, '325', NULL, NULL, '052100000001', 'false', '2027-02-07', 'Defaukt', 800, 'Default', 'f4d670b1-65f5-489b-b171-d4df9be44ab7', NULL, 'Midazolam', '2025-02-07 07:02:17', 34, 'CARD', '', NULL, '', '9544', '');

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

--
-- Table structure for table `pharm_store_entries`
--

CREATE TABLE `pharm_store_entries` (
  `version_id` varchar(100) DEFAULT NULL,
  `receive_date` varchar(50) DEFAULT NULL,
  `drug_name` varchar(50) DEFAULT NULL,
  `id` int(11) NOT NULL,
  `po_no` varchar(50) DEFAULT NULL,
  `qty_in` varchar(50) DEFAULT NULL,
  `qty_out` varchar(50) DEFAULT NULL,
  `store_type` varchar(20) DEFAULT 'Local',
  `item_code` varchar(50) DEFAULT NULL,
  `barcode` varchar(50) DEFAULT NULL,
  `grn_no` varchar(50) DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `unit_price` float NOT NULL DEFAULT 0,
  `cost_price` float DEFAULT NULL,
  `mark_up` varchar(50) DEFAULT NULL,
  `selling_price` varchar(100) DEFAULT NULL,
  `transfer_from` varchar(50) DEFAULT NULL,
  `transfer_to` varchar(50) DEFAULT 'Prime Pharmacy',
  `branch_name` varchar(50) DEFAULT 'Prime Pharmacy',
  `item_status` varchar(20) DEFAULT NULL,
  `inserted_time` datetime(6) DEFAULT current_timestamp(6),
  `inserted_by` varchar(50) DEFAULT NULL,
  `facilityId` varchar(50) DEFAULT NULL,
  `trn_number` varchar(50) DEFAULT NULL,
  `uniqueId` varchar(40) DEFAULT NULL,
  `drug_category` varchar(100) DEFAULT 'Local',
  `truckNo` varchar(50) DEFAULT NULL,
  `waybillNo` varchar(50) DEFAULT NULL,
  `otherInfo` varchar(100) DEFAULT NULL,
  `supplier_code` varchar(150) DEFAULT NULL,
  `supplier_name` varchar(200) DEFAULT NULL,
  `reorder_level` int(11) DEFAULT NULL,
  `sales_type` varchar(50) DEFAULT NULL,
  `userName` varchar(100) DEFAULT NULL,
  `patient_id` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pharm_store_entries`
--

INSERT INTO `pharm_store_entries` (`version_id`, `receive_date`, `drug_name`, `id`, `po_no`, `qty_in`, `qty_out`, `store_type`, `item_code`, `barcode`, `grn_no`, `expiry_date`, `unit_price`, `cost_price`, `mark_up`, `selling_price`, `transfer_from`, `transfer_to`, `branch_name`, `item_status`, `inserted_time`, `inserted_by`, `facilityId`, `trn_number`, `uniqueId`, `drug_category`, `truckNo`, `waybillNo`, `otherInfo`, `supplier_code`, `supplier_name`, `reorder_level`, `sales_type`, `userName`, `patient_id`) VALUES
('', '2024-08-10', 'Pentazocine', 1, '20240810032710', '40', '0', '', '323', '', '9540', '2024-09-05', 500, 500, '0', '1000', 'Purchase order', 'Prime Pharmacy', 'Prime Pharmacy', NULL, '2024-08-10 14:27:11.000000', 'abdurrahman', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', NULL, '', '', '', '', '', '2e2b599c-1fbf-4727-8965-b43b3935a592', 'Pfizer', 10, 'Purchase Order', NULL, NULL),
('', '2024-08-10', 'Ceftazidime', 2, '20240810032710', '50', '0', '', '322', '', '9540', '2026-09-10', 300, 300, '0', '500', 'Purchase order', 'Prime Pharmacy', 'Prime Pharmacy', NULL, '2024-08-10 14:27:11.000000', 'abdurrahman', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', NULL, '', '', '', '', '', '2e2b599c-1fbf-4727-8965-b43b3935a592', 'Pfizer', 10, 'Purchase Order', NULL, NULL),
('', '2025-01-31', 'Paracetamol tab', 3, '20250131013252', '90', '0', '', '269', '23434', '9541', '2025-02-07', 10000, 10000, '0', '15000', 'Purchase order', 'Prime Pharmacy', 'Prime Pharmacy', NULL, '2025-01-31 12:32:52.000000', 'abdurrahman', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', NULL, '', 'PPT', '', '', '', '2e2b599c-1fbf-4727-8965-b43b3935a592', 'Pfizer', 212112, 'Purchase Order', NULL, NULL),
('', '2025-02-06', 'Isoflurane', 4, '20250206113436', '50', '0', '', '324', '234', '9542', '2027-02-06', 600, 600, '0', '900', 'Purchase order', 'Main Store', 'Prime Pharmacy', NULL, '2025-02-06 22:34:36.000000', 'nasarawa', '052100000000', NULL, '', 'General', '', '', '', 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', 'Default', 10, 'Purchase Order', NULL, NULL),
('', '2025-02-07', 'Ceftazidime', 5, '20250207080005', '200', '0', '', '322', '', '9543', '2025-02-06', 600, 600, '0', '1000', 'Purchase order', 'Defaukt', 'Prime Pharmacy', NULL, '2025-02-07 07:00:05.000000', 'murtala', '052100000001', NULL, '', '', '', '', '', 'f4d670b1-65f5-489b-b171-d4df9be44ab7', 'Default', 10, 'Purchase Order', NULL, NULL),
('', '2025-02-07', 'Midazolam', 6, '20250207080217', '700', '0', '', '325', '', '9544', '2027-02-07', 500, 500, '0', '800', 'Purchase order', 'Defaukt', 'Prime Pharmacy', NULL, '2025-02-07 07:02:17.000000', 'murtala', '052100000001', NULL, '', '', '', '', '', 'f4d670b1-65f5-489b-b171-d4df9be44ab7', 'Default', 34, 'Purchase Order', NULL, NULL),
('', '2025-02-08', 'Pentazocine', 7, '20250208103201', '60', '0', '', '323', '', '9545', '2026-02-09', 700, 700, '0', '1000', 'Purchase order', 'Main Store', 'Prime Pharmacy', NULL, '2025-02-08 09:32:01.000000', 'nasarawa', '052100000000', NULL, '', '', '', '', '', 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', 'Default', 9, 'Purchase Order', NULL, NULL),
('', '2025-02-08', 'ETT', 8, '20250208103350', '100', '0', '', '321', '', '9546', '2026-02-08', 1000, 1000, '0', '1200', 'Purchase order', 'Main Store', 'Prime Pharmacy', NULL, '2025-02-08 09:33:50.000000', 'nasarawa', '052100000000', NULL, '', '', '', '', '', 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', 'Default', 34, 'Purchase Order', NULL, NULL),
('', '2025-02-09', 'neostgimin iv', 9, '20250209010035', '44', '0', '', '318', '34', '9547', '2026-02-09', 600, 600, '0', '900', 'Purchase order', 'Main Store', 'Main Store', NULL, '2025-02-09 12:00:35.000000', 'nasarawa', '052100000000', NULL, '', '', '', '', '', 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', 'Default', 34, 'Purchase Order', NULL, NULL),
('', '2025-02-14', 'Aminophylline inj 250mg', 10, '20250214034101', '0', '0', '', '229', '', '9548', '2025-02-12', 0, 0, '0', '600', 'Purchase order', 'Main Store', 'Main Store', NULL, '2025-02-14 14:41:01.000000', 'nasarawa', '052100000000', NULL, '', '', '', '', '', 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', 'Default', 90, 'Purchase Order', NULL, NULL),
('', '2025-02-14', 'Flagyl 150mg', 11, '20250214034159', '50', '0', '', '244', '', '9549', '2027-02-21', 500, 500, '0', '600', 'Purchase order', 'Main Store', 'Main Store', NULL, '2025-02-14 14:41:59.000000', 'nasarawa', '052100000000', NULL, '', 'ooo', '', '', '', 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', 'Default', 23, 'Purchase Order', NULL, NULL),
('', '2025-02-15', 'Pentazocine', 12, '20250215043224', '50', '0', '', '323', '', '9550', '2025-02-14', 400, 400, '0', '1000', 'Purchase order', 'Main Store', 'Main Store', NULL, '2025-02-15 15:32:24.000000', 'pharmacy', '052100000003', NULL, '', 'ooo', '', '', '', 'dcdc3a08-06cd-4341-a288-5c32e907ef81', 'Drug Management Agency', 10, 'Purchase Order', NULL, NULL),
('', '2025-02-15', 'Flagyl syr', 13, '20250215043224', '40', '0', '', '310', '', '9550', '2025-02-15', 500, 500, '0', '1000', 'Purchase order', 'Main Store', 'Main Store', NULL, '2025-02-15 15:32:24.000000', 'pharmacy', '052100000003', NULL, '', 'ooo', '', '', '', 'dcdc3a08-06cd-4341-a288-5c32e907ef81', 'Drug Management Agency', 10, 'Purchase Order', NULL, NULL),
('', '2025-02-16', 'Amoxicillin + Clav 625mg syr', 14, '20250216033704', '110', '0', '', '282', '1324', '9551', '2027-02-14', 400, 400, '0', '500', 'Purchase order', 'Nasarawa Hospital Main Store', 'Nasarawa Hospital Main Store', NULL, '2025-02-16 14:37:04.000000', 'nasarawa', '052100000000', NULL, '', '', '', '', '', '4b9720e3-f46d-48aa-9fd5-3da356b9945c', 'New Supplier', 0, 'Purchase Order', NULL, NULL);

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

--
-- Table structure for table `prescriptionrequests`
--

CREATE TABLE `prescriptionrequests` (
  `facilityId` varchar(50) NOT NULL,
  `date` date DEFAULT NULL,
  `patient_id` varchar(11) NOT NULL,
  `dosage` varchar(10) NOT NULL,
  `drug_status` varchar(10) NOT NULL,
  `seen_by` varchar(20) NOT NULL,
  `duration` varchar(10) NOT NULL,
  `period` varchar(5) NOT NULL,
  `drug` varchar(15) NOT NULL,
  `frequency` int(5) NOT NULL,
  `drug_request_id` int(30) NOT NULL,
  `price` int(10) NOT NULL,
  `quantity_dispensed` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `previous_doc`
--

CREATE TABLE `previous_doc` (
  `id` int(11) NOT NULL,
  `patient_id` varchar(20) DEFAULT NULL,
  `file_type` varchar(50) DEFAULT NULL,
  `file_url` varchar(200) DEFAULT NULL,
  `file_date` date DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `prime_old_lab`
--

CREATE TABLE `prime_old_lab` (
  `id` int(11) NOT NULL DEFAULT 0,
  `account` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `subhead` varchar(100) NOT NULL,
  `head` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `unit` varchar(100) DEFAULT NULL,
  `range_from` varchar(100) DEFAULT NULL,
  `range_to` varchar(100) DEFAULT NULL,
  `other_range` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specimen` varchar(100) NOT NULL,
  `price` int(100) NOT NULL,
  `commission_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `percentage` int(11) NOT NULL,
  `noOfLabels` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` varchar(100) DEFAULT NULL,
  `facilityId` varchar(50) NOT NULL,
  `created_by` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `referrals`
--

CREATE TABLE `referrals` (
  `id` char(36) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `referee` varchar(255) DEFAULT NULL,
  `refereeContact` varchar(255) DEFAULT NULL,
  `referer` varchar(255) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `referrals`
--

INSERT INTO `referrals` (`id`, `referee`, `refereeContact`, `referer`, `createdAt`, `updatedAt`) VALUES
('082e4afa-9f99-4175-a8a1-9dfdb1cf5ac7', '', 'issatoyin@gmail.com', '34', '2020-05-16 18:34:17', '2020-05-16 18:34:17');

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

--
-- Table structure for table `repairlogs`
--

CREATE TABLE `repairlogs` (
  `facilityId` varchar(50) NOT NULL,
  `id` int(11) NOT NULL,
  `date` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `repaired_by` varchar(255) DEFAULT NULL,
  `nature` varchar(255) DEFAULT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp(),
  `updatedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `repairlogs`
--

INSERT INTO `repairlogs` (`facilityId`, `id`, `date`, `time`, `repaired_by`, `nature`, `createdAt`, `updatedAt`) VALUES
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 1, '2019-12-24', '12:34', 'Aminu', 'reservice', '2019-12-24 15:38:11', NULL),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 2, '2019-12-24', '23:12', 'ggggg', 'nljnkm', '2019-12-24 22:43:52', NULL),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 3, '2019-12-25', '10:12', 'fahad', 'out of oil', '2019-12-25 09:48:13', NULL),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 4, '2019-12-25', '17:12', 'glo', 'illness', '2019-12-25 16:11:46', NULL);

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

--
-- Table structure for table `report_templates`
--

CREATE TABLE `report_templates` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `department` varchar(50) NOT NULL,
  `header` varchar(200) NOT NULL,
  `body` varchar(3000) NOT NULL,
  `facilityId` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_by` varchar(50) NOT NULL,
  `updated_at` datetime NOT NULL,
  `updated_by` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `report_templates`
--

INSERT INTO `report_templates` (`id`, `name`, `department`, `header`, `body`, `facilityId`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(4, 'Result', 'Microbiology', 'Results', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sunt repudiandae non sapiente provident facere, ratione praesentium molestiae reprehenderit perspiciatis deleniti fugiat accusantium quaerat autem dolore possimus harum aliquam pariatur exercitationem. Alias officia incidunt reprehenderit ut libero rem consectetur reiciendis eligendi voluptatibus facilis eaque similique iste, exercitationem suscipit fugit harum deleniti delectus amet cum architecto consequatur! Aspernatur omnis suscipit, id, officia expedita, accusantium nihil fugiat totam magnam recusandae vel itaque provident eos. Tenetur pariatur cupiditate a quasi amet reprehenderit officia minima facere voluptate quod. Eius dolorem sapiente, nobis iusto nisi commodi neque porro qui, labore asperiores ipsa ut dicta fuga aliquam nostrum, ea alias sunt recusandae facere doloremque! Explicabo voluptatem minus ullam quisquam earum, delectus fuga unde culpa ad quod placeat, et, nemo sapiente animi! Suscipit aperiam perspiciatis, recusandae inventore dolor nemo repellat nulla sit? Pariatur architecto maxime modi eos, amet doloribus aut ipsum libero autem voluptatibus quam repellendus consequatur, iure aspernatur laboriosam sapiente debitis, magni eum molestias nostrum possimus iste ex! Sapiente aspernatur dignissimos aperiam suscipit cumque facilis quia debitis placeat? Excepturi iste, quisquam temporibus blanditiis, facilis obcaecati dolorum hic voluptate impedit aspernatur qui repellat nisi nesciunt odio quos vel, provident ut similique nam eius molestiae! Consectetur animi possimus voluptatem vitae molestiae perferendis minima placeat, consequatur nisi similique aperiam consequuntur voluptate iusto voluptatum vel? Facilis blanditiis, vitae ad non deleniti aut qui exercitationem itaque expedita, quaerat obcaecati repudiandae debitis eum ex repellendus. Sit vitae illum quisquam, dolor sint veritatis quam asperiores maiores praesentium eum corrupti nesciunt, doloremque molestias cum recusandae expedita. Perferendis veritatis placeat soluta libero velit porro odit voluptates illum repellat ad aperiam dicta ab, maiores accusamus qui expedita quibusdam dolorum blanditiis minima dolor quaerat. In debitis ratione consequatur porro molestiae nisi quas, similique quo repellendus voluptatem dolor autem, consectetur ut quod asperiores distinctio tempore labore sint. Fugit error nisi et ut dolor vel quos ab assumenda eum laborum, nemo placeat consequuntur vero. Illum porro doloribus excepturi et eligendi aspernatur tempora assumenda ducimus, placeat odit nisi ab sapiente dolorum exercitationem accusamus quasi architecto repellat nihil mollitia quis neque a veniam adipisci temporibus! Possimus ut autem repellat magni animi architecto eaque aliquam, culpa distinctio debitis deleniti nam eos ducimus obcaecati et blanditiis? Voluptatem cupiditate ipsa ut eos neque natus rem sapiente sequi quae quisquam aspernatur ipsum reiciendis eius tenetur, doloribus blanditiis non nulla rerum voluptates vel nostrum ape', '966a89f6-05d8-4564-b319-2f8863821e75', '2020-09-01 01:26:18', '41', '0000-00-00 00:00:00', ''),
(5, 'Result', 'Radiology', 'Result', '<p>some design</p>\n', '966a89f6-05d8-4564-b319-2f8863821e75', '2020-09-18 03:51:47', 'admin', '0000-00-00 00:00:00', ''),
(6, 'WIDAL', 'Laboratories', 'WIDAL', '\n', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2022-10-03 10:58:25', 'Mubarak', '0000-00-00 00:00:00', '');

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

--
-- Stand-in structure for view `saved_pending_request`
-- (See below for the actual view)
--
CREATE TABLE `saved_pending_request` (
`labno` int(1)
,`booking_no` int(1)
,`name` int(1)
,`code` int(1)
,`patient_id` int(1)
,`status` int(1)
,`department` int(1)
,`head` int(1)
,`test_group` int(1)
,`description` int(1)
,`subhead` int(1)
);

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

--
-- Table structure for table `sensitivity_list`
--

CREATE TABLE `sensitivity_list` (
  `id` int(11) NOT NULL,
  `antibiotic` varchar(100) DEFAULT NULL,
  `facilityId` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `created_by` varchar(50) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `sensitivity_list`
--

INSERT INTO `sensitivity_list` (`id`, `antibiotic`, `facilityId`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(3, 'Flucloxacillin', '966a89f6-05d8-4564-b319-2f8863821e75', '2020-08-27 00:49:34', '', '0000-00-00 00:00:00', ''),
(4, 'Tetracycline', '966a89f6-05d8-4564-b319-2f8863821e75', '2020-08-27 00:49:34', '', '0000-00-00 00:00:00', ''),
(5, 'Ampicilin', '966a89f6-05d8-4564-b319-2f8863821e75', '2020-08-27 00:49:34', '', '0000-00-00 00:00:00', ''),
(8, 'Flucloxacillin', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-03-14 03:54:32', 'abdurrahman', NULL, NULL),
(9, 'Tetracycline', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-03-14 03:54:42', 'abdurrahman', NULL, NULL),
(10, 'Ampicilin', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-03-14 03:54:50', 'abdurrahman', NULL, NULL),
(11, 'Gentamacin', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-10-26 07:03:19', 'zaks', NULL, NULL),
(12, 'Colistin sulphate', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-12-02 07:54:34', 'abdurrahman', NULL, NULL),
(13, 'Amoxycline /clavulanic acid', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-12-02 07:54:48', 'abdurrahman', NULL, NULL),
(14, 'Cefuroxime', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-12-02 07:55:05', 'abdurrahman', NULL, NULL),
(15, 'Azithromycin', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-12-02 07:55:39', 'abdurrahman', NULL, NULL),
(16, 'Doxycycline', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-12-02 07:55:53', 'abdurrahman', NULL, NULL),
(17, 'Imipenem', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-12-02 07:56:34', 'abdurrahman', NULL, NULL),
(18, 'Meropenem', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-12-02 07:56:47', 'abdurrahman', NULL, NULL),
(19, 'Clindamycin', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-12-02 07:57:04', 'abdurrahman', NULL, NULL);

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

--
-- Table structure for table `sensitivity_results`
--

CREATE TABLE `sensitivity_results` (
  `antibiotic` varchar(50) NOT NULL,
  `isolates` varchar(50) DEFAULT NULL,
  `R` varchar(10) NOT NULL,
  `S` varchar(10) NOT NULL,
  `I` varchar(10) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_by` varchar(50) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` varchar(50) NOT NULL,
  `labno` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `servicelogs`
--

CREATE TABLE `servicelogs` (
  `facilityId` varchar(50) NOT NULL,
  `id` int(11) NOT NULL,
  `date` varchar(255) DEFAULT NULL,
  `next_service_due_date` varchar(255) DEFAULT NULL,
  `createdAt` datetime DEFAULT current_timestamp(),
  `updatedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `servicelogs`
--

INSERT INTO `servicelogs` (`facilityId`, `id`, `date`, `next_service_due_date`, `createdAt`, `updatedAt`) VALUES
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 1, NULL, '2019-12-30', '2019-12-24 00:00:00', NULL);

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `facilityId` varchar(50) NOT NULL,
  `title` varchar(225) DEFAULT NULL,
  `description` varchar(225) DEFAULT NULL,
  `accHead` varchar(50) NOT NULL,
  `cost` varchar(7) DEFAULT '0',
  `service_id` int(11) NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`facilityId`, `title`, `description`, `accHead`, `cost`, `service_id`, `createdAt`) VALUES
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Staff Medical Bill', 'Companies', 'Income', '0', 23, '2019-12-21 11:39:03'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Consultations (Ortho, Neurosurgeon)', '', 'Income', '7000', 2, '2019-12-19 08:21:39'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Enema', '', 'Income', '5000', 3, '2019-12-19 08:23:10'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Surgery', '', 'Income', '0', 4, '2019-12-19 08:36:55'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Consultation (Regular)', '', 'Income', '3000', 6, '2019-12-20 01:58:14'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Registration (Single)', '', 'Income', '5000', 7, '2019-12-20 01:58:45'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Registration (Family)', '', 'Income', '7000', 8, '2019-12-20 01:59:09'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Consultation (Neurology)', '', 'Income', '8000', 9, '2019-12-20 01:59:49'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Consultation (Specialist) F/Up', '', 'Income', '6000', 10, '2019-12-20 02:00:41'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Consultation (Ortho, Neurosurgeon) F/Up', '', 'Income', '4000', 11, '2019-12-20 02:31:32'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Consultation (ENT)', '', 'Income', '8000', 12, '2019-12-20 02:35:19'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Consultation (Nephrology)', '', 'Income', '8000', 13, '2019-12-20 02:35:57'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Consultation (Psycharist)', '', 'Income', '8000', 14, '2019-12-20 02:36:39'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Consultation (Paediatrics)', '', 'Income', '6000', 15, '2019-12-20 02:37:07'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Consultation (Cardiology)', '', 'Income', '8000', 16, '2019-12-20 02:37:53'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Medication', 'Dispensed drugs, injection s and treatment', 'Income', '0', 24, '2019-12-22 02:08:36'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Wound Dressing (Minor)', '', 'Income', '1000', 19, '2019-12-20 02:39:05'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Wound Dressing (Major)', '', 'Income', '2000', 20, '2019-12-20 02:39:05'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'ECG', '', 'Income', '4000', 21, '2019-12-20 02:39:05'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'General Ward', '', 'Income', '7000', 25, '2019-12-22 03:15:36'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'House (White, Blue, Green)', '', 'Income', '19000', 26, '2019-12-22 03:16:59'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'PSC (0,1,2,3)', '', 'Income', '17000', 27, '2019-12-22 03:17:25'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Private (1, 2, Yellow)', '', 'Income', '12000', 28, '2019-12-22 03:17:57'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Professional Management', 'In-patient consultations', 'Income', '4000', 29, '2019-12-22 03:27:22'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Investigation', '', 'Income', '0', 30, '2019-12-22 03:50:36'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Consultation (Urology)', 'Payment before cosultation', 'Income', '8000', 31, '2019-12-22 11:17:33'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Consultation (Orthopedic)', 'Regular Orthopedic Consultation', 'Income', '7000', 32, '2019-12-23 03:52:27'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Orthopedic Registration (Family)', '', 'Income', '9000', 33, '2019-12-24 04:08:12'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Ear syringing', '', 'Income', '7000', 34, '2019-12-25 08:53:20'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Registration /Specialist Consultation (Family)', '', 'Income', '10000', 35, '2019-12-25 09:04:08'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'conversion of file', '', 'Income', '2000', 36, '2019-12-25 09:10:01'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Orthopedic Registration', '', 'Income', '7000', 37, '2019-12-25 09:13:16'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Uncology (Registration/Consultation)', '', 'Income', '8000', 38, '2019-12-26 06:00:06'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Laboratory (RBS)', '', 'Income', '500', 39, '2019-12-26 06:04:08'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Lab', '', 'Income', '0', 40, '2019-12-26 06:04:35'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Neurosurgeon (Registration)', '', 'Income', '7000', 42, '2019-12-27 06:35:36'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Urologist Registration', '', 'Income', '8000', 43, '2019-12-27 07:41:18'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Theatre fee', '', 'Income', '0', 44, '2019-12-29 05:45:01'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Implants', 'Screws and Rod', 'Income', '0', 45, '2019-12-29 05:48:29'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Nebulizer', '', 'Income', '0', 46, '2019-12-31 00:26:37'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Hospitalization Deposit', '', 'Income', '0', 47, '2020-01-01 11:16:05'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Orthopaedic F/up', 'Wages', 'Income', '4000', 48, '2020-01-02 10:47:42'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Admission', '', 'Income', '0', 49, '2020-01-03 09:29:05'),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'Specialist', 'First visit', 'Income', '8000', 50, '2020-01-04 11:10:25'),
('6c6af0c0-35ea-40d8-a928-b13a9766113a', 'Wound Dressing', '', 'Consultation', '2050', 53, '2020-07-15 13:56:59'),
('6c6af0c0-35ea-40d8-a928-b13a9766113a', 'Admission', '', 'Consultation', '3000', 54, '2020-07-15 13:57:17'),
('966a89f6-05d8-4564-b319-2f8863821e75', 'Admission', '', 'Other Income', '1000', 55, '2020-08-16 01:33:44');

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

--
-- Table structure for table `specimen`
--

CREATE TABLE `specimen` (
  `id` int(11) NOT NULL,
  `department` varchar(50) NOT NULL,
  `sample` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `facilityId` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `specimen`
--

INSERT INTO `specimen` (`id`, `department`, `sample`, `created_at`, `facilityId`) VALUES
(1, 'Hematology', 'Blood', '2020-10-16 01:44:33', '966a89f6-05d8-4564-b319-2f8863821e75'),
(2, 'Chemical Pathology', 'Swab', '2020-10-16 01:44:33', '966a89f6-05d8-4564-b319-2f8863821e75'),
(3, 'Hematology', 'EDTA Blood', '2020-10-16 01:44:40', '966a89f6-05d8-4564-b319-2f8863821e75'),
(4, 'Chemical Pathology', 'Serum Refrigerated', '2020-10-16 01:44:40', '966a89f6-05d8-4564-b319-2f8863821e75'),
(5, 'Hematology', 'Floride Fasting', '2020-10-16 01:50:17', '966a89f6-05d8-4564-b319-2f8863821e75'),
(6, 'Hematology', 'Urine', '2020-10-16 01:57:42', '966a89f6-05d8-4564-b319-2f8863821e75'),
(7, 'Chemical Pathology', 'Stool', '2020-10-16 01:57:42', '966a89f6-05d8-4564-b319-2f8863821e75');

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

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `id` int(11) NOT NULL,
  `Names` varchar(50) NOT NULL,
  `Address` varchar(100) NOT NULL,
  `role` varchar(100) NOT NULL,
  `Phone` varchar(30) NOT NULL,
  `code` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `suppliersinfo`
--

CREATE TABLE `suppliersinfo` (
  `facilityId` varchar(50) NOT NULL,
  `id` int(11) NOT NULL,
  `supplier_name` varchar(100) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `address` varchar(250) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  `balance` int(11) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `website` varchar(100) DEFAULT NULL,
  `supplier_code` varchar(55) DEFAULT NULL,
  `tinnumber` varchar(60) DEFAULT NULL,
  `supplier_type` varchar(100) DEFAULT NULL,
  `vat` varchar(80) DEFAULT NULL,
  `email` varchar(90) DEFAULT NULL,
  `version_id` varchar(100) DEFAULT NULL,
  `other_info` varchar(80) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `suppliersinfo`
--

INSERT INTO `suppliersinfo` (`facilityId`, `id`, `supplier_name`, `date`, `address`, `phone`, `code`, `balance`, `status`, `website`, `supplier_code`, `tinnumber`, `supplier_type`, `vat`, `email`, `version_id`, `other_info`) VALUES
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 1, 'Pfizer', '2024-08-10 14:23:29', 'Kano', '', NULL, NULL, NULL, '', '2e2b599c-1fbf-4727-8965-b43b3935a592', '0', '', '0', '', '', ''),
('052100000000', 2, 'Default', '2025-02-06 22:33:57', 'Kano', '09023231122', NULL, NULL, NULL, '', 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', '0', '', '0', '', '', ''),
('052100000001', 3, 'Default', '2025-02-07 06:59:14', 'Kano', '090', NULL, NULL, NULL, '', 'f4d670b1-65f5-489b-b171-d4df9be44ab7', '0', '', '0', '', '', ''),
('052100000003', 4, 'Drug Management Agency', '2025-02-15 15:28:30', '', '', NULL, NULL, NULL, '', 'dcdc3a08-06cd-4341-a288-5c32e907ef81', '0', '', '0', '', '', ''),
('052100000000', 5, 'New Supplier', '2025-02-16 14:33:16', '', '', NULL, NULL, NULL, '', '4b9720e3-f46d-48aa-9fd5-3da356b9945c', '0', '', '0', '', '', '');

--
-- Triggers `suppliersinfo`
--
DELIMITER $$
CREATE TRIGGER `after_supplier_edit` AFTER UPDATE ON `suppliersinfo` FOR EACH ROW BEGIN
    IF OLD.supplier_name <> new.supplier_name THEN
        INSERT INTO audit_trail(id,facilityId,	supplier_name, new_supplier_name,source_table)
        VALUES(old.id, old.facilityId, old.supplier_name,new.supplier_name,'suppliersinfo');
    END IF;
END
$$
DELIMITER ;

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

--
-- Table structure for table `supplier_entries`
--

CREATE TABLE `supplier_entries` (
  `entry_id` int(11) NOT NULL,
  `supplier_id` varchar(50) NOT NULL,
  `dr` int(11) NOT NULL,
  `cr` int(11) NOT NULL,
  `reference_no` varchar(50) NOT NULL,
  `facilityId` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `description` varchar(60) DEFAULT NULL,
  `truckNo` varchar(50) DEFAULT NULL,
  `waybillNo` varchar(50) DEFAULT NULL,
  `version_id` varchar(50) DEFAULT NULL,
  `cost_price` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `supplier_entries`
--

INSERT INTO `supplier_entries` (`entry_id`, `supplier_id`, `dr`, `cr`, `reference_no`, `facilityId`, `created_at`, `description`, `truckNo`, `waybillNo`, `version_id`, `cost_price`, `quantity`) VALUES
(1, '2e2b599c-1fbf-4727-8965-b43b3935a592', 20000, 0, '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2024-08-10 14:27:11', 'Pentazocine', '', '', '', 500, 40),
(2, '2e2b599c-1fbf-4727-8965-b43b3935a592', 15000, 0, '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2024-08-10 14:27:11', 'Ceftazidime', '', '', '', 300, 50),
(3, '2e2b599c-1fbf-4727-8965-b43b3935a592', 900000, 0, '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2025-01-31 12:32:52', 'Paracetamol tab', '', '', '', 10000, 90),
(4, 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', 30000, 0, '', '052100000000', '2025-02-06 22:34:36', 'Isoflurane', '', '', '', 600, 50),
(5, 'f4d670b1-65f5-489b-b171-d4df9be44ab7', 120000, 0, '', '052100000001', '2025-02-07 07:00:05', 'Ceftazidime', '', '', '', 600, 200),
(6, 'f4d670b1-65f5-489b-b171-d4df9be44ab7', 350000, 0, '', '052100000001', '2025-02-07 07:02:17', 'Midazolam', '', '', '', 500, 700),
(7, 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', 42000, 0, '', '052100000000', '2025-02-08 09:32:01', 'Pentazocine', '', '', '', 700, 60),
(8, 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', 100000, 0, '', '052100000000', '2025-02-08 09:33:50', 'ETT', '', '', '', 1000, 100),
(9, 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', 26400, 0, '', '052100000000', '2025-02-09 12:00:35', 'neostgimin iv', '', '', '', 600, 44),
(10, 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', 0, 0, '', '052100000000', '2025-02-14 14:41:01', 'Aminophylline inj 250mg', '', '', '', 0, 0),
(11, 'fbfe5c1e-f025-4079-9f74-1927ac7f2b78', 25000, 0, '', '052100000000', '2025-02-14 14:41:59', 'Flagyl 150mg', '', '', '', 500, 50),
(12, 'dcdc3a08-06cd-4341-a288-5c32e907ef81', 20000, 0, '', '052100000003', '2025-02-15 15:32:24', 'Pentazocine', '', '', '', 400, 50),
(13, 'dcdc3a08-06cd-4341-a288-5c32e907ef81', 20000, 0, '', '052100000003', '2025-02-15 15:32:24', 'Flagyl syr', '', '', '', 500, 40),
(14, '4b9720e3-f46d-48aa-9fd5-3da356b9945c', 44000, 0, '', '052100000000', '2025-02-16 14:37:04', 'Amoxicillin + Clav 625mg syr', '', '', '', 400, 110);

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

--
-- Table structure for table `surgeons_list`
--

CREATE TABLE `surgeons_list` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `type` varchar(50) NOT NULL,
  `facilityId` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_by` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `surgeons_list`
--

INSERT INTO `surgeons_list` (`id`, `name`, `type`, `facilityId`, `created_at`, `created_by`) VALUES
(1, 'Dr. Abdurrahman', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-09-04 07:42:09', '1'),
(11, 'Dr. Hassan Ismail', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-09-04 07:43:10', '1'),
(21, 'Dr. Nasiru Jinjiri', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-09-04 07:43:25', '1'),
(41, 'Dr. M. K. Abubakar', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-09-04 07:44:27', '1'),
(204, 'Dr Chiroma', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2022-07-11 12:12:35', 'abdurrahman'),
(71, 'Dr. Ibrahim Karofi', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-09-04 07:46:47', '1'),
(81, 'Dr. Dalhat Salahu', 'Anesthetists', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-09-04 07:47:10', '1'),
(228, 'Dr Aboki', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2024-05-18 14:40:33', 'abdurrahman'),
(101, 'Dr. Alfa', 'Anesthetists', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-09-04 07:47:43', '1'),
(121, 'Mal Ibrahim', 'Scrub Nurse', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-09-04 16:22:55', '5'),
(141, 'Dr Nasiru', 'Anesthetists', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-09-04 16:23:51', '5'),
(151, 'Dr Mukhtar Teli', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-09-06 15:49:08', '5'),
(161, 'Dr Musa Tauhid', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-09-06 16:16:27', '5'),
(171, 'Dr Garko', 'Anesthetists', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-09-06 16:16:45', '5'),
(194, 'Dr Abubakar Nagoma', 'Anesthetists', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-06-06 12:10:28', 'abdurrahman'),
(191, 'Dr Musa Ibrahim', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-09-06 16:18:06', '5'),
(193, 'Dr Ibrahim Abba', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-06-03 11:50:33', 'abdurrahman'),
(227, 'Yusuf Rufai', 'Scrub Nurse', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2024-04-23 17:12:00', 'abdurrahman'),
(197, 'Dr Mubarak', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-07-05 11:22:17', 'abdurrahman'),
(198, 'Dr Abubakar Musa', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-07-05 11:22:53', 'abdurrahman'),
(226, 'Dr Atiku Ayuba', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2024-04-23 17:05:22', 'abdurrahman'),
(200, 'Mal Jamilu', 'Anesthetists', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2021-08-29 14:24:34', 'abdurrahman'),
(203, 'Dr Umma Abubakar Isah', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2022-06-17 12:20:28', 'abdurrahman'),
(205, 'Dr Sadeeq Ibrahim Abdulsalam', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2022-08-11 15:19:24', 'abdurrahman'),
(207, 'Dr Oseni Ganiyu', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2022-08-11 15:20:31', 'abdurrahman'),
(211, 'Dr Salihi', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2022-11-06 05:55:01', 'abdurrahman'),
(212, 'Dr Mustapha', 'Anesthetists', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2022-11-06 05:55:11', 'abdurrahman'),
(230, 'Dr. Kabiru Usman Aliyu', 'Anesthetists', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2024-05-31 16:14:34', 'Manager'),
(214, 'Dr Mustapha Orthopedic', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2023-02-19 16:23:43', 'abdurrahman'),
(215, 'Dr Jameel Ismail', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2023-04-23 06:24:18', 'Manager'),
(217, 'Mal Sunusi', 'Scrub Nurse', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2023-09-06 10:46:32', 'abdurrahman'),
(218, 'Dr Ladan', 'Anesthetists', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2023-10-10 17:20:56', 'abdurrahman'),
(231, 'Zarah Galadima', 'Scrub Nurse', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2024-06-23 12:53:36', 'abdurrahman'),
(229, 'Dr. Saminu Mohammad', 'Surgeon', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2024-05-30 13:32:13', 'Manager');

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

--
-- Table structure for table `surgical_note`
--

CREATE TABLE `surgical_note` (
  `id` int(11) NOT NULL,
  `patient_id` varchar(20) NOT NULL,
  `patient_name` varchar(80) NOT NULL,
  `relative` varchar(80) NOT NULL,
  `agreed` varchar(6) NOT NULL,
  `witness_by` varchar(80) NOT NULL,
  `created_by` varchar(40) NOT NULL,
  `facilityId` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `surgical_note_temp`
--

CREATE TABLE `surgical_note_temp` (
  `id` int(11) NOT NULL,
  `template` varchar(4567) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `facilityId` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `surgical_note_temp`
--

INSERT INTO `surgical_note_temp` (`id`, `template`, `created_at`, `facilityId`) VALUES
(0, '<h1 style=\"text-align: center;\"><strong>&nbsp;<span style=\"font-size:36px\"><span style=\"font-family:Times New Roman,Times,serif\">PRIME SPECIALIST CLINIC, KANO</span></span></strong></h1>\r\n\r\n<p style=\"text-align: center;\"><strong><span style=\"font-family:Arial,Helvetica,sans-serif\"><span style=\"font-size:16pt\">19 Lamido Crescent, off Tarauni, Kano.</span></span></strong></p>\r\n\r\n<p style=\"text-align: right;\"><strong><span style=\"font-family:Arial,Helvetica,sans-serif\"><span style=\"font-size:16pt\">RC: 1285352</span></span></strong></p>\r\n\r\n<p style=\"text-align: center;\"><strong><span style=\"font-family:Times New Roman,Times,serif\"><span style=\"font-size:22pt\">SURGICAL CONSENT </span></span></strong></p>\r\n\r\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;I am signing this document with full knowledge of its contents. I absolutely agreed for the medical team to carry out all necessary investigations concerning (my/my wife&#39;s/relative&#39;s/child&#39;s) ailment including ultrasound scanning, lumber puncture, etc. and also to carry out surgical intervention on (me/my wife/my relative and/or child).</p>\r\n\r\n<p>I understood that during surgical procedures and anesthesia, there could be unforeseeable consequences and complications.</p>\r\n\r\n<p>I know that surgical procedures carry risks of bleeding, infection, cardiac disturbance and even negative outcomes. Prior to signing this consent, I (parent/relative) had a discussion with the (doctor/ doctors) and the (doctor/doctors) explained to (me/us) about (my/ my wife&#39;s/ my relative&#39;s/ child&#39;s) health&#39;s condition and on (form/ forms) of</p>\r\n\r\n<p>Treatments; explained what exactly would be done during the surgical manipulations; informed us on the other forms of treatment for this particular ailment and the advantage of the chosen treatment.</p>\r\n\r\n<p>(1/ we) understood that in some circumstances, there could be a need for a repeat surgical procedure in which I agreed. (I/ we) know that (I am/ we are) obliged to notify the (doctor/ doctors) about all health&#39;s problems including allergic reactions prior to and during post-surgical rehabilitations periods.</p>\r\n\r\n<p>In case of blood lost, I agreed for blood transfusion to (meet my wife/ my relative/ my child). In situation of blood deficit from blood banks, (me/ us) the relatives are informed and agreed/ ready to provide blood and other medications during surgery or during post-surgical rehabilitation.</p>\r\n', '2024-01-28 14:45:05', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(1, '<h1 style=\"text-align: center;\"><strong>&nbsp;<span style=\"font-size:36px\"><span style=\"font-family:Times New Roman,Times,serif\">PRIME SPECIALIST CLINIC, KANO</span></span></strong></h1>\n\n<p style=\"text-align: center;\"><strong><span style=\"font-family:Arial,Helvetica,sans-serif\"><span style=\"font-size:16pt\">19 Lamido Crescent, off Tarauni, Kano.</span></span></strong></p>\n\n<p style=\"text-align: right;\"><strong><span style=\"font-family:Arial,Helvetica,sans-serif\"><span style=\"font-size:16pt\">RC: 1285352</span></span></strong></p>\n\n<p style=\"text-align: center;\"><strong><span style=\"font-family:Times New Roman,Times,serif\"><span style=\"font-size:22pt\">SURGICAL CONSENT </span></span></strong></p>\n\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;I am signing this document with full knowledge of its contents. I absolutely agreed for the medical team to carry out all necessary investigations concerning (my/my wife&#39;s/relative&#39;s/child&#39;s) ailment including ultrasound scanning, lumber puncture, etc. and also to carry out surgical intervention on (me/my wife/my relative and/or child).</p>\n\n<p>I understood that during surgical procedures and anesthesia, there could be unforeseeable consequences and complications.</p>\n\n<p>I know that surgical procedures carry risks of bleeding, infection, cardiac disturbance and even negative outcomes. Prior to signing this consent, I (parent/relative) had a discussion with the (doctor/ doctors) and the (doctor/doctors) explained to (me/us) about (my/ my wife&#39;s/ my relative&#39;s/ child&#39;s) health&#39;s condition and on (form/ forms) of</p>\n\n<p>Treatments; explained what exactly would be done during the surgical manipulations; informed us on the other forms of treatment for this particular ailment and the advantage of the chosen treatment.</p>\n\n<p>(1/ we) understood that in some circumstances, there could be a need for a repeat surgical procedure in which I agreed. (I/ we) know that (I am/ we are) obliged to notify the (doctor/ doctors) about all health&#39;s problems including allergic reactions prior to and during post-surgical rehabilitations periods.</p>\n\n<p>In case of blood lost, I agreed for blood transfusion to (meet my wife/ my relative/ my child). In situation of blood deficit from blood banks, (me/ us) the relatives are informed and agreed/ ready to provide blood and other medications during surgery or during post-surgical rehabilitation.</p>\n\n<p>I fully understood the above document for which (I/we) agreed and signed</p>\n\n<p>Patient&#39;s Name ...........................................................................................................................</p>\n\n<p>Name (Patient&#39;s husband/wife/child/relatives)................................................................ Date................................................................................................</p>\n\n<p>Signature &hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;&hellip;..</p>\n\n<p>WITNESS BY ME (NAME/IN FULL)</p>\n\n<p>..................................................................................................................................................................................</p>\n\n<p>DATE...............................................................................................................................</p>\n\n<p>SIGNATURE................................................................................................................</p>\n', '2022-07-04 10:39:31', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a'),
(2, '<h1 style=\"text-align: center;\"><strong>&nbsp;<span style=\"font-size:36px\"><span style=\"font-family:Times New Roman,Times,serif\">PRIME SPECIALIST CLINIC, KANO</span></span></strong></h1>\r\n\r\n<p style=\"text-align: center;\"><strong><span style=\"font-family:Arial,Helvetica,sans-serif\"><span style=\"font-size:16pt\">19 Lamido Crescent, off Tarauni, Kano.</span></span></strong></p>\r\n\r\n<p style=\"text-align: right;\"><strong><span style=\"font-family:Arial,Helvetica,sans-serif\"><span style=\"font-size:16pt\">RC: 1285352</span></span></strong></p>\r\n\r\n<p style=\"text-align: center;\"><strong><span style=\"font-family:Times New Roman,Times,serif\"><span style=\"font-size:22pt\">SURGICAL CONSENT </span></span></strong></p>\r\n\r\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;I am signing this document with full knowledge of its contents. I absolutely agreed for the medical team to carry out all necessary investigations concerning (my/my wife&#39;s/relative&#39;s/child&#39;s) ailment including ultrasound scanning, lumber puncture, etc. and also to carry out surgical intervention on (me/my wife/my relative and/or child).</p>\r\n\r\n<p>I understood that during surgical procedures and anesthesia, there could be unforeseeable consequences and complications.</p>\r\n\r\n<p>I know that surgical procedures carry risks of bleeding, infection, cardiac disturbance and even negative outcomes. Prior to signing this consent, I (parent/relative) had a discussion with the (doctor/ doctors) and the (doctor/doctors) explained to (me/us) about (my/ my wife&#39;s/ my relative&#39;s/ child&#39;s) health&#39;s condition and on (form/ forms) of</p>\r\n\r\n<p>Treatments; explained what exactly would be done during the surgical manipulations; informed us on the other forms of treatment for this particular ailment and the advantage of the chosen treatment.</p>\r\n\r\n<p>(1/ we) understood that in some circumstances, there could be a need for a repeat surgical procedure in which I agreed. (I/ we) know that (I am/ we are) obliged to notify the (doctor/ doctors) about all health&#39;s problems including allergic reactions prior to and during post-surgical rehabilitations periods.</p>\r\n\r\n<p>In case of blood lost, I agreed for blood transfusion to (meet my wife/ my relative/ my child). In situation of blood deficit from blood banks, (me/ us) the relatives are informed and agreed/ ready to provide blood and other medications during surgery or during post-surgical rehabilitation.</p>\r\n', '2022-07-05 19:18:33', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a');

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

--
-- Table structure for table `test`
--

CREATE TABLE `test` (
  `id` int(11) NOT NULL,
  `description` varchar(50) NOT NULL,
  `debit` varchar(50) NOT NULL,
  `amount` int(11) NOT NULL,
  `credit` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Stand-in structure for view `test1`
-- (See below for the actual view)
--
CREATE TABLE `test1` (
`head` varchar(100)
,`subhead` varchar(50)
,`des` varchar(500)
,`acct` varchar(100)
,`debit` int(50)
,`credit` int(50)
,`description` varchar(225)
,`facilityId` varchar(50)
,`createdAt` date
,`transaction_date` date
,`transaction_id` int(11)
,`enteredBy` varchar(20)
,`receiptDateSN` varchar(50)
,`receiptNo` varchar(50)
,`modeOfPayment` varchar(50)
,`status` varchar(30)
,`approvedBy` varchar(20)
,`paymentStatus` varchar(11)
,`client_acct` varchar(200)
,`patient_id` varchar(50)
);

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `facilityId` varchar(50) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `transaction_id` int(11) NOT NULL,
  `transaction_date` date DEFAULT NULL,
  `description` varchar(225) DEFAULT NULL,
  `acct` varchar(100) DEFAULT NULL,
  `debit` int(50) DEFAULT NULL,
  `credit` int(50) DEFAULT NULL,
  `unit_price` double NOT NULL DEFAULT 0,
  `enteredBy` varchar(20) DEFAULT NULL,
  `receiptDateSN` varchar(50) NOT NULL DEFAULT '0',
  `receiptNo` varchar(50) DEFAULT NULL,
  `modeOfPayment` varchar(50) DEFAULT NULL,
  `bank_name` varchar(50) DEFAULT NULL,
  `status` varchar(30) DEFAULT 'pending',
  `approvedBy` varchar(20) DEFAULT NULL,
  `paymentStatus` varchar(11) NOT NULL DEFAULT '',
  `client_acct` varchar(200) DEFAULT NULL,
  `patient_id` varchar(50) DEFAULT NULL,
  `qty` varchar(20) DEFAULT NULL,
  `branch_name` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`facilityId`, `createdAt`, `transaction_id`, `transaction_date`, `description`, `acct`, `debit`, `credit`, `unit_price`, `enteredBy`, `receiptDateSN`, `receiptNo`, `modeOfPayment`, `bank_name`, `status`, `approvedBy`, `paymentStatus`, `client_acct`, `patient_id`, `qty`, `branch_name`) VALUES
('052100000000', '2025-02-06 21:58:09', 1, '2025-02-06', 'Laboratory: Pcv', '20026', 0, 100, 0, 'nasarawa', '250206224709', '250206224709', 'cash', '', 'completed', 'nasarawa', 'completed', '1', '1-2', '1', ''),
('052100000000', '2025-02-06 21:58:09', 2, '2025-02-06', 'Laboratory: Pcv', '400021', 100, 0, 0, 'nasarawa', '250206224709', '250206224709', 'cash', '', 'completed', 'nasarawa', 'completed', '1', '1-2', '1', ''),
('052100000000', '2025-02-06 10:59:53', 3, NULL, 'Deposit from account 2', '400022', 0, 0, 0, '', '250206225953', '250206225953', '', '', 'pending', NULL, '', '2', '2', NULL, NULL),
('052100000000', '2025-02-06 10:59:53', 4, NULL, 'Deposit from account 2', '500021', 0, 0, 0, '', '250206225953', '250206225953', '', '', 'pending', NULL, '', '2', '2', NULL, NULL),
('052100000000', '2025-02-06 11:10:44', 5, NULL, 'Deposit from account 3', '400022', 0, 0, 0, '', '250206231044', '250206231044', '', '', 'pending', NULL, '', '3', '3', NULL, NULL),
('052100000000', '2025-02-06 11:10:44', 6, NULL, 'Deposit from account 3', '500021', 0, 0, 0, '', '250206231044', '250206231044', '', '', 'pending', NULL, '', '3', '3', NULL, NULL),
('052100000000', '2025-02-06 11:16:26', 7, NULL, 'Deposit from account 4', '400022', 0, 0, 0, '', '250206231626', '250206231626', '', '', 'pending', NULL, '', '4', '4', NULL, NULL),
('052100000000', '2025-02-06 11:16:26', 8, NULL, 'Deposit from account 4', '500021', 0, 0, 0, '', '250206231626', '250206231626', '', '', 'pending', NULL, '', '4', '4', NULL, NULL),
('052100000000', '2025-02-06 11:26:31', 9, NULL, 'Deposit from account 5', '400022', 0, 0, 0, '', '250206232631', '250206232631', '', '', 'pending', NULL, '', '5', '5', NULL, NULL),
('052100000000', '2025-02-06 11:26:31', 10, NULL, 'Deposit from account 5', '500021', 0, 0, 0, '', '250206232631', '250206232631', '', '', 'pending', NULL, '', '5', '5', NULL, NULL),
('052100000000', '2025-02-07 01:11:40', 11, NULL, 'Deposit from account 6', '400022', 0, 0, 0, '', '25020711140', '25020711140', '', '', 'pending', NULL, '', '6', '6', NULL, NULL),
('052100000000', '2025-02-07 01:11:40', 12, NULL, 'Deposit from account 6', '500021', 0, 0, 0, '', '25020711140', '25020711140', '', '', 'pending', NULL, '', '6', '6', NULL, NULL),
('052100000000', '2025-02-07 02:32:57', 13, NULL, 'Deposit from account 7', '400022', 0, 0, 0, '', '25020723257', '25020723257', '', '', 'pending', NULL, '', '7', '7', NULL, NULL),
('052100000000', '2025-02-07 02:32:57', 14, NULL, 'Deposit from account 7', '500021', 0, 0, 0, '', '25020723257', '25020723257', '', '', 'pending', NULL, '', '7', '7', NULL, NULL),
('052100000000', '2025-02-07 02:34:47', 15, NULL, 'Deposit from account 8', '400022', 0, 0, 0, '', '25020723447', '25020723447', '', '', 'pending', NULL, '', '8', '8', NULL, NULL),
('052100000000', '2025-02-07 02:34:47', 16, NULL, 'Deposit from account 8', '500021', 0, 0, 0, '', '25020723447', '25020723447', '', '', 'pending', NULL, '', '8', '8', NULL, NULL),
('052100000000', '2025-02-07 02:39:54', 17, NULL, 'Deposit from account 9', '400022', 0, 0, 0, '', '25020723954', '25020723954', '', '', 'pending', NULL, '', '9', '9', NULL, NULL),
('052100000000', '2025-02-07 02:39:54', 18, NULL, 'Deposit from account 9', '500021', 0, 0, 0, '', '25020723954', '25020723954', '', '', 'pending', NULL, '', '9', '9', NULL, NULL),
('052100000000', '2025-02-07 02:41:05', 19, NULL, 'Deposit from account 10', '400022', 0, 0, 0, '', '25020724105', '25020724105', '', '', 'pending', NULL, '', '10', '10', NULL, NULL),
('052100000000', '2025-02-07 02:41:05', 20, NULL, 'Deposit from account 10', '500021', 0, 0, 0, '', '25020724105', '25020724105', '', '', 'pending', NULL, '', '10', '10', NULL, NULL),
('052100000000', '2025-02-07 02:41:58', 21, NULL, 'Deposit from account 11', '400022', 0, 0, 0, '', '25020724158', '25020724158', '', '', 'pending', NULL, '', '11', '11', NULL, NULL),
('052100000000', '2025-02-07 02:41:58', 22, NULL, 'Deposit from account 11', '500021', 0, 0, 0, '', '25020724158', '25020724158', '', '', 'pending', NULL, '', '11', '11', NULL, NULL),
('052100000000', '2025-02-07 02:44:13', 23, NULL, 'Deposit from account 12', '400022', 0, 0, 0, '', '25020724413', '25020724413', '', '', 'pending', NULL, '', '12', '12', NULL, NULL),
('052100000000', '2025-02-07 02:44:13', 24, NULL, 'Deposit from account 12', '500021', 0, 0, 0, '', '25020724413', '25020724413', '', '', 'pending', NULL, '', '12', '12', NULL, NULL),
('052100000001', '2025-02-07 07:53:46', 25, NULL, 'Deposit from account 1', '400022', 0, 0, 0, '', '25020775346', '25020775346', '', '', 'pending', NULL, '', '1', '1', NULL, NULL),
('052100000001', '2025-02-07 07:53:46', 26, NULL, 'Deposit from account 1', '500021', 0, 0, 0, '', '25020775346', '25020775346', '', '', 'pending', NULL, '', '1', '1', NULL, NULL),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2025-02-07 10:14:41', 27, NULL, 'Deposit from account 4', '400022', 0, 0, 0, '', '250207101441', '250207101441', '', '', 'pending', NULL, '', '4', '4', NULL, NULL),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2025-02-07 10:14:41', 28, NULL, 'Deposit from account 4', '500021', 0, 0, 0, '', '250207101441', '250207101441', '', '', 'pending', NULL, '', '4', '4', NULL, NULL),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2025-02-07 11:16:00', 29, NULL, 'Deposit from account 5', '400022', 0, 0, 0, '', '250207111600', '250207111600', '', '', 'pending', NULL, '', '5', '5', NULL, NULL),
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2025-02-07 11:16:00', 30, NULL, 'Deposit from account 5', '500021', 0, 0, 0, '', '250207111600', '250207111600', '', '', 'pending', NULL, '', '5', '5', NULL, NULL),
('052100000000', '2025-02-07 12:15:31', 31, NULL, 'Deposit from account 13', '400022', 0, 0, 0, '', '250207121530', '250207121530', '', '', 'pending', NULL, '', '13', '13', NULL, NULL),
('052100000000', '2025-02-07 12:15:31', 32, NULL, 'Deposit from account 13', '500021', 0, 0, 0, '', '250207121530', '250207121530', '', '', 'pending', NULL, '', '13', '13', NULL, NULL),
('052100000000', '2025-02-07 12:17:23', 33, NULL, 'Deposit from account 14', '400022', 0, 0, 0, '', '250207121723', '250207121723', '', '', 'pending', NULL, '', '14', '14', NULL, NULL),
('052100000000', '2025-02-07 12:17:23', 34, NULL, 'Deposit from account 14', '500021', 0, 0, 0, '', '250207121723', '250207121723', '', '', 'pending', NULL, '', '14', '14', NULL, NULL),
('052100000000', '2025-02-07 12:27:03', 35, NULL, 'Deposit from account 15', '400022', 0, 0, 0, 'nasarawa', '250207122703', '250207122703', '', '', 'pending', NULL, '', '15', '15', NULL, NULL),
('052100000000', '2025-02-07 12:27:03', 36, NULL, 'Deposit from account 15', '500021', 0, 0, 0, 'nasarawa', '250207122703', '250207122703', '', '', 'pending', NULL, '', '15', '15', NULL, NULL),
('052100000000', '2025-02-07 03:08:35', 37, NULL, 'Deposit from account 16', '400022', 0, 0, 0, 'nasarawa', '250207150835', '250207150835', '', '', 'pending', NULL, '', '16', '16', NULL, NULL),
('052100000000', '2025-02-07 03:08:35', 38, NULL, 'Deposit from account 16', '500021', 0, 0, 0, 'nasarawa', '250207150835', '250207150835', '', '', 'pending', NULL, '', '16', '16', NULL, NULL),
('052100000000', '2025-02-07 05:10:08', 39, NULL, 'Deposit from account 17', '400022', 0, 0, 0, 'nasarawa', '250207171008', '250207171008', '', '', 'pending', NULL, '', '17', '17', NULL, NULL),
('052100000000', '2025-02-07 05:10:08', 40, NULL, 'Deposit from account 17', '500021', 0, 0, 0, 'nasarawa', '250207171008', '250207171008', '', '', 'pending', NULL, '', '17', '17', NULL, NULL),
('052100000000', '2025-02-07 05:28:46', 41, NULL, 'Deposit from account 18', '400022', 0, 0, 0, 'nasarawa', '250207172846', '250207172846', '', '', 'pending', NULL, '', '18', '18', NULL, NULL),
('052100000000', '2025-02-07 05:28:46', 42, NULL, 'Deposit from account 18', '500021', 0, 0, 0, 'nasarawa', '250207172846', '250207172846', '', '', 'pending', NULL, '', '18', '18', NULL, NULL),
('052100000000', '2025-02-07 06:09:52', 43, NULL, 'Deposit from account 19', '400022', 0, 0, 0, 'nasarawa', '250207180952', '250207180952', '', '', 'pending', NULL, '', '19', '19', NULL, NULL),
('052100000000', '2025-02-07 06:09:52', 44, NULL, 'Deposit from account 19', '500021', 0, 0, 0, 'nasarawa', '250207180952', '250207180952', '', '', 'pending', NULL, '', '19', '19', NULL, NULL);

--
-- Triggers `transactions`
--
DELIMITER $$
CREATE TRIGGER `set_txn_date` BEFORE INSERT ON `transactions` FOR EACH ROW BEGIN
    		IF (isnull(new.createdAt)) THEN
    			SET NEW.createdAt=CURDATE();
            END IF;
        END
$$
DELIMITER ;

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

--
-- Table structure for table `transactions3`
--

CREATE TABLE `transactions3` (
  `facilityId` varchar(50) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `transaction_id` int(11) NOT NULL,
  `transaction_date` date DEFAULT NULL,
  `id` int(11) NOT NULL,
  `description` varchar(225) DEFAULT NULL,
  `acct` varchar(100) DEFAULT NULL,
  `acct_name` varchar(300) NOT NULL,
  `debit` int(50) DEFAULT NULL,
  `credit` int(50) DEFAULT NULL,
  `enteredBy` varchar(20) DEFAULT NULL,
  `receiptDateSN` varchar(18) NOT NULL DEFAULT '0',
  `receiptNo` int(7) DEFAULT 0,
  `modeOfPayment` varchar(15) DEFAULT NULL,
  `bank_name` varchar(50) NOT NULL,
  `status` varchar(50) DEFAULT 'Pending Lab',
  `approvedBy` varchar(20) DEFAULT NULL,
  `paymentStatus` varchar(11) NOT NULL DEFAULT '',
  `client_acct` varchar(11) DEFAULT NULL,
  `patient_id` varchar(50) NOT NULL,
  `settlement_status` varchar(50) NOT NULL,
  `client_id` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transactions3`
--

INSERT INTO `transactions3` (`facilityId`, `createdAt`, `transaction_id`, `transaction_date`, `id`, `description`, `acct`, `acct_name`, `debit`, `credit`, `enteredBy`, `receiptDateSN`, `receiptNo`, `modeOfPayment`, `bank_name`, `status`, `approvedBy`, `paymentStatus`, `client_acct`, `patient_id`, `settlement_status`, `client_id`) VALUES
('1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2025-01-27 06:23:20', 0, '2025-01-27', 0, 'Registration ( Family )', '20002', 'REGISTRATION', 0, 0, 'abdurrahman', '250127125357', 2147483647, 'CASH', '', 'Pending Lab', NULL, '', '20002', '9-1', '', 0);

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

--
-- Table structure for table `transactionsetup`
--

CREATE TABLE `transactionsetup` (
  `id` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `debit` varchar(50) NOT NULL,
  `credit` varchar(50) NOT NULL,
  `facilityId` varchar(50) NOT NULL,
  `createdBy` varchar(50) NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `transactionsetup`
--

INSERT INTO `transactionsetup` (`id`, `title`, `debit`, `credit`, `facilityId`, `createdBy`, `createdAt`) VALUES
(8, 'Payment from somewhere else', 'Hematology', 'Trade Payable', '966a89f6-05d8-4564-b319-2f8863821e75', '41', '2020-08-15 05:03:14'),
(9, '', 'Revenue', 'Cash', '6c6af0c0-35ea-40d8-a928-b13a9766113a', '40', '2020-08-17 00:13:26'),
(10, '', 'Registration & Testing fees', 'Cash', '966a89f6-05d8-4564-b319-2f8863821e75', '41', '2020-08-28 02:36:52');

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

--
-- Table structure for table `transaction_backup`
--

CREATE TABLE `transaction_backup` (
  `facilityId` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `transaction_id` int(11) NOT NULL DEFAULT 0,
  `id` int(11) NOT NULL,
  `description` varchar(225) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `acct` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `debit` int(50) DEFAULT NULL,
  `credit` int(50) DEFAULT NULL,
  `enteredBy` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `receiptDateSN` varchar(18) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `receiptNo` int(7) DEFAULT 0,
  `modeOfPayment` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `status` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'pending',
  `approvedBy` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `paymentStatus` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `client_acct` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `patient_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `transaction_entries`
--

CREATE TABLE `transaction_entries` (
  `id` int(11) NOT NULL,
  `transaction_date` date NOT NULL,
  `patient_id` varchar(20) NOT NULL,
  `patient_name` varchar(200) NOT NULL,
  `receivable_head` varchar(20) NOT NULL,
  `receivable_head_name` varchar(100) NOT NULL,
  `total_amount` int(11) NOT NULL,
  `amount_paid` int(11) NOT NULL,
  `balance` int(11) NOT NULL,
  `receiptNo` varchar(50) NOT NULL,
  `entries_status` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Stand-in structure for view `transaction_view`
-- (See below for the actual view)
--
CREATE TABLE `transaction_view` (
`facilityId` int(1)
,`createdAt` int(1)
,`acct` int(1)
,`debit` int(1)
,`description` int(1)
,`patient_id` int(1)
);

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

--
-- Stand-in structure for view `transaction_view2`
-- (See below for the actual view)
--
CREATE TABLE `transaction_view2` (
`date` int(1)
,`drug` int(1)
,`quantity` int(1)
,`price` int(1)
,`profit` int(1)
,`amount` int(1)
,`facilityId` int(1)
);

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

--
-- Table structure for table `transfers`
--

CREATE TABLE `transfers` (
  `id` int(11) NOT NULL,
  `facilityId` varchar(50) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `amountReceived` int(12) NOT NULL DEFAULT 0,
  `amountHandedOver` int(12) DEFAULT 0,
  `transfer_from` varchar(50) NOT NULL,
  `transfer_to` varchar(50) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'pending',
  `comment` varchar(500) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `transfers`
--

INSERT INTO `transfers` (`id`, `facilityId`, `date`, `amountReceived`, `amountHandedOver`, `transfer_from`, `transfer_to`, `status`, `comment`) VALUES
(1, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-02-03 08:49:08', 0, 4000, 'Manager', 'Kemi', 'pending', '02-02-2020 / cash in'),
(2, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-02-05 09:54:39', 0, 129200, 'Patience', 'Manager', 'pending', 'Yesterday\'s day cash'),
(3, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-02-05 09:55:57', 0, 75200, 'Manager', 'Patience', 'pending', 'Today cash'),
(4, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-02-16 09:38:19', 0, 62000, 'Kemi', 'Manager', 'pending', '15-02 CASH IN'),
(5, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-03-14 14:50:51', 0, 50000, 'Manager', 'Kemi', 'pending', 'test'),
(6, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '2020-03-14 14:51:20', 0, 30000, 'Manager', 'abdurrahman', 'pending', 'netest'),
(7, 'b8823207-58e1-438c-bb62-f3c6c16d8d3d', '2020-03-19 14:51:59', 0, 1, 'isahboy01', 'isahboy01', 'pending', '');

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

--
-- Stand-in structure for view `trialbalance`
-- (See below for the actual view)
--
CREATE TABLE `trialbalance` (
`head` int(1)
,`subhead` int(1)
,`des` int(1)
,`acct` int(1)
,`description` int(1)
,`debit` int(1)
,`credit` int(1)
,`createdAt` int(1)
,`date` int(1)
,`facilityId` int(1)
);

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

--
-- Stand-in structure for view `trial_balance`
-- (See below for the actual view)
--
CREATE TABLE `trial_balance` (
`acct` varchar(100)
,`narration` varchar(225)
,`Acct_source` varchar(500)
,`parent_account` varchar(500)
,`debit` int(50)
,`credit` int(50)
,`facilityId` varchar(50)
,`createdAt` date
,`created_at` date
,`enteredBy` varchar(20)
,`receiptDateSN` varchar(50)
,`receiptNo` varchar(50)
,`modeOfPayment` varchar(50)
,`client_acct` varchar(200)
);

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

--
-- Table structure for table `t_patientr`
--

CREATE TABLE `t_patientr` (
  `cc` bigint(21) NOT NULL,
  `id` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `firstname` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `surname` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `other` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `t_patientr`
--

INSERT INTO `t_patientr` (`cc`, `id`, `firstname`, `surname`, `other`) VALUES
(15, '-', 'Fatima', 'Suleman', ''),
(2, '1-1', 'Musa', 'Ibrahim', ''),
(2, '2-1', 'Hassan', 'Ismail', ''),
(2, '2551-15', 'Hua', 'Ding', 'Li'),
(2, '299-8', 'Abubakar', 'Amina', ''),
(2, '30-1', 'Usman', 'Mai Aliyu', 'Mai'),
(2, '3004-1', 'Mukhtar', 'Muhammad', ''),
(2, '314-12', 'Abdullahi', 'Hafsat', ''),
(2, '3151-1', 'Hafsat', 'Sabiu', ''),
(2, '4060-1', 'Idris', 'Asmau', 'undefined'),
(2, '4160-1', 'Godwin', 'Ogwuche', ''),
(4, '4347-1', 'Wonah', 'Abraham', 'undefined'),
(2, '4473-1', 'Hani', 'Okan', 'undefined'),
(2, '45-6', 'Adnan', 'Muhammad', ''),
(2, '4685-1', 'Jamilu', 'Yakudima', ''),
(2, '4691-1', 'Mariya', 'Abubakar', ''),
(2, '4708-1', 'Payment', 'Instant', NULL),
(2, '5184-1', 'RUFAI', 'GARBA', ''),
(2, '5312-1', 'Justice Nura', 'Sagir Umar', ''),
(2, '5479-1', 'Saudah', 'Ismail', ''),
(2, '5781-1', 'Mukaddas', 'Babangida', ''),
(2, '6198-1', 'Samadi', 'Aya', NULL),
(2, '6279-1', 'Musa', 'Sani', ''),
(2, '6330-1', 'Lawal', 'Umar', ''),
(2, '6356-4', 'Shehu', 'Hadiza', ''),
(2, '6608-1', 'Mustapha', '', NULL),
(2, '96-17', 'Ahmad', 'Ali', 'Sadi'),
(6, 'undefined', 'undefined', 'undefined', 'undefined');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `firstname` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `privilege` int(11) DEFAULT 4,
  `role` varchar(255) DEFAULT NULL,
  `speciality` varchar(50) DEFAULT NULL,
  `accessTo` varchar(255) DEFAULT NULL,
  `functionalities` varchar(2000) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `prefix` varchar(50) DEFAULT NULL,
  `userType` varchar(10) DEFAULT NULL,
  `serviceCost` varchar(10) DEFAULT NULL,
  `licenceNo` varchar(50) DEFAULT NULL,
  `placeOfWork` varchar(100) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `status` varchar(20) DEFAULT 'pending',
  `loggedIn` varchar(200) DEFAULT NULL,
  `availableDays` varchar(200) DEFAULT NULL,
  `availableFromTime` varchar(20) DEFAULT NULL,
  `availableToTime` varchar(20) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `paymentMethod` varchar(50) DEFAULT NULL,
  `paymentAmount` int(11) DEFAULT NULL,
  `referralId` varchar(50) DEFAULT NULL,
  `lastLogin` varchar(20) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `facilityId` varchar(50) NOT NULL,
  `createdBy` varchar(50) DEFAULT NULL,
  `department` varchar(50) DEFAULT NULL,
  `functionality` varchar(2000) DEFAULT NULL,
  `branch_name` varchar(50) DEFAULT NULL,
  `lga` varchar(100) DEFAULT NULL,
  `applicate_status` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `firstname`, `lastname`, `privilege`, `role`, `speciality`, `accessTo`, `functionalities`, `username`, `email`, `prefix`, `userType`, `serviceCost`, `licenceNo`, `placeOfWork`, `password`, `status`, `loggedIn`, `availableDays`, `availableFromTime`, `availableToTime`, `address`, `phone`, `paymentMethod`, `paymentAmount`, `referralId`, `lastLogin`, `image`, `createdAt`, `updatedAt`, `facilityId`, `createdBy`, `department`, `functionality`, `branch_name`, `lga`, `applicate_status`) VALUES
(5, 'Abdurrahman', 'Nasir', 8, 'Doctor', 'Neurosurgery', 'Dashboard,Records,Accounts,Admin,Doctors,Theater,Laboratory,Reports,Pharmacy,Nurse,Management,Kirs', '', 'abdurrahman', 'drmuhsin@live.com', 'AN', 'admin', 'null', NULL, NULL, '$2a$10$mPqL/ehjm7v5UIy0pG9FFeWa1vfzfWo05.KyYHn/L3hmjoF8yM0vS', 'approved', NULL, 'Monday,Tuesday,Wednesday', '12:00', '16:00', 'Kano', '090', NULL, NULL, NULL, NULL, 'public\\1666117684695-download - Copy.jpg', '2019-12-06 04:14:07', '2022-10-18 18:28:04', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', NULL, '6', 'Add New Patient,Bed Allocation,Hospital Billings,Create a Client Account,Make Deposit,Record Expenses,Generate Account Report,Account Statement,Asset Register,Rent Register,Create/Edit Services,Setup Account Chart,Cash Handover,Create User,Manage Users,Settings,Patient List,Appointments,Consultations,Lab Results,Video Chat,Add New Account Note,Setup Lab Test,Registrations,Report Summary,Inventory Overview,Analytics,Daily Sales,Profit,Suppliers Overview,Drug Sales,Drug Dispensary,Store Record,Returned Drugs,Manage Suppliers,Drug List,Sample Analysis,Account Review,Drug Schedule,Nursing Report,In-Patient Vitals,In-Patients,Out-Patient Prescriptions,Nursing Requests,Opening Balance,Other Incomes,Discount Setup,Pending Discount Requests,Purchase Record,Bookings,Messages,Integration, HMO Patient Report, HMO Billing Report,Dashboard', NULL, NULL, ''),
(877, 'Sadiq', 'Haruna', 4, 'Doctor', NULL, 'Dashboard,Records,Accounts,Admin,Laboratory', NULL, 'reignsb', 'harunakadiri702@gmail.com', NULL, NULL, NULL, NULL, NULL, '$2a$10$GfJ.S70T8RXlydsPXDPiTeY/65pl.dzdoQ8yhXHHDbkGkuQwtGBsa', 'approved', NULL, NULL, NULL, NULL, NULL, '07032151593', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '23311111', 'admin', NULL, 'Add New Patient,Bed Allocation,Hospital Billings,Create a Client Account,Make Deposit,Record Expenses,Generate Account Report,Account Statement,Asset Register,Rent Register,Create/Edit Services,Setup Account Chart,Cash Handover,Create User,Manage Users,Settings,Patient List,Appointments,Consultations,Lab Results,Video Chat,Add New Account Note,Setup Lab Test,Registrations,Report Summary,Inventory Overview,Analytics,Daily Sales,Profit,Suppliers Overview,Drug Sales,Drug Dispensary,Store Record,Returned Drugs,Manage Suppliers,Drug List,Sample Analysis,Account Review,Drug Schedule,Nursing Report,In-Patient Vitals,In-Patients,Out-Patient Prescriptions,Nursing Requests,Opening Balance,Other Incomes,Discount Setup,Pending Discount Requests,Purchase Record,Bookings,Messages,Integration, HMO Patient Report, HMO Billing Report,Dashboard', NULL, NULL, ''),
(878, 'nasarawa', 'user', 4, 'Doctor', NULL, 'Dashboard,Records,Accounts,Admin,Doctors,Theater,Laboratory,Reports,Pharmacy,Nurse,Management', NULL, 'nasarawa', 'nasarawa@gmail.com', NULL, NULL, NULL, NULL, NULL, '$2a$10$vq2YV1V8vIGCuNsUsvQsWeRDH9s/xcUfb/qCiGda8nass1vb01G9K', 'approved', NULL, NULL, NULL, NULL, NULL, '09012121212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '052100000000', 'admin', '6', 'Add New Patient,Bed Allocation,Hospital Billings,Create a Client Account,Make Deposit,Record Expenses,Generate Account Report,Account Statement,Asset Register,Rent Register,Create/Edit Services,Setup Account Chart,Cash Handover,Create User,Manage Users,Settings,Patient List,Appointments,Consultations,Lab Results,Video Chat,Add New Account Note,Setup Lab Test,Registrations,Report Summary,Inventory Overview,Analytics,Daily Sales,Profit,Suppliers Overview,Drug Sales,Drug Dispensary,Store Record,Returned Drugs,Manage Suppliers,Drug List,Sample Analysis,Account Review,Drug Schedule,Nursing Report,In-Patient Vitals,In-Patients,Out-Patient Prescriptions,Nursing Requests,Opening Balance,Other Incomes,Discount Setup,Pending Discount Requests,Purchase Record,Bookings,Messages,Integration, HMO Patient Report, HMO Billing Report,Dashboard', NULL, NULL, ''),
(879, 'Murtala', 'User', 4, 'Doctor', NULL, 'Dashboard,Records,Accounts,Admin,Doctors,Theater,Laboratory,Reports,Pharmacy,Nurse,Management', NULL, 'murtala', 'murtala@gmail.com', NULL, NULL, NULL, NULL, NULL, '$2a$10$16T/hTjfQ.gqOjlPVI410O8jFJIxcwu6FqhH65Av3k6v7KYSgwChm', 'approved', NULL, NULL, NULL, NULL, NULL, '09012121212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '052100000001', 'admin', '8', 'Add New Patient,Bed Allocation,Hospital Billings,Create a Client Account,Make Deposit,Record Expenses,Generate Account Report,Account Statement,Asset Register,Rent Register,Create/Edit Services,Setup Account Chart,Cash Handover,Create User,Manage Users,Settings,Patient List,Appointments,Consultations,Lab Results,Video Chat,Add New Account Note,Setup Lab Test,Registrations,Report Summary,Inventory Overview,Analytics,Daily Sales,Profit,Suppliers Overview,Drug Sales,Drug Dispensary,Store Record,Returned Drugs,Manage Suppliers,Drug List,Sample Analysis,Account Review,Drug Schedule,Nursing Report,In-Patient Vitals,In-Patients,Out-Patient Prescriptions,Nursing Requests,Opening Balance,Other Incomes,Discount Setup,Pending Discount Requests,Purchase Record,Bookings,Messages,Integration, HMO Patient Report, HMO Billing Report,Dashboard', NULL, NULL, ''),
(880, 'admin', 'user', 4, 'Doctor', NULL, 'Kirs,Accounts,Admin,Reports', NULL, 'admin', 'nasarawa@gmail.com', NULL, NULL, NULL, NULL, NULL, '$2a$10$vq2YV1V8vIGCuNsUsvQsWeRDH9s/xcUfb/qCiGda8nass1vb01G9K', 'approved', NULL, NULL, NULL, NULL, NULL, '09012121212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '052100000000', 'admin', '6', 'Add New Patient,Bed Allocation,Hospital Billings,Create a Client Account,Make Deposit,Record Expenses,Generate Account Report,Account Statement,Asset Register,Rent Register,Create/Edit Services,Setup Account Chart,Cash Handover,Create User,Manage Users,Settings,Patient List,Appointments,Consultations,Lab Results,Video Chat,Add New Account Note,Setup Lab Test,Registrations,Report Summary,Inventory Overview,Analytics,Daily Sales,Profit,Suppliers Overview,Drug Sales,Drug Dispensary,Store Record,Returned Drugs,Manage Suppliers,Drug List,Sample Analysis,Account Review,Drug Schedule,Nursing Report,In-Patient Vitals,In-Patients,Out-Patient Prescriptions,Nursing Requests,Opening Balance,Other Incomes,Discount Setup,Pending Discount Requests,Purchase Record,Bookings,Messages,Integration, HMO Patient Report, HMO Billing Report,Dashboard', NULL, NULL, ''),
(881, 'sadiq', 'sadiq', 4, 'Doctor', 'doc', 'Reports,Appointments,Inventory,Nurse', NULL, 'sadiq', 'sadiq@gmail.com', NULL, NULL, NULL, NULL, NULL, '$2a$10$FYE6BGhH9GtNjFMXetJBIOTyzukYvAo.d.V6wiGmdEcRShnCr6KXm', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'https://res.cloudinary.com/emaitee/image/upload/v1593618169/mylikita/profile_images/docAvater.png', '2025-02-13 15:19:12', '2025-02-13 15:19:12', '052100000000', 'nasarawa', '10', 'Report Summary,Inventory Overview,Analytics,Daily Sales,Profit,Suppliers Overview,Store Management,Requisition,Manage Suppliers,Purchase Other,Inventory Table,Goods Transfer Form,Item Description,GRN,In-Patient Vitals,Drug Schedule,Nursing Requests,Out-Patient Prescriptions,Nursing Report', NULL, NULL, ''),
(882, 'Testing', 'Neq ', 4, 'Cashier', '', 'Reports,Accounts', NULL, 'neq', 'some@gmail.com', NULL, NULL, NULL, NULL, NULL, '$2a$10$fVTUepk7XUacO2PJH2YuV.2do6cymYeSANj12vJQh3qKSBfe3TMIe', 'approved ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'https://res.cloudinary.com/emaitee/image/upload/v1593618169/mylikita/profile_images/docAvater.png', '2025-02-13 16:06:10', '2025-02-13 16:06:56', '052100000000', 'nasarawa', '11', 'Report Summary', NULL, NULL, ''),
(883, 'Muhammad', 'Buhari', 4, 'Doctor', NULL, 'Dashboard,Records,Accounts,Admin,Doctors,Theater,Laboratory,Reports,Pharmacy,Nurse,Management', NULL, 'buhari', 'buhari@gmail.com', NULL, NULL, NULL, NULL, NULL, '$2a$10$T3HR5sa6d3fHlmVG9LLMceuioeixPbeY.RPRw4Y8fRx4l0zMokt0i', 'approved', NULL, NULL, NULL, NULL, NULL, '09017901953', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '052100000003', 'admin', NULL, 'Add New Patient,Bed Allocation,Hospital Billings,Create a Client Account,Make Deposit,Record Expenses,Generate Account Report,Account Statement,Asset Register,Rent Register,Create/Edit Services,Setup Account Chart,Cash Handover,Create User,Manage Users,Settings,Patient List,Appointments,Consultations,Lab Results,Video Chat,Add New Account Note,Setup Lab Test,Registrations,Report Summary,Inventory Overview,Analytics,Daily Sales,Profit,Suppliers Overview,Drug Sales,Drug Dispensary,Store Record,Returned Drugs,Manage Suppliers,Drug List,Sample Analysis,Account Review,Drug Schedule,Nursing Report,In-Patient Vitals,In-Patients,Out-Patient Prescriptions,Nursing Requests,Opening Balance,Other Incomes,Discount Setup,Pending Discount Requests,Purchase Record,Bookings,Messages,Integration, HMO Patient Report, HMO Billing Report,Dashboard', NULL, NULL, ''),
(884, 'Card', 'Cashier', 4, 'Billing Officer', '', 'Accounts', NULL, 'card', 'card@gm.com', NULL, NULL, NULL, NULL, NULL, '$2a$10$MlqkyUyKtaOksoq8JNAPVOtzNwb7Gyb4sKH0UGHHnWcTZwA1J8miC', 'approved ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'https://res.cloudinary.com/emaitee/image/upload/v1593618169/mylikita/profile_images/docAvater.png', '2025-02-15 12:46:17', '2025-02-15 13:04:24', '052100000003', 'buhari', '12', 'Other Incomes', NULL, NULL, ''),
(885, 'Lab', 'Biller', 4, 'Billing Officer', '', 'Accounts', NULL, 'lab', 'lab@biller.com', NULL, NULL, NULL, NULL, NULL, '$2a$10$rI1eMGcrdZagqVP1zcy07.wI4yoBUGAz8BMnJxmaAJE9pakJBflDi', 'approved ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'https://res.cloudinary.com/emaitee/image/upload/v1593618169/mylikita/profile_images/docAvater.png', '2025-02-15 13:04:11', '2025-02-15 13:04:21', '052100000003', 'buhari', '13', 'Other Incomes', NULL, NULL, ''),
(886, 'Pharmacy', 'Biller', 4, 'Billing Officer', '', 'Pharmacy', NULL, 'pharmacy', 'pharmacy@gmaillcom', NULL, NULL, NULL, NULL, NULL, '$2a$10$EtdIx2/CyFigrxK.1lCD7uVE1I4vnyeeCOXxTacd8QiXBj6FwGQT6', 'approved ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'https://res.cloudinary.com/emaitee/image/upload/v1593618169/mylikita/profile_images/docAvater.png', '2025-02-15 15:16:26', '2025-02-15 15:17:04', '052100000003', 'buhari', '16', 'Other Incomes', NULL, NULL, ''),
(887, 'Muhammad', 'Test', 4, NULL, NULL, 'PHIMA', NULL, 'moh', 'Saifullahmoriki@gmail.com', NULL, NULL, NULL, NULL, NULL, '$2a$10$MKWNnRQZjWvU.Wzyavv3Xuw8tk4SZe4l07Lzlk9NRCTEElUrku4oe', 'approved', NULL, NULL, NULL, NULL, NULL, '09011223344', NULL, NULL, NULL, NULL, 'https://res.cloudinary.com/emaitee/image/upload/v1593618169/mylikita/profile_images/docAvater.png', '2025-02-16 13:26:51', '2025-02-16 13:26:51', 'PHIMA', NULL, NULL, 'Application Status,Pending application', NULL, 'Kura', 'PHIMA'),
(888, 'Muhammad', 'Test', 4, NULL, NULL, 'PHIMA', NULL, 'admin_phima', 'Saifullahmoriki@gmail.com', NULL, NULL, NULL, NULL, NULL, '$2a$10$MKWNnRQZjWvU.Wzyavv3Xuw8tk4SZe4l07Lzlk9NRCTEElUrku4oe', 'approved', NULL, NULL, NULL, NULL, NULL, '09011223344', NULL, NULL, NULL, NULL, 'https://res.cloudinary.com/emaitee/image/upload/v1593618169/mylikita/profile_images/docAvater.png', '2025-02-16 13:26:51', '2025-02-16 13:26:51', 'PHIMA', NULL, NULL, 'Application Status,Pending application', NULL, 'Kura', 'Pending'),
(889, 'Salam', 'Musa', 4, NULL, NULL, 'PHIMA', NULL, 'salam', 'buhari1@gmail.com', NULL, NULL, NULL, NULL, NULL, '$2a$10$cAstoXOvXF4QqhD9LoXoAedC.VWNlhr.MaYeoN6tkN7POeg92..Ma', 'pending', NULL, NULL, NULL, NULL, NULL, '09011223344', NULL, NULL, NULL, NULL, 'https://res.cloudinary.com/emaitee/image/upload/v1593618169/mylikita/profile_images/docAvater.png', '2025-02-16 13:33:51', '2025-02-16 13:33:51', 'PHIMA', NULL, NULL, 'Application Status,Pending application', NULL, 'Kura', 'Pending');

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

--
-- Table structure for table `vital_signs`
--

CREATE TABLE `vital_signs` (
  `id` int(11) NOT NULL,
  `patient_id` varchar(50) NOT NULL,
  `body_temp` varchar(5) DEFAULT NULL,
  `pulse_rate` varchar(10) DEFAULT NULL,
  `blood_pressure` varchar(10) DEFAULT NULL,
  `respiratory_rate` varchar(10) DEFAULT NULL,
  `fasting_blood_sugar` varchar(10) DEFAULT NULL,
  `random_blood_sugar` varchar(10) DEFAULT NULL,
  `spo2` varchar(50) DEFAULT NULL,
  `created_by` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `facilityId` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vital_signs`
--

INSERT INTO `vital_signs` (`id`, `patient_id`, `body_temp`, `pulse_rate`, `blood_pressure`, `respiratory_rate`, `fasting_blood_sugar`, `random_blood_sugar`, `spo2`, `created_by`, `created_at`, `facilityId`) VALUES
(1, '1-1', '35', '123', '434', '23', '212', '12', '30', 'abdurrahman', '2024-08-10 03:08:22', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a');

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

--
-- Table structure for table `voucher`
--

CREATE TABLE `voucher` (
  `vo_No` int(11) NOT NULL,
  `debit` varchar(40) NOT NULL,
  `Amount` int(11) NOT NULL,
  `credit` varchar(40) NOT NULL,
  `description` varchar(50) NOT NULL,
  `authorizedby` varchar(40) NOT NULL,
  `approveBy` varchar(40) NOT NULL,
  `PatientAcct` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `wholesale_transaction`
--

CREATE TABLE `wholesale_transaction` (
  `id` char(36) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `date` varchar(100) NOT NULL,
  `time` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `phone_no` varchar(50) DEFAULT NULL,
  `unit` int(11) DEFAULT NULL,
  `amount` varchar(50) NOT NULL,
  `type` varchar(20) NOT NULL,
  `giver` varchar(100) DEFAULT NULL,
  `reciever` varchar(100) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Structure for view `bedlist_view`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `bedlist_view`  AS SELECT 1 AS `id`, 1 AS `sort_index`, 1 AS `class_type`, 1 AS `price`, 1 AS `name`, 1 AS `no_of_beds`, 1 AS `occupied`, 1 AS `facilityId` ;

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

--
-- Structure for view `drug_schedule_view`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `drug_schedule_view`  AS SELECT 1 AS `drug`, 1 AS `dosage`, 1 AS `patient_id`, 1 AS `created_at`, 1 AS `id`, 1 AS `prescription_id`, 1 AS `prescribed_by`, 1 AS `duration`, 1 AS `period`, 1 AS `frequency`, 1 AS `route`, 1 AS `time_stamp`, 1 AS `administered_by`, 1 AS `served_by`, 1 AS `reason`, 1 AS `status`, 1 AS `facilityId` ;

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

--
-- Structure for view `expenditure_view`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `expenditure_view`  AS SELECT 1 AS `subhead`, 1 AS `description`, 1 AS `modeOfPayment`, 1 AS `acct`, 1 AS `createdAt`, 1 AS `amount`, 1 AS `facilityId`, 1 AS `client_acct`, 1 AS `enteredBy` ;

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

--
-- Structure for view `in_patient_list`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `in_patient_list`  AS SELECT 1 AS `sort_index`, 1 AS `bed_id`, 1 AS `allocation_id`, 1 AS `allocation_status`, 1 AS `allocated`, 1 AS `allocated_by`, 1 AS `patient_name`, 1 AS `patient_id`, 1 AS `accountNo`, 1 AS `name`, 1 AS `class_type`, 1 AS `account`, 1 AS `price`, 1 AS `facilityId` ;

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

--
-- Structure for view `lab_info`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `lab_info`  AS SELECT 1 AS `sort_index`, 1 AS `sn`, 1 AS `created_at`, 1 AS `facilityId`, 1 AS `id`, 1 AS `code`, 1 AS `booking_no`, 1 AS `request_id`, 1 AS `patient_id`, 1 AS `name`, 1 AS `DOB`, 1 AS `Gender`, 1 AS `qms_dept_id`, 1 AS `head`, 1 AS `subhead`, 1 AS `unit`, 1 AS `range_from`, 1 AS `range_to`, 1 AS `price`, 1 AS `old_price`, 1 AS `modeOfPayment`, 1 AS `account`, 1 AS `account_name`, 1 AS `payable_head`, 1 AS `payable_head_name`, 1 AS `receivable_head`, 1 AS `receivable_head_name`, 1 AS `commission_type`, 1 AS `percentage`, 1 AS `description`, 1 AS `test`, 1 AS `test_group`, 1 AS `specimen`, 1 AS `noOfLabels`, 1 AS `label_type`, 1 AS `label_name`, 1 AS `department`, 1 AS `unit_name`, 1 AS `unit_code`, 1 AS `result`, 1 AS `h_value`, 1 AS `o_value`, 1 AS `appearance`, 1 AS `serology`, 1 AS `culture_yielded`, 1 AS `sensitivity`, 1 AS `resistivity`, 1 AS `intermediaryTo`, 1 AS `lab_code`, 1 AS `selectable`, 1 AS `status`, 1 AS `print_type`, 1 AS `report_type`, 1 AS `collect_sample`, 1 AS `to_be_reported`, 1 AS `to_be_analyzed`, 1 AS `created_by`, 1 AS `sample_collected_by`, 1 AS `sample_collected_at`, 1 AS `analyzed_by`, 1 AS `analyzed_at`, 1 AS `result_by`, 1 AS `result_at`, 1 AS `reviewed_by`, 1 AS `reviewed_at`, 1 AS `printed_by`, 1 AS `printed_at`, 1 AS `n_unit`, 1 AS `n_range_from`, 1 AS `n_range_to`, 1 AS `receiptNo`, 1 AS `sop_instance_id`, 1 AS `uploaded_at`, 1 AS `uploaded_by`, 1 AS `payment_status`, 1 AS `approval_status`, 1 AS `report_fee_status`, 1 AS `department_head`, 1 AS `group_head`, 1 AS `patient_status`, 1 AS `printable` ;

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

--
-- Structure for view `lab_info_2`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `lab_info_2`  AS SELECT 1 AS `sn`, 1 AS `created_at`, 1 AS `facilityId`, 1 AS `id`, 1 AS `code`, 1 AS `booking_no`, 1 AS `request_id`, 1 AS `patient_id`, 1 AS `name`, 1 AS `DOB`, 1 AS `Gender`, 1 AS `qms_dept_id`, 1 AS `head`, 1 AS `subhead`, 1 AS `unit`, 1 AS `range_from`, 1 AS `range_to`, 1 AS `price`, 1 AS `old_price`, 1 AS `modeOfPayment`, 1 AS `account`, 1 AS `account_name`, 1 AS `payable_head`, 1 AS `payable_head_name`, 1 AS `receivable_head`, 1 AS `receivable_head_name`, 1 AS `commission_type`, 1 AS `percentage`, 1 AS `description`, 1 AS `test`, 1 AS `test_group`, 1 AS `specimen`, 1 AS `noOfLabels`, 1 AS `label_type`, 1 AS `label_name`, 1 AS `department`, 1 AS `unit_name`, 1 AS `unit_code`, 1 AS `result`, 1 AS `h_value`, 1 AS `o_value`, 1 AS `appearance`, 1 AS `serology`, 1 AS `culture_yielded`, 1 AS `sensitivity`, 1 AS `resistivity`, 1 AS `intermediaryTo`, 1 AS `lab_code`, 1 AS `selectable`, 1 AS `status`, 1 AS `print_type`, 1 AS `report_type`, 1 AS `collect_sample`, 1 AS `to_be_reported`, 1 AS `to_be_analyzed`, 1 AS `created_by`, 1 AS `sample_collected_by`, 1 AS `sample_collected_at`, 1 AS `analyzed_by`, 1 AS `analyzed_at`, 1 AS `result_by`, 1 AS `result_at`, 1 AS `reviewed_by`, 1 AS `reviewed_at`, 1 AS `printed_by`, 1 AS `printed_at`, 1 AS `n_unit`, 1 AS `n_range_from`, 1 AS `n_range_to`, 1 AS `receiptNo`, 1 AS `sop_instance_id`, 1 AS `uploaded_at`, 1 AS `uploaded_by`, 1 AS `payment_status`, 1 AS `approval_status`, 1 AS `report_fee_status`, 1 AS `department_head`, 1 AS `group_head`, 1 AS `patient_status` ;

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

--
-- Structure for view `lab_process`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `lab_process`  AS SELECT 1 AS `sn`, 1 AS `created_at`, 1 AS `facilityId`, 1 AS `id`, 1 AS `qms_dept_id`, 1 AS `code`, 1 AS `booking_no`, 1 AS `request_id`, 1 AS `patient_id`, 1 AS `name`, 1 AS `DOB`, 1 AS `Gender`, 1 AS `head`, 1 AS `subhead`, 1 AS `unit`, 1 AS `range_from`, 1 AS `range_to`, 1 AS `price`, 1 AS `old_price`, 1 AS `commission_type`, 1 AS `percentage`, 1 AS `description`, 1 AS `specimen`, 1 AS `noOfLabels`, 1 AS `label_type`, 1 AS `label_name`, 1 AS `group_head`, 1 AS `department`, 1 AS `department_head`, 1 AS `result`, 1 AS `h_value`, 1 AS `o_value`, 1 AS `appearance`, 1 AS `serology`, 1 AS `culture_yielded`, 1 AS `sensitivity`, 1 AS `resistivity`, 1 AS `intermediaryTo`, 1 AS `lab_code`, 1 AS `selectable`, 1 AS `status`, 1 AS `unit_code`, 1 AS `unit_name`, 1 AS `print_type`, 1 AS `report_type`, 1 AS `collect_sample`, 1 AS `to_be_reported`, 1 AS `to_be_analyzed`, 1 AS `created_by`, 1 AS `sample_collected_by`, 1 AS `sample_collected_at`, 1 AS `analyzed_by`, 1 AS `analyzed_at`, 1 AS `result_by`, 1 AS `result_at`, 1 AS `reviewed_by`, 1 AS `reviewed_at`, 1 AS `printed_by`, 1 AS `printed_at`, 1 AS `n_unit`, 1 AS `n_range_from`, 1 AS `n_range_to`, 1 AS `receiptNo`, 1 AS `sop_instance_id`, 1 AS `uploaded_at`, 1 AS `uploaded_by`, 1 AS `payment_status`, 1 AS `approval_status`, 1 AS `patient_status`, 1 AS `test`, 1 AS `test_group` ;

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

--
-- Structure for view `lab_request2`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `lab_request2`  AS SELECT 1 AS `sn`, 1 AS `created_at`, 1 AS `facilityId`, 1 AS `id`, 1 AS `qms_dept_id`, 1 AS `code`, 1 AS `name`, 1 AS `DOB`, 1 AS `Gender`, 1 AS `booking_no`, 1 AS `request_id`, 1 AS `patient_id`, 1 AS `head`, 1 AS `subhead`, 1 AS `unit`, 1 AS `range_from`, 1 AS `range_to`, 1 AS `price`, 1 AS `old_price`, 1 AS `commission_type`, 1 AS `percentage`, 1 AS `description`, 1 AS `specimen`, 1 AS `noOfLabels`, 1 AS `label_type`, 1 AS `label_name`, 1 AS `group_head`, 1 AS `department`, 1 AS `unit_code`, 1 AS `unit_name`, 1 AS `result`, 1 AS `h_value`, 1 AS `o_value`, 1 AS `appearance`, 1 AS `serology`, 1 AS `culture_yielded`, 1 AS `sensitivity`, 1 AS `resistivity`, 1 AS `intermediaryTo`, 1 AS `lab_code`, 1 AS `selectable`, 1 AS `status`, 1 AS `print_type`, 1 AS `report_type`, 1 AS `collect_sample`, 1 AS `to_be_reported`, 1 AS `to_be_analyzed`, 1 AS `created_by`, 1 AS `sample_collected_by`, 1 AS `sample_collected_at`, 1 AS `analyzed_by`, 1 AS `analyzed_at`, 1 AS `result_by`, 1 AS `result_at`, 1 AS `reviewed_by`, 1 AS `reviewed_at`, 1 AS `printed_by`, 1 AS `printed_at`, 1 AS `n_unit`, 1 AS `n_range_from`, 1 AS `n_range_to`, 1 AS `receiptNo`, 1 AS `sop_instance_id`, 1 AS `uploaded_at`, 1 AS `uploaded_by`, 1 AS `payment_status`, 1 AS `approval_status`, 1 AS `patient_status`, 1 AS `test`, 1 AS `test_group` ;

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

--
-- Structure for view `lab_requests`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `lab_requests`  AS SELECT 1 AS `department`, 1 AS `patient_id`, 1 AS `status` ;

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

--
-- Structure for view `medication_report`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `medication_report`  AS SELECT 1 AS `patient_id`, 1 AS `drug`, 1 AS `dosage`, 1 AS `route`, 1 AS `time_stamp`, 1 AS `status`, 1 AS `served_by`, 1 AS `nurse_name`, 1 AS `reason` ;

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

--
-- Structure for view `overview`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `overview`  AS SELECT 1 AS `drug`, 1 AS `quantity_bought`, 1 AS `amount_bought`, 1 AS `quantity_in_store`, 1 AS `amount_in_store`, 1 AS `quantity_sold`, 1 AS `amount_sold`, 1 AS `quantity_in_shelf`, 1 AS `amount_in_shelf`, 1 AS `sales_date`, 1 AS `purchase_date`, 1 AS `facilityId` ;

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

--
-- Structure for view `overview_wo_store`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `overview_wo_store`  AS SELECT 1 AS `drug`, 1 AS `price`, 1 AS `quantity_in_shelf`, 1 AS `amount_in_shelf`, 1 AS `quantity_sold`, 1 AS `amount_sold`, 1 AS `expiry_date`, 1 AS `created_at`, 1 AS `facilityId` ;

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

--
-- Structure for view `patientfileno_full`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `patientfileno_full`  AS SELECT 1 AS `id`, 1 AS `acc_count`, 1 AS `accountNo`, 1 AS `beneficiaries`, 1 AS `firstname`, 1 AS `surname`, 1 AS `status`, 1 AS `createdAt`, 1 AS `accName`, 1 AS `description`, 1 AS `accountType`, 1 AS `contactName`, 1 AS `contactAddress`, 1 AS `contactPhone`, 1 AS `contactEmail`, 1 AS `contactWebsite`, 1 AS `balance`, 1 AS `guarantor_name`, 1 AS `guarantor_address`, 1 AS `guarantor_phone`, 1 AS `created_by`, 1 AS `approved_by`, 1 AS `approved_at` ;

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

--
-- Structure for view `patient_bed`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `patient_bed`  AS SELECT 1 AS `allocation_id`, 1 AS `bed_id`, 1 AS `allocated`, 1 AS `allocated_by`, 1 AS `allocation_status`, 1 AS `patient_name`, 1 AS `patient_id`, 1 AS `accountNo`, 1 AS `facilityId` ;

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

--
-- Structure for view `saved_pending_request`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `saved_pending_request`  AS SELECT 1 AS `labno`, 1 AS `booking_no`, 1 AS `name`, 1 AS `code`, 1 AS `patient_id`, 1 AS `status`, 1 AS `department`, 1 AS `head`, 1 AS `test_group`, 1 AS `description`, 1 AS `subhead` ;

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

--
-- Structure for view `test1`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `test1`  AS SELECT DISTINCT `a`.`head` AS `head`, `a`.`subhead` AS `subhead`, `a`.`description` AS `des`, `b`.`acct` AS `acct`, `b`.`debit` AS `debit`, `b`.`credit` AS `credit`, `b`.`description` AS `description`, `b`.`facilityId` AS `facilityId`, `b`.`transaction_date` AS `createdAt`, `b`.`transaction_date` AS `transaction_date`, `b`.`transaction_id` AS `transaction_id`, `b`.`enteredBy` AS `enteredBy`, `b`.`receiptDateSN` AS `receiptDateSN`, `b`.`receiptNo` AS `receiptNo`, `b`.`modeOfPayment` AS `modeOfPayment`, `b`.`status` AS `status`, `b`.`approvedBy` AS `approvedBy`, `b`.`paymentStatus` AS `paymentStatus`, `b`.`client_acct` AS `client_acct`, `b`.`patient_id` AS `patient_id` FROM (`account` `a` join `transactions` `b` on(`b`.`acct` = `a`.`head`)) WHERE `b`.`status` = 'paid' ;

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

--
-- Structure for view `transaction_view`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `transaction_view`  AS SELECT 1 AS `facilityId`, 1 AS `createdAt`, 1 AS `acct`, 1 AS `debit`, 1 AS `description`, 1 AS `patient_id` ;

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

--
-- Structure for view `transaction_view2`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `transaction_view2`  AS SELECT 1 AS `date`, 1 AS `drug`, 1 AS `quantity`, 1 AS `price`, 1 AS `profit`, 1 AS `amount`, 1 AS `facilityId` ;

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

--
-- Structure for view `trialbalance`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `trialbalance`  AS SELECT 1 AS `head`, 1 AS `subhead`, 1 AS `des`, 1 AS `acct`, 1 AS `description`, 1 AS `debit`, 1 AS `credit`, 1 AS `createdAt`, 1 AS `date`, 1 AS `facilityId` ;

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

--
-- Structure for view `trial_balance`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `trial_balance`  AS SELECT DISTINCT `a`.`acct` AS `acct`, `a`.`description` AS `narration`, `a`.`des` AS `Acct_source`, `b`.`description` AS `parent_account`, `a`.`debit` AS `debit`, `a`.`credit` AS `credit`, `b`.`facilityId` AS `facilityId`, `a`.`transaction_date` AS `createdAt`, `a`.`transaction_date` AS `created_at`, `a`.`enteredBy` AS `enteredBy`, `a`.`receiptDateSN` AS `receiptDateSN`, `a`.`receiptNo` AS `receiptNo`, `a`.`modeOfPayment` AS `modeOfPayment`, `a`.`client_acct` AS `client_acct` FROM (`test1` `a` join `account` `b`) WHERE `a`.`subhead` = `b`.`head` AND `a`.`status` = 'paid' ;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `account4`
--
ALTER TABLE `account4`
  ADD PRIMARY KEY (`head`,`facilityId`);

--
-- Indexes for table `account_entries`
--
ALTER TABLE `account_entries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `facilityId` (`facilityId`,`createdAt`),
  ADD KEY `acct` (`acct`);

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

--
-- Indexes for table `account_opt`
--
ALTER TABLE `account_opt`
  ADD PRIMARY KEY (`head`,`facilityId`);

--
-- Indexes for table `account_ubec`
--
ALTER TABLE `account_ubec`
  ADD PRIMARY KEY (`head`,`facilityId`);

--
-- Indexes for table `application_type`
--
ALTER TABLE `application_type`
  ADD PRIMARY KEY (`application_id`);

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

--
-- Indexes for table `bedlist`
--
ALTER TABLE `bedlist`
  ADD PRIMARY KEY (`id`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `class_type` (`class_type`),
  ADD KEY `id` (`id`);

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

--
-- Indexes for table `bed_allocation`
--
ALTER TABLE `bed_allocation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `allocation_status` (`allocation_status`),
  ADD KEY `patient_id` (`patient_id`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `allocated_by` (`allocated_by`),
  ADD KEY `ended` (`ended`),
  ADD KEY `allocated` (`allocated`),
  ADD KEY `bed_id` (`bed_id`);

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

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

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

--
-- Indexes for table `checklists_setup`
--
ALTER TABLE `checklists_setup`
  ADD PRIMARY KEY (`checklist_setup_id`);

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

--
-- Indexes for table `consultations`
--
ALTER TABLE `consultations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `patient_id` (`patient_id`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `created_at` (`created_at`),
  ADD KEY `decision` (`decision`),
  ADD KEY `nursing_request_status` (`nursing_request_status`),
  ADD KEY `treatment_plan_status` (`treatment_plan_status`),
  ADD KEY `treatment_by` (`treatment_by`),
  ADD KEY `userId` (`userId`);

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

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

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

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

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

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

--
-- Indexes for table `dispensary`
--
ALTER TABLE `dispensary`
  ADD PRIMARY KEY (`id`),
  ADD KEY `request_id` (`request_id`),
  ADD KEY `patient_id` (`patient_id`),
  ADD KEY `receiptNo` (`receiptNo`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `created_at` (`created_at`),
  ADD KEY `status` (`status`),
  ADD KEY `schedule_status` (`schedule_status`),
  ADD KEY `end_date` (`end_date`);

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

--
-- Indexes for table `drugpurchaserecords`
--
ALTER TABLE `drugpurchaserecords`
  ADD PRIMARY KEY (`drug`,`expiry_date`,`cost_price`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `status` (`status`),
  ADD KEY `balance` (`balance`),
  ADD KEY `created_at` (`created_at`),
  ADD KEY `supplier` (`supplier`),
  ADD KEY `expiry_date` (`expiry_date`),
  ADD KEY `quantity` (`quantity`);

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

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

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

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

--
-- Indexes for table `drug_schedule`
--
ALTER TABLE `drug_schedule`
  ADD PRIMARY KEY (`id`),
  ADD KEY `prescription_id` (`prescription_id`),
  ADD KEY `patient_id` (`patient_id`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `status` (`status`),
  ADD KEY `served_by` (`served_by`),
  ADD KEY `administered_by` (`administered_by`),
  ADD KEY `allocation_id` (`allocation_id`);

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `lab`
--
ALTER TABLE `lab`
  ADD PRIMARY KEY (`test_id`);

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

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

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

--
-- Indexes for table `lab_requisition`
--
ALTER TABLE `lab_requisition`
  ADD PRIMARY KEY (`facilityId`,`id`),
  ADD KEY `test` (`test`),
  ADD KEY `patient_id` (`patient_id`),
  ADD KEY `booking_no` (`booking_no`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `request_id` (`request_id`),
  ADD KEY `test_group` (`test_group`),
  ADD KEY `id` (`id`),
  ADD KEY `department` (`department`),
  ADD KEY `status` (`status`),
  ADD KEY `created_at` (`created_at`,`updated_at`,`sample_collected_at`,`analyzed_at`,`result_at`,`uploaded_at`,`reviewed_at`,`printed_at`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `sample_collected_by` (`sample_collected_by`,`analyzed_by`,`result_by`,`uploaded_by`,`reviewed_by`,`printed_by`),
  ADD KEY `receiptNo` (`receiptNo`),
  ADD KEY `print_type` (`print_type`),
  ADD KEY `department_code` (`department_code`),
  ADD KEY `client_account` (`client_account`),
  ADD KEY `client_type` (`client_type`),
  ADD KEY `patient_status` (`patient_status`),
  ADD KEY `patient_name` (`patient_name`);

--
-- Indexes for table `lab_setup`
--
ALTER TABLE `lab_setup`
  ADD PRIMARY KEY (`subhead`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `subhead` (`subhead`),
  ADD KEY `head` (`head`);

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

--
-- Indexes for table `lab_setup4`
--
ALTER TABLE `lab_setup4`
  ADD PRIMARY KEY (`subhead`,`facilityId`);

--
-- Indexes for table `number_generator`
--
ALTER TABLE `number_generator`
  ADD PRIMARY KEY (`prefix`);

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

--
-- Indexes for table `nursing_report`
--
ALTER TABLE `nursing_report`
  ADD PRIMARY KEY (`id`),
  ADD KEY `created_at` (`created_at`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `created_by` (`created_by`);

--
-- Indexes for table `operationnotes`
--
ALTER TABLE `operationnotes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `patientId` (`patientId`),
  ADD KEY `facilityId` (`facilityId`);

--
-- Indexes for table `pagenavigation`
--
ALTER TABLE `pagenavigation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role` (`role`),
  ADD KEY `facilityId` (`facilityId`);

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

--
-- Indexes for table `patientfileno`
--
ALTER TABLE `patientfileno`
  ADD PRIMARY KEY (`id`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `accountNo` (`accountNo`);

--
-- Indexes for table `patientrecords`
--
ALTER TABLE `patientrecords`
  ADD PRIMARY KEY (`facilityId`,`id`,`patient_id`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `patient_id` (`patient_id`),
  ADD KEY `seen_by` (`seen_by`,`date_seen`),
  ADD KEY `accountNo` (`accountNo`),
  ADD KEY `status` (`status`),
  ADD KEY `assigned_to` (`assigned_to`),
  ADD KEY `patientStatus` (`patientStatus`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `patient_history`
--
ALTER TABLE `patient_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `patient_id` (`patient_id`),
  ADD KEY `request_id` (`request_id`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `createdAt` (`createdAt`);

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

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

--
-- Indexes for table `pharm_store`
--
ALTER TABLE `pharm_store`
  ADD PRIMARY KEY (`item_code`,`facilityId`,`expiry_date`,`store`,`selling_price`),
  ADD UNIQUE KEY `item_id` (`item_id`);

--
-- Indexes for table `pharm_store_entries`
--
ALTER TABLE `pharm_store_entries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transfer_from` (`transfer_from`,`transfer_to`,`branch_name`,`facilityId`),
  ADD KEY `inserted_time` (`inserted_time`);

--
-- Indexes for table `prescriptionrequests`
--
ALTER TABLE `prescriptionrequests`
  ADD PRIMARY KEY (`drug_request_id`);

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

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

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

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

--
-- Indexes for table `sensitivity_results`
--
ALTER TABLE `sensitivity_results`
  ADD PRIMARY KEY (`antibiotic`,`labno`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`service_id`);

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

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

--
-- Indexes for table `supplier_entries`
--
ALTER TABLE `supplier_entries`
  ADD PRIMARY KEY (`entry_id`);

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

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

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

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`transaction_id`);

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`,`facilityId`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `createdAt` (`createdAt`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `vital_signs`
--
ALTER TABLE `vital_signs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `patient_id` (`patient_id`),
  ADD KEY `facilityId` (`facilityId`),
  ADD KEY `created_at` (`created_at`),
  ADD KEY `created_by` (`created_by`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

--
-- AUTO_INCREMENT for table `billing_units`
--
ALTER TABLE `billing_units`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

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

--
-- AUTO_INCREMENT for table `comment`
--
ALTER TABLE `comment`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `lab`
--
ALTER TABLE `lab`
  MODIFY `test_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `labservices`
--
ALTER TABLE `labservices`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

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

--
-- AUTO_INCREMENT for table `lab_requisition`
--
ALTER TABLE `lab_requisition`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

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

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

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

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

--
-- AUTO_INCREMENT for table `patientrecords`
--
ALTER TABLE `patientrecords`
  MODIFY `patient_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `service_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;

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

--
-- AUTO_INCREMENT for table `supplier_entries`
--
ALTER TABLE `supplier_entries`
  MODIFY `entry_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

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

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

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `transaction_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

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

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

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

