[encoded data, 54048 characters]','[102, 115, 100, 107, 3, 0, 0, 0, 16, 4, 0, 0, 231, 181, 196, 66, 39, 68, 108, 61, 54, 221, 123, 188, 40, 142, 225, 188, 115, 229, 137, 188, 127, 244, 23, 189, 149, 171, 14, 189, 10, 214, 171, 60, 65, 64, 70, 188, 13, 163, 45, 189, 55, 64, 139, 61, 112, 105, 148, 189, 235, 186, 75, 189, 150, 207, 155, 188, 50, 29, 172, 188, 30, 214, 139, 189, 192, 109, 97, 189, 51, 88, 172, 189, 96, 183, 160, 188, 223, 223, 3, 60, 87, 9, 67, 59, 146, 186, 21, 61, 107, 38, 119, 189, 225, 185, 209, 59, 191, 104, 175, 60, 229, 93, 77, 60, 125, 52, 28, 61, 33, 191, 91, 61, 90, 149, 223, 189, 118, 27, 110, 61, 15, 79, 36, 58, 6, 85, 137, 61, 35, 16, 81, 61, 72, 38, 146, 61, 69, 64, 11, 62, 224, 226, 94, 187, 60, 111, 185, 189, 5, 163, 52, 189, 87, 150, 14, 187, 206, 203, 37, 61, 9, 91, 33, 187, 121, 101, 155, 59, 38, 82, 91, 188, 114, 32, 160, 61, 233, 26, 1, 190, 185, 183, 185, 189, 82, 53, 14, 189, 45, 170, 113, 189, 115, 76, 139, 189, 58, 15, 9, 189, 9, 103, 207, 189, 78, 167, 152, 60, 132, 167, 81, 60, 118, 80, 171, 61, 88, 52, 155, 189, 100, 242, 46, 61, 154, 254, 133, 187, 39, 69, 152, 188, 179, 10, 28, 62, 226, 100, 108, 61, 13, 214, 18, 60, 244, 123, 5, 190, 92, 81, 99, 61, 207, 86, 161, 189, 240, 14, 22, 188, 143, 114, 225, 61, 3, 255, 106, 61, 250, 200, 0, 61, 224, 241, 95, 188, 83, 187, 170, 189, 1, 134, 176, 61, 238, 165, 227, 60, 46, 71, 138, 60, 93, 93, 159, 188, 30, 160, 212, 187, 184, 74, 69, 189, 105, 59, 76, 61, 155, 132, 47, 188, 235, 87, 21, 61, 177, 168, 57, 188, 105, 47, 4, 62, 76, 147, 236, 58, 154, 210, 245, 60, 184, 238, 212, 189, 125, 234, 51, 61, 22, 211, 197, 189, 197, 48, 177, 189, 47, 16, 156, 189, 52, 143, 249, 189, 163, 164, 132, 188, 79, 163, 210, 188, 163, 133, 143, 60, 218, 222, 169, 189, 164, 168, 248, 60, 156, 171, 232, 188, 54, 253, 157, 59, 217, 201, 159, 60, 7, 149, 167, 60, 14, 94, 139, 188, 23, 147, 11, 61, 171, 74, 14, 61, 181, 153, 132, 61, 30, 205, 215, 60, 30, 30, 64, 61, 168, 164, 141, 189, 126, 110, 14, 60, 194, 79, 230, 189, 17, 207, 252, 60, 54, 228, 180, 187, 127, 131, 44, 61, 157, 5, 130, 188, 85, 44, 235, 188, 80, 74, 203, 58, 246, 25, 54, 187, 28, 62, 212, 61, 17, 172, 120, 61, 169, 85, 226, 58, 193, 49, 80, 189, 97, 171, 175, 188, 117, 20, 188, 61, 94, 255, 70, 188, 110, 228, 245, 189, 145, 180, 53, 189, 0, 2, 208, 61, 182, 252, 195, 61, 69, 10, 154, 189, 186, 105, 184, 61, 79, 168, 194, 188, 109, 163, 49, 188, 51, 245, 142, 189, 224, 227, 172, 188, 240, 212, 228, 61, 154, 9, 186, 189, 165, 48, 222, 61, 103, 209, 47, 189, 176, 235, 63, 61, 0, 216, 169, 61, 120, 42, 120, 60, 15, 192, 148, 188, 152, 160, 63, 189, 192, 239, 22, 190, 56, 197, 202, 61, 157, 74, 129, 189, 146, 83, 228, 61, 233, 249, 224, 188, 30, 38, 10, 61, 25, 252, 9, 189, 163, 184, 43, 61, 136, 83, 123, 61, 48, 20, 199, 189, 146, 220, 8, 62, 74, 14, 201, 189, 99, 149, 153, 189, 217, 66, 155, 189, 84, 55, 27, 189, 98, 164, 237, 61, 251, 183, 14, 61, 32, 100, 171, 189, 122, 116, 59, 185, 171, 111, 113, 61, 236, 109, 186, 61, 234, 56, 129, 61, 63, 3, 80, 61, 81, 94, 247, 59, 77, 121, 65, 61, 65, 45, 33, 61, 37, 19, 206, 188, 250, 218, 2, 60, 173, 243, 65, 189, 201, 100, 125, 189, 247, 98, 15, 190, 16, 18, 69, 189, 223, 192, 126, 61, 215, 206, 234, 189, 84, 124, 30, 189, 194, 79, 61, 61, 98, 154, 55, 189, 199, 125, 134, 188, 221, 37, 67, 61, 89, 29, 178, 60, 77, 221, 113, 189, 122, 99, 119, 189, 229, 86, 209, 188, 230, 197, 31, 188, 81, 210, 81, 189, 27, 82, 49, 59, 92, 230, 154, 61, 66, 234, 116, 59, 44, 48, 1, 61, 45, 31, 105, 189, 4, 72, 98, 188, 53, 197, 67, 189, 202, 126, 159, 60, 86, 140, 12, 61, 209, 36, 112, 60, 67, 148, 18, 61, 131, 21, 51, 61, 227, 37, 160, 189, 219, 127, 244, 61, 136, 197, 221, 60, 114, 64, 4, 61, 79, 65, 161, 60, 208, 78, 111, 61, 71, 32, 179, 61, 21, 78, 151, 189, 50, 234, 154, 189, 206, 189, 151, 58, 178, 31, 180, 189, 81, 14, 220, 188, 225, 200, 25, 61, 130, 208, 194, 189, 15, 175, 124, 59, 224, 95, 165, 187, 98, 162, 39, 61, 184, 225, 230, 61, 173, 102, 58, 61, 28, 8, 175, 61, 158, 7, 49, 188, 90, 111, 16, 61, 30, 174, 41, 186, 167, 91, 145, 189, 77, 166, 39, 62, 168, 231, 157, 187, 231, 227, 35, 61, 115, 219, 162, 189, 239, 110, 193, 189, 97, 225, 43, 61, 3, 124, 177, 189, 75, 119, 45, 61, 219, 239, 137, 189, 194, 106, 151, 61, 234, 104, 6, 61, 157, 108, 84, 60, 223, 220, 245, 59, 250, 54, 223, 189, 98, 180, 9, 62, 146, 191, 85, 189, 155, 97, 96, 189, 120, 87, 3, 189, 142, 88, 194, 61, 82, 205, 226, 189, 254, 129, 96, 188, 220, 254, 24, 189, 154, 159, 80, 189, 218, 12, 217, 60, 156, 59, 213, 61, 194, 227, 21, 188, 158, 175, 77, 61, 159, 139, 176, 187, 228, 77, 216, 61, 73, 105, 148, 188, 135, 25, 48, 187, 151, 138, 183, 189, 145, 69, 137, 188, 176, 205, 27, 189, 207, 139, 110, 60, 172, 20, 188, 61]','6673646b300010400e7b5c44227446c3d36dd7bbc288ee1bc73e589bc7ff417bd95abebdad6ab3c414046bcda32dbd37408b3d706994bdebba4bbd96cf9bbc321dacbc1ed68bbdc06d61bd3358acbd60b7a0bcdfdf33c579433b92ba153d6b2677bde1b9d13bbf68af3ce55d4d3c7d341c3d21bf5b3d5a95dfbd761b6e3df4f243a655893d2310513d4826923d4540b3ee0e25ebb3c6fb9bd5a334bd5796ebbcecb253d95b21bb79659b3b26525bbc7220a03de91a1beb9b7b9bd5235ebd2daa71bd734c8bbd3af9bd967cfbd4ea7983c84a7513c7650ab3d58349bbd64f22e3d9afe85bb274598bcb3a1c3ee2646c3ddd6123cf47b5be5c51633dcf56a1bdf0e16bc8f72e13d3ff6a3dfac803de0f15fbc53bbaabd186b03deea5e33c2e478a3c5d5d9fbc1ea0d4bbb84a45bd693b4c3d9b842fbceb57153db1a839bc692f43e4c93ec3a9ad2f53cb8eed4bd7dea333d16d3c5bdc530b1bd2f109cbd348ff9bda3a484bc4fa3d2bca3858f3cdadea9bda4a8f83c9cabe8bc36fd9d3bd9c99f3c795a73ce5e8bbc1793b3dab4ae3db599843d1ecdd73c1e1e403da8a48dbd7e6ee3cc24fe6bd11cffc3c36e4b4bb7f832c3d9d582bc552cebbc504acb3af61936bb1c3ed43d11ac783da955e23ac13150bd61abafbc7514bc3d5eff46bc6ee4f5bd91b435bd02d03db6fcc33d45a9abdba69b83d4fa8c2bc6da331bc33f58ebde0e3acbcf0d4e43d9a9babda530de3d67d12fbdb0eb3f3d0d8a93d782a783cfc094bc98a03fbdc0ef16be38c5ca3d9d4a81bd9253e43de9f9e0bc1e26a3d19fc9bda3b82b3d88537b3d3014c7bd92dc83e4aec9bd639599bdd9429bbd54371bbd62a4ed3dfbb7e3d2064abbd7a743bb9ab6f713dec6dba3dea38813d3f3503d515ef73b4d79413d412d213d2513cebcfada23cadf341bdc9647dbdf762fbe101245bddfc07e3dd7ceeabd547c1ebdc24f3d3d629a37bdc77d86bcdd25433d591db23c4ddd71bd7a6377bde556d1bce6c51fbc51d251bd1b52313b5ce69a3d42ea743b2c3013d2d1f69bd44862bc35c543bdca7e9f3c568cc3dd124703c4394123d8315333de325a0bddb7ff43d88c5dd3c724043d4f41a13cd04e6f3d4720b33d154e97bd32ea9abdcebd973ab21fb4bd51edcbce1c8193d82d0c2bdfaf7c3be05fa5bb62a2273db8e1e63dad663a3d1c8af3d9e731bc5a6f103d1eae29baa75b91bd4da6273ea8e79dbbe7e3233d73dba2bdef6ec1bd61e12b3d37cb1bd4b772d3ddbef89bdc26a973dea6863d9d6c543cdfdcf53bfa36dfbd62b493e92bf55bd9b6160bd78573bd8e58c23d52cde2bdfe8160bcdcfe18bd9a9f50bddacd93c9c3bd53dc2e315bc9eaf4d3d9f8bb0bbe44dd83d496994bc871930bb978ab7bd914589bcb0cd1bbdcf8b6e3cac14bc3d');

