text: -- phpMyAdmin SQL Dump
  -- version 5.1.1
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost:3306
  -- Waktu pembuatan: 23 Jul 2021 pada 07.01
  -- Versi server: 5.7.33
  -- Versi PHP: 7.4.19
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `padas`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `ibu_has_berkebutuhan_khusus`
  --
  
  CREATE TABLE `ibu_has_berkebutuhan_khusus` (
    `ibu_id_ibu` bigint(20) NOT NULL,
    `berkebutuhan_khusus_id_berkebutuhan_khusus` int(11) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `deleted_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data untuk tabel `ibu_has_berkebutuhan_khusus`
  --
  
  INSERT INTO `ibu_has_berkebutuhan_khusus` VALUES
  (14, 6, '2021-07-19 18:20:23', '2021-07-08 20:14:52', NULL),
  (49, 12, '2021-07-12 01:53:53', '2021-07-12 09:13:35', NULL),
  (50, 6, '2021-06-28 08:47:14', '2021-06-26 14:17:03', NULL),
  (54, 2, '2021-07-17 20:40:42', '2021-06-26 06:16:17', NULL),
  (59, 10, '2021-07-02 17:35:47', '2021-07-10 14:43:00', NULL),
  (63, 6, '2021-07-22 20:31:16', '2021-07-12 16:12:00', NULL),
  (95, 3, '2021-06-26 17:27:47', '2021-07-05 15:58:52', NULL),
  (99, 6, '2021-07-02 16:15:17', '2021-07-12 18:58:57', NULL),
  (118, 5, '2021-07-04 15:53:24', '2021-06-30 17:48:23', NULL),
  (137, 9, '2021-07-15 08:13:01', '2021-06-28 02:12:56', NULL),
  (146, 17, '2021-06-29 07:15:11', '2021-06-25 01:22:03', NULL),
  (155, 17, '2021-06-29 23:42:54', '2021-07-02 01:53:49', NULL),
  (167, 6, '2021-07-21 23:56:41', '2021-07-10 20:12:27', NULL),
  (168, 17, '2021-06-27 20:47:22', '2021-06-28 19:11:26', NULL),
  (171, 13, '2021-07-06 09:11:57', '2021-07-08 00:52:08', NULL),
  (174, 9, '2021-07-09 01:26:02', '2021-07-17 07:17:43', NULL),
  (174, 12, '2021-07-20 04:36:31', '2021-07-19 15:44:02', NULL),
  (188, 8, '2021-07-10 20:21:24', '2021-06-23 10:11:21', NULL),
  (189, 4, '2021-07-21 11:24:24', '2021-07-11 15:48:10', NULL),
  (190, 11, '2021-07-09 12:36:33', '2021-07-10 05:02:23', NULL),
  (196, 17, '2021-06-30 04:53:16', '2021-07-19 15:54:11', NULL),
  (204, 15, '2021-07-15 16:39:38', '2021-07-19 14:15:10', NULL),
  (218, 2, '2021-07-19 08:27:20', '2021-07-08 17:09:45', NULL),
  (238, 14, '2021-07-22 10:11:39', '2021-06-30 18:42:39', NULL),
  (247, 14, '2021-07-19 00:30:12', '2021-07-20 16:20:15', NULL),
  (249, 13, '2021-07-05 10:14:14', '2021-07-22 05:51:41', NULL),
  (256, 10, '2021-07-21 09:17:51', '2021-07-20 07:41:39', NULL),
  (275, 15, '2021-07-09 03:06:00', '2021-06-30 06:39:19', NULL),
  (333, 15, '2021-07-04 12:50:22', '2021-06-27 05:44:26', NULL),
  (334, 11, '2021-07-08 16:53:44', '2021-06-26 11:10:32', NULL),
  (337, 15, '2021-07-08 02:10:10', '2021-07-19 17:59:25', NULL),
  (340, 8, '2021-06-26 18:45:16', '2021-06-30 16:34:47', NULL),
  (341, 5, '2021-06-24 11:38:45', '2021-07-05 10:59:45', NULL),
  (391, 2, '2021-07-15 14:10:57', '2021-07-18 11:23:48', NULL),
  (419, 5, '2021-07-12 04:26:09', '2021-07-09 16:23:49', NULL),
  (420, 6, '2021-07-19 23:06:18', '2021-07-11 08:53:55', NULL),
  (434, 11, '2021-06-23 18:55:31', '2021-06-30 08:09:43', NULL),
  (440, 6, '2021-07-20 08:49:42', '2021-07-20 10:22:25', NULL),
  (456, 13, '2021-07-18 21:31:20', '2021-07-14 13:21:09', NULL),
  (457, 4, '2021-06-23 15:00:48', '2021-07-16 11:25:10', NULL),
  (476, 4, '2021-07-16 08:53:06', '2021-07-07 19:28:30', NULL),
  (552, 12, '2021-07-03 11:08:36', '2021-07-08 11:25:00', NULL),
  (592, 12, '2021-07-01 08:02:43', '2021-07-02 14:01:59', NULL),
  (595, 2, '2021-07-18 06:47:01', '2021-07-10 03:18:56', NULL),
  (614, 10, '2021-07-15 15:35:24', '2021-07-20 08:15:08', NULL),
  (617, 6, '2021-07-07 00:50:27', '2021-07-15 17:34:53', NULL),
  (621, 13, '2021-07-07 11:50:38', '2021-06-30 12:13:01', NULL),
  (623, 16, '2021-07-19 06:47:14', '2021-07-08 20:09:19', NULL),
  (638, 12, '2021-07-10 19:52:49', '2021-07-14 00:38:32', NULL),
  (645, 17, '2021-06-27 01:13:46', '2021-06-26 06:10:40', NULL),
  (656, 11, '2021-06-30 20:44:47', '2021-06-25 12:41:44', NULL),
  (668, 16, '2021-07-21 06:06:11', '2021-07-10 08:27:06', NULL),
  (680, 9, '2021-07-12 06:03:43', '2021-06-29 16:58:23', NULL),
  (697, 6, '2021-07-01 06:52:24', '2021-06-28 17:46:04', NULL),
  (724, 9, '2021-07-12 19:07:29', '2021-06-23 20:14:13', NULL),
  (725, 9, '2021-07-06 13:41:01', '2021-07-20 02:20:47', NULL),
  (726, 12, '2021-07-13 14:24:15', '2021-07-03 18:45:10', NULL),
  (730, 10, '2021-07-03 05:53:57', '2021-07-20 02:30:34', NULL),
  (730, 16, '2021-06-28 16:17:33', '2021-07-06 00:17:21', NULL),
  (737, 16, '2021-07-16 07:29:00', '2021-07-15 11:59:12', NULL),
  (747, 11, '2021-07-08 07:25:12', '2021-07-09 18:10:21', NULL),
  (752, 11, '2021-07-18 10:41:27', '2021-07-01 14:53:32', NULL),
  (756, 12, '2021-06-30 10:13:27', '2021-07-21 20:16:23', NULL),
  (769, 17, '2021-06-23 00:34:59', '2021-07-06 18:32:45', NULL),
  (780, 11, '2021-07-07 03:29:27', '2021-06-27 09:28:26', NULL),
  (809, 5, '2021-07-04 16:35:18', '2021-07-01 03:39:18', NULL),
  (816, 1, '2021-07-21 18:27:25', '2021-06-28 15:57:43', NULL),
  (817, 15, '2021-07-11 11:50:08', '2021-07-06 04:57:21', NULL),
  (821, 5, '2021-07-14 15:47:16', '2021-06-30 00:58:05', NULL),
  (821, 12, '2021-07-01 06:41:12', '2021-06-27 18:04:28', NULL),
  (830, 15, '2021-07-01 01:42:34', '2021-07-21 22:08:12', NULL),
  (837, 14, '2021-07-22 05:31:28', '2021-07-11 05:30:42', NULL),
  (847, 6, '2021-07-04 00:33:20', '2021-07-13 11:37:23', NULL),
  (852, 6, '2021-07-02 03:05:06', '2021-07-01 10:45:28', NULL),
  (878, 15, '2021-07-09 22:06:48', '2021-07-04 11:02:52', NULL),
  (878, 16, '2021-07-21 08:32:53', '2021-07-07 00:25:38', NULL),
  (881, 9, '2021-07-08 07:41:27', '2021-06-25 11:15:01', NULL),
  (882, 2, '2021-07-12 12:26:14', '2021-07-16 20:44:23', NULL),
  (909, 13, '2021-07-13 20:44:00', '2021-07-15 18:47:58', NULL),
  (922, 10, '2021-07-01 21:03:31', '2021-07-15 13:18:00', NULL),
  (948, 4, '2021-07-16 03:36:00', '2021-07-13 07:46:05', NULL),
  (948, 7, '2021-06-24 01:09:09', '2021-06-23 19:31:49', NULL),
  (988, 11, '2021-07-06 19:01:15', '2021-06-24 18:26:31', NULL),
  (1017, 5, '2021-07-21 00:21:29', '2021-07-16 09:56:07', NULL),
  (1049, 8, '2021-07-07 14:49:44', '2021-07-17 08:00:05', NULL),
  (1054, 2, '2021-07-22 07:49:35', '2021-07-18 08:38:23', NULL),
  (1058, 4, '2021-07-04 19:05:26', '2021-06-26 18:43:09', NULL),
  (1078, 12, '2021-06-24 09:00:03', '2021-07-17 07:45:42', NULL),
  (1095, 14, '2021-06-25 03:07:10', '2021-06-26 00:20:39', NULL),
  (1099, 11, '2021-06-24 18:17:05', '2021-06-25 16:12:19', NULL),
  (1115, 5, '2021-07-01 07:39:30', '2021-07-11 01:09:09', NULL),
  (1125, 17, '2021-06-27 16:04:52', '2021-07-16 11:43:16', NULL),
  (1126, 7, '2021-06-23 11:08:35', '2021-07-13 08:27:27', NULL),
  (1139, 8, '2021-07-20 20:11:34', '2021-07-21 16:01:59', NULL),
  (1164, 14, '2021-07-08 17:48:00', '2021-07-20 19:20:26', NULL),
  (1178, 5, '2021-07-17 23:27:28', '2021-07-17 09:30:31', NULL),
  (1184, 1, '2021-06-25 14:53:44', '2021-07-05 05:51:17', NULL),
  (1241, 16, '2021-06-27 03:01:59', '2021-07-19 19:48:44', NULL),
  (1248, 11, '2021-06-24 23:10:23', '2021-07-13 10:14:00', NULL),
  (1292, 17, '2021-07-08 10:22:32', '2021-07-03 03:01:31', NULL);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indeks untuk tabel `ibu_has_berkebutuhan_khusus`
  --
  ALTER TABLE `ibu_has_berkebutuhan_khusus`
    ADD PRIMARY KEY (`ibu_id_ibu`,`berkebutuhan_khusus_id_berkebutuhan_khusus`),
    ADD KEY `fk_ibu_has_berkebutuhan_khusus_berkebutuhan_khusus1_idx` (`berkebutuhan_khusus_id_berkebutuhan_khusus`),
    ADD KEY `fk_ibu_has_berkebutuhan_khusus_ibu1_idx` (`ibu_id_ibu`);
  
  --
  -- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
  --
  
  --
  -- Ketidakleluasaan untuk tabel `ibu_has_berkebutuhan_khusus`
  --
  ALTER TABLE `ibu_has_berkebutuhan_khusus`
    ADD CONSTRAINT `fk_ibu_has_berkebutuhan_khusus_berkebutuhan_khusus1` FOREIGN KEY (`berkebutuhan_khusus_id_berkebutuhan_khusus`) REFERENCES `berkebutuhan_khusus` (`id_berkebutuhan_khusus`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_ibu_has_berkebutuhan_khusus_ibu1` FOREIGN KEY (`ibu_id_ibu`) REFERENCES `ibu` (`id_ibu`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  COMMIT;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  