qJhTKDzL

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) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Dumping data for table `admins`
40--
41
42LOCK TABLES `admins` WRITE;
43/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
44INSERT 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);
45/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `chats`
50--
51
52DROP TABLE IF EXISTS `chats`;
53/*!40101 SET @saved_cs_client     = @@character_set_client */;
54/*!50503 SET character_set_client = utf8mb4 */;
55CREATE TABLE `chats` (
56  `id` int unsigned NOT NULL AUTO_INCREMENT,
57  `isPatient` tinyint(1) NOT NULL,
58  `content` varchar(100) DEFAULT NULL,
59  `type` varchar(100) DEFAULT NULL,
60  `consultation_id` int unsigned NOT NULL,
61  `createdAt` timestamp NULL DEFAULT NULL,
62  `updatedAt` timestamp NULL DEFAULT NULL,
63  `deletedAt` timestamp NULL DEFAULT NULL,
64  PRIMARY KEY (`id`)
65) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Dumping data for table `chats`
70--
71
72LOCK TABLES `chats` WRITE;
73/*!40000 ALTER TABLE `chats` DISABLE KEYS */;
74INSERT INTO `chats` VALUES (1,0,'Halo doc edit','text',3,'2020-12-23 23:01:37','2020-12-23 23:59:06','2020-12-23 23:59:56'),(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);
75/*!40000 ALTER TABLE `chats` ENABLE KEYS */;
76UNLOCK TABLES;
77
78--
79-- Table structure for table `consultations`
80--
81
82DROP TABLE IF EXISTS `consultations`;
83/*!40101 SET @saved_cs_client     = @@character_set_client */;
84/*!50503 SET character_set_client = utf8mb4 */;
85CREATE TABLE `consultations` (
86  `id` int unsigned NOT NULL AUTO_INCREMENT,
87  `booked_date` date NOT NULL,
88  `resume` text,
89  `isChat` tinyint(1) NOT NULL,
90  `isVideo` tinyint(1) NOT NULL,
91  `payment_proof` varchar(100) DEFAULT NULL,
92  `status` char(1) NOT NULL,
93  `createdAt` timestamp NULL DEFAULT NULL,
94  `updatedAt` timestamp NULL DEFAULT NULL,
95  `deletedAt` timestamp NULL DEFAULT NULL,
96  `patient_id` int unsigned NOT NULL,
97  `doctor_id` int unsigned NOT NULL,
98  `start_time` datetime DEFAULT NULL,
99  `end_time` datetime DEFAULT NULL,
100  `booked_slot` tinyint unsigned NOT NULL,
101  PRIMARY KEY (`id`)
102) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
103/*!40101 SET character_set_client = @saved_cs_client */;
104
105--
106-- Dumping data for table `consultations`
107--
108
109LOCK TABLES `consultations` WRITE;
110/*!40000 ALTER TABLE `consultations` DISABLE KEYS */;
111INSERT INTO `consultations` VALUES (1,'1970-01-19',NULL,1,0,NULL,'B','2020-12-24 09:08:47','2020-12-24 09:08:47',NULL,1,2,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,2,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,2,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);
112/*!40000 ALTER TABLE `consultations` ENABLE KEYS */;
113UNLOCK TABLES;
114
115--
116-- Table structure for table `doctors`
117--
118
119DROP TABLE IF EXISTS `doctors`;
120/*!40101 SET @saved_cs_client     = @@character_set_client */;
121/*!50503 SET character_set_client = utf8mb4 */;
122CREATE TABLE `doctors` (
123  `id` int unsigned NOT NULL AUTO_INCREMENT,
124  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
125  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
126  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
127  `birth_date` date DEFAULT NULL,
128  `gender` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
129  `phone_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
130  `ktp_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
131  `blood_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
132  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
133  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
134  `province_id` int unsigned DEFAULT NULL,
135  `regency_id` int unsigned DEFAULT NULL,
136  `createdAt` timestamp NULL DEFAULT NULL,
137  `updatedAt` timestamp NULL DEFAULT NULL,
138  `deletedAt` timestamp NULL DEFAULT NULL,
139  `hospital_id` int unsigned NOT NULL,
140  PRIMARY KEY (`id`)
141) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
142/*!40101 SET character_set_client = @saved_cs_client */;
143
144--
145-- Dumping data for table `doctors`
146--
147
148LOCK TABLES `doctors` WRITE;
149/*!40000 ALTER TABLE `doctors` DISABLE KEYS */;
150INSERT INTO `doctors` VALUES (3,'Dr. Paijo bin Paiman','paijo@paiman.com','$2b$10$w2w6mJ86S6KOIQVFNFJHTexXPXSrQZkVNltE5w9M49F.Io4Xbb2Iy',NULL,NULL,'081232312323',NULL,NULL,NULL,NULL,NULL,NULL,'2020-12-24 02:28:27','2020-12-24 02:28:27',NULL,1);
151/*!40000 ALTER TABLE `doctors` ENABLE KEYS */;
152UNLOCK TABLES;
153
154--
155-- Table structure for table `drugs`
156--
157
158DROP TABLE IF EXISTS `drugs`;
159/*!40101 SET @saved_cs_client     = @@character_set_client */;
160/*!50503 SET character_set_client = utf8mb4 */;
161CREATE TABLE `drugs` (
162  `id` int unsigned NOT NULL AUTO_INCREMENT,
163  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
164  `instruction` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
165  `type` varchar(100) DEFAULT NULL,
166  `strength` varchar(100) DEFAULT NULL,
167  `createdAt` timestamp NULL DEFAULT NULL,
168  `updatedAt` timestamp NULL DEFAULT NULL,
169  `deletedAt` timestamp NULL DEFAULT NULL,
170  PRIMARY KEY (`id`)
171) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
172/*!40101 SET character_set_client = @saved_cs_client */;
173
174--
175-- Dumping data for table `drugs`
176--
177
178LOCK TABLES `drugs` WRITE;
179/*!40000 ALTER TABLE `drugs` DISABLE KEYS */;
180INSERT INTO `drugs` VALUES (1,'paracetamol','diminum sebelum makan','tablet','500mg','2020-12-24 03:57:37','2020-12-24 03:57:37','2020-12-24 04:00:00'),(2,'paracetamol','diminum sebelum makan','tablet','500mg','2020-12-24 04:00:03','2020-12-24 04:00:03',NULL);
181/*!40000 ALTER TABLE `drugs` ENABLE KEYS */;
182UNLOCK TABLES;
183
184--
185-- Table structure for table `hospitals`
186--
187
188DROP TABLE IF EXISTS `hospitals`;
189/*!40101 SET @saved_cs_client     = @@character_set_client */;
190/*!50503 SET character_set_client = utf8mb4 */;
191CREATE TABLE `hospitals` (
192  `id` int unsigned NOT NULL AUTO_INCREMENT,
193  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
194  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
195  `province_id` int unsigned DEFAULT NULL,
196  `regency_id` int unsigned DEFAULT NULL,
197  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
198  `competence` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
199  `latitude` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
200  `longitude` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
201  `createdAt` timestamp NULL DEFAULT NULL,
202  `updatedAt` timestamp NULL DEFAULT NULL,
203  `deletedAt` timestamp NULL DEFAULT NULL,
204  PRIMARY KEY (`id`)
205) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
206/*!40101 SET character_set_client = @saved_cs_client */;
207
208--
209-- Dumping data for table `hospitals`
210--
211
212LOCK TABLES `hospitals` WRITE;
213/*!40000 ALTER TABLE `hospitals` DISABLE KEYS */;
214INSERT INTO `hospitals` VALUES (1,'RS. Bandung Heart Center','Jl. Buah Batu',NULL,NULL,'Rumah Sakit yang menangani pasienn khusus penyakit jantung.',NULL,NULL,NULL,'2020-12-24 04:04:44','2020-12-24 04:04:44','2020-12-24 04:07:38'),(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);
215/*!40000 ALTER TABLE `hospitals` ENABLE KEYS */;
216UNLOCK TABLES;
217
218--
219-- Table structure for table `patients`
220--
221
222DROP TABLE IF EXISTS `patients`;
223/*!40101 SET @saved_cs_client     = @@character_set_client */;
224/*!50503 SET character_set_client = utf8mb4 */;
225CREATE TABLE `patients` (
226  `id` int unsigned NOT NULL AUTO_INCREMENT,
227  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
228  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
229  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
230  `birth_date` date DEFAULT NULL,
231  `gender` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
232  `phone_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
233  `ktp_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
234  `blood_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
235  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
236  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
237  `province_id` int unsigned DEFAULT NULL,
238  `regency_id` int unsigned DEFAULT NULL,
239  `createdAt` timestamp NULL DEFAULT NULL,
240  `updatedAt` timestamp NULL DEFAULT NULL,
241  `deletedAt` timestamp NULL DEFAULT NULL,
242  `old_patient_id` int unsigned DEFAULT NULL,
243  PRIMARY KEY (`id`)
244) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
245/*!40101 SET character_set_client = @saved_cs_client */;
246
247--
248-- Dumping data for table `patients`
249--
250
251LOCK TABLES `patients` WRITE;
252/*!40000 ALTER TABLE `patients` DISABLE KEYS */;
253INSERT INTO `patients` VALUES (6,'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);
254/*!40000 ALTER TABLE `patients` ENABLE KEYS */;
255UNLOCK TABLES;
256
257--
258-- Table structure for table `prescriptions`
259--
260
261DROP TABLE IF EXISTS `prescriptions`;
262/*!40101 SET @saved_cs_client     = @@character_set_client */;
263/*!50503 SET character_set_client = utf8mb4 */;
264CREATE TABLE `prescriptions` (
265  `id` int unsigned NOT NULL AUTO_INCREMENT,
266  `consultation_id` int unsigned NOT NULL,
267  `drug_id` int unsigned NOT NULL,
268  `dose` varchar(100) DEFAULT NULL,
269  `frequency` varchar(100) DEFAULT NULL,
270  `createdAt` timestamp NULL DEFAULT NULL,
271  `updatedAt` timestamp NULL DEFAULT NULL,
272  `deletedAt` timestamp NULL DEFAULT NULL,
273  `information` text,
274  PRIMARY KEY (`id`)
275) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
276/*!40101 SET character_set_client = @saved_cs_client */;
277
278--
279-- Dumping data for table `prescriptions`
280--
281
282LOCK TABLES `prescriptions` WRITE;
283/*!40000 ALTER TABLE `prescriptions` DISABLE KEYS */;
284INSERT 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);
285/*!40000 ALTER TABLE `prescriptions` ENABLE KEYS */;
286UNLOCK TABLES;
287
288--
289-- Table structure for table `provinces`
290--
291
292DROP TABLE IF EXISTS `provinces`;
293/*!40101 SET @saved_cs_client     = @@character_set_client */;
294/*!50503 SET character_set_client = utf8mb4 */;
295CREATE TABLE `provinces` (
296  `id` int unsigned NOT NULL AUTO_INCREMENT,
297  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
298  `eng_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
299  PRIMARY KEY (`id`)
300) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
301/*!40101 SET character_set_client = @saved_cs_client */;
302
303--
304-- Dumping data for table `provinces`
305--
306
307LOCK TABLES `provinces` WRITE;
308/*!40000 ALTER TABLE `provinces` DISABLE KEYS */;
309INSERT 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');
310/*!40000 ALTER TABLE `provinces` ENABLE KEYS */;
311UNLOCK TABLES;
312
313--
314-- Table structure for table `regencies`
315--
316
317DROP TABLE IF EXISTS `regencies`;
318/*!40101 SET @saved_cs_client     = @@character_set_client */;
319/*!50503 SET character_set_client = utf8mb4 */;
320CREATE TABLE `regencies` (
321  `id` int unsigned NOT NULL AUTO_INCREMENT,
322  `province_id` int unsigned NOT NULL,
323  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
324  PRIMARY KEY (`id`),
325  KEY `regencies_province_id_foreign` (`province_id`) USING BTREE
326) ENGINE=InnoDB AUTO_INCREMENT=515 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
327/*!40101 SET character_set_client = @saved_cs_client */;
328
329--
330-- Dumping data for table `regencies`
331--
332
333LOCK TABLES `regencies` WRITE;
334/*!40000 ALTER TABLE `regencies` DISABLE KEYS */;
335INSERT 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');
336/*!40000 ALTER TABLE `regencies` ENABLE KEYS */;
337UNLOCK TABLES;
338
339--
340-- Table structure for table `schedules`
341--
342
343DROP TABLE IF EXISTS `schedules`;
344/*!40101 SET @saved_cs_client     = @@character_set_client */;
345/*!50503 SET character_set_client = utf8mb4 */;
346CREATE TABLE `schedules` (
347  `id` int unsigned NOT NULL AUTO_INCREMENT,
348  `date` date NOT NULL,
349  `doctor_id` int unsigned NOT NULL,
350  `createdAt` timestamp NULL DEFAULT NULL,
351  `updatedAt` timestamp NULL DEFAULT NULL,
352  `deletedAt` timestamp NULL DEFAULT NULL,
353  `timeslot` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
354  PRIMARY KEY (`id`)
355) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
356/*!40101 SET character_set_client = @saved_cs_client */;
357
358--
359-- Dumping data for table `schedules`
360--
361
362LOCK TABLES `schedules` WRITE;
363/*!40000 ALTER TABLE `schedules` DISABLE KEYS */;
364INSERT INTO `schedules` VALUES (21,'2020-12-30',1,'2020-12-24 10:16:29','2020-12-24 10:16:29',NULL,'11110000111111111BBTSX11111111111111111111101111');
365/*!40000 ALTER TABLE `schedules` ENABLE KEYS */;
366UNLOCK TABLES;
367
368--
369-- Dumping routines for database 'jantungku'
370--
371/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
372
373/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
374/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
375/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
376/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
377/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
378/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
379/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
380
381-- Dump completed on 2020-12-24 18:47:11
382