--
-- Table structure for table `religion`
--

CREATE TABLE `religion` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `title` text NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `religion`
--

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

--
-- Table structure for table `tbl_Allergies`
--

CREATE TABLE `tbl_Allergies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_Allergies`
--

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

--
-- Table structure for table `tbl_DischargeSummary`
--

CREATE TABLE `tbl_DischargeSummary` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_DischargeSummary`
--

INSERT INTO `tbl_DischargeSummary` 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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(46,'Pneumonia','Ct scan','After 2weeks','Oral antibiotics~Nebulization','Balanced diet','2024-11-08 12:25:08','Dr Theodor Seuss Geisel','2000000008','123456757','ARNEL BABIERRA','20241108122508','10000008;      Dr Theodor Seuss Geisel ;2000000008'),(47,'Hypertension~Diabetes','Bp monitoring~Ecg','Outpatient','Twynsta 40/5mg','Daily exercises','2024-11-08 12:26:45','Dr Theodor Seuss Geisel','2000000008','123456757','ARNEL BABIERRA','20241108122645','10000008;      Dr Theodor Seuss Geisel ;2000000008'),(48,'Hypertension','Blood chem','3days','Aspirin~Metoprolol','Exercise daily','2024-11-08 12:44:06','Dr Theodor Seuss Geisel','2000000008','123456787','NOEL CASTRO','20241108124406','10000008;      Dr Theodor Seuss Geisel ;2000000008'),(49,'Cerebrovascular','Ecg~MRI~Xray','Physical rehab~Therapy','Paracetamol~Aapiren','Exercises daily~Low fat diet','2024-11-08 12:46:12','Dr Theodor Seuss Geisel','2000000008','123456787','NOEL CASTRO','20241108124612','10000008;      Dr Theodor Seuss Geisel ;2000000008');

--
-- Table structure for table `tbl_DoNotResuscitate`
--

CREATE TABLE `tbl_DoNotResuscitate` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_DoNotResuscitate`
--

