LgSHHG8w

1-- MySQL dump 10.13  Distrib 8.0.22, for macos10.15 (x86_64)
2--
3-- Host: localhost    Database: jantungku
4-- ------------------------------------------------------
5-- Server version	8.0.22
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `admins`
20--
21
22DROP TABLE IF EXISTS `admins`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!50503 SET character_set_client = utf8mb4 */;
25CREATE TABLE `admins` (
26  `id` int unsigned NOT NULL AUTO_INCREMENT,
27  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
28  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
29  `role` varchar(100) NOT NULL,
30  `hospital_id` int unsigned DEFAULT NULL,
31  `createdAt` timestamp NULL DEFAULT NULL,
32  `updatedAt` timestamp NULL DEFAULT NULL,
33  `deletedAt` timestamp NULL DEFAULT NULL,
34  PRIMARY KEY (`id`),
35  KEY `admins_FK` (`hospital_id`),
36  CONSTRAINT `admins_FK` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`)
37) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Dumping data for table `admins`
42--
43
44LOCK TABLES `admins` WRITE;
45/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
46INSERT INTO `admins` VALUES (12,'admin2@jantungku.com','$2b$10$6VD3x1u9XzdhEslXmRiIPOvl86ivW6rghZR4kww/vOyLmWi2ec40O','super',NULL,'2020-12-23 03:42:59','2020-12-23 03:42:59',NULL),(13,'admin123@jantungku.com','$2b$10$41m7das//zT4tf7o5hRVm.oeWD4oWomo8Mqshle0T.ALDscAlaYsm','super',NULL,'2020-12-23 03:50:09','2020-12-23 03:50:09',NULL),(14,'Vince48@yahoo.com','$2b$10$66zDCYkm.awlZuc1eTIkp.6nlE.1gcwctNm0.QhIno9cjd5L/5ABe','super',NULL,'2020-12-25 13:26:24','2020-12-25 13:26:24',NULL),(15,'Ressie1@gmail.com','$2b$10$5PmMez8JUIdP3.Q5Xn3lB.ykWiZ40F0mHyF8EJVDS5wXWyKu8VJ2W','super',NULL,'2020-12-25 13:26:27','2020-12-25 13:26:27',NULL),(16,'Ericka_Greenfelder84@gmail.com','$2b$10$wbgiAGBNrd0tAmuPgf0AwuyxMJed55ec7g0S42hO2FCn/nqxGLc1i','super',NULL,'2020-12-25 13:26:28','2020-12-25 13:26:28',NULL),(17,'Pablo7@gmail.com','$2b$10$PCRZzsIVrxTqLbSGpKw1SumYZ9krLS.CsFsUTXIMma2ies7rm5AI6','super',NULL,'2020-12-25 13:26:29','2020-12-25 13:26:29',NULL),(18,'Roxanne.Mosciski52@gmail.com','$2b$10$zf8PjapQPUVGg/9enY3S0eheWiS5EEqyZh8LPQMmyOoAgrbLokY9G','super',NULL,'2020-12-25 13:26:29','2020-12-25 13:26:29',NULL),(19,'Keaton26@hotmail.com','$2b$10$Cel.H7Ok33KLv7tKUkBsNeodpiYgWShYalqYR75rA/Cpx1gTJtm3W','super',NULL,'2020-12-25 13:26:30','2020-12-25 13:26:30',NULL),(20,'Nikki.Casper@yahoo.com','$2b$10$UhAlNDhOfc7Wqwrkr3nYTesoyXJI3u9LR12aSy5xptaNIE4HogOLy','super',NULL,'2020-12-25 13:26:31','2020-12-25 13:26:31',NULL),(21,'Jayson_Gerhold@gmail.com','$2b$10$QkWAk2EzNR5krNeWrJE7Y.jQeXdfUYzkwxO1.HYN8XblKk8e4XFGe','super',NULL,'2020-12-25 13:26:32','2020-12-25 13:26:32',NULL),(22,'Antonietta_Weissnat@hotmail.com','$2b$10$nuQKDLpPnAJ1qLA1Cmmuf.cRm/1jggq2Rs5IJ3axsetHattNHbonm','super',NULL,'2020-12-25 13:26:32','2020-12-25 13:26:32',NULL),(23,'Dion.Greenfelder44@hotmail.com','$2b$10$lNH5qo2saYuDjAn/Deqt3u0U/.yRqOjP2At1N2mmdx.qvhexZZAkK','super',NULL,'2020-12-25 13:26:33','2020-12-25 13:26:33',NULL),(24,'Doyle.Stehr84@gmail.com','$2b$10$t4ggLA66.FmVqGAjoh1ox.Zv0RkukNRa7tDNiXVsCkUnmRHRYuFPi','super',NULL,'2020-12-25 13:26:33','2020-12-25 13:26:33',NULL),(25,'Amos98@yahoo.com','$2b$10$Mg2UUPzDDJ8t7qh5w32cDuosR41NPvBsaLCd68I9KkQPaI6zMuf2O','super',NULL,'2020-12-25 13:26:33','2020-12-25 13:26:33',NULL),(26,'Rick.Ondricka@gmail.com','$2b$10$ot2D/6IcFz1l4WzWbgOgVOCWcIdTlWy4mwKrrJegKiDaXDUVmJzbO','super',NULL,'2020-12-25 13:26:34','2020-12-25 13:26:34',NULL),(27,'Claudine_Kiehn22@hotmail.com','$2b$10$I0ViA8OR7lgJa0m.YAYxIuTn2jonxDrdhooNatd8TxG1aYgrUYtCu','super',NULL,'2020-12-25 13:26:34','2020-12-25 13:26:34',NULL),(28,'Ransom_Botsford@yahoo.com','$2b$10$lao.X61JSj/P9Rnk6D7SReVDkG90Pd0LKcYI5w1ByoHuf3iqPXcMy','super',NULL,'2020-12-25 13:26:35','2020-12-25 13:26:35',NULL),(29,'Leola.Moore@hotmail.com','$2b$10$1D5atH6KFfwTCHDWLSAG1uy2/eXbU0/nlGerDoZi7hdNUuCaFeHs.','super',NULL,'2020-12-25 13:26:35','2020-12-25 13:26:35',NULL),(30,'Steve.Buckridge21@gmail.com','$2b$10$59wBOpiOqZttA4xOQVYDqeTun9UjVKadaQFM4QLtoTdtXSUGnBWSC','super',NULL,'2020-12-25 13:26:35','2020-12-25 13:26:35',NULL),(31,'Nayeli33@gmail.com','$2b$10$TUPz/wXiIA1oRAzQwR/nreLroe5lXUax3qu9voHymCCHPbkPuwRnu','super',NULL,'2020-12-25 13:26:36','2020-12-25 13:26:36',NULL),(32,'Agnes.Bartoletti@yahoo.com','$2b$10$786wHwROny79FrA9x0hdUOkc4e04G4iz6GSyFfHlsmym0lNL9c4lO','super',NULL,'2020-12-25 13:26:36','2020-12-25 13:26:36',NULL),(33,'Winston.Kuhic7@yahoo.com','$2b$10$daRwPd8JbXU1bsBFjbqTF.CJZFiij8megvo8Z/0UfwWEcrXdMYr0y','super',NULL,'2020-12-25 14:12:53','2020-12-25 14:12:53',NULL),(34,'Deshawn15@hotmail.com','$2b$10$PITyNvkwfjl0AMMr8rtKY.aM1gvZSQfLcjEUAOtu7uVAxcPHQHE8W','super',NULL,'2020-12-25 14:14:04','2020-12-25 14:14:04',NULL),(35,'Ernestine_Gerhold1@gmail.com','$2b$10$A.NCZhmhIB.FeQT0OhE3Y.WRDOC7uMmzg7xFZwQaZMPiXvDEiUZy2','super',NULL,'2020-12-25 14:23:34','2020-12-25 14:23:34',NULL),(36,'Jeremie_Bogan87@gmail.com','$2b$10$VrwRQOtJmzwJjO5u/hvVf.75yHsGXDh3BpAgmU1PZBbzaBqwfzoUO','super',NULL,'2020-12-25 14:23:58','2020-12-25 14:23:58',NULL),(37,'Marguerite21@yahoo.com','$2b$10$Ce3cNekhuVhJtIQIypT4GeLzAYDotSe08tkWnu.c55BXAgiNeAd8i','super',NULL,'2020-12-25 14:38:17','2020-12-25 14:38:17',NULL),(38,'adminfaskes@gmail.com','$2b$10$gbtGkD.tzQzMFdHDTYyZc.2ZYlIXGDhsR7x59sBgDWoW23FM75bWC','faskes',1,'2020-12-25 14:39:02','2020-12-25 14:39:02',NULL),(39,'adminfaskes2@gmail.com','$2b$10$BrVAEmbKB8gwgbh9i0RtsOHQhhuYhZ9Hzab6g6aG.pd293IHi4WJa','faskes',2,'2020-12-25 14:39:24','2020-12-25 14:39:24',NULL);
47/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
48UNLOCK TABLES;
49
50--
51-- Table structure for table `chats`
52--
53
54DROP TABLE IF EXISTS `chats`;
55/*!40101 SET @saved_cs_client     = @@character_set_client */;
56/*!50503 SET character_set_client = utf8mb4 */;
57CREATE TABLE `chats` (
58  `id` int unsigned NOT NULL AUTO_INCREMENT,
59  `isPatient` tinyint(1) NOT NULL,
60  `content` varchar(100) DEFAULT NULL,
61  `type` varchar(100) DEFAULT NULL,
62  `consultation_id` int unsigned NOT NULL,
63  `createdAt` timestamp NULL DEFAULT NULL,
64  `updatedAt` timestamp NULL DEFAULT NULL,
65  `deletedAt` timestamp NULL DEFAULT NULL,
66  PRIMARY KEY (`id`),
67  KEY `chats_FK` (`consultation_id`),
68  CONSTRAINT `chats_FK` FOREIGN KEY (`consultation_id`) REFERENCES `consultations` (`id`)
69) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
70/*!40101 SET character_set_client = @saved_cs_client */;
71
72--
73-- Dumping data for table `chats`
74--
75
76LOCK TABLES `chats` WRITE;
77/*!40000 ALTER TABLE `chats` DISABLE KEYS */;
78INSERT INTO `chats` VALUES (1,0,'Halo doc edit','text',3,'2020-12-23 23:01:37','2020-12-23 23:59:06',NULL),(2,1,'Halo doc','text',1,'2020-12-23 23:24:51','2020-12-23 23:24:51',NULL),(3,1,'Halo doc','text',1,'2020-12-23 23:32:24','2020-12-23 23:32:24',NULL),(4,1,'Halo doc','text',2,'2020-12-23 23:45:25','2020-12-23 23:45:25',NULL),(5,1,'Halo doc','text',3,'2020-12-23 23:45:29','2020-12-23 23:45:29',NULL);
79/*!40000 ALTER TABLE `chats` ENABLE KEYS */;
80UNLOCK TABLES;
81
82--
83-- Table structure for table `consultations`
84--
85
86DROP TABLE IF EXISTS `consultations`;
87/*!40101 SET @saved_cs_client     = @@character_set_client */;
88/*!50503 SET character_set_client = utf8mb4 */;
89CREATE TABLE `consultations` (
90  `id` int unsigned NOT NULL AUTO_INCREMENT,
91  `booked_date` date NOT NULL,
92  `resume` text,
93  `isChat` tinyint(1) NOT NULL,
94  `isVideo` tinyint(1) NOT NULL,
95  `payment_proof` varchar(100) DEFAULT NULL,
96  `status` char(1) NOT NULL,
97  `createdAt` timestamp NULL DEFAULT NULL,
98  `updatedAt` timestamp NULL DEFAULT NULL,
99  `deletedAt` timestamp NULL DEFAULT NULL,
100  `patient_id` int unsigned NOT NULL,
101  `doctor_id` int unsigned NOT NULL,
102  `start_time` datetime DEFAULT NULL,
103  `end_time` datetime DEFAULT NULL,
104  `booked_slot` tinyint unsigned NOT NULL,
105  PRIMARY KEY (`id`),
106  KEY `consultations_FK` (`doctor_id`),
107  KEY `consultations_FK_1` (`patient_id`),
108  CONSTRAINT `consultations_FK` FOREIGN KEY (`doctor_id`) REFERENCES `doctors` (`id`),
109  CONSTRAINT `consultations_FK_1` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`)
110) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
111/*!40101 SET character_set_client = @saved_cs_client */;
112
113--
114-- Dumping data for table `consultations`
115--
116
117LOCK TABLES `consultations` WRITE;
118/*!40000 ALTER TABLE `consultations` DISABLE KEYS */;
119INSERT INTO `consultations` VALUES (1,'2020-12-25',NULL,1,0,NULL,'B','2020-12-24 09:08:47','2020-12-26 11:10:36',NULL,8,1,NULL,NULL,1),(2,'1970-01-19',NULL,1,0,NULL,'B','2020-12-24 09:08:47','2020-12-24 09:08:47',NULL,1,4,NULL,NULL,1),(3,'1970-01-19',NULL,1,0,NULL,'B','2020-12-24 09:08:48','2020-12-24 09:08:48',NULL,1,5,NULL,NULL,1),(4,'2020-12-23',NULL,1,0,NULL,'B','2020-12-24 09:48:58','2020-12-24 09:48:58',NULL,1,2,NULL,NULL,1),(5,'2020-12-25',NULL,1,0,NULL,'B','2020-12-26 10:45:24','2020-12-26 10:45:24',NULL,1,2,NULL,NULL,1),(6,'2020-12-25',NULL,1,0,NULL,'B','2020-12-26 10:46:56','2020-12-26 10:46:56',NULL,8,2,NULL,NULL,1),(7,'2020-12-25',NULL,1,0,NULL,'B','2020-12-26 10:47:25','2020-12-26 10:47:25',NULL,8,3,NULL,NULL,1);
120/*!40000 ALTER TABLE `consultations` ENABLE KEYS */;
121UNLOCK TABLES;
122
123--
124-- Table structure for table `doctors`
125--
126
127DROP TABLE IF EXISTS `doctors`;
128/*!40101 SET @saved_cs_client     = @@character_set_client */;
129/*!50503 SET character_set_client = utf8mb4 */;
130CREATE TABLE `doctors` (
131  `id` int unsigned NOT NULL AUTO_INCREMENT,
132  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
133  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
134  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
135  `birth_date` date DEFAULT NULL,
136  `gender` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
137  `phone_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
138  `ktp_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
139  `blood_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
140  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
141  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
142  `province_id` int unsigned DEFAULT NULL,
143  `regency_id` int unsigned DEFAULT NULL,
144  `createdAt` timestamp NULL DEFAULT NULL,
145  `updatedAt` timestamp NULL DEFAULT NULL,
146  `deletedAt` timestamp NULL DEFAULT NULL,
147  `hospital_id` int unsigned NOT NULL,
148  PRIMARY KEY (`id`),
149  KEY `doctors_FK` (`hospital_id`),
150  KEY `doctors_FK_1` (`province_id`),
151  KEY `doctors_FK_2` (`regency_id`),
152  CONSTRAINT `doctors_FK` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`),
153  CONSTRAINT `doctors_FK_1` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`),
154  CONSTRAINT `doctors_FK_2` FOREIGN KEY (`regency_id`) REFERENCES `regencies` (`id`)
155) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
156/*!40101 SET character_set_client = @saved_cs_client */;
157
158--
159-- Dumping data for table `doctors`
160--
161
162LOCK TABLES `doctors` WRITE;
163/*!40000 ALTER TABLE `doctors` DISABLE KEYS */;
164INSERT INTO `doctors` VALUES (1,'Dr. Rufus Heidenreich','Nels80@hotmail.com','$2b$10$VMb4M0KF32v3mm8OlPXlAedfw/KQcBCwHhaFQmzu9Of5VLwDA06qS',NULL,NULL,'656-707-8165',NULL,NULL,NULL,NULL,NULL,NULL,'2020-12-25 22:57:02','2020-12-25 22:57:02',NULL,1),(2,'Dr. Dean Schiller','Rosamond96@hotmail.com','$2b$10$JrCC4TjNyvEPnF.0MBizQ.nYaweLzXYsiSaAIDmEhuvAYfEEMDlbu',NULL,NULL,'801-457-0072',NULL,NULL,NULL,NULL,NULL,NULL,'2020-12-26 00:08:49','2020-12-26 00:08:49',NULL,1),(3,'Dr. Mr. Silvia Gottlieb','paijo@paiman.com','$2b$10$r7wjdmlBtXveNX.hRwIBveoDeNG8J036Yqs.UPQnkn.K7iXR2pOUe',NULL,NULL,'268-308-0798',NULL,NULL,NULL,NULL,NULL,NULL,'2020-12-24 02:28:27','2020-12-26 00:06:03',NULL,1),(4,'Dr. Karen Ruecker','Dorcas_Rohan@hotmail.com','$2b$10$GAF94QIqzsnJjjUzDZj45.boyCMYu08vKQNCK0z01NP8rirxKeL7a',NULL,NULL,'327-852-5882',NULL,NULL,NULL,NULL,NULL,NULL,'2020-12-25 22:56:23','2020-12-25 22:56:23',NULL,2),(5,'Dr. Viola Ferry','Freeda.Orn@hotmail.com','$2b$10$f43GjUEJlcV0MFgBYiJLx.t4jOg9l3tVvbtF10o2S9fX9Z8AxW6dK',NULL,NULL,'996-493-5957',NULL,NULL,NULL,NULL,NULL,NULL,'2020-12-25 22:56:43','2020-12-25 22:56:43',NULL,2),(6,'Dr. Sam Abshire','Rafaela_Lindgren@gmail.com','$2b$10$TN1F3aC3wHaOBHIlRXaMS.nOzT3WgddRIhld8eVfINmdkT9ezquGS',NULL,NULL,'537-389-8854',NULL,NULL,NULL,NULL,NULL,NULL,'2020-12-25 22:56:44','2020-12-25 22:56:44',NULL,1),(7,'Dr. Mrs. Luz Bogan','Giovanny26@hotmail.com','$2b$10$2J33fCRhxJ385VDWYBLU1O34.JN7Z.I7qC18CBpEJhC67Bfa7HOia',NULL,NULL,'811-824-6766',NULL,NULL,NULL,NULL,NULL,NULL,'2020-12-25 22:57:00','2020-12-25 22:57:00',NULL,1);
165/*!40000 ALTER TABLE `doctors` ENABLE KEYS */;
166UNLOCK TABLES;
167
168--
169-- Table structure for table `drugs`
170--
171
172DROP TABLE IF EXISTS `drugs`;
173/*!40101 SET @saved_cs_client     = @@character_set_client */;
174/*!50503 SET character_set_client = utf8mb4 */;
175CREATE TABLE `drugs` (
176  `id` int unsigned NOT NULL AUTO_INCREMENT,
177  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
178  `instruction` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
179  `type` varchar(100) DEFAULT NULL,
180  `strength` varchar(100) DEFAULT NULL,
181  `createdAt` timestamp NULL DEFAULT NULL,
182  `updatedAt` timestamp NULL DEFAULT NULL,
183  `deletedAt` timestamp NULL DEFAULT NULL,
184  PRIMARY KEY (`id`)
185) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
186/*!40101 SET character_set_client = @saved_cs_client */;
187
188--
189-- Dumping data for table `drugs`
190--
191
192LOCK TABLES `drugs` WRITE;
193/*!40000 ALTER TABLE `drugs` DISABLE KEYS */;
194INSERT INTO `drugs` VALUES (1,'Account mesh empower','Est ab quo nihil nihil aperiam velit.','tablet','500mg','2020-12-24 03:57:37','2020-12-26 10:18:27',NULL),(2,'paracetamol','diminum sebelum makan','tablet','500mg','2020-12-24 04:00:03','2020-12-24 04:00:03',NULL),(3,'deposit Guyana Dynamic','Quae ipsa esse corrupti sit autem.','tablet','500mg','2020-12-26 10:17:20','2020-12-26 10:17:20',NULL),(4,'Music firewall','Voluptate ullam tempore.','tablet','500mg','2020-12-26 10:17:23','2020-12-26 10:17:23',NULL);
195/*!40000 ALTER TABLE `drugs` ENABLE KEYS */;
196UNLOCK TABLES;
197
198--
199-- Table structure for table `hospitals`
200--
201
202DROP TABLE IF EXISTS `hospitals`;
203/*!40101 SET @saved_cs_client     = @@character_set_client */;
204/*!50503 SET character_set_client = utf8mb4 */;
205CREATE TABLE `hospitals` (
206  `id` int unsigned NOT NULL AUTO_INCREMENT,
207  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
208  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
209  `province_id` int unsigned DEFAULT NULL,
210  `regency_id` int unsigned DEFAULT NULL,
211  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
212  `competence` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
213  `latitude` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
214  `longitude` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
215  `createdAt` timestamp NULL DEFAULT NULL,
216  `updatedAt` timestamp NULL DEFAULT NULL,
217  `deletedAt` timestamp NULL DEFAULT NULL,
218  PRIMARY KEY (`id`),
219  KEY `hospitals_FK` (`province_id`),
220  KEY `hospitals_FK_1` (`regency_id`),
221  CONSTRAINT `hospitals_FK` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`),
222  CONSTRAINT `hospitals_FK_1` FOREIGN KEY (`regency_id`) REFERENCES `regencies` (`id`)
223) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
224/*!40101 SET character_set_client = @saved_cs_client */;
225
226--
227-- Dumping data for table `hospitals`
228--
229
230LOCK TABLES `hospitals` WRITE;
231/*!40000 ALTER TABLE `hospitals` DISABLE KEYS */;
232INSERT INTO `hospitals` VALUES (1,'RS. Hammes - Heidenreich','750 Noemi Court',NULL,NULL,'Necessitatibus cupiditate et rerum ut esse.',NULL,NULL,NULL,'2020-12-24 04:04:44','2020-12-26 10:03:18',NULL),(2,'RS. Bandung Heart Center','Jl. Buah Batu No.10',NULL,NULL,'Rumah Sakit yang menangani pasienn khusus penyakit jantung. Tapi bukan jantung pisang.',NULL,NULL,NULL,'2020-12-24 04:07:40','2020-12-24 04:08:27',NULL),(3,'RS. Bandung Heart Center','Jl. Buah Batu',NULL,NULL,'Rumah Sakit yang menangani pasienn khusus penyakit jantung.',NULL,NULL,NULL,'2020-12-26 09:54:47','2020-12-26 09:54:47',NULL),(4,'RS. Torp - Kilback','52290 Abernathy Valleys',NULL,NULL,'Quam qui sequi tempore ullam accusamus qui.',NULL,NULL,NULL,'2020-12-26 09:55:46','2020-12-26 09:55:46',NULL),(5,'RS. Williamson, Schaden and Carter','70368 Amara Ridge',NULL,NULL,'Consequatur ut qui sed.',NULL,NULL,NULL,'2020-12-26 10:00:26','2020-12-26 10:00:26',NULL),(6,'RS. Lang, Torphy and Price','033 Bernhard Knolls',NULL,NULL,'Non accusamus eos facere est sed amet reprehenderit aliquam.',NULL,NULL,NULL,'2020-12-26 10:00:28','2020-12-26 10:00:28',NULL),(7,'RS. Jacobson and Sons','508 Kamren Village',NULL,NULL,'Vero maxime perspiciatis.',NULL,NULL,NULL,'2020-12-26 10:01:04','2020-12-26 10:01:04',NULL);
233/*!40000 ALTER TABLE `hospitals` ENABLE KEYS */;
234UNLOCK TABLES;
235
236--
237-- Table structure for table `patients`
238--
239
240DROP TABLE IF EXISTS `patients`;
241/*!40101 SET @saved_cs_client     = @@character_set_client */;
242/*!50503 SET character_set_client = utf8mb4 */;
243CREATE TABLE `patients` (
244  `id` int unsigned NOT NULL AUTO_INCREMENT,
245  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
246  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
247  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
248  `birth_date` date DEFAULT NULL,
249  `gender` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
250  `phone_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
251  `ktp_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
252  `blood_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
253  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
254  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
255  `province_id` int unsigned DEFAULT NULL,
256  `regency_id` int unsigned DEFAULT NULL,
257  `createdAt` timestamp NULL DEFAULT NULL,
258  `updatedAt` timestamp NULL DEFAULT NULL,
259  `deletedAt` timestamp NULL DEFAULT NULL,
260  `old_patient_id` int unsigned DEFAULT NULL,
261  PRIMARY KEY (`id`),
262  KEY `patients_FK` (`province_id`),
263  KEY `patients_FK_1` (`regency_id`),
264  CONSTRAINT `patients_FK` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`),
265  CONSTRAINT `patients_FK_1` FOREIGN KEY (`regency_id`) REFERENCES `regencies` (`id`)
266) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
267/*!40101 SET character_set_client = @saved_cs_client */;
268
269--
270-- Dumping data for table `patients`
271--
272
273LOCK TABLES `patients` WRITE;
274/*!40000 ALTER TABLE `patients` DISABLE KEYS */;
275INSERT INTO `patients` VALUES (1,'Sakitin bub Merananto','sakitin@merananto.com','$2b$10$G4fGWBfq7uvnuyukL0H3KOsfh3/zRuHUnd1UuEStgyWves/Z8TCCe',NULL,NULL,'081232312323',NULL,NULL,NULL,NULL,NULL,NULL,'2020-12-24 03:27:12','2020-12-24 03:27:12','2020-12-24 03:29:47',NULL),(7,'Sakitin bub Merananto','sakitin@merananto.com','$2b$10$gSmYxjdSUpNsf4Fp.a2Aiu4Oom67T0T3DGB6HglLxR.r9sCSWVaOK',NULL,NULL,'081232312323',NULL,NULL,NULL,NULL,NULL,NULL,'2020-12-24 03:29:50','2020-12-24 03:29:50','2020-12-24 03:30:11',NULL),(8,'Sakitin bin Merananto','sakitin@merananto.com','$2b$10$8FLRfG9YKB2r2BWVdvEO9.HL8MbQKL0j3lZOcjamI7sbZPGZwzCJK',NULL,NULL,'081232312323',NULL,NULL,NULL,NULL,NULL,NULL,'2020-12-24 03:30:14','2020-12-24 03:30:14',NULL,NULL);
276/*!40000 ALTER TABLE `patients` ENABLE KEYS */;
277UNLOCK TABLES;
278
279--
280-- Table structure for table `prescriptions`
281--
282
283DROP TABLE IF EXISTS `prescriptions`;
284/*!40101 SET @saved_cs_client     = @@character_set_client */;
285/*!50503 SET character_set_client = utf8mb4 */;
286CREATE TABLE `prescriptions` (
287  `id` int unsigned NOT NULL AUTO_INCREMENT,
288  `consultation_id` int unsigned NOT NULL,
289  `drug_id` int unsigned NOT NULL,
290  `dose` varchar(100) DEFAULT NULL,
291  `frequency` varchar(100) DEFAULT NULL,
292  `createdAt` timestamp NULL DEFAULT NULL,
293  `updatedAt` timestamp NULL DEFAULT NULL,
294  `deletedAt` timestamp NULL DEFAULT NULL,
295  `information` text,
296  PRIMARY KEY (`id`),
297  KEY `prescriptions_FK` (`drug_id`),
298  KEY `prescriptions_FK_1` (`consultation_id`),
299  CONSTRAINT `prescriptions_FK` FOREIGN KEY (`drug_id`) REFERENCES `drugs` (`id`),
300  CONSTRAINT `prescriptions_FK_1` FOREIGN KEY (`consultation_id`) REFERENCES `consultations` (`id`)
301) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
302/*!40101 SET character_set_client = @saved_cs_client */;
303
304--
305-- Dumping data for table `prescriptions`
306--
307
308LOCK TABLES `prescriptions` WRITE;
309/*!40000 ALTER TABLE `prescriptions` DISABLE KEYS */;
310INSERT INTO `prescriptions` VALUES (1,1,2,NULL,NULL,'2020-12-24 04:13:01','2020-12-24 04:13:24','2020-12-24 04:13:47',NULL),(2,1,1,NULL,NULL,'2020-12-24 04:13:57','2020-12-24 04:13:57',NULL,NULL),(3,1,1,NULL,NULL,'2020-12-24 09:09:42','2020-12-24 09:09:42',NULL,NULL),(4,1,1,NULL,NULL,'2020-12-24 09:09:43','2020-12-24 09:09:43',NULL,NULL),(5,1,1,NULL,NULL,'2020-12-24 09:09:43','2020-12-24 09:09:43',NULL,NULL);
311/*!40000 ALTER TABLE `prescriptions` ENABLE KEYS */;
312UNLOCK TABLES;
313
314--
315-- Table structure for table `provinces`
316--
317
318DROP TABLE IF EXISTS `provinces`;
319/*!40101 SET @saved_cs_client     = @@character_set_client */;
320/*!50503 SET character_set_client = utf8mb4 */;
321CREATE TABLE `provinces` (
322  `id` int unsigned NOT NULL AUTO_INCREMENT,
323  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
324  `eng_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
325  PRIMARY KEY (`id`)
326) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
327/*!40101 SET character_set_client = @saved_cs_client */;
328
329--
330-- Dumping data for table `provinces`
331--
332
333LOCK TABLES `provinces` WRITE;
334/*!40000 ALTER TABLE `provinces` DISABLE KEYS */;
335INSERT INTO `provinces` VALUES (1,'Aceh','Aceh'),(2,'Bali','Bali'),(3,'Banten','Banten'),(4,'Bengkulu','Bengkulu'),(5,'Gorontalo','Gorontalo'),(6,'Jakarta','Jakarta'),(7,'Jambi','Jambi'),(8,'Jawa Barat','West Java'),(9,'Jawa Tengah','Central Java'),(10,'Jawa Timur','East Java'),(11,'Kalimantan Barat','West Borneo'),(12,'Kalimantan Selatan','South Borneo'),(13,'Kalimantan Tengah','Central Borneo'),(14,'Kalimantan Timur','East Borneo'),(15,'Kalimantan Utara','North Borneo'),(16,'Kepulauan Bangka Belitung','Bangka Belitung Islands'),(17,'Kepulauan Riau','Riau Islands'),(18,'Lampung','Lampung'),(19,'Maluku','Maluku'),(20,'Maluku Utara','North Maluku'),(21,'Nusa Tenggara Barat','West Nusa Tenggara'),(22,'Nusa Tenggara Timur','East Nusa Tenggara'),(23,'Papua','Papua'),(24,'Papua Barat','West Papua'),(25,'Riau','Riau'),(26,'Sulawesi Barat','West Sulawesi'),(27,'Sulawesi Selatan','South Sulawesi'),(28,'Sulawesi Tengah','Central Sulawesi'),(29,'Sulawesi Tenggara','South East Sulawesi'),(30,'Sulawesi Utara','North Sulawesi'),(31,'Sumatera Barat','West Sumatera'),(32,'Sumatera Selatan','South Sumatera'),(33,'Sumatera Utara','North Sumatera'),(34,'Yogyakarta','Yogyakarta'),(35,'Lain-lain','Others');
336/*!40000 ALTER TABLE `provinces` ENABLE KEYS */;
337UNLOCK TABLES;
338
339--
340-- Table structure for table `regencies`
341--
342
343DROP TABLE IF EXISTS `regencies`;
344/*!40101 SET @saved_cs_client     = @@character_set_client */;
345/*!50503 SET character_set_client = utf8mb4 */;
346CREATE TABLE `regencies` (
347  `id` int unsigned NOT NULL AUTO_INCREMENT,
348  `province_id` int unsigned NOT NULL,
349  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
350  PRIMARY KEY (`id`),
351  KEY `regencies_province_id_foreign` (`province_id`) USING BTREE
352) ENGINE=InnoDB AUTO_INCREMENT=515 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
353/*!40101 SET character_set_client = @saved_cs_client */;
354
355--
356-- Dumping data for table `regencies`
357--
358
359LOCK TABLES `regencies` WRITE;
360/*!40000 ALTER TABLE `regencies` DISABLE KEYS */;
361INSERT INTO `regencies` VALUES (1,1,'Kabupaten Aceh Barat'),(2,1,'Kabupaten Aceh Barat Daya'),(3,1,'Kabupaten Aceh Besar'),(4,1,'Kabupaten Aceh Jaya'),(5,1,'Kabupaten Aceh Selatan'),(6,1,'Kabupaten Aceh Singkil'),(7,1,'Kabupaten Aceh Tamiang'),(8,1,'Kabupaten Aceh Tengah'),(9,1,'Kabupaten Aceh Tenggara'),(10,1,'Kabupaten Aceh Timur'),(11,1,'Kabupaten Aceh Utara'),(12,1,'Kabupaten Bener Meriah'),(13,1,'Kabupaten Bireuen'),(14,1,'Kabupaten Gayo Lues'),(15,1,'Kabupaten Nagan Raya'),(16,1,'Kabupaten Pidie'),(17,1,'Kabupaten Pidie Jaya'),(18,1,'Kabupaten Simeulue'),(19,1,'Kota Banda Aceh'),(20,1,'Kota Langsa'),(21,1,'Kota Lhokseumawe'),(22,1,'Kota Sabang'),(23,1,'Kota Subulussalam'),(24,2,'Kabupaten Badung'),(25,2,'Kabupaten Bangli'),(26,2,'Kabupaten Buleleng'),(27,2,'Kabupaten Gianyar'),(28,2,'Kabupaten Jembrana'),(29,2,'Kabupaten Karangasem'),(30,2,'Kabupaten Klungkung'),(31,2,'Kabupaten Tabanan'),(32,2,'Kota Denpasar'),(33,3,'Kabupaten Lebak'),(34,3,'Kabupaten Pandeglang'),(35,3,'Kabupaten Serang'),(36,3,'Kabupaten Tangerang'),(37,3,'Kota Cilegon'),(38,3,'Kota Serang'),(39,3,'Kota Tangerang'),(40,3,'Kota Tangerang Selatan'),(41,4,'Kabupaten Bengkulu Selatan'),(42,4,'Kabupaten Bengkulu Tengah'),(43,4,'Kabupaten Bengkulu Utara'),(44,4,'Kabupaten Kaur'),(45,4,'Kabupaten Kepahiang'),(46,4,'Kabupaten Lebong'),(47,4,'Kabupaten Mukomuko'),(48,4,'Kabupaten Rejang Lebong'),(49,4,'Kabupaten Seluma'),(50,4,'Kota Bengkulu'),(51,5,'Kabupaten Boalemo'),(52,5,'Kabupaten Bone Bolango'),(53,5,'Kabupaten Gorontalo'),(54,5,'Kabupaten Gorontalo Utara'),(55,5,'Kabupaten Pohuwato'),(56,5,'Kota Gorontalo'),(57,6,'Kepulauan Seribu'),(58,6,'Jakarta Barat'),(59,6,'Jakarta Pusat'),(60,6,'Jakarta Selatan'),(61,6,'Jakarta Timur'),(62,6,'Jakarta Utara'),(63,7,'Kabupaten Batanghari'),(64,7,'Kabupaten Bungo'),(65,7,'Kabupaten Kerinci'),(66,7,'Kabupaten Merangin'),(67,7,'Kabupaten Muaro Jambi'),(68,7,'Kabupaten Sarolangun'),(69,7,'Kabupaten Tanjung Jabung Barat'),(70,7,'Kabupaten Tanjung Jabung Timur'),(71,7,'Kabupaten Tebo'),(72,7,'Kota Jambi'),(73,7,'Kota Sungaipenuh'),(74,8,'Kabupaten Bandung'),(75,8,'Kabupaten Bandung Barat'),(76,8,'Kabupaten Bekasi'),(77,8,'Kabupaten Bogor'),(78,8,'Kabupaten Ciamis'),(79,8,'Kabupaten Cianjur'),(80,8,'Kabupaten Cirebon'),(81,8,'Kabupaten Garut'),(82,8,'Kabupaten Indramayu'),(83,8,'Kabupaten Karawang'),(84,8,'Kabupaten Kuningan'),(85,8,'Kabupaten Majalengka'),(86,8,'Kabupaten Pangandaran'),(87,8,'Kabupaten Purwakarta'),(88,8,'Kabupaten Subang'),(89,8,'Kabupaten Sukabumi'),(90,8,'Kabupaten Sumedang'),(91,8,'Kabupaten Tasikmalaya'),(92,8,'Kota Bandung'),(93,8,'Kota Banjar'),(94,8,'Kota Bekasi'),(95,8,'Kota Bogor'),(96,8,'Kota Cimahi'),(97,8,'Kota Cirebon'),(98,8,'Kota Depok'),(99,8,'Kota Sukabumi'),(100,8,'Kota Tasikmalaya'),(101,9,'Kabupaten Banjarnegara'),(102,9,'Kabupaten Banyumas'),(103,9,'Kabupaten Batang'),(104,9,'Kabupaten Blora'),(105,9,'Kabupaten Boyolali'),(106,9,'Kabupaten Brebes'),(107,9,'Kabupaten Cilacap'),(108,9,'Kabupaten Demak'),(109,9,'Kabupaten Grobogan'),(110,9,'Kabupaten Jepara'),(111,9,'Kabupaten Karanganyar'),(112,9,'Kabupaten Kebumen'),(113,9,'Kabupaten Kendal'),(114,9,'Kabupaten Klaten'),(115,9,'Kabupaten Kudus'),(116,9,'Kabupaten Magelang'),(117,9,'Kabupaten Pati'),(118,9,'Kabupaten Pekalongan'),(119,9,'Kabupaten Pemalang'),(120,9,'Kabupaten Purbalingga'),(121,9,'Kabupaten Purworejo'),(122,9,'Kabupaten Rembang'),(123,9,'Kabupaten Semarang'),(124,9,'Kabupaten Sragen'),(125,9,'Kabupaten Sukoharjo'),(126,9,'Kabupaten Tegal'),(127,9,'Kabupaten Temanggung'),(128,9,'Kabupaten Wonogiri'),(129,9,'Kabupaten Wonosobo'),(130,9,'Kota Magelang'),(131,9,'Kota Pekalongan'),(132,9,'Kota Salatiga'),(133,9,'Kota Semarang'),(134,9,'Kota Surakarta'),(135,9,'Kota Tegal'),(136,10,'Kabupaten Bangkalan'),(137,10,'Kabupaten Banyuwangi'),(138,10,'Kabupaten Blitar'),(139,10,'Kabupaten Bojonegoro'),(140,10,'Kabupaten Bondowoso'),(141,10,'Kabupaten Gresik'),(142,10,'Kabupaten Jember'),(143,10,'Kabupaten Jombang'),(144,10,'Kabupaten Kediri'),(145,10,'Kabupaten Lamongan'),(146,10,'Kabupaten Lumajang'),(147,10,'Kabupaten Madiun'),(148,10,'Kabupaten Magetan'),(149,10,'Kabupaten Malang'),(150,10,'Kabupaten Mojokerto'),(151,10,'Kabupaten Nganjuk'),(152,10,'Kabupaten Ngawi'),(153,10,'Kabupaten Pacitan'),(154,10,'Kabupaten Pamekasan'),(155,10,'Kabupaten Pasuruan'),(156,10,'Kabupaten Ponorogo'),(157,10,'Kabupaten Probolinggo'),(158,10,'Kabupaten Sampang'),(159,10,'Kabupaten Sidoarjo'),(160,10,'Kabupaten Situbondo'),(161,10,'Kabupaten Sumenep'),(162,10,'Kabupaten Trenggalek'),(163,10,'Kabupaten Tuban'),(164,10,'Kabupaten Tulungagung'),(165,10,'Kota Batu'),(166,10,'Kota Blitar'),(167,10,'Kota Kediri'),(168,10,'Kota Madiun'),(169,10,'Kota Malang'),(170,10,'Kota Mojokerto'),(171,10,'Kota Pasuruan'),(172,10,'Kota Probolinggo'),(173,10,'Kota Surabaya'),(174,11,'Kabupaten Bengkayang'),(175,11,'Kabupaten Kapuas Hulu'),(176,11,'Kabupaten Kayong Utara'),(177,11,'Kabupaten Ketapang'),(178,11,'Kabupaten Kubu Raya'),(179,11,'Kabupaten Landak'),(180,11,'Kabupaten Melawi'),(181,11,'Kabupaten Mempawah'),(182,11,'Kabupaten Sambas'),(183,11,'Kabupaten Sanggau'),(184,11,'Kabupaten Sekadau'),(185,11,'Kabupaten Sintang'),(186,11,'Kota Pontianak'),(187,11,'Kota Singkawang'),(188,12,'Kabupaten Balangan'),(189,12,'Kabupaten Banjar'),(190,12,'Kabupaten Barito Kuala'),(191,12,'Kabupaten Hulu Sungai Selatan'),(192,12,'Kabupaten Hulu Sungai Tengah'),(193,12,'Kabupaten Hulu Sungai Utara'),(194,12,'Kabupaten Kotabaru'),(195,12,'Kabupaten Tabalong'),(196,12,'Kabupaten Tanah Bumbu'),(197,12,'Kabupaten Tanah Laut'),(198,12,'Kabupaten Tapin'),(199,12,'Kota Banjarbaru'),(200,12,'Kota Banjarmasin'),(201,13,'Kabupaten Barito Kidul'),(202,13,'Kabupaten Barito Wétan'),(203,13,'Kabupaten Barito Lor'),(204,13,'Kabupaten Gunung Mas'),(205,13,'Kabupaten Kapuas'),(206,13,'Kabupaten Katingan'),(207,13,'Kabupaten Kotawaringin Kulon'),(208,13,'Kabupaten Kotawaringin Wétan'),(209,13,'Kabupaten Lamandau'),(210,13,'Kabupaten Murung Raya'),(211,13,'Kabupaten Pulang Pisau'),(212,13,'Kabupaten Seruyan'),(213,13,'Kabupaten Sukamara'),(214,13,'Kota Palangka Raya'),(215,14,'Kabupaten Berau'),(216,14,'Kabupaten Kutai Barat'),(217,14,'Kabupaten Kutai Kartanegara'),(218,14,'Kabupaten Kutai Timur'),(219,14,'Kabupaten Mahakam Ulu'),(220,14,'Kabupaten Paser'),(221,14,'Kabupaten Penajam Paser Utara'),(222,14,'Kota Balikpapan'),(223,14,'Kota Bontang'),(224,14,'Kota Samarinda'),(225,15,'Kabupaten Bulungan'),(226,15,'Kabupaten Malinau'),(227,15,'Kabupaten Nunukan'),(228,15,'Kabupaten Tana Tidung'),(229,15,'Kota Tarakan'),(230,16,'Kabupaten Bangka'),(231,16,'Kabupaten Bangka Barat'),(232,16,'Kabupaten Bangka Selatan'),(233,16,'Kabupaten Bangka Tengah'),(234,16,'Kabupaten Belitung'),(235,16,'Kabupaten Belitung Timur'),(236,16,'Kota Pangkal Pinang'),(237,17,'Kabupaten Bintan'),(238,17,'Kabupaten Karimun'),(239,17,'Kabupaten Kepulauan Anambas'),(240,17,'Kabupaten Lingga'),(241,17,'Kabupaten Natuna'),(242,17,'Kota Batam'),(243,17,'Kota Tanjung Pinang'),(244,18,'Kabupaten Lampung Barat'),(245,18,'Kabupaten Lampung Selatan'),(246,18,'Kabupaten Lampung Tengah'),(247,18,'Kabupaten Lampung Timur'),(248,18,'Kabupaten Lampung Utara'),(249,18,'Kabupaten Mesuji'),(250,18,'Kabupaten Pesawaran'),(251,18,'Kabupaten Pesisir Barat'),(252,18,'Kabupaten Pringsewu'),(253,18,'Kabupaten Tanggamus'),(254,18,'Kabupaten Tulang Bawang'),(255,18,'Kabupaten Tulang Bawang Barat'),(256,18,'Kabupaten Way Kanan'),(257,18,'Kota Bandar Lampung'),(258,18,'Kota Metro'),(259,19,'Kabupaten Buru'),(260,19,'Kabupaten Buru Selatan'),(261,19,'Kabupaten Kepulauan Aru'),(262,19,'Kabupaten Maluku Barat Daya'),(263,19,'Kabupaten Maluku Tengah'),(264,19,'Kabupaten Maluku Tenggara'),(265,19,'Kabupaten Kepulauan Tanimbar'),(266,19,'Kabupaten Seram Bagian Barat'),(267,19,'Kabupaten Seram Bagian Timur'),(268,19,'Kota Ambon'),(269,19,'Kota Tual'),(270,20,'Kabupaten Halmahera Barat'),(271,20,'Kabupaten Halmahera Tengah'),(272,20,'Kabupaten Halmahera Timur'),(273,20,'Kabupaten Halmahera Selatan'),(274,20,'Kabupaten Halmahera Utara'),(275,20,'Kabupaten Kepulauan Sula'),(276,20,'Kabupaten Pulau Morotai'),(277,20,'Kabupaten Pulau Taliabu'),(278,20,'Kota Ternate'),(279,20,'Kota Tidore Kepulauan'),(280,21,'Kabupaten Bima'),(281,21,'Kabupaten Dompu'),(282,21,'Kabupaten Lombok Barat'),(283,21,'Kabupaten Lombok Tengah'),(284,21,'Kabupaten Lombok Timur'),(285,21,'Kabupaten Lombok Utara'),(286,21,'Kabupaten Sumbawa'),(287,21,'Kabupaten Sumbawa Barat'),(288,21,'Kota Bima'),(289,21,'Kota Mataram'),(290,22,'Kabupaten Alor'),(291,22,'Kabupaten Belu'),(292,22,'Kabupaten Ende'),(293,22,'Kabupaten Flores Timur'),(294,22,'Kabupaten Kupang'),(295,22,'Kabupaten Lembata'),(296,22,'Kabupaten Malaka'),(297,22,'Kabupaten Manggarai'),(298,22,'Kabupaten Manggarai Barat'),(299,22,'Kabupaten Manggarai Timur'),(300,22,'Kabupaten Ngada'),(301,22,'Kabupaten Nagekeo'),(302,22,'Kabupaten Rote Ndao'),(303,22,'Kabupaten Sabu Raijua'),(304,22,'Kabupaten Sikka'),(305,22,'Kabupaten Sumba Barat'),(306,22,'Kabupaten Sumba Barat Daya'),(307,22,'Kabupaten Sumba Tengah'),(308,22,'Kabupaten Sumba Timur'),(309,22,'Kabupaten Timor Tengah Selatan'),(310,22,'Kabupaten Timor Tengah Utara'),(311,22,'Kota Kupang'),(312,23,'Kabupaten Asmat'),(313,23,'Kabupaten Biak Numfor'),(314,23,'Kabupaten Boven Digoel'),(315,23,'Kabupaten Deiyai'),(316,23,'Kabupaten Dogiyai'),(317,23,'Kabupaten Intan Jaya'),(318,23,'Kabupaten Jayapura'),(319,23,'Kabupaten Jayawijaya'),(320,23,'Kabupaten Keerom'),(321,23,'Kabupaten Kepulauan Yapen'),(322,23,'Kabupaten Lanny Jaya'),(323,23,'Kabupaten Mamberamo Raya'),(324,23,'Kabupaten Mamberamo Tengah'),(325,23,'Kabupaten Mappi'),(326,23,'Kabupaten Merauke'),(327,23,'Kabupaten Mimika'),(328,23,'Kabupaten Nabire'),(329,23,'Kabupaten Nduga'),(330,23,'Kabupaten Paniai'),(331,23,'Kabupaten Pegunungan Bintang'),(332,23,'Kabupaten Puncak'),(333,23,'Kabupaten Puncak Jaya'),(334,23,'Kabupaten Sarmi'),(335,23,'Kabupaten Supiori'),(336,23,'Kabupaten Tolikara'),(337,23,'Kabupaten Waropen'),(338,23,'Kabupaten Yahukimo'),(339,23,'Kabupaten Yalimo'),(340,23,'Kota Jayapura'),(341,24,'Kabupaten Fakfak'),(342,24,'Kabupaten Kaimana'),(343,24,'Kabupaten Manokwari'),(344,24,'Kabupaten Manokwari Selatan'),(345,24,'Kabupaten Maybrat'),(346,24,'Kabupaten Pegunungan Arfak'),(347,24,'Kabupaten Raja Ampat'),(348,24,'Kabupaten Sorong'),(349,24,'Kabupaten Sorong Selatan'),(350,24,'Kabupaten Tambrauw'),(351,24,'Kabupaten Teluk Bintuni'),(352,24,'Kabupaten Teluk Wondama'),(353,24,'Kota Sorong'),(354,25,'Kabupaten Bengkalis'),(355,25,'Kabupaten Indragiri Hilir'),(356,25,'Kabupaten Indragiri Hulu'),(357,25,'Kabupaten Kampar'),(358,25,'Kabupaten Kepulauan Meranti'),(359,25,'Kabupaten Kuantan Singingi'),(360,25,'Kabupaten Pelalawan'),(361,25,'Kabupaten Rokan Hilir'),(362,25,'Kabupaten Rokan Hulu'),(363,25,'Kabupaten Siak'),(364,25,'Kota Dumai'),(365,25,'Kota Pekanbaru'),(366,26,'Kabupaten Majene'),(367,26,'Kabupaten Mamasa'),(368,26,'Kabupaten Mamuju'),(369,26,'Kabupaten Mamuju Tengah'),(370,26,'Kabupaten Pasangkayu'),(371,26,'Kabupaten Polewali Mandar'),(372,27,'Kabupaten Bantaeng'),(373,27,'Kabupaten Barru'),(374,27,'Kabupaten Bone'),(375,27,'Kabupaten Bulukumba'),(376,27,'Kabupaten Enrekang'),(377,27,'Kabupaten Gowa'),(378,27,'Kabupaten Jeneponto'),(379,27,'Kabupaten Kepulauan Selayar'),(380,27,'Kabupaten Luwu'),(381,27,'Kabupaten Luwu Timur'),(382,27,'Kabupaten Luwu Utara'),(383,27,'Kabupaten Maros'),(384,27,'Kabupaten Pangkajene dan Kepulauan'),(385,27,'Kabupaten Pinrang'),(386,27,'Kabupaten Sidenreng Rappang'),(387,27,'Kabupaten Sinjai'),(388,27,'Kabupaten Soppeng'),(389,27,'Kabupaten Takalar'),(390,27,'Kabupaten Tana Toraja'),(391,27,'Kabupaten Toraja Utara'),(392,27,'Kabupaten Wajo'),(393,27,'Kota Makassar'),(394,27,'Kota Palopo'),(395,27,'Kota Parepare'),(396,28,'Kabupaten Banggai'),(397,28,'Kabupaten Banggai Kepulauan'),(398,28,'Kabupaten Banggai Laut'),(399,28,'Kabupaten Buol'),(400,28,'Kabupaten Donggala'),(401,28,'Kabupaten Morowali'),(402,28,'Kabupaten Morowali Utara'),(403,28,'Kabupaten Parigi Moutong'),(404,28,'Kabupaten Poso'),(405,28,'Kabupaten Sigi'),(406,28,'Kabupaten Tojo Una-Una'),(407,28,'Kabupaten Tolitoli'),(408,28,'Kota Palu'),(409,29,'Kabupaten Bombana'),(410,29,'Kabupaten Buton'),(411,29,'Kabupaten Buton Selatan'),(412,29,'Kabupaten Buton Tengah'),(413,29,'Kabupaten Buton Utara'),(414,29,'Kabupaten Kolaka'),(415,29,'Kabupaten Kolaka Timur'),(416,29,'Kabupaten Kolaka Utara'),(417,29,'Kabupaten Konawe'),(418,29,'Kabupaten Konawe Kepulauan'),(419,29,'Kabupaten Konawe Selatan'),(420,29,'Kabupaten Konawe Utara'),(421,29,'Kabupaten Muna'),(422,29,'Kabupaten Muna Barat'),(423,29,'Kabupaten Wakatobi'),(424,29,'Kota Bau-Bau'),(425,29,'Kota Kendari'),(426,30,'Kabupaten Bolaang Mongondow'),(427,30,'Kabupaten Bolaang Mongondow Selatan'),(428,30,'Kabupaten Bolaang Mongondow Timur'),(429,30,'Kabupaten Bolaang Mongondow Utara'),(430,30,'Kabupaten Kepulauan Sangihe'),(431,30,'Kabupaten Kepulauan Siau Tagulandang Biaro'),(432,30,'Kabupaten Kepulauan Talaud'),(433,30,'Kabupaten Minahasa'),(434,30,'Kabupaten Minahasa Selatan'),(435,30,'Kabupaten Minahasa Tenggara'),(436,30,'Kabupaten Minahasa Utara'),(437,30,'Kota Bitung'),(438,30,'Kota Kotamobagu'),(439,30,'Kota Manado'),(440,30,'Kota Tomohon'),(441,31,'Kabupaten Agam'),(442,31,'Kabupaten Dharmasraya'),(443,31,'Kabupaten Kepulauan Mentawai'),(444,31,'Kabupaten Lima Puluh Kota'),(445,31,'Kabupaten Padang Pariaman'),(446,31,'Kabupaten Pasaman'),(447,31,'Kabupaten Pasaman Barat'),(448,31,'Kabupaten Pesisir Selatan'),(449,31,'Kabupaten Sijunjung'),(450,31,'Kabupaten Solok'),(451,31,'Kabupaten Solok Selatan'),(452,31,'Kabupaten Tanah Datar'),(453,31,'Kota Bukittinggi'),(454,31,'Kota Padang'),(455,31,'Kota Padangpanjang'),(456,31,'Kota Pariaman'),(457,31,'Kota Payakumbuh'),(458,31,'Kota Sawahlunto'),(459,31,'Kota Solok'),(460,32,'Kabupaten Banyuasin'),(461,32,'Kabupaten Empat Lawang'),(462,32,'Kabupaten Lahat'),(463,32,'Kabupaten Muara Enim'),(464,32,'Kabupaten Musi Banyuasin'),(465,32,'Kabupaten Musi Rawas'),(466,32,'Kabupaten Musi Rawas Utara'),(467,32,'Kabupaten Ogan Ilir'),(468,32,'Kabupaten Ogan Komering Ilir'),(469,32,'Kabupaten Ogan Komering Ulu'),(470,32,'Kabupaten Ogan Komering Ulu Selatan'),(471,32,'Kabupaten Ogan Komering Ulu Timur'),(472,32,'Kabupaten Penukal Abab Lematang Ilir'),(473,32,'Kota Lubuklinggau'),(474,32,'Kota Pagar Alam'),(475,32,'Kota Palembang'),(476,32,'Kota Prabumulih'),(477,33,'Kabupaten Asahan'),(478,33,'Kabupaten Batu Barat'),(479,33,'Kabupaten Dairi'),(480,33,'Kabupaten Deli Serdang'),(481,33,'Kabupaten Humbang Hasundutan'),(482,33,'Kabupaten Karo'),(483,33,'Kabupaten Labuhanbatu'),(484,33,'Kabupaten Labuhanbatu Selatan'),(485,33,'Kabupaten Labuhanbatu Utara'),(486,33,'Kabupaten Langkat'),(487,33,'Kabupaten Mandailing Natal'),(488,33,'Kabupaten Nias'),(489,33,'Kabupaten Nias Barat'),(490,33,'Kabupaten Nias Selatan'),(491,33,'Kabupaten Nias Utara'),(492,33,'Kabupaten Padang Lawas'),(493,33,'Kabupaten Padang Lawas Utara'),(494,33,'Kabupaten Pakpak Bharat'),(495,33,'Kabupaten Samosir'),(496,33,'Kabupaten Serdang Bedagai'),(497,33,'Kabupaten Simalungun'),(498,33,'Kabupaten Tapanuli Selatan'),(499,33,'Kabupaten Tapanuli Tengah'),(500,33,'Kabupaten Tapanuli Utara'),(501,33,'Kabupaten Toba Samosir'),(502,33,'Kota Binjai'),(503,33,'Kota Gunungsitoli'),(504,33,'Kota Medan'),(505,33,'Kota Padangsidempuan'),(506,33,'Kota Pematangsiantar'),(507,33,'Kota Sibolga'),(508,33,'Kota Tanjungbalai'),(509,33,'Kota Tebing Tinggi'),(510,34,'Kabupaten Bantul'),(511,34,'Kabupaten Gunungkidul'),(512,34,'Kabupaten Kulon Progo'),(513,34,'Kabupaten Sleman'),(514,34,'Kota Yogyakarta');
362/*!40000 ALTER TABLE `regencies` ENABLE KEYS */;
363UNLOCK TABLES;
364
365--
366-- Table structure for table `schedules`
367--
368
369DROP TABLE IF EXISTS `schedules`;
370/*!40101 SET @saved_cs_client     = @@character_set_client */;
371/*!50503 SET character_set_client = utf8mb4 */;
372CREATE TABLE `schedules` (
373  `id` int unsigned NOT NULL AUTO_INCREMENT,
374  `date` date NOT NULL,
375  `doctor_id` int unsigned NOT NULL,
376  `createdAt` timestamp NULL DEFAULT NULL,
377  `updatedAt` timestamp NULL DEFAULT NULL,
378  `deletedAt` timestamp NULL DEFAULT NULL,
379  `timeslot` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
380  PRIMARY KEY (`id`),
381  KEY `schedules_FK` (`doctor_id`),
382  CONSTRAINT `schedules_FK` FOREIGN KEY (`doctor_id`) REFERENCES `doctors` (`id`)
383) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
384/*!40101 SET character_set_client = @saved_cs_client */;
385
386--
387-- Dumping data for table `schedules`
388--
389
390LOCK TABLES `schedules` WRITE;
391/*!40000 ALTER TABLE `schedules` DISABLE KEYS */;
392INSERT INTO `schedules` VALUES (21,'2020-12-30',1,'2020-12-24 10:16:29','2020-12-24 10:16:29',NULL,'11110000111111111BBTSX11111111111111111111101111'),(22,'2020-12-30',1,'2020-12-26 10:25:19','2020-12-26 10:25:19',NULL,'111100001111111111BTSX11111111111111111111101111'),(23,'2020-12-30',2,'2020-12-26 10:25:23','2020-12-26 10:25:23',NULL,'111100001111111111BTSX11111111111111111111101111'),(24,'2020-12-30',2,'2020-12-26 10:25:32','2020-12-26 10:25:32',NULL,'111100001111111111BTSX11111111111111111111101111'),(25,'2020-12-30',3,'2020-12-26 10:28:06','2020-12-26 10:29:23',NULL,'111100001111111111BTSX11111111111111111111101111');
393/*!40000 ALTER TABLE `schedules` ENABLE KEYS */;
394UNLOCK TABLES;
395
396--
397-- Dumping routines for database 'jantungku'
398--
399/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
400
401/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
402/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
403/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
404/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
405/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
406/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
407/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
408
409-- Dump completed on 2020-12-27 14:29:35
410