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

START TRANSACTION;



--
-- Database: `manila`
--

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

--
-- Table structure for table `allergies`
--

CREATE TABLE `allergies` (
  `id` int NOT NULL,
  `symptoms_experienced` varchar(255) DEFAULT NULL,
  `allergy_record` varchar(255) DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `physician` varchar(255) DEFAULT NULL,
  `physician_license` varchar(100) DEFAULT NULL,
  `philhealth_id_number` varchar(100) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `allergies`
--

INSERT INTO `allergies` (`id`, `symptoms_experienced`, `allergy_record`, `trans_date`, `physician`, `physician_license`, `philhealth_id_number`, `fullname`, `reference`, `created_at`, `updated_at`) VALUES
(1, 'Rashes and itching after eating peanuts', 'Peanut allergy', '2024-09-16 00:00:00', 'Dr. Maria Cruz', 'LIC567890', 'PHID876543', 'Grace Lee', 'REF112233', NULL, NULL),
(2, 'Rashes and itching after eating peanuts', 'Peanut allergy', '2024-09-18 00:00:00', 'Dr. Maria Cruz', 'LIC567890', 'PHID876543', 'Grace Lee', 'REF112232', NULL, NULL),
(15, 'Smell', 'Pollen Allergy', '2024-10-10 15:54:44', 'Dr Theodor Seuss Geisel', '2000000008', '', '', '20241010155444', NULL, NULL),
(16, 'Dog', 'Pet Allergy', '2024-10-10 15:54:44', 'Dr Theodor Seuss Geisel', '2000000008', '', '', '20241010155444', NULL, NULL),
(36, 'Test allegies', 'Insect Sting Allergy', '2024-10-29 10:06:23', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029100623', NULL, NULL),
(37, 'Dog, cat, pig', 'Pet Allergy', '2024-10-29 12:10:27', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029121027', NULL, NULL),
(39, 'Test', 'Medication Allergy', '2024-10-29 14:12:25', 'Dr Theodor Seuss III', '2000000058', '123456788', 'CORAZON CRUZ', '20241029141225', NULL, NULL),
(40, 'Test', 'Food Allergy', '2024-10-29 14:34:14', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CORAZON CRUZ', '20241029143414', NULL, NULL),
(41, 'Rushes, fever', 'Food Allergy', '2024-10-29 14:48:54', 'Dr Theodor Seuss III', '2000000058', '123456788', 'CORAZON CRUZ', '20241029144854', NULL, NULL),
(42, 'Bee, red eyes', 'Insect Sting Allergy', '2024-10-29 15:13:13', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029151313', NULL, NULL),
(43, 'Fever', 'Milk Allergy', '2024-10-29 15:14:26', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029151426', NULL, NULL),
(44, 'Boamoting', 'Food Allergy', '2024-10-29 15:46:06', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029154606', NULL, NULL),
(45, 'Fever', 'Pollen Allergy', '2024-10-30 15:05:27', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241030150527', NULL, NULL),
(46, 'Dog', 'Pet Allergy', '2024-10-30 15:45:23', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241030154523', NULL, NULL),
(47, 'Apple', 'Food Allergy', '2024-10-30 15:54:09', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241030155409', NULL, NULL),
(48, 'Rashes', 'Dust Mite Allergy', '2024-11-04 20:24:17', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241104202417', NULL, NULL),
(49, 'A food allergy is an abnormal immune response to food.', 'Food Allergy', '2024-11-04 22:28:17', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241104222817', NULL, NULL),
(50, 'Dust', 'Dust Mite Allergy', '2024-11-05 08:41:47', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241105084147', NULL, NULL),
(51, 'Sample', 'Latex Allergy', '2024-11-05 08:57:40', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241105085740', NULL, NULL),
(52, 'Rashes', 'Pollen Allergy', '2024-11-05 10:59:25', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241105105925', NULL, NULL),
(53, 'Fever', 'Latex Allergy', '2024-11-05 11:00:09', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241105110009', NULL, NULL),
(54, 'Stomachache', 'Food Allergy', '2024-11-05 11:01:17', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241105110117', NULL, NULL),
(55, 'Red eyes', 'Insect Sting Allergy', '2024-11-05 11:01:45', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241105110145', NULL, NULL),
(56, 'Rashes', 'Food Allergy', '2024-11-08 08:58:42', 'Dr Theodor Seuss Geisel', '2000000008', '123456758', 'ROLDAN TORRALBA', '20241108085842', NULL, NULL),
(57, 'Fever', 'Pollen Allergy', '2024-11-08 12:04:58', 'Dr Theodor Seuss Geisel', '2000000008', '123456757', 'ARNEL BABIERRA', '20241108120458', NULL, NULL),
(58, 'Rushes', 'Nut Allergy', '2024-11-08 19:52:02', 'Dr Theodor M Cruz', '2000000208', '123456789', 'CORAZON CRUZ', '20241108195202', NULL, NULL),
(59, 'Grass, Fever, Bloated', '', '2024-11-16 04:50:11', 'Dr Theodor Seuss Geisel', '2000000008', '1234567587', 'TORRALBA, ROLDAN', '20241116045011', NULL, NULL),
(60, 'Grass, Fever, Bloated', '', '2024-11-16 04:51:16', 'Dr Theodor Seuss Geisel', '2000000008', '1234567587', 'TORRALBA, ROLDAN', '20241116045116', NULL, NULL),
(61, 'Hypertension', '', '2024-11-16 04:52:55', 'Dr Theodor Seuss Geisel', '2000000008', '1234567587', 'TORRALBA, ROLDAN', '20241116045255', NULL, NULL),
(62, 'Cow. Bat', '', '2024-11-16 04:59:09', 'Dr Theodor Seuss Geisel', '2000000008', '1234567587', 'TORRALBA, ROLDAN', '20241116045909', NULL, NULL),
(63, 'red, pink', '', '2024-11-16 14:21:02', 'Dr Theodor Seuss Geisel', '2000000008', '123456758', 'TORRALBA, ROLDAN', '20241116142102', NULL, NULL),
(64, 'Skin is red, swollen and itchy.', '', '2024-11-17 23:31:37', 'Dr Theodor Seuss III', '2000000058', '123456788', 'CRUZ, CORAZON', '20241117233137', NULL, NULL),
(65, 'New rashes was spotted', '', '2024-11-18 11:27:33', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', '20241118112733', NULL, NULL),
(66, 'paracetamol', '', '2024-11-18 11:28:13', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', '20241118112813', NULL, NULL),
(67, 'Rashes', '', '2024-11-18 12:16:35', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', '20241118121635', NULL, NULL),
(68, 'Alamang', '', '2024-11-19 05:14:16', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', '20241119051416', NULL, NULL),
(69, 'Dizy', '', '2024-11-19 05:25:33', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', '20241119052533', NULL, NULL),
(70, 'boysen', '', '2024-11-19 13:58:52', 'Dr Theodor Seuss Geisel', '2000000008', '123456758', 'TORRALBA, ROLDAN', '20241119135852', NULL, NULL),
(71, 'sampaguita', '', '2024-11-19 14:47:22', 'Dr Theodor Seuss Geisel', '2000000008', '123456758', 'TORRALBA, ROLDAN', '20241119144722', NULL, NULL),
(72, 'Rose', '', '2024-11-19 15:28:18', 'Dr Theodor Seuss Geisel', '2000000008', '123456700', 'DELACRUS, JUAN', '20241119152818', NULL, NULL),
(73, 'Cow Milk, Carabao Milk', '', '2024-11-19 15:50:34', 'Dr Theodor Seuss Geisel', '2000000008', '123456758', 'TORRALBA, ROLDAN', '20241119155034', NULL, NULL),
(74, 'sample new', '', '2024-11-20 13:48:19', 'Dr Theodor Seuss Geisel', '2000000008', '123456758', 'TORRALBA, ROLDAN', '20241120134819', NULL, NULL),
(75, 'Awet', '', '2024-11-21 10:34:32', 'Dr Theodor Seuss Geisel', '2000000008', '123456758', 'TORRALBA, ROLDAN', '20241121103432', NULL, NULL);

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

--
-- Table structure for table `dischargesummary`
--

CREATE TABLE `dischargesummary` (
  `id` int NOT NULL,
  `discharge_diagnosis` varchar(255) DEFAULT NULL,
  `procedures_performed` varchar(255) DEFAULT NULL,
  `followup_arrangements` varchar(255) DEFAULT NULL,
  `therapeutic_orders` varchar(255) DEFAULT NULL,
  `patient_home_instructions` varchar(255) DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `physician` varchar(255) DEFAULT NULL,
  `physician_license` varchar(100) DEFAULT NULL,
  `philhealth_id_number` varchar(100) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `doctor_info` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dischargesummary`
--

INSERT INTO `dischargesummary` (`id`, `discharge_diagnosis`, `procedures_performed`, `followup_arrangements`, `therapeutic_orders`, `patient_home_instructions`, `trans_date`, `physician`, `physician_license`, `philhealth_id_number`, `fullname`, `reference`, `doctor_info`, `created_at`, `updated_at`) VALUES
(20, 'Acute bronchitis', 'Nebulization, Spirometry', '2024-11-10', 'Inhalers prescribed', 'Rest and hydration', '2024-10-28 14:30:00', 'Dr. John Smith', 'PH123456', 'PH9876543210', 'Jane Doe', 'REF202410281230', 'Specialist in Pulmonology', NULL, NULL),
(28, 'Metabolic dysfunction as streatotic liver disease', 'Fibroscan~Blood tests: hepatitis profile, blood chemistries', 'Outpatient follow-up after 6 months with repeat lab exams', 'Ursodeoxycholic acid 500mg tablet 2xday for 6 months', 'Low fat, low carbohydrates diet~Regular exercise 150 minutes per week', '2024-10-29 12:43:01', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029124301', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(29, 'Essential hypertension', '24 hours ambulatory BP monitoring~24 hours holder monitor~2D echo with Doppler~ECG, Chest Xray~Blood chemistries', 'Out patient follow up after 6 month', 'Twynsta 40/5mg after breakfast', 'Low chol, low carb, low salt, diet~Daily exercise 150min/week', '2024-10-29 12:51:16', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029125116', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(36, 'New discharge', 'Take med 1~Procedure 2', 'After 6days', 'Issue with urine', 'Take antibiotic~Low carb', '2024-10-29 14:56:55', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029145655', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(37, 'Discharge 2', 'New lab test', 'After 5 days', 'Paracetamol 5mg', 'Take med', '2024-10-29 15:06:47', 'Dr Theodor Seuss III', '2000000058', '123456788', 'CORAZON CRUZ', '20241029150647', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(38, 'Community acquired', 'Chest CT Scan~Arterial blood gas', 'Chest Xray', 'Oral antibiotics', 'Balanced diet~Regular exercise', '2024-10-29 15:30:40', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029153040', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(39, 'Essential hypertension', '24hrs Ambular Bp~ECG, Chest Xray~ 2D Echo', 'Outpatient', 'Twynsta 5mg', 'Daily exercise', '2024-10-29 15:33:50', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029153350', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(40, 'Cerebrovascular', 'Brain MRI', 'Phycal Rehab~After 2weeks', 'Aspwrin 80mh~Metoprobol 50mg', 'Low fat diet', '2024-10-29 15:39:57', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029153957', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(41, 'Left-sider paralysis', 'Blood chem', 'Therapy', 'Citicholin 500mg', 'Low chol', '2024-10-29 15:41:22', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029154122', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(42, 'Right-side paralysis', 'MRI', 'Rehabilitation', 'Anlodophine', 'Exercises', '2024-10-29 15:43:30', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029154330', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(43, 'Hypertension', 'Blood chem', 'Admit', 'Paracetamol 500mg', 'Low chol', '2024-10-29 15:49:33', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029154933', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(44, 'Pneumonia', 'O2 inhalation', 'Xray', 'Nebulizers', 'Low carb', '2024-10-29 15:51:21', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029155121', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(45, 'High blood', 'Admit 24hrs', 'Take med', 'Anlodophine 3 months', 'Low carb diet~Low cholesterol diet', '2024-10-30 15:15:53', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241030151553', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(46, 'Hypertension, controlled', 'Blood test, ECG', 'Follow-up in 2 weeks', 'Continue maintenance meds', 'Low sodium diet, daily exercise', '2025-09-08 00:00:00', 'Dr Theodor Seuss Geisel', '10000008', '2000000008', 'Maria Santos', 'REF20250908-001', '10000008; Dr Theodor Seuss Geisel ;2000000008', NULL, NULL);

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

--
-- Table structure for table `donotresuscitate`
--

CREATE TABLE `donotresuscitate` (
  `id` int NOT NULL,
  `trans_date` datetime NOT NULL,
  `physician_name` varchar(255) NOT NULL,
  `physician_license` varchar(100) NOT NULL,
  `philhealth_id_number` varchar(100) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `reference` varchar(100) NOT NULL,
  `doctorinfo` varchar(255) DEFAULT NULL,
  `DNRReason` varchar(500) NOT NULL,
  `DNRAdvise` varchar(500) NOT NULL,
  `DNRPatientConsent` varchar(500) NOT NULL,
  `DNRStatus` varchar(50) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `donotresuscitate`
--

INSERT INTO `donotresuscitate` (`id`, `trans_date`, `physician_name`, `physician_license`, `philhealth_id_number`, `fullname`, `reference`, `doctorinfo`, `DNRReason`, `DNRAdvise`, `DNRPatientConsent`, `DNRStatus`, `created_at`, `updated_at`) VALUES
(1, '2024-09-19 17:02:44', 'Dr. John Smith', 'ABC12345', 'PH1234567890', 'Jane Doe', 'REF20240918', 'Cardiologist', 'Chronic illness, patient request', 'Advised family about risks and benefits', 'Patient signed consent form', 'Active', NULL, NULL),
(23, '2024-10-29 12:34:11', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029123411', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'Lack of financial', 'CPR', 'Yes', 'Yes', NULL, NULL),
(24, '2024-10-29 15:26:18', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029152618', '10000058;          Dr Theodor Seuss III;2000000058', 'For humanity', 'Good', 'Yes', 'Yes', NULL, NULL),
(25, '2024-10-30 15:12:35', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241030151235', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'Humanity', 'Good', 'Written consent', 'Yes', NULL, NULL),
(26, '2024-11-16 06:58:06', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', '20241116065806', '', '', '', '', '', NULL, NULL),
(27, '2024-11-16 07:00:03', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', '20241116070003', '', 'No Money', 'Good', 'Legal Agreement', '1', NULL, NULL),
(28, '2024-11-18 12:26:20', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', '20241118122620', '', 'No Money', 'Yes, good', 'Yes', '1', NULL, NULL);

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

--
-- Table structure for table `healthproblem`
--

CREATE TABLE `healthproblem` (
  `id` int NOT NULL,
  `chief_complaint` varchar(255) DEFAULT NULL,
  `history_of_illness` varchar(255) DEFAULT NULL,
  `physical_exam_findings` varchar(255) DEFAULT NULL,
  `diagnostic_tests` varchar(255) DEFAULT NULL,
  `diagnosis` varchar(255) DEFAULT NULL,
  `treatment_plan` varchar(255) DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `physician` varchar(255) DEFAULT NULL,
  `physician_license` varchar(100) DEFAULT NULL,
  `philhealth_id_number` varchar(100) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `healthproblem`
--

INSERT INTO `healthproblem` (`id`, `chief_complaint`, `history_of_illness`, `physical_exam_findings`, `diagnostic_tests`, `diagnosis`, `treatment_plan`, `trans_date`, `physician`, `physician_license`, `philhealth_id_number`, `fullname`, `reference`, `created_at`, `updated_at`) VALUES
(1, 'Severe headache', 'Patient has been experiencing headaches for 3 days.', 'Blood pressure is elevated, slight tenderness in the neck.', 'CT scan of the brain', 'Migraine', 'Prescribed pain relievers, advised rest and hydration.', '2024-09-18 00:00:00', 'Dr. John Doe', '123456789', 'PH123456789', 'Jane Doe', 'REF987654321', NULL, NULL),
(18, 'High bloos', 'A stroke', 'Failed', 'Okay', 'Fail', 'Operations', '2024-10-29 10:20:48', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029102048', NULL, NULL),
(19, 'Stomach pain', 'Appendicitis', 'Not normal', 'Acute', 'Need immediate action', 'Operation', '2024-10-29 12:15:43', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029121543', NULL, NULL),
(20, 'Stomach', 'Fever', 'Gas problems', 'Stomach', 'Delay breath', 'Operations', '2024-10-29 15:21:04', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029152104', NULL, NULL),
(21, 'Chest pain', 'Fever', 'Low blood', 'Fever', 'Fever', 'Medication', '2024-10-30 15:07:45', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241030150745', NULL, NULL),
(22, 'Fever', 'Hypertention', 'Xray, ECG', 'CT-SCAN', 'HB, HC, HA', '1 week med', '2024-11-16 06:00:27', 'Dr Theodor Seuss Geisel', '2000000008', '', '', '20241116060027', NULL, NULL),
(23, 'Fever', 'Hypertention', 'Xray, ECG', 'CT-SCAN', 'HB, HC, HA', '1 week med', '2024-11-16 06:01:02', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', '20241116060102', NULL, NULL),
(24, 'Chest Pain', 'Hypertension', 'Failed', 'Okay', 'Hypertension', 'Medication', '2024-11-17 23:36:03', 'Dr Theodor Seuss III', '2000000058', '123456788', 'CRUZ, CORAZON', '20241117233603', NULL, NULL),
(25, 'Headache', 'high blood', 'ECG Fiale', 'Xray', 'CT Scan', 'Medication 2 weeks', '2024-11-18 11:43:28', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', '20241118114328', NULL, NULL),
(26, 'Hypertension', 'Highblood', 'ECG', 'Xray', 'Need Medication', '1 week med', '2024-11-19 15:30:12', 'Dr Theodor Seuss Geisel', '2000000008', '123456700', 'DELACRUS, JUAN', '20241119153012', NULL, NULL);

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

--
-- Table structure for table `insurancerecord`
--

CREATE TABLE `insurancerecord` (
  `id` int NOT NULL,
  `transDate` datetime NOT NULL,
  `doctorInfo` varchar(255) NOT NULL,
  `referenceNum` varchar(100) NOT NULL,
  `insuranceCompanyName` varchar(255) NOT NULL,
  `contactInformation` varchar(255) DEFAULT NULL,
  `policyNumber` varchar(100) DEFAULT NULL,
  `insuranceHealthPlan` varchar(255) DEFAULT NULL,
  `coverageDateFrom` date DEFAULT NULL,
  `coverageDateTo` date DEFAULT NULL,
  `eligibilityStatus` varchar(100) DEFAULT NULL,
  `prcid` varchar(100) NOT NULL,
  `physicianName` varchar(255) NOT NULL,
  `physicianLicense` varchar(100) NOT NULL,
  `PhilhealthId` varchar(100) NOT NULL,
  `PatientName` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `insurancerecord`
--

INSERT INTO `insurancerecord` (`id`, `transDate`, `doctorInfo`, `referenceNum`, `insuranceCompanyName`, `contactInformation`, `policyNumber`, `insuranceHealthPlan`, `coverageDateFrom`, `coverageDateTo`, `eligibilityStatus`, `prcid`, `physicianName`, `physicianLicense`, `PhilhealthId`, `PatientName`, `created_at`, `updated_at`) VALUES
(32, '2024-10-29 03:54:13', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241029035413', 'PruLife', '09358525885', '25808552', 'Pru100', '2024-10-27', '2025-10-27', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', NULL, NULL),
(33, '2024-10-29 12:09:31', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241029120931', 'Sun Life', '09552585458', '125880885214', 'Sum Maxilink', '2024-10-01', '2025-10-01', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', NULL, NULL),
(34, '2024-10-29 15:11:39', '10000058;          Dr Theodor Seuss III;2000000058', '20241029151139', 'Pru Life', '09658525588', '25858555', 'Protect 100', '2024-10-27', '2028-10-27', 'Active', '10000058', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', NULL, NULL),
(35, '2024-10-29 15:12:34', '10000058;          Dr Theodor Seuss III;2000000058', '20241029151234', 'Sun Life', '09658525555', '2547588555', 'Sun Maximum', '2024-10-30', '2025-10-30', 'Inactive', '10000058', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', NULL, NULL),
(36, '2024-10-29 15:45:24', '10000058;          Dr Theodor Seuss III;2000000058', '20241029154524', 'Cocolife', '09585487545', '1245852555', 'Coco 200', '2024-10-27', '2024-10-27', 'Active', '10000058', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', NULL, NULL),
(37, '2024-10-30 15:04:45', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241030150445', 'Prulife', '09308525858', '45678965', 'Protector 100', '2024-10-07', '2028-10-31', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', NULL, NULL),
(38, '2024-10-30 15:37:51', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241030153751', 'Coco Life', '09658555585', '258802588', 'Life100', '2024-10-27', '2025-10-27', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', NULL, NULL),
(39, '2024-11-08 16:17:17', '10000208;             Dr Theodor M Cruz;2000000208', '20241108161717', 'Prulife', '87000', 'Policy 1', 'Plan A', '2024-11-08', '2025-11-08', 'Active', '10000208', 'Dr Theodor M Cruz', '2000000208', '123456789', 'CORAZON CRUZ', NULL, NULL),
(40, '2024-11-16 03:44:17', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241116034417', 'ManuLife', '09636548247', '12345678', 'Life 100', '2023-11-14', '2025-11-28', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '1234567587', 'TORRALBA, ROLDAN', NULL, NULL),
(41, '2024-11-16 03:46:00', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241116034600', 'ManuLife', '09636548247', '12345678', 'Life 100', '2023-11-14', '2025-11-28', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '1234567587', 'TORRALBA, ROLDAN', NULL, NULL),
(42, '2024-11-16 03:48:21', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241116034821', 'ManuLife', '09636548247', '12345678', 'Life 100', '2023-11-14', '2025-11-28', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '1234567587', 'TORRALBA, ROLDAN', NULL, NULL),
(43, '2024-11-16 03:48:54', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241116034854', 'Prulife', '09636548111', '74174444444', 'Life 100', '2023-01-14', '2025-01-28', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '1234567587', 'TORRALBA, ROLDAN', NULL, NULL),
(44, '2024-11-16 03:53:27', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241116035327', 'Cocolife', '09652541254', '123456789', 'Coco200', '2024-11-05', '2025-12-03', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '1234567587', 'TORRALBA, ROLDAN', NULL, NULL),
(45, '2024-11-16 03:57:00', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241116035700', 'Sunilfe', '098765432', '123456743', 'Degue Plan', '2024-11-11', '2026-11-29', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '1234567587', 'TORRALBA, ROLDAN', NULL, NULL),
(46, '2024-11-16 03:59:29', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241116035929', 'Sun Life', '0987654321', '12345432', 'Life Plan 200', '2024-01-01', '2028-01-01', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '1234567587', 'TORRALBA, ROLDAN', NULL, NULL),
(47, '2024-11-16 05:43:31', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241116054331', 'ManuLife', '098765432', '23412', 'Plan 100', '2024-11-06', '2028-11-29', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', NULL, NULL),
(48, '2024-11-16 05:44:10', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241116054410', 'Prulife', '098765432', '12345654321', 'Life 100', '2024-11-14', '2024-11-29', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', NULL, NULL),
(49, '2024-11-16 05:44:27', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241116054427', 'Cocolife', '09876543223', '12322245654321', 'Life 200', '2024-11-14', '2024-11-29', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', NULL, NULL),
(50, '2024-11-16 05:44:43', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241116054443', 'Sun Life', '0987345678', '5665432112321', 'Life 1000', '2024-11-14', '2024-11-29', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', NULL, NULL),
(51, '2024-11-16 05:45:08', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241116054508', 'Sun Life', '09822222222', '2222222222222', 'TO LIFE 1000', '2024-11-14', '2024-11-29', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', NULL, NULL),
(52, '2024-11-17 23:30:40', '10000058;          Dr Theodor Seuss III;2000000058', '20241117233040', 'Prulife', '09560836689', '25808552', 'PruWellnes', '2024-11-17', '2025-11-17', 'Active', '10000058', 'Dr Theodor Seuss III', '2000000058', '123456788', 'CRUZ, CORAZON', NULL, NULL),
(53, '2024-11-18 10:49:51', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241118104951', 'Axa Life 2', '23232323', '32323232323', 'Axa 1500', '2024-01-12', '2028-01-02', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', NULL, NULL),
(54, '2024-11-18 11:04:28', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241118110428', 'Maxicare', '09658542574', '8588855888', 'Plus 200', '2024-01-12', '2025-01-12', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', NULL, NULL),
(55, '2024-11-18 11:11:12', '10000008;      Dr Theodor Seuss Geisel ;2000000008', '20241118111112', 'Prulife', '0985555555555', '85577555444444', 'Prutect 2000', '2024-11-18', '2025-11-28', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', NULL, NULL),
(56, '2024-11-19 14:46:23', '10000008;Dr Theodor Seuss Geisel;2000000008', '20241119144623', 'Cocolife', 'juan', '78945612', 'plan100', '2024-11-11', '2024-11-29', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456758', 'TORRALBA, ROLDAN', NULL, NULL),
(57, '2024-11-19 15:27:52', '10000008;Dr Theodor Seuss Geisel;2000000008', '20241119152752', 'Maxicare', 'Juan Cruz', '09305254175', 'MAX 500', '2024-11-19', '2024-11-29', 'Active', '10000008', 'Dr Theodor Seuss Geisel', '2000000008', '123456700', 'DELACRUS, JUAN', NULL, NULL);

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

--
-- Table structure for table `listfamilyhistorydisease`
--

CREATE TABLE `listfamilyhistorydisease` (
  `id` int NOT NULL,
  `disease` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `code` varchar(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `status` int DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `listfamilyhistorydisease`
--

INSERT INTO `listfamilyhistorydisease` (`id`, `disease`, `code`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Asthma', '01', 0, NULL, NULL),
(2, 'Bleeding tendency', '02', 0, NULL, NULL),
(3, 'Cancer', '03', 0, NULL, NULL),
(4, 'Diabetes', '04', 0, NULL, NULL),
(5, 'Heart Disorder', '05', 0, NULL, NULL),
(6, 'High Blood Pressure', '06', 0, NULL, NULL),
(7, 'Kidney Problem', '07', 0, NULL, NULL),
(8, 'Mental Disorder', '08', 0, NULL, NULL),
(9, 'Obesity', '09', 0, NULL, NULL),
(10, 'Seizure Disorder', '0A', 0, NULL, NULL),
(11, 'Stroke', '0B', 0, NULL, NULL),
(12, 'Thyroid Problem', '0C', 0, NULL, NULL),
(13, 'Tuberculosis', '0D', 0, NULL, NULL);

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

--
-- Table structure for table `medicalfamilyhistory`
--

CREATE TABLE `medicalfamilyhistory` (
  `id` int NOT NULL,
  `philhealth_id` varchar(50) NOT NULL,
  `code` varchar(50) NOT NULL,
  `diseaseName` varchar(255) NOT NULL,
  `relationship` varchar(50) NOT NULL,
  `date_ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `consultation_date` datetime NOT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `medicalfamilyhistory`
--

INSERT INTO `medicalfamilyhistory` (`id`, `philhealth_id`, `code`, `diseaseName`, `relationship`, `date_ts`, `consultation_date`, `reference`, `created_at`, `updated_at`) VALUES
(1, '123456789', '01', 'Asthma', 'AAAAA', '2024-10-12 09:36:01', '2024-10-12 17:35:59', '20241012173559', NULL, NULL),
(2, '123456789', '01', 'Asthma', 'Test 1', '2024-10-15 08:15:52', '2024-10-15 16:15:50', '20241015161550', NULL, NULL),
(3, '123456789', '03', 'Cancer', 'Test 2', '2024-10-15 08:15:52', '2024-10-15 16:15:50', '20241015161550', NULL, NULL),
(4, '123456789', '04', 'Diabetes', 'Father', '2024-10-16 03:08:53', '2024-10-16 11:08:52', '20241016110852', NULL, NULL),
(5, '123456789', '07', 'Kidney Problem', 'adsdsa', '2024-10-16 03:54:11', '2024-10-16 11:54:10', '20241016115410', NULL, NULL),
(6, '123456789', '02', 'Bleeding tendency', 'adssas', '2024-10-16 03:59:15', '2024-10-16 11:59:15', '20241016115915', NULL, NULL),
(7, '123456789', '01', 'Asthma', 'Mother', '2024-10-16 04:37:10', '2024-10-16 12:37:09', '20241016123709', NULL, NULL),
(8, '123456789', '01', 'Asthma', 'Father Side', '2024-10-16 04:54:00', '2024-10-16 12:53:59', '20241016125359', NULL, NULL),
(9, '123456789', '04', 'Diabetes', 'asdas', '2024-10-16 05:07:58', '2024-10-16 13:07:56', '20241016130756', NULL, NULL),
(10, '123456789', '01', 'Asthma', 'Father', '2024-10-16 05:10:27', '2024-10-16 13:10:26', '20241016131026', NULL, NULL),
(11, '123456789', '01', 'Asthma', 'Father', '2024-10-16 05:13:14', '2024-10-16 13:13:13', '20241016131313', NULL, NULL),
(12, '123456789', '02', 'Bleeding tendency', 'Mother', '2024-10-16 05:15:35', '2024-10-16 13:15:34', '20241016131534', NULL, NULL),
(13, '123456789', '01', 'Asthma', 'Father side', '2024-10-16 05:18:16', '2024-10-16 13:18:15', '20241016131815', NULL, NULL),
(14, '123456789', '01', 'Asthma', 'aass', '2024-10-16 05:28:24', '2024-10-16 13:28:23', '20241016132823', NULL, NULL),
(15, '123456789', '05', 'Heart Disorder', 'Father', '2024-10-18 00:58:42', '2024-10-18 08:58:41', '20241018085841', NULL, NULL),
(16, '123456789', '0B', 'Stroke', 'Mother', '2024-10-25 05:30:40', '2024-10-25 13:30:39', '20241025133039', NULL, NULL),
(17, '123456789', '01', 'Asthma', 'asdas', '2024-10-25 05:30:41', '2024-10-25 13:30:39', '20241025133039', NULL, NULL),
(18, '123456788', '01', 'Asthma', 'Father', '2024-10-29 02:21:44', '2024-10-29 10:21:40', '20241029102140', NULL, NULL),
(19, '123456788', '04', 'Diabetes', 'Mother', '2024-10-29 04:17:13', '2024-10-29 12:17:09', '20241029121709', NULL, NULL),
(20, '123456788', '05', 'Heart Disorder', 'Father', '2024-10-29 04:17:13', '2024-10-29 12:17:09', '20241029121709', NULL, NULL),
(21, '123456788', '08', 'Mental Disorder', 'Grand parents', '2024-10-29 04:17:13', '2024-10-29 12:17:09', '20241029121709', NULL, NULL),
(22, '123456788', '09', 'Obesity', 'Parents', '2024-10-29 04:18:12', '2024-10-29 12:18:08', '20241029121808', NULL, NULL),
(23, '123456787', '01', 'Asthma', 'Parents', '2024-10-29 07:21:55', '2024-10-29 15:21:52', '20241029152152', NULL, NULL),
(24, '123456789', '01', 'Asthma', 'Fathet', '2024-10-30 07:08:40', '2024-10-30 15:08:36', '20241030150836', NULL, NULL),
(25, '123456789', '04', 'Diabetes', 'Mother', '2024-10-30 07:08:40', '2024-10-30 15:08:36', '20241030150836', NULL, NULL),
(26, '123456787', '01', 'Asthma', 'Father', '2024-11-17 06:15:18', '2024-11-17 14:15:15', '20241117141515', NULL, NULL),
(27, '123456787', '01', 'Asthma', 'Father', '2024-11-17 06:16:16', '2024-11-17 14:16:13', '20241117141613', NULL, NULL),
(28, '123456788', '04', 'Diabetes', 'Mother', '2024-11-17 15:37:23', '2024-11-17 23:37:23', '20241117233723', NULL, NULL),
(29, '123456788', '05', 'Heart Disorder', 'Father', '2024-11-17 15:37:23', '2024-11-17 23:37:23', '20241117233723', NULL, NULL),
(30, '123456787', '01', 'Asthma', 'father', '2024-11-18 03:51:13', '2024-11-18 11:51:12', '20241118115112', NULL, NULL),
(31, '123456787', '09', 'Obesity', 'mother', '2024-11-18 03:51:13', '2024-11-18 11:51:12', '20241118115112', NULL, NULL);

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

--
-- Table structure for table `medicalhistory`
--

CREATE TABLE `medicalhistory` (
  `id` int NOT NULL,
  `trans_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `diseaseName` varchar(255) DEFAULT NULL,
  `diseaseCode` varchar(100) DEFAULT NULL,
  `does_smoke` enum('Daily','Occasionally','No') DEFAULT 'No',
  `smoking_status` text,
  `does_drink_alcohol` enum('Daily','Occasionally','No') DEFAULT 'No',
  `alcohol_status` text,
  `physician_name` varchar(255) DEFAULT NULL,
  `physician_license` varchar(100) DEFAULT NULL,
  `philhealth_id_number` varchar(100) DEFAULT NULL,
  `patient_name` varchar(255) DEFAULT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `doctorinfo` varchar(255) DEFAULT NULL,
  `surgery_history` enum('Yes','No') DEFAULT NULL,
  `surgery_details` varchar(255) DEFAULT NULL,
  `date_ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `medicalhistory`
--

INSERT INTO `medicalhistory` (`id`, `trans_date`, `diseaseName`, `diseaseCode`, `does_smoke`, `smoking_status`, `does_drink_alcohol`, `alcohol_status`, `physician_name`, `physician_license`, `philhealth_id_number`, `patient_name`, `reference`, `doctorinfo`, `surgery_history`, `surgery_details`, `date_ts`, `created_at`, `updated_at`) VALUES
(16, '2024-10-29 10:21:40', 'Allergy,Asthma,Behavioral Problem ', '01,03,04', 'Daily', NULL, 'Daily', NULL, 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029102140', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'No', '', '2024-10-29 02:21:44', NULL, NULL),
(17, '2024-10-29 12:17:09', 'Anemia,Asthma,Chickenpox ,Convulsion ', '02,03,07,08', 'No', NULL, 'Occasionally', NULL, 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029121709', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'Yes', 'Appendix', '2024-10-29 04:17:13', NULL, NULL),
(18, '2024-10-29 12:18:08', 'Asthma,Diabetes ', '03,0A', 'Occasionally', NULL, 'Daily', NULL, 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029121808', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'No', '', '2024-10-29 04:18:12', NULL, NULL),
(19, '2024-10-29 15:21:52', 'Allergy,Anemia', '01,02', 'Daily', NULL, 'Daily', NULL, 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029152152', '10000058;          Dr Theodor Seuss III;2000000058', 'No', '', '2024-10-29 07:21:55', NULL, NULL),
(20, '2024-10-30 15:08:36', 'Allergy,Anemia', '01,02', 'Daily', NULL, 'Occasionally', NULL, 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241030150836', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'No', '', '2024-10-30 07:08:40', NULL, NULL),
(21, '2024-11-05 11:09:44', 'Allergy,Vision Defect', '01,1F', 'Daily', NULL, 'Occasionally', NULL, 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241105110944', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'No', '', '2024-11-05 04:26:43', NULL, NULL),
(22, '2024-11-05 11:10:51', 'Behavioral Problem ', '04', 'Occasionally', NULL, 'Occasionally', NULL, 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241105111051', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'No', '', '2024-11-05 04:26:53', NULL, NULL),
(23, '2024-11-17 14:15:15', '01,02,07', 'Allergy,Anemia,Chickenpox ', 'No', NULL, 'Daily', NULL, 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', '20241117141515', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'Yes', 'Liver', '2024-11-17 06:15:18', NULL, NULL),
(24, '2024-11-17 14:16:13', '01,02,07', 'Allergy,Anemia,Chickenpox ', 'No', NULL, 'Daily', NULL, 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', '20241117141613', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'Yes', 'Liver', '2024-11-17 06:16:16', NULL, NULL),
(25, '2024-11-17 23:37:23', 'Allergy', '01', 'No', NULL, 'No', NULL, 'Dr Theodor Seuss III', '2000000058', '123456788', 'CRUZ, CORAZON', '20241117233723', '10000058;          Dr Theodor Seuss III;2000000058', 'No', '', '2024-11-17 15:37:23', NULL, NULL),
(26, '2024-11-18 11:51:12', 'Allergy,Epilepsy ,Vision Defect', '01,0D,1F', 'Daily', NULL, 'Occasionally', NULL, 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', '20241118115112', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'No', '', '2024-11-18 03:51:13', NULL, NULL);

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

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

CREATE TABLE `members` (
  `id` int NOT NULL,
  `fname` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mname` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lname` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `complete_address` varchar(1225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `birthday` date NOT NULL,
  `gender` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `house_no` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `street` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `brgy` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `city` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `province` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `zip_code` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contact_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `philhealth_id` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date_ts` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `members` (`id`, `fname`, `mname`, `lname`, `complete_address`, `birthday`, `gender`, `house_no`, `street`, `brgy`, `city`, `province`, `zip_code`, `contact_no`, `status`, `philhealth_id`, `date_ts`, `created_at`, `updated_at`) VALUES
(1, 'Rommel', 'Cayabyab', 'Santiago', '436 Oplas, Bacnar, San Carlos City, Pangasinan', '1996-03-27', 'Male', '436', 'Oplas', 'Bacnar', 'San Carlos City', 'Pangasinan', '2420', '09384547619', 0, '231935100876', '2024-03-20 19:46:00', NULL, NULL),
(2, 'Ivana', 'Alawi', 'Alawi', '436 Oplas, Bacnar, San Carlos City, Pangasinan', '1996-03-27', 'Female', '436', 'Oplas', 'Bacnar', 'San Carlos City', 'Pangasinan', '2420', '09384547619', 0, '444647098480', '2024-03-20 19:51:43', NULL, NULL),
(3, 'Reymart', 'Mangaliag', 'Tamondong', '123 Santiago, Santolan, Pasig City, Manila', '2018-09-27', 'Male', '123', 'Santiago', 'Santolan', 'Pasig City', 'Manila', '1016', '09673291243', 0, '692060871636', '2024-03-20 21:35:23', NULL, NULL),
(4, 'San', 'Gokou', 'Kakarot', '143 Alalbong, Bacnar, San Carlos City, Pangasinan', '1996-03-27', 'Male', '143', 'Alalbong', 'Bacnar', 'San Carlos City', 'Pangasinan', '2420', '09384547619', 0, '730965892221', '2024-03-20 21:39:46', NULL, NULL),
(5, 'Fname 1', 'Mname 1', 'Lname1', '436 Oplas, Bacnar, San Carlos City , Pangasinan', '1996-03-27', 'Male', '436', 'Oplas', 'Bacnar', 'San Carlos City ', 'Pangasinan', '2420', '09090900909', 0, '290335176039', '2024-08-13 13:38:36', NULL, NULL);

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

--
-- Table structure for table `organdonor`
--

CREATE TABLE `organdonor` (
  `id` int NOT NULL,
  `trans_date` datetime NOT NULL,
  `physician_name` varchar(255) NOT NULL,
  `physician_license` varchar(100) NOT NULL,
  `philhealth_id_number` varchar(100) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `reference` varchar(100) NOT NULL,
  `doctorinfo` varchar(255) DEFAULT NULL,
  `organ_donor_reason` varchar(500) NOT NULL,
  `organ_donor_advise` varchar(500) NOT NULL,
  `organ_donor_patient_consent` varchar(500) NOT NULL,
  `selected_organs` varchar(500) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `organdonor`
--

INSERT INTO `organdonor` (`id`, `trans_date`, `physician_name`, `physician_license`, `philhealth_id_number`, `fullname`, `reference`, `doctorinfo`, `organ_donor_reason`, `organ_donor_advise`, `organ_donor_patient_consent`, `selected_organs`, `created_at`, `updated_at`) VALUES
(1, '2024-09-19 17:08:43', '', '', '', '', '', '', '', '', '', '', NULL, NULL),
(2, '2024-09-19 17:09:10', 'Dr. Maria Santos', '456789', 'PH987654321', 'Juan dela Cruz', 'REF987654', 'Specialist in organ transplants', 'To contribute to life-saving treatments', 'The donor is aware of the procedures and implications.', 'Patient has given informed consent for organ donation.', 'Heart~Kidney~Liver', NULL, NULL),
(17, '2024-10-29 10:24:09', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029102409', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'Poor', 'Not a good decision', 'Yes', '03,05', NULL, NULL),
(18, '2024-10-29 12:35:04', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029123504', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'For humanity', 'Good decision', 'Yes', '04,05', NULL, NULL),
(19, '2024-10-29 12:36:01', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029123601', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'For money', 'Good', 'Written agreement', '09,0A', NULL, NULL),
(20, '2024-10-29 15:26:55', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029152655', '10000058;          Dr Theodor Seuss III;2000000058', 'Love', 'Good', 'Yes', '02,03', NULL, NULL),
(21, '2024-10-30 15:13:41', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241030151341', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'For money', 'Ideally', 'Yes, agreement', '02,03', NULL, NULL),
(22, '2024-11-16 07:34:41', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', '20241116073441', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'No Money', 'Not Good', 'Yes, legal agreement', '02,08,09,0A', NULL, NULL),
(23, '2024-11-17 23:43:45', 'Dr Theodor Seuss III', '2000000058', '123456788', 'CRUZ, CORAZON', '20241117234345', '10000058;          Dr Theodor Seuss III;2000000058', 'Sudden Heart Failure', 'Good', 'Written', '02', NULL, NULL),
(24, '2024-11-18 12:31:54', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', '20241118123154', '10000008;      Dr Theodor Seuss Geisel ;2000000008', 'For Kindness', 'Think again', 'Yes', '02,08', NULL, NULL);

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

--
-- Table structure for table `prescription`
--

CREATE TABLE `prescription` (
  `id` int NOT NULL,
  `generic_med` varchar(255) DEFAULT NULL,
  `brand` varchar(255) DEFAULT NULL,
  `dosage` varchar(100) DEFAULT NULL,
  `dosage_remarks` varchar(255) DEFAULT NULL,
  `duration` varchar(50) DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `purchased` int DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `physician` varchar(255) DEFAULT NULL,
  `physician_license` varchar(100) DEFAULT NULL,
  `philhealth_id_number` varchar(100) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `doctor_info` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `prescription`
--

INSERT INTO `prescription` (`id`, `generic_med`, `brand`, `dosage`, `dosage_remarks`, `duration`, `quantity`, `purchased`, `trans_date`, `physician`, `physician_license`, `philhealth_id_number`, `fullname`, `reference`, `doctor_info`, `created_at`, `updated_at`) VALUES
(1, 'Paracetamol', 'Tylenol', '500mg', 'Take after meals', '7 days', 14, 0, '2024-09-19 01:26:06', 'Dr. John Doe', '123456789', 'PH987654321', 'Jane Doe', 'REF123456789', 'General Physician', NULL, NULL),
(13, 'Paracetamol', 'Prizer', '500mg', 'Adults', '1week', 7, 7, '2024-10-29 10:22:52', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029102252', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(14, 'Panadol', 'Paracetamol', '250 mg', '3x a day', '7days', 21, 800, '2024-10-29 12:28:42', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029122842', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(15, 'Paracetamol', 'Bioflue', '500g', '3xday', '3days', 9, 800, '2024-10-29 15:23:04', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029152304', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(16, 'Anlodophine', 'Alo Med', '500mg', '1 daily', '1 week', 7, 7, '2024-10-29 15:54:29', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029155429', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(17, 'Paracetamol', 'Panadoll', '500mg', '1x day', '1week', 7, 900, '2024-10-30 15:09:58', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241030150958', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(18, 'Panadol', 'BioFlu', '500mg', '', '5days', 15, 10147, '2024-11-16 06:29:11', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', '20241116062911', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(19, 'Paracetamol', 'Unilab', '500 mg', '', '2 days', 10, 25, '2024-11-17 23:40:10', 'Dr Theodor Seuss III', '2000000058', '123456788', 'CRUZ, CORAZON', '20241117234010', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(20, 'Paracetamol', 'Neosep', '500mg', '', '1 week', 7, 2500, '2024-11-18 12:03:30', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', '20241118120330', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL);

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

--
-- Table structure for table `ref_allergies`
--

CREATE TABLE `ref_allergies` (
  `id` int NOT NULL,
  `allergy` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `code` varchar(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `status` int DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ref_allergies`
--

INSERT INTO `ref_allergies` (`id`, `allergy`, `code`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Pollen Allergy', '01', 0, NULL, NULL),
(2, 'Latex Allergy', '02', 0, NULL, NULL),
(3, 'Food Allergy', '03', 0, NULL, NULL),
(4, 'Insect Sting Allergy', '04', 0, NULL, NULL),
(5, 'Dust Mite Allergy', '05', 0, NULL, NULL),
(6, 'Pet Allergy', '06', 0, NULL, NULL),
(7, 'Medication Allergy', '07', 0, NULL, NULL),
(8, 'Egg Allergy', '08', 0, NULL, NULL),
(9, 'Milk Allergy', '09', 0, NULL, NULL),
(10, 'Nut Allergy', '0A', 0, NULL, NULL),
(11, 'Alcohon Allergy', '0B', 0, NULL, NULL),
(12, 'Penicillin Allergy', '0C', 0, NULL, NULL),
(13, 'Mefenamic Allergy', '0D', 0, NULL, NULL);

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

--
-- Table structure for table `ref_disease`
--

CREATE TABLE `ref_disease` (
  `id` int NOT NULL,
  `disease` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `code` varchar(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `status` int DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ref_disease`
--

INSERT INTO `ref_disease` (`id`, `disease`, `code`, `status`, `created_at`, `updated_at`) VALUES
(12, 'Allergy', '01', 0, NULL, NULL),
(13, 'Anemia', '02', 0, NULL, NULL),
(14, 'Asthma', '03', 0, NULL, NULL),
(15, 'Behavioral Problem ', '04', 0, NULL, NULL),
(16, 'Bleeding Problem ', '05', 0, NULL, NULL),
(17, 'Blood Abnormality ', '06', 0, NULL, NULL),
(18, 'Chickenpox ', '07', 0, NULL, NULL),
(19, 'Convulsion ', '08', 0, NULL, NULL),
(20, 'Dengue ', '09', 0, NULL, NULL),
(21, 'Diabetes ', '0A', 0, NULL, NULL),
(22, 'Ear Problem ', '0B', 0, NULL, NULL),
(23, 'Eating Disorder', '0C', 0, NULL, NULL),
(24, 'Epilepsy ', '0D', 0, NULL, NULL),
(25, 'Eye Problem', '0E', 0, NULL, NULL),
(26, 'Fracture Typhoid Fever', '0F', 0, NULL, NULL),
(27, 'Hearing Problem ', '10', 0, NULL, NULL),
(28, 'Heart Disorder', '11', 0, NULL, NULL),
(29, 'Hyperacidity', '12', 0, NULL, NULL),
(30, 'Indigestion', '13', 0, NULL, NULL),
(31, 'Insomnia', '14', 0, NULL, NULL),
(32, 'Kidney Problem', '15', 0, NULL, NULL),
(33, 'Liver Problem', '16', 0, NULL, NULL),
(34, 'Measles', '17', 0, NULL, NULL),
(35, 'Mumps', '18', 0, NULL, NULL),
(36, 'Parasitism', '19', 0, NULL, NULL),
(37, 'Pneumonia', '1A', 0, NULL, NULL),
(38, 'Primary Complex', '1B', 0, NULL, NULL),
(39, 'Scoliosis', '1C', 0, NULL, NULL),
(40, 'Skin Problem', '1D', 0, NULL, NULL),
(41, 'Tonsillitis', '1E', 0, NULL, NULL),
(42, 'Vision Defect', '1F', 0, NULL, NULL),
(43, 'Asthma', '01', 1, NULL, NULL);

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

--
-- Table structure for table `ref_healthproblem`
--

CREATE TABLE `ref_healthproblem` (
  `id` int NOT NULL,
  `healthproblem` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `code` varchar(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `status` int DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ref_healthproblem`
--

INSERT INTO `ref_healthproblem` (`id`, `healthproblem`, `code`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Tuberculosis (TB)', '01', 0, NULL, NULL),
(2, 'Ischaemic Heart Disease', '02', 0, NULL, NULL),
(3, 'Cancer', '03', 0, NULL, NULL),
(4, 'Protein-Energy Malnutrition and Micronutrient Deficiencies', '04', 0, NULL, NULL),
(5, 'Dengue Fever', '05', 0, NULL, NULL),
(6, 'Malaria', '06', 0, NULL, NULL),
(7, 'HIV/AIDS', '07', 0, NULL, NULL),
(8, 'Obesity and Heart Disease', '08', 0, NULL, NULL),
(9, 'Infectious Diseases', '09', 0, NULL, NULL),
(10, 'Mental Health', '0A', 0, NULL, NULL),
(11, 'Cholera', '0B', 0, NULL, NULL),
(12, 'Typhoid fever', '0C', 0, NULL, NULL),
(13, 'Influenza', '0D', 0, NULL, NULL),
(14, 'Measles', '0E', 0, NULL, NULL),
(15, 'Meningitis', '0F', 0, NULL, NULL),
(16, 'Pneumonia', '10', 0, NULL, NULL),
(17, 'Diarrheal diseases', '11', 0, NULL, NULL),
(18, 'Respiratory tract infections', '12', 0, NULL, NULL),
(19, 'Diabetes', '13', 0, NULL, NULL),
(20, 'Heart disease', '14', 0, NULL, NULL),
(21, 'Stroke', '15', 0, NULL, NULL),
(22, 'Cancer', '16', 0, NULL, NULL),
(23, 'Chronic diseases affecting the airways and lungs', '17', 0, NULL, NULL);

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

--
-- Table structure for table `ref_organ`
--

CREATE TABLE `ref_organ` (
  `id` int NOT NULL,
  `organs` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `code` varchar(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `status` int DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ref_organ`
--

INSERT INTO `ref_organ` (`id`, `organs`, `code`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Brain', '01', 1, NULL, NULL),
(2, 'Heart', '02', 0, NULL, NULL),
(3, 'Kidney', '03', 0, NULL, NULL),
(4, 'Liver', '04', 0, NULL, NULL),
(5, 'Pancreas', '05', 0, NULL, NULL),
(6, 'Stomach', '06', 0, NULL, NULL),
(7, 'Lungs', '07', 0, NULL, NULL),
(8, 'Skin', '08', 0, NULL, NULL),
(9, 'Spleen', '09', 0, NULL, NULL),
(10, 'Eye', '0A', 0, NULL, NULL);

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

--
-- Table structure for table `ref_periodictreatments`
--

CREATE TABLE `ref_periodictreatments` (
  `id` int NOT NULL,
  `treatments` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `code` varchar(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `status` int DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ref_periodictreatments`
--

INSERT INTO `ref_periodictreatments` (`id`, `treatments`, `code`, `status`, `created_at`, `updated_at`) VALUES
(1, '2D + 3D Breast Ultrasound', '01', 0, NULL, NULL),
(2, 'Blood Transfusion', '02', 0, NULL, NULL),
(3, 'Diabetes Combined: Insulin/CBG', '03', 0, NULL, NULL),
(4, 'Bladder Scan', '04', 1, NULL, NULL),
(5, 'Dialysis', '05', 0, NULL, NULL),
(6, 'Chemotheraphy', '06', 0, NULL, NULL);

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

--
-- Table structure for table `ref_religion`
--

CREATE TABLE `ref_religion` (
  `id` int NOT NULL,
  `code` varchar(255) NOT NULL,
  `title` text NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `ref_religion`
--

INSERT INTO `ref_religion` (`id`, `code`, `title`, `created_at`, `updated_at`) VALUES
(1, '01', 'Roman Catholic', '2024-10-28 16:56:08', NULL),
(2, '02', 'Iglesia ni Kristo', '2024-10-28 16:56:08', NULL),
(3, '03', 'Jehovah\'s Withnesses', '2024-10-28 16:56:08', NULL),
(4, '04', 'Born Again', '2024-10-28 16:56:08', NULL);

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

--
-- Table structure for table `treatments`
--

CREATE TABLE `treatments` (
  `id` int NOT NULL,
  `diagnosis` varchar(255) DEFAULT NULL,
  `conditions` varchar(255) DEFAULT NULL,
  `treatment_type` varchar(255) DEFAULT NULL,
  `treatment_schedule` varchar(255) DEFAULT NULL,
  `medications` varchar(255) DEFAULT NULL,
  `laboratory_tests` varchar(255) DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `physician_name` varchar(255) DEFAULT NULL,
  `physician_license` varchar(100) DEFAULT NULL,
  `philhealth_id_number` varchar(100) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `doctorinfo` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `treatments`
--

INSERT INTO `treatments` (`id`, `diagnosis`, `conditions`, `treatment_type`, `treatment_schedule`, `medications`, `laboratory_tests`, `trans_date`, `physician_name`, `physician_license`, `philhealth_id_number`, `fullname`, `reference`, `doctorinfo`, `created_at`, `updated_at`) VALUES
(1, 'Hypertension', 'High blood pressure, Obesity', 'Medication', '2 times daily for 30 days', 'Amlodipine, Losartan', 'Blood test, ECG', '2024-09-19 01:29:53', 'Dr. Juan Dela Cruz', '123456', 'PH123456789', 'Maria Santos', 'REF1234567890', NULL, NULL, NULL),
(2, 'Hypertension', 'High blood pressure', 'Medication', 'Once daily', 'Lisinopril', 'Blood pressure check', '2024-09-19 01:35:49', 'Dr. John Doe', '123456', 'PH123456789', 'Jane Smith', 'REF123456', 'Specialist in cardiovascular diseases', NULL, NULL),
(3, '', '', '', '', '', '', '2024-09-19 01:43:14', 'Dr. Jane Smith', '123456', 'PH123456789', 'John Doe', 'REF123456', 'General Practitioner with 10 years of experience.', NULL, NULL),
(4, 'Hypertension', 'High blood pressure', 'Medication', 'Once daily', 'Lisinopril', 'Blood pressure check', '2024-09-19 09:08:49', 'Dr. John Doe', '123456', 'PH123456789', 'Jane Smith', 'REF123456', NULL, NULL, NULL),
(19, 'Strep throat', 'Chills, headach, abdominal pain', 'Antibiotics', '5days', 'Take antibiotics', 'Positive to bacteria', '2024-10-29 12:32:09', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029123209', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(20, 'Eye issue', 'Rear views', 'Operations', 'New week', 'Oitment', 'Good', '2024-10-29 15:25:25', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029152525', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(21, 'Chest pain', 'HB', 'Admit 24hrs', 'Today', 'Anlodophine', 'High cholesterol', '2024-10-30 15:11:35', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241030151135', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(22, 'Highblood', 'Severe', '', '', 'Not Goood', '', '2024-11-16 06:42:49', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', '20241116064249', '', NULL, NULL),
(23, 'Hypetension', 'Bad', '', '', '3x', '', '2024-11-16 14:22:06', 'Dr Theodor Seuss Geisel', '2000000008', '123456758', 'TORRALBA, ROLDAN', '20241116142206', '', NULL, NULL),
(24, 'Hypertension', 'Stage 1 Hypertension', '', '', 'Medicine', '', '2024-11-17 23:42:31', 'Dr Theodor Seuss III', '2000000058', '123456788', 'CRUZ, CORAZON', '20241117234231', '', NULL, NULL),
(25, 'Kidney stones', 'severe', '', '', 'diet', '', '2024-11-18 12:22:23', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', '20241118122223', '', NULL, NULL);

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

--
-- Table structure for table `users_manila`
--

CREATE TABLE `users_manila` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `fname` varchar(255) NOT NULL,
  `mname` varchar(255) NOT NULL,
  `lname` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `marital` varchar(255) NOT NULL,
  `birthday` date NOT NULL,
  `street` varchar(255) NOT NULL,
  `barangay` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `zip_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `type` int NOT NULL COMMENT '1-Super Administrator, 2-Administrator	',
  `status` int NOT NULL COMMENT '	0-Inactive, 1-Active, 2-Deleted',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `vaccinations`
--

CREATE TABLE `vaccinations` (
  `id` int NOT NULL,
  `manufacturer` varchar(255) DEFAULT NULL,
  `vaccine_name` varchar(255) DEFAULT NULL,
  `dose_number` varchar(10) DEFAULT NULL,
  `administration_date` date DEFAULT NULL,
  `next_injection_date` date DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `physician` varchar(255) DEFAULT NULL,
  `physician_license` varchar(100) DEFAULT NULL,
  `philhealth_id_number` varchar(100) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `doctor_info` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `vaccinations`
--

INSERT INTO `vaccinations` (`id`, `manufacturer`, `vaccine_name`, `dose_number`, `administration_date`, `next_injection_date`, `trans_date`, `physician`, `physician_license`, `philhealth_id_number`, `fullname`, `reference`, `doctor_info`, `created_at`, `updated_at`) VALUES
(1, 'Pfizer', 'COVID-19 Vaccine', '2nd Dose', '2023-03-20', '2024-03-20', '2024-09-16 00:00:00', 'Dr. Peter Parker', 'LIC908765', 'PHID556677', 'Clark Kent', 'REF445566', NULL, NULL, NULL),
(2, 'Pfizer', 'COVID-19 Vaccine', '1', '2024-09-15', '2024-10-15', '2024-09-18 00:00:00', 'Dr. John Smith', 'LIC123456', 'PH123456789', 'Jane Doe', 'REF987654321', 'Dr. John Smith is a licensed physician specializing in immunology.', NULL, NULL),
(7, 'Johnson & Johnson', 'COVID-19 Vaccine', '1', '2024-09-25', '2024-11-25', '2024-09-18 14:15:55', 'Dr. Robert Brown', 'LIC789012', 'PH123456787', 'Robert Lee', 'REF321654987', 'Dr. Robert Brown has extensive experience in vaccination and public health.', NULL, NULL),
(20, 'Prizer', 'XVac', '500mg', '2024-10-30', '2024-10-31', '2024-10-29 10:16:14', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029101614', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(21, 'Philippines Lab', 'Influenza Vaccine', '1 shot', '2024-10-27', '2024-11-30', '2024-10-29 12:13:17', 'Dr Theodor Seuss Geisel', '2000000008', '123456788', 'CORAZON CRUZ', '20241029121317', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(22, 'Prizer', 'Flu Vax', '5lml', '2024-10-28', '2024-12-27', '2024-10-29 15:15:37', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029151537', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(23, 'Medicare Tech', 'Sinovax', '1dose', '2024-10-28', '2024-11-30', '2024-10-29 15:16:59', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029151659', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(24, 'Russia Mac', 'Sinovac', '1ml', '2024-10-28', '2024-11-28', '2024-10-29 15:47:42', 'Dr Theodor Seuss III', '2000000058', '123456787', 'CORAZON CRUZ', '20241029154742', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(25, 'Pfizer', 'Fluvaccine', '1ml', '2024-10-31', '2024-11-04', '2024-10-30 15:06:33', 'Dr Theodor Seuss Geisel', '2000000008', '123456789', 'CORAZON CRUZ', '20241030150633', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(26, 'Sinovac', 'COVID 19', '1ml', '2024-11-04', '2024-11-29', '2024-11-16 05:35:50', 'Dr Theodor Seuss Geisel', '2000000008', '1234567587', 'TORRALBA, ROLDAN', '20241116053550', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(27, 'RUSSIA', 'RUSH VAC', '2 dose', '2024-01-10', '2025-11-29', '2024-11-16 05:47:16', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CASTRO, NOEL', '20241116054716', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(28, 'Pfizer', 'Corminaty', '2', '2024-11-17', '2025-12-17', '2024-11-17 23:34:05', 'Dr Theodor Seuss III', '2000000058', '123456788', 'CRUZ, CORAZON', '20241117233405', '10000058;          Dr Theodor Seuss III;2000000058', NULL, NULL),
(29, 'Flux VAc', 'flu vaccine', '5ml', '2024-01-14', '2025-12-12', '2024-11-18 11:35:10', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', '20241118113510', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(30, 'Flux VAc', 'flu vaccine', '5ml', '2024-01-14', '2025-12-12', '2024-11-18 11:41:45', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', '20241118114145', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(31, 'Flux VAc', 'flu vaccine', '5ml', '2024-01-14', '2025-12-12', '2024-11-18 11:42:35', 'Dr Theodor Seuss Geisel', '2000000008', '123456787', 'CRUZ, CORAZON', '20241118114235', '10000008;      Dr Theodor Seuss Geisel ;2000000008', NULL, NULL),
(32, 'Prizer', 'Flu Vaccine', '500ml', '2024-04-17', '2025-02-04', '2024-11-19 15:29:14', 'Dr Theodor Seuss Geisel', '2000000008', '123456700', 'DELACRUS, JUAN', '20241119152914', '10000008;Dr Theodor Seuss Geisel;2000000008', NULL, NULL);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `allergies`
--
ALTER TABLE `allergies`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT for table `dischargesummary`
--
ALTER TABLE `dischargesummary`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `donotresuscitate`
--
ALTER TABLE `donotresuscitate`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `healthproblem`
--
ALTER TABLE `healthproblem`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `insurancerecord`
--
ALTER TABLE `insurancerecord`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT for table `listfamilyhistorydisease`
--
ALTER TABLE `listfamilyhistorydisease`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `medicalfamilyhistory`
--
ALTER TABLE `medicalfamilyhistory`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `medicalhistory`
--
ALTER TABLE `medicalhistory`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `organdonor`
--
ALTER TABLE `organdonor`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `prescription`
--
ALTER TABLE `prescription`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `ref_allergies`
--
ALTER TABLE `ref_allergies`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `ref_disease`
--
ALTER TABLE `ref_disease`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `ref_healthproblem`
--
ALTER TABLE `ref_healthproblem`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `ref_organ`
--
ALTER TABLE `ref_organ`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `ref_periodictreatments`
--
ALTER TABLE `ref_periodictreatments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `ref_religion`
--
ALTER TABLE `ref_religion`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `treatments`
--
ALTER TABLE `treatments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `vaccinations`
--
ALTER TABLE `vaccinations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;
COMMIT;