INSERT INTO `tbl_DoNotResuscitate` 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'),(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'),(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'),(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'),(26,'2024-11-16 06:58:06','Dr Theodor Seuss Geisel','2000000008','123456787','CASTRO, NOEL','20241116065806','','','','',''),(27,'2024-11-16 07:00:03','Dr Theodor Seuss Geisel','2000000008','123456787','CASTRO, NOEL','20241116070003','','No Money','Good','Legal Agreement','1'),(28,'2024-11-18 12:26:20','Dr Theodor Seuss Geisel','2000000008','123456787','CRUZ, CORAZON','20241118122620','','No Money','Yes, good','Yes','1'),(29,'2024-11-08 12:20:48','Dr Theodor Seuss Geisel','2000000008','123456757','ARNEL BABIERRA','20241108122048','10000008;      Dr Theodor Seuss Geisel ;2000000008','Humanity','Good','Yes, signed agreement','Yes'),(30,'2024-11-08 12:41:21','Dr Theodor Seuss Geisel','2000000008','123456787','NOEL CASTRO','20241108124121','10000008;      Dr Theodor Seuss Geisel ;2000000008','Poverty','Good','Yes','Yes');

--
-- Table structure for table `tbl_HealthProblem`
--

CREATE TABLE `tbl_HealthProblem` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_HealthProblem`
--

INSERT INTO `tbl_HealthProblem` 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'),(18,'High bloos','A stroke','Failed','Okay','Fail','Operations','2024-10-29 10:20:48','Dr Theodor Seuss Geisel','2000000008','123456788','CORAZON CRUZ','20241029102048'),(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'),(20,'Stomach','Fever','Gas problems','Stomach','Delay breath','Operations','2024-10-29 15:21:04','Dr Theodor Seuss III','2000000058','123456787','CORAZON CRUZ','20241029152104'),(21,'Chest pain','Fever','Low blood','Fever','Fever','Medication','2024-10-30 15:07:45','Dr Theodor Seuss Geisel','2000000008','123456789','CORAZON CRUZ','20241030150745'),(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'),(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'),(24,'Chest Pain','Hypertension','Failed','Okay','Hypertension','Medication','2024-11-17 23:36:03','Dr Theodor Seuss III','2000000058','123456788','CRUZ, CORAZON','20241117233603'),(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'),(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'),(27,'Hypertension','None','HB','High Blood','Diabetes','Medications','2024-11-08 12:11:50','Dr Theodor Seuss Geisel','2000000008','123456757','ARNEL BABIERRA','20241108121150'),(28,'Headaches','Fever','Low blood','Xray','Need vitamin','Exercise','2024-11-08 12:13:16','Dr Theodor Seuss Geisel','2000000008','123456757','ARNEL BABIERRA','20241108121316'),(29,'Stomachache','Diarrhea','Xray','Need antibiotics','Take med','2weeks','2024-11-08 12:32:24','Dr Theodor Seuss Geisel','2000000008','123456787','NOEL CASTRO','20241108123224'),(30,'Fever','LBM','Need chest xray','General checkup ','Test stool','Observe 3days','2024-11-08 12:34:25','Dr Theodor Seuss Geisel','2000000008','123456787','NOEL CASTRO','20241108123425');

--
-- Table structure for table `tbl_MedicalFamilyHistory`
--

CREATE TABLE `tbl_MedicalFamilyHistory` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_MedicalFamilyHistory`
--

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

--
-- Table structure for table `tbl_MedicalHistory`
--

CREATE TABLE `tbl_MedicalHistory` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_MedicalHistory`
--

INSERT INTO `tbl_MedicalHistory` 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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(27,'2024-11-08 12:13:56','Allergy,Anemia','01,02','Daily',NULL,'Occasionally',NULL,'Dr Theodor Seuss Geisel','2000000008','123456757','ARNEL BABIERRA','20241108121356','10000008;      Dr Theodor Seuss Geisel ;2000000008','No','','2025-02-25 03:40:33'),(28,'2024-11-08 12:15:37','Asthma','03','Daily',NULL,'Occasionally',NULL,'Dr Theodor Seuss Geisel','2000000008','123456757','ARNEL BABIERRA','20241108121537','10000008;      Dr Theodor Seuss Geisel ;2000000008','No','','2025-02-25 03:40:42'),(29,'2024-11-08 12:35:09','Pneumonia','1A','Occasionally',NULL,'Occasionally',NULL,'Dr Theodor Seuss Geisel','2000000008','123456787','NOEL CASTRO','20241108123509','10000008;      Dr Theodor Seuss Geisel ;2000000008','No','','2025-02-25 03:43:33'),(30,'2024-11-08 12:36:01','Allergy,Fracture Typhoid Fever,Hearing Problem ,Heart Disorder','01,0F,10,11','No',NULL,'No',NULL,'Dr Theodor Seuss Geisel','2000000008','123456787','NOEL CASTRO','20241108123601','10000008;      Dr Theodor Seuss Geisel ;2000000008','Yes','Stomach','2025-02-25 03:43:45');

--
-- Table structure for table `tbl_OrganDonor`
--

CREATE TABLE `tbl_OrganDonor` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_OrganDonor`
--

INSERT INTO `tbl_OrganDonor` VALUES (1,'2024-09-19 17:08:43','','','','','','','','','',''),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(25,'2024-11-28 14:10:16','Dr Theodor M Cruz','2000000208','123456789','CRUZ CORAZON','20241128141016','10000208;             Dr Theodor M Cruz;2000000208','AA','AAA','AAA','W'),(26,'2024-11-29 10:41:52','Dr Theodor M Cruz','2000000208','123456789','CRUZ CORAZON','20241129104152','10000208;             Dr Theodor M Cruz;2000000208','AAA','BBB','CCC','W'),(27,'2024-11-08 12:21:21','Dr Theodor Seuss Geisel','2000000008','123456757','ARNEL BABIERRA','20241108122121','10000008;      Dr Theodor Seuss Geisel ;2000000008','Love','Good','Yes','03'),(28,'2024-11-08 12:22:01','Dr Theodor Seuss Geisel','2000000008','123456757','ARNEL BABIERRA','20241108122201','10000008;      Dr Theodor Seuss Geisel ;2000000008','Poverty','Good','Deal','04'),(29,'2024-11-08 12:41:47','Dr Theodor Seuss Geisel','2000000008','123456787','NOEL CASTRO','20241108124147','10000008;      Dr Theodor Seuss Geisel ;2000000008','Humanity','Goos','Yea','02,03'),(30,'2024-11-08 12:42:11','Dr Theodor Seuss Geisel','2000000008','123456787','NOEL CASTRO','20241108124211','10000008;      Dr Theodor Seuss Geisel ;2000000008','Good','Good','Yes','06,07');

--
-- Table structure for table `tbl_Prescription`
--

CREATE TABLE `tbl_Prescription` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_Prescription`
--

INSERT INTO `tbl_Prescription` 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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(21,'Panadol','Bioflu','500mg','3x daily','7days',21,580,'2024-11-08 12:16:44','Dr Theodor Seuss Geisel','2000000008','123456757','ARNEL BABIERRA','20241108121644','10000008;      Dr Theodor Seuss Geisel ;2000000008'),(22,'Paracetamol','Medicol','100ml','3x','1week',25,2500,'2024-11-08 12:39:12','Dr Theodor Seuss Geisel','2000000008','123456787','NOEL CASTRO','20241108123912','10000008;      Dr Theodor Seuss Geisel ;2000000008');

--
-- Table structure for table `tbl_Treatments`
--

CREATE TABLE `tbl_Treatments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_Treatments`
--

INSERT INTO `tbl_Treatments` 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),(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'),(3,'','','','','','','2024-09-19 01:43:14','Dr. Jane Smith','123456','PH123456789','John Doe','REF123456','General Practitioner with 10 years of experience.'),(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),(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'),(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'),(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'),(22,'Highblood','Severe','','','Not Goood','','2024-11-16 06:42:49','Dr Theodor Seuss Geisel','2000000008','123456787','CASTRO, NOEL','20241116064249',''),(23,'Hypetension','Bad','','','3x','','2024-11-16 14:22:06','Dr Theodor Seuss Geisel','2000000008','123456758','TORRALBA, ROLDAN','20241116142206',''),(24,'Hypertension','Stage 1 Hypertension','','','Medicine','','2024-11-17 23:42:31','Dr Theodor Seuss III','2000000058','123456788','CRUZ, CORAZON','20241117234231',''),(25,'Kidney stones','severe','','','diet','','2024-11-18 12:22:23','Dr Theodor Seuss Geisel','2000000008','123456787','CRUZ, CORAZON','20241118122223',''),(26,'Hypertension','HB','Take Med','3days','Losartan','Xrau','2024-11-08 12:20:03','Dr Theodor Seuss Geisel','2000000008','123456757','ARNEL BABIERRA','20241108122003','10000008;      Dr Theodor Seuss Geisel ;2000000008'),(27,'Paralysis','Hypertension','Therapy','1year','Therapy','ECG','2024-11-08 12:40:55','Dr Theodor Seuss Geisel','2000000008','123456787','NOEL CASTRO','20241108124055','10000008;      Dr Theodor Seuss Geisel ;2000000008');

--
-- Table structure for table `tbl_Vaccinations`
--

CREATE TABLE `tbl_Vaccinations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_Vaccinations`
--

INSERT INTO `tbl_Vaccinations` 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),(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.'),(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.'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(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'),(33,'Pfizer','FluuVax','2','2024-11-06','2024-11-30','2024-11-08 12:09:50','Dr Theodor Seuss Geisel','2000000008','123456757','ARNEL BABIERRA','20241108120950','10000008;      Dr Theodor Seuss Geisel ;2000000008'),(34,'Sinovac','Covid','5mg','2024-11-29','2024-11-30','2024-11-08 12:10:33','Dr Theodor Seuss Geisel','2000000008','123456757','ARNEL BABIERRA','20241108121033','10000008;      Dr Theodor Seuss Geisel ;2000000008'),(35,'Paracetamol','BioFlu','500mg','2024-11-07','2024-11-30','2024-11-08 12:30:20','Dr Theodor Seuss Geisel','2000000008','123456787','NOEL CASTRO','20241108123020','10000008;      Dr Theodor Seuss Geisel ;2000000008'),(36,'Medref','Flu','1ml','2024-11-07','2024-11-30','2024-11-08 12:31:02','Dr Theodor Seuss Geisel','2000000008','123456787','NOEL CASTRO','20241108123102','10000008;      Dr Theodor Seuss Geisel ;2000000008');

--
-- Table structure for table `tbl_audit_trail`
--

CREATE TABLE `tbl_audit_trail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `voters_id` varchar(225) COLLATE utf8mb4_general_ci NOT NULL,
  `appName` varchar(124) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `msg_log` varchar(225) COLLATE utf8mb4_general_ci NOT NULL,
  `log_user` varchar(225) COLLATE utf8mb4_general_ci NOT NULL,
  `logsdate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_audit_trail`
--

INSERT INTO `tbl_audit_trail` VALUES (1,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. by ','','2024-02-28 23:57:34'),(2,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. by ','','2024-02-28 23:58:58'),(3,'3002-0201B-C0272ESA20000','verify_voters.php','Successful Verified.. by ','','2024-02-29 00:00:00'),(4,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. by ','','2024-02-29 00:09:28'),(5,'3002-0201B-C0272ESA20000','verify_voters.php','Successful Verified.. by ','','2024-02-29 00:30:29'),(6,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by ','','2024-02-29 00:31:38'),(7,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by ako','ako','2024-02-29 00:32:32'),(8,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by ako','ako','2024-02-29 00:32:49'),(9,'a111','verify_voters.php','Successful Verified.. by ako','ako','2024-02-29 00:51:40'),(10,'12345','verify_voters.php','Successful Verified.. by ako','ako','2024-02-29 00:52:17'),(11,'a112','verify_voters.php','Successful Verified.. by ako','ako','2024-02-29 00:52:39'),(12,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by ako','ako','2024-03-04 21:33:13'),(13,'3002-0201B-C0272ESA20000','verify_voters.php','Successful Verified.. by ','','2024-03-04 21:41:48'),(14,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by ','','2024-03-04 21:43:15'),(15,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by ','','2024-03-04 21:43:58'),(16,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 21:45:27'),(17,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 21:48:36'),(18,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 21:48:47'),(19,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 21:50:37'),(20,'3002-0201B-C0272ESA20000','verify_voters.php','Successful Verified.. by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 21:51:06'),(21,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 21:55:55'),(22,'3002-0201B-C0272ESA20000','verify_voters.php','Successful Verified.. by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 21:56:20'),(23,'3002-0201B-C0272ESA20000','verify_voters.php','Successful Verified.. by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 21:57:15'),(24,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 21:58:33'),(25,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:01:25'),(26,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:01:27'),(27,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:03:36'),(28,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:03:37'),(29,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:03:37'),(30,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:03:37'),(31,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:04:17'),(32,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:06:06'),(33,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:06:15'),(34,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:08:00'),(35,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:08:01'),(36,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:08:01'),(37,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:08:48'),(38,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:10:25'),(39,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:10:55'),(40,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:16:14'),(41,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:16:53'),(42,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.admin','Admin@Admin.admin','2024-03-04 22:19:49'),(43,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-04 23:24:00'),(44,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-05 19:19:59'),(45,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 03:05:58'),(46,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:06:13'),(47,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:09:40'),(48,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:09:41'),(49,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:14:12'),(50,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:17:50'),(51,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:19:07'),(52,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:19:09'),(53,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:20:13'),(54,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:20:14'),(55,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:21:33'),(56,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:23:21'),(57,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:25:45'),(58,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:26:11'),(59,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:26:16'),(60,'3002-0201B-C0272ESA20000','verify_voters.php','The Voters Already Issued!.. Attempt by Admin@Admin.com','Admin@Admin.com','2024-03-07 21:27:26');

--
-- Table structure for table `tbl_image`
--

CREATE TABLE `tbl_image` (
  `id` int NOT NULL AUTO_INCREMENT,
  `image` longblob,
  `philhealth_id` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_image`
--

INSERT INTO `tbl_image` VALUES (1,_binary 'data:image/jpeg;base64,[encoded data, 70068 characters]','231935100876'),(2,_binary 'data:image/jpeg;base64,[encoded data, 47108 characters]','444647098480'),(3,_binary 'data:image/png;base64,[encoded data, 22144 characters]','730965892221'),(4,_binary 'data:image/jpeg;base64,[encoded data, 31832 characters]','290335176039'),(5,'',''),(6,'','');

--
-- Table structure for table `tbl_members`
--

CREATE TABLE `tbl_members` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_members`
--

INSERT INTO `tbl_members` 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'),(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'),(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'),(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'),(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');

--
-- Table structure for table `tbl_menu_list`
--

CREATE TABLE `tbl_menu_list` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `link` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `parentid` int DEFAULT NULL,
  `remarks` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=311 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_menu_list`
--

INSERT INTO `tbl_menu_list` VALUES (1,'Dashboard','index.php',0,'','fas fa-home'),(204,'User','#',295,NULL,'fe fe-user fe-16'),(205,'Add User','add-user.php',204,NULL,NULL),(206,'List User','list-user.php',204,NULL,NULL),(207,'Modify User Level','add-access-menu.php',204,NULL,NULL),(208,'Access Level','#',295,NULL,'fe fe-trello fe-16'),(209,'Add User Access Level','add-user-level.php',208,NULL,NULL),(211,'View User Access Level','list-accesslvl.php',208,NULL,NULL),(232,'Dynamic Menu','#',295,'Good','fe fe-menu fe-16'),(234,'List Dynamic Menu','list_of_dynamic_menu.php',232,'Good',NULL),(292,'Member','#',0,'Good','fas fa-users'),(293,'Reports','report_issue_voters.php',0,'Good','fe fe-file-text fe-16'),(294,'Logs','logs_voters_issued.php',0,'Good','fe fe-book-open fe-16'),(295,'User Management','#',0,'Good','fas fa-bars'),(297,'Add Member','add_member.php',292,'Good',NULL),(298,'View Members','view_member.php',292,'Good',NULL),(300,'Libraries','#',0,'Good','fa icon-layers'),(302,'Health Problems','list_of_health_problems.php',300,'Good',NULL),(304,'Allergies','list_of_allergy.php',300,'Good',NULL),(306,'Periodic Treatments','list_of_Periodic_Treatments.php',300,'Good',NULL),(307,'Organs','list_of_organ.php',300,'Good',NULL),(308,'View Users','view_users.php',292,'Users',NULL),(309,'Disease','list_of_disease.php',300,'Child',NULL),(310,'Family History Disease','list_of_familyhistory_disease.php',300,'Child',NULL);

--
-- Table structure for table `tbl_menu_list_xaml`
--

CREATE TABLE `tbl_menu_list_xaml` (
  `id` int NOT NULL DEFAULT '0',
  `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `link` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `parentid` int DEFAULT NULL,
  `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_menu_list_xaml`
--

INSERT INTO `tbl_menu_list_xaml` VALUES (1,'Dashboard','UserControlDashboard',0,'','fas fa-home'),(204,'User','#',500,NULL,'fe fe-user fe-16'),(205,'Add User','UserControlAddUser',204,NULL,NULL),(206,'List User','UserControlListUser',204,NULL,NULL),(207,'Modify User Level','UserControlAddAccessMenu',204,NULL,NULL),(208,'Access Level','#',500,NULL,'fe fe-trello fe-16'),(209,'Add User Access Level','UserControlAddUserLevel',208,NULL,NULL),(211,'View User Access Level','UserControlListAccessLevel',208,NULL,NULL),(232,'Dynamic Menu','#',500,'Good','fe fe-menu fe-16'),(234,'List Dynamic Menu','UserControlListDynamicMenu',232,'Good',NULL),(292,'Member','#',0,'Good','fas fa-users'),(293,'Reports','report_issue_voters.php',0,'Good','fe fe-file-text fe-16'),(294,'Logs','logs_voters_issued.php',0,'Good','fe fe-book-open fe-16'),(500,'User Management','#',0,'Good','fas fa-bars'),(297,'Add Member','add_member.php',292,'Good',NULL),(298,'View Members','view_member.php',292,'Good',NULL),(300,'Libraries','#',0,'Good','fa icon-layers'),(302,'Health Problems','list_of_health_problems.php',300,'Good',NULL),(304,'Allergies','list_of_allergy.php',300,'Good',NULL),(306,'Periodic Treatments','list_of_Periodic_Treatments.php',300,'Good',NULL),(307,'Organs','list_of_organ.php',300,'Good',NULL),(308,'PATIENT RECORD','#',0,'Good',NULL);

--
-- Table structure for table `tbl_users`
--

CREATE TABLE `tbl_users` (
  `idno` int NOT NULL AUTO_INCREMENT,
  `uname` varchar(255) DEFAULT NULL,
  `userpass` varchar(255) DEFAULT NULL,
  `userempidno` varchar(15) DEFAULT NULL,
  `userfname` varchar(255) DEFAULT NULL,
  `userlname` varchar(255) DEFAULT NULL,
  `userposition` varchar(255) DEFAULT NULL,
  `userrole` varchar(255) DEFAULT NULL,
  `useroffice` varchar(255) DEFAULT NULL,
  `officeid` varchar(10) DEFAULT NULL,
  `userstatus` varchar(255) DEFAULT NULL,
  `userdatereg` varchar(255) DEFAULT NULL,
  `useremail` varchar(255) DEFAULT NULL,
  `access_level_cde` varchar(6) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `android_user` int DEFAULT NULL,
  `reset_pwd` smallint DEFAULT '0',
  `prcid_no` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idno`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_users`
--

INSERT INTO `tbl_users` VALUES (28,'Admin@Admin.com','$2y$10$6hSlrq.DUmQU./T.VlCqsOi/abwZdM.Dr4gZebmVIgZy67GN0x6a6','1001','DR. Jose','Rizal','Admin','1','Admin',NULL,'1','2024-02-23 19:07:30','Admin@Admin.com','1',NULL,0,1,'0012345'),(29,'user@gmail.com','$2y$10$rniUUvIO2p.TtZW4iQAGVu5ZUaaICz0kDXnU5vFWMimyCY9YQEPkK','1002','Rommel','Santiago','Staff','115','Staff',NULL,'1','2024-03-07 21:30:04','user@gmail.com','115',NULL,0,1,NULL),(31,'Admin@Admin.admin','$2y$10$xU6K.oloHNkiui5/zknYWuUhZPnajwfQqnbT.6b/xIBsGzESRepxW','','','','','','',NULL,'1','2024-03-05 19:42:35','Admin@Admin.admin','',NULL,0,1,NULL),(32,'user@gmail.com456','$2y$10$115O26L/8rDml3hgMlIKn.DiYs7nXbCWzAZAmxHRGLYP.59wQMnWa','3','Jet','Santiago','User','','User',NULL,'1','2024-03-06 21:47:58','user@gmail.com456','',NULL,0,1,NULL),(33,'user@gmail.com123','$2y$10$UfuG9DvUNXYvz91DcW/NGuBHpeRdQH2anthjlB.eOoGMhiTK4E.Hm','1003','Rommel','Santiago','User','','User',NULL,'1','2024-03-06 21:48:11','user@gmail.com','',NULL,0,1,NULL),(34,'Admin@Admin.com.ph','$2y$10$KYwO7hg5OIxum28Plzk/WOkZ0YAD3fB.dfUSM2SzDsFptjnMoCL8u','1004','Juan','Dela Cruz','Admin','1','Admin',NULL,'1','2024-03-05 20:13:44','Admin@Admin.com.ph','1',NULL,0,1,NULL),(35,'','$2y$10$3Zqp9Qcb1n.1NM2SuCZFaOxbzSMEWvnyN6uYKjQGLPoT1Zl1Bo0qG','','','','','','',NULL,'1','2024-10-26 21:47:10','','',NULL,0,1,NULL);


