-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 07 Nov 2021 pada 03.01
-- Versi server: 10.4.11-MariaDB
-- Versi PHP: 7.2.31

START TRANSACTION;



--
-- Database: `delima_backend`
--

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

--
-- Struktur dari tabel `data_periksa_pertama`
--

CREATE TABLE `data_periksa_pertama` (
  `id_data_periksa_pertama` int(11) NOT NULL,
  `tgl_hpht` varchar(100) DEFAULT NULL,
  `tgl_hpt` varchar(100) DEFAULT NULL,
  `lingkar_lengan_atas` varchar(50) DEFAULT NULL,
  `tinggi_badan` varchar(50) DEFAULT NULL,
  `gol_darah` varchar(20) DEFAULT NULL,
  `penggunaan_kontrasepsi_kehamilan` int(50) DEFAULT NULL,
  `riwayat_penyakit` text DEFAULT NULL,
  `riwayat_alergi` text DEFAULT NULL,
  `id_delima_bumil` int(11) DEFAULT NULL,
  `id_delima_bidan` int(11) DEFAULT NULL,
  `hamil_ke` varchar(50) DEFAULT NULL,
  `jumlah_persalinan` varchar(50) DEFAULT NULL,
  `jumlah_keguguran` varchar(50) DEFAULT NULL,
  `jumlah_anak_hidup` varchar(50) DEFAULT NULL,
  `jumlah_lahir_mati` varchar(50) DEFAULT NULL,
  `jumlah_anak_lahir_kurang_bulan` varchar(50) DEFAULT NULL,
  `jarak_kehamilan` varchar(50) DEFAULT NULL,
  `status_imunisasi` varchar(50) DEFAULT NULL,
  `penolong_persalinan_terakhir` varchar(50) DEFAULT NULL,
  `cara_persalinan_terakhir` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data untuk tabel `data_periksa_pertama`
--

INSERT INTO `data_periksa_pertama` (`id_data_periksa_pertama`, `tgl_hpht`, `tgl_hpt`, `lingkar_lengan_atas`, `tinggi_badan`, `gol_darah`, `penggunaan_kontrasepsi_kehamilan`, `riwayat_penyakit`, `riwayat_alergi`, `id_delima_bumil`, `id_delima_bidan`, `hamil_ke`, `jumlah_persalinan`, `jumlah_keguguran`, `jumlah_anak_hidup`, `jumlah_lahir_mati`, `jumlah_anak_lahir_kurang_bulan`, `jarak_kehamilan`, `status_imunisasi`, `penolong_persalinan_terakhir`, `cara_persalinan_terakhir`, `created_at`, `updated_at`) VALUES
(1, '2021-11-04', '2021-11-04', NULL, 'undefined', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-03 20:38:10', '2021-11-03 20:38:10'),
(2, '2021-11-04', '2021-11-04', '56', '567', 'O', 667, '45', '77', NULL, NULL, '45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-03 20:39:17', '2021-11-03 20:39:17'),
(3, '2021-11-04', '2021-11-04', '667', '789', '567', 567, '345', '789', NULL, NULL, '45', '467', '876', '456', '8877', '467', '899', '544', '577', '987', '2021-11-03 20:40:21', '2021-11-03 20:40:21'),
(4, '2021-11-04', '2021-11-04', NULL, 'undefined', '585', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '75', '2021-11-03 20:41:42', '2021-11-03 20:41:42'),
(5, '2021-11-04', '2021-11-04', NULL, 'undefined', 'O', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-03 21:29:23', '2021-11-03 21:29:23'),
(6, '2021-11-07', '2021-11-07', 'Vivi', '56', 'B', 56, 'Hh', 'Gh', 413, NULL, '4', '7', '3', '8', '6', '4', '8', '3', '8', '9', '2021-11-06 18:00:57', '2021-11-06 18:00:57'),
(7, '2021-11-07', '2021-11-07', NULL, 'undefined', NULL, NULL, NULL, NULL, 41, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-06 18:59:01', '2021-11-06 18:59:01');

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

--
-- Struktur dari tabel `data_rows`
--

CREATE TABLE `data_rows` (
  `id` int(10) UNSIGNED NOT NULL,
  `data_type_id` int(10) UNSIGNED NOT NULL,
  `field` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT 0,
  `browse` tinyint(1) NOT NULL DEFAULT 1,
  `read` tinyint(1) NOT NULL DEFAULT 1,
  `edit` tinyint(1) NOT NULL DEFAULT 1,
  `add` tinyint(1) NOT NULL DEFAULT 1,
  `delete` tinyint(1) NOT NULL DEFAULT 1,
  `details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

--
-- Struktur dari tabel `data_types`
--

CREATE TABLE `data_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_singular` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_plural` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `policy_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `controller` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generate_permissions` tinyint(1) NOT NULL DEFAULT 0,
  `server_side` tinyint(4) NOT NULL DEFAULT 0,
  `details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `data_types`
--

INSERT INTO `data_types` (`id`, `name`, `slug`, `display_name_singular`, `display_name_plural`, `icon`, `model_name`, `policy_name`, `controller`, `description`, `generate_permissions`, `server_side`, `details`, `created_at`, `updated_at`) VALUES
(1, 'users', 'users', 'User', 'Users', 'voyager-person', 'TCG\\Voyager\\Models\\User', 'TCG\\Voyager\\Policies\\UserPolicy', 'TCG\\Voyager\\Http\\Controllers\\VoyagerUserController', '', 1, 0, NULL, '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(2, 'menus', 'menus', 'Menu', 'Menus', 'voyager-list', 'TCG\\Voyager\\Models\\Menu', NULL, '', '', 1, 0, NULL, '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(3, 'roles', 'roles', 'Role', 'Roles', 'voyager-lock', 'TCG\\Voyager\\Models\\Role', NULL, '', '', 1, 0, NULL, '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(5, 'delimaartikeltb', 'delimaartikeltb', 'Artikel', 'Artikels', 'voyager-file-text', 'App\\Models\\DelimaArtikelModel', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null}', '2021-03-15 04:12:46', '2021-03-15 04:12:46');

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

--
-- Struktur dari tabel `delimaartikeltb`
--

CREATE TABLE `delimaartikeltb` (
  `delima_artikel_id` int(11) NOT NULL,
  `judul_artikel` varchar(150) NOT NULL,
  `isi_artikel` text NOT NULL,
  `banner_artikel` varchar(150) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `tanggal_publish` varchar(50) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `delimaartikeltb`
--

INSERT INTO `delimaartikeltb` (`delima_artikel_id`, `judul_artikel`, `isi_artikel`, `banner_artikel`, `user_id`, `status`, `tanggal_publish`, `created_at`, `updated_at`) VALUES
(1, 'test artikel 1', '\r\nH3\r\n660 WORDS\r\nPOWERED BY TINY\r\nSource Code\r\n\r\n \r\n1\r\n<h2><span class=\"span\"><img style=\"margin: 30px;\" src=\"//www.tiny.cloud/images/glyph-tinymce@2x.png\" alt=\"TinyMCE Logo\" width=\"110\" height=\"97\" align=\"right\" /></span>Experience TinyMCE Premium Plugins</h2>\r\n2\r\n<p>This demo contains our most popular Premium Plugins, including Word copy/paste, rich-media embeds, our IDE-like source code viewer, and several of our advanced error checking services. They\'re available any time you\'re ready to add Premium Plugins to your Developer Plan, or upgrade to the Pro Plan.</p>\r\n3\r\n<h3>PowerPaste</h3>\r\n4\r\n<p>The TinyMCE <a href=\"https://www.tinymce.com/docs/enterprise/paste-from-word/\">PowerPaste plugin</a> automatically cleans up and transfers content &amp; images from Microsoft Word and HTML sources to ensure clean, compliant content that matches the look and feel of the site.</p>\r\n5\r\n<h5>COPY AND PASTE FROM WORD or EXCEL</h5>\r\n6\r\n<ol>\r\n7\r\n<li>Copy and paste content from MS Word or Excel into this editor.</li>\r\n8\r\n<li>Choose Remove Formatting (remove inline styles) or Keep Formatting (keep inline styles)</li>\r\n9\r\n</ol>\r\n10\r\n<h5>COPY AND PASTE FROM WEBSITE OR HTML SOURCES</h5>\r\n11\r\n<ol>\r\n12\r\n<li>Copy and paste content from website content into this editor.</li>\r\n13\r\n<li>Choose Remove Formatting (remove inline styles) or Keep Formatting (keep inline styles)</li>\r\n14\r\n</ol>\r\n15\r\n<h5>DRAG AND DROP IMAGE</h5>\r\n16\r\n<ol>\r\n17\r\n<li>Drag a local image into this editor.</li>\r\n18\r\n</ol>\r\n19\r\n<p>&nbsp;</p>\r\n20\r\n<h3>SPELL CHECK PRO</h3>\r\n21\r\n<p>Spell Checker Pro adds spell check as-you-type capabilities to TinyMCE. This includes inline spell checking and a dialog mode that steps a user through each error offering a list of suggested corrections.</p>\r\n22\r\n<h5>SPELL CHECKER PRO - DIALOG MODE</h5>\r\n23\r\n<ol>\r\n24\r\n<li>Start typing some texts with misspells.</li>\r\n25\r\n<li>Click the upper right (ABC)button to get pop up dialog to check spelling</li>\r\n26\r\n</ol>\r\n27\r\n<h5>SPELL CHECKER PRO - CHECK AS YOU TYPE</h5>\r\n28\r\n<ol>\r\nCancel\r\nSave', 'https://reactjs.org/logo-og.png', 1, 1, '07 Februari 2021', '2021-02-19 16:05:24', '2021-02-19 16:05:24');

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

--
-- Struktur dari tabel `delimabidantb`
--

CREATE TABLE `delimabidantb` (
  `delima_bidan_id` int(10) UNSIGNED NOT NULL,
  `delima_user_id` int(11) NOT NULL,
  `delima_bidan_nama` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `delima_bidan_email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `delima_bidan_no_str` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `delima_bidan_no_telp` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `delima_bidan_lokasi` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foto` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `delimabidantb`
--

INSERT INTO `delimabidantb` (`delima_bidan_id`, `delima_user_id`, `delima_bidan_nama`, `delima_bidan_email`, `delima_bidan_no_str`, `delima_bidan_no_telp`, `delima_bidan_lokasi`, `foto`, `created_at`, `updated_at`) VALUES
(1, 28, 'fermyth', 'fermyth', 'KR9798', '9878767', 'JAKARTA', NULL, '2021-03-01 05:25:40', '2021-03-01 05:25:40'),
(3, 7, 'bidan 2', 'bidan2@gmail.com', 'STR12345', 'phoone0994883', 'BOGOR', NULL, '2021-02-05 02:21:10', '2021-02-05 02:21:10'),
(4, 24, 'test', 'test', 'STR12345', 'phoone0994883', 'BOGOR', NULL, '2021-03-01 05:10:09', '2021-03-01 05:10:09'),
(5, 26, 'fermyth', 'fermyth', 'KR07975', '086876', 'JAKARTA', NULL, '2021-03-01 05:20:02', '2021-03-01 05:20:02'),
(6, 27, 'fermyth', 'fermyth', 'KR07975', '086876', 'JAKARTA', NULL, '2021-03-01 05:20:39', '2021-03-01 05:20:39'),
(7, 1, 'bidan 1', 'bidan1@gmail.com', '1234', '028087412', 'BOGOR', NULL, '2021-02-05 04:40:00', '2021-02-05 04:40:00'),
(16, 88, 'Halimah', 'hermansyahali94@gmail.com', '123', '0867563774', 'BOGOR', 'Bidan_1635003431.jpg', '2021-10-23 08:37:11', '2021-10-23 08:37:11');

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

--
-- Struktur dari tabel `delimabumiltb`
--

CREATE TABLE `delimabumiltb` (
  `delima_bumil_id` int(10) UNSIGNED NOT NULL,
  `delima_user_id` int(11) NOT NULL,
  `delima_bumil_unique_id` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delima_bumil_nama_ibu` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `delima_bumil_pekerjaan_ibu` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `delima_bumil_nama_ayah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `delima_bumil_pekerjaan_ayah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `delima_bumil_lokasi` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `umur` int(11) DEFAULT NULL,
  `pendidikan` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gol_darah` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat_rumah` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foto` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `delimabumiltb`
--

INSERT INTO `delimabumiltb` (`delima_bumil_id`, `delima_user_id`, `delima_bumil_unique_id`, `delima_bumil_nama_ibu`, `delima_bumil_pekerjaan_ibu`, `delima_bumil_nama_ayah`, `delima_bumil_pekerjaan_ayah`, `delima_bumil_lokasi`, `umur`, `pendidikan`, `gol_darah`, `alamat_rumah`, `foto`, `created_at`, `updated_at`) VALUES
(1, 20, '1011', 'nai', 'pei', 'naa', 'pea', NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-19 08:30:21', '2021-02-19 08:30:21'),
(2, 10, '1012', 'namanya ibu', 'job ibu', 'nama ayahya', 'ini pekrjaan ayah', NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-07 12:14:14', '2021-02-07 12:14:14'),
(3, 11, '1013', 'namanya ibu', 'job ibu', 'nama ayahya', 'ini pekrjaan ayah', NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-18 07:50:14', '2021-02-18 07:50:14'),
(4, 12, '1014', 'satu', 'dua', 'tiga', 'empat', NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-18 07:51:04', '2021-02-18 07:51:04'),
(7, 15, '1017', 'na i', 'pe i', 'na a', 'pe. a', NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-19 08:12:32', '2021-02-19 08:12:32'),
(8, 16, '1018', 'na i', 'pe i', 'na a', 'pe a', NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-19 08:17:08', '2021-02-19 08:17:08'),
(9, 17, '1019', 'nai', 'pei', 'naa', 'pea', NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-19 08:23:22', '2021-02-19 08:23:22'),
(10, 18, '10110', 'nai', 'pei', 'naa', 'pea', NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-19 08:25:25', '2021-02-19 08:25:25'),
(11, 19, '10111', 'nai', 'pei', 'naa', 'pea', NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-19 08:28:39', '2021-02-19 08:28:39'),
(41, 89, NULL, 'Rudiah', 'Orang biasa', 'Sukardi', 'Pekerjaan', 'Bogor', NULL, NULL, NULL, NULL, 'Bumil_1635046231.jpg', '2021-10-23 20:30:31', '2021-10-23 20:30:31');

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

--
-- Struktur dari tabel `delimarekammedistb`
--

CREATE TABLE `delimarekammedistb` (
  `delima_rekam_medis_id` int(11) NOT NULL,
  `delima_bidan_id` int(11) NOT NULL,
  `delima_bumil_id` int(11) NOT NULL,
  `data_rekam_medis` text NOT NULL,
  `tanggal_datang` varchar(50) NOT NULL,
  `tanggal_next` varchar(50) NOT NULL,
  `visit_no` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `delimarekammedistb`
--

INSERT INTO `delimarekammedistb` (`delima_rekam_medis_id`, `delima_bidan_id`, `delima_bumil_id`, `data_rekam_medis`, `tanggal_datang`, `tanggal_next`, `visit_no`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '{\"contoh\":\"contoh2\", \"data2\" : \"30\"}', '1614932059', '1614932080', 1, '2021-02-08 19:20:26', '2021-02-08 19:20:26'),
(3, 1, 1, '{\"contoh\":\"contoh ke sekian\"}', '1612839438', '1612839438', 2, '2021-02-08 19:57:18', '2021-02-08 19:57:18'),
(4, 1, 1, '{\"contoh\":\"contoh ke sekian2\"}', '1612839441', '1612839441', 3, '2021-02-08 19:57:21', '2021-02-08 19:57:21'),
(5, 1, 1, '\"{\\\"Tekanan Darah\\\":\\\"tekanan\\\",\\\"Berat Badan\\\":\\\"berat2\\\",\\\"Denyut Jantung\\\":\\\"denyut\\\",\\\"Tinggi Fundus\\\":\\\"tinggi\\\",\\\"Keluhan saat ini\\\":\\\"keluhan\\\",\\\"Tanggal Periksa Selanjutnya\\\":\\\"2021-03-21\\\"}\"', '1615726344', '1616284800', 4, '2021-03-14 12:52:24', '2021-03-14 12:52:24'),
(6, 1, 1, '{\"Tekanan Darah\":\"tekanan\",\"Berat Badan\":\"berat2\",\"Denyut Jantung\":\"denyut\",\"Tinggi Fundus\":\"tinggi\",\"Keluhan saat ini\":\"keluhan\",\"Tanggal Periksa Selanjutnya\":\"2021-03-21\"}', '1615726735', '1616284800', 5, '2021-03-14 12:58:55', '2021-03-14 12:58:55'),
(7, 1, 1, '{\"Tekanan Darah\":\"tekanan\",\"Berat Badan\":\"berat2\",\"Denyut Jantung\":\"denyut\",\"Tinggi Fundus\":\"tinggi\",\"Keluhan saat ini\":\"keluhan\",\"Tanggal Periksa Selanjutnya\":\"2021-03-21\"}', '1615729974', '1616284800', 6, '2021-03-14 13:52:54', '2021-03-14 13:52:54'),
(8, 1, 1, '{\"Tekanan Darah\":\"32\",\"Berat Badan\":\"43434\",\"Denyut Jantung\":\"5454\",\"Tinggi Fundus\":\"4243\",\"Keluhan saat ini\":\"43\",\"Tanggal Periksa Selanjutnya\":\"2021-03-24\"}', '1615730598', '1616544000', 7, '2021-03-14 14:03:18', '2021-03-14 14:03:18'),
(9, 1, 1, '{\"Tekanan Darah\":\"tekanan\",\"Berat Badan\":\"berat34\",\"Denyut Jantung\":\"denyut44\",\"Tinggi Fundus\":\"tinggi\",\"Keluhan saat ini\":\"ekluhan\",\"Tanggal Periksa Selanjutnya\":\"2021-03-24\"}', '1615730704', '1616544000', 8, '2021-03-14 14:05:04', '2021-03-14 14:05:04'),
(14, 16, 41, '{\"Tekanan Darah\":\"30\",\"Berat Badan\":\"60\",\"Denyut Jantung\":\"20\",\"Tinggi Fundus\":\"50\",\"Keluhan saat ini\":\"60\",\"Tanggal Periksa Selanjutnya\":\"2021-11-06\"}', '1636184053', '1636156800', 1, '2021-11-06 00:34:13', '2021-11-06 00:34:13'),
(15, 16, 41, '{\"Tanggal Periksa Selanjutnya\":\"2021-11-07\"}', '1636243231', '1636243200', 2, '2021-11-06 17:00:31', '2021-11-06 17:00:31');

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

--
-- Struktur dari tabel `kontrol`
--

CREATE TABLE `kontrol` (
  `id_kontrol` int(11) NOT NULL,
  `id_delima_bumil` int(11) DEFAULT NULL,
  `id_delima_bidan` int(11) DEFAULT NULL,
  `tgl` varchar(50) DEFAULT NULL,
  `keluhan_sekarang` varchar(100) DEFAULT NULL,
  `berat_badan` varchar(50) DEFAULT NULL,
  `umur_kehamilan` varchar(50) DEFAULT NULL,
  `tinggi_fundus` varchar(50) DEFAULT NULL,
  `letak_janin` varchar(100) DEFAULT NULL,
  `denyut_jantung` varchar(50) DEFAULT NULL,
  `kaki_bengkak` varchar(100) DEFAULT NULL,
  `hasil_periksa_lap` varchar(100) DEFAULT NULL,
  `tindakan` varchar(100) DEFAULT NULL,
  `nasihat` varchar(100) DEFAULT NULL,
  `keterangan` varchar(150) DEFAULT NULL,
  `tgl_kembali` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data untuk tabel `kontrol`
--

INSERT INTO `kontrol` (`id_kontrol`, `id_delima_bumil`, `id_delima_bidan`, `tgl`, `keluhan_sekarang`, `berat_badan`, `umur_kehamilan`, `tinggi_fundus`, `letak_janin`, `denyut_jantung`, `kaki_bengkak`, `hasil_periksa_lap`, `tindakan`, `nasihat`, `keterangan`, `tgl_kembali`, `created_at`, `updated_at`) VALUES
(1, NULL, NULL, '2021-11-04', NULL, 'I57', 'U47', '7575', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-04', '2021-11-03 21:47:34', '2021-11-03 21:47:34'),
(2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-05 00:36:38', '2021-11-05 00:36:38');

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

--
-- Struktur dari tabel `menus`
--

CREATE TABLE `menus` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `menus`
--

INSERT INTO `menus` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'admin', '2020-10-18 22:13:10', '2020-10-18 22:13:10');

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

--
-- Struktur dari tabel `menu_items`
--

CREATE TABLE `menu_items` (
  `id` int(10) UNSIGNED NOT NULL,
  `menu_id` int(10) UNSIGNED DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  `icon_class` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `order` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `route` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parameters` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `menu_items`
--

INSERT INTO `menu_items` (`id`, `menu_id`, `title`, `url`, `target`, `icon_class`, `color`, `parent_id`, `order`, `created_at`, `updated_at`, `route`, `parameters`) VALUES
(1, 1, 'Dashboard', '', '_self', 'voyager-boat', NULL, NULL, 1, '2020-10-18 22:13:10', '2020-10-18 22:13:10', 'voyager.dashboard', NULL),
(2, 1, 'Media', '', '_self', 'voyager-images', NULL, NULL, 5, '2020-10-18 22:13:10', '2020-10-18 22:13:10', 'voyager.media.index', NULL),
(3, 1, 'Users', '', '_self', 'voyager-person', NULL, NULL, 3, '2020-10-18 22:13:10', '2020-10-18 22:13:10', 'voyager.users.index', NULL),
(4, 1, 'Roles', '', '_self', 'voyager-lock', NULL, NULL, 2, '2020-10-18 22:13:10', '2020-10-18 22:13:10', 'voyager.roles.index', NULL),
(5, 1, 'Tools', '', '_self', 'voyager-tools', NULL, NULL, 9, '2020-10-18 22:13:10', '2020-10-18 22:13:10', NULL, NULL),
(6, 1, 'Menu Builder', '', '_self', 'voyager-list', NULL, 5, 10, '2020-10-18 22:13:10', '2020-10-18 22:13:10', 'voyager.menus.index', NULL),
(7, 1, 'Database', '', '_self', 'voyager-data', NULL, 5, 11, '2020-10-18 22:13:10', '2020-10-18 22:13:10', 'voyager.database.index', NULL),
(8, 1, 'Compass', '', '_self', 'voyager-compass', NULL, 5, 12, '2020-10-18 22:13:10', '2020-10-18 22:13:10', 'voyager.compass.index', NULL),
(9, 1, 'BREAD', '', '_self', 'voyager-bread', NULL, 5, 13, '2020-10-18 22:13:10', '2020-10-18 22:13:10', 'voyager.bread.index', NULL),
(10, 1, 'Settings', '', '_self', 'voyager-settings', NULL, NULL, 14, '2020-10-18 22:13:10', '2020-10-18 22:13:10', 'voyager.settings.index', NULL),
(11, 1, 'Hooks', '', '_self', 'voyager-hook', NULL, 5, 13, '2020-10-18 22:13:11', '2020-10-18 22:13:11', 'voyager.hooks', NULL),
(12, 1, 'Artikels', '', '_self', 'voyager-file-text', NULL, NULL, 15, '2021-03-15 04:12:46', '2021-03-15 04:12:46', 'voyager.delimaartikeltb.index', NULL);

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

--
-- Struktur dari tabel `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_01_01_000000_add_voyager_user_fields', 1),
(4, '2016_01_01_000000_create_data_types_table', 1),
(5, '2016_05_19_173453_create_menu_table', 1),
(6, '2016_10_21_190000_create_roles_table', 1),
(7, '2016_10_21_190000_create_settings_table', 1),
(8, '2016_11_30_135954_create_permission_table', 1),
(9, '2016_11_30_141208_create_permission_role_table', 1),
(10, '2016_12_26_201236_data_types__add__server_side', 1),
(11, '2017_01_13_000000_add_route_to_menu_items_table', 1),
(12, '2017_01_14_005015_create_translations_table', 1),
(13, '2017_01_15_000000_make_table_name_nullable_in_permissions_table', 1),
(14, '2017_03_06_000000_add_controller_to_data_types_table', 1),
(15, '2017_04_21_000000_add_order_to_data_rows_table', 1),
(16, '2017_07_05_210000_add_policyname_to_data_types_table', 1),
(17, '2017_08_05_000000_add_group_to_settings_table', 1),
(18, '2017_11_26_013050_add_user_role_relationship', 1),
(19, '2017_11_26_015000_create_user_roles_table', 1),
(20, '2018_03_11_000000_add_user_settings', 1),
(21, '2018_03_14_000000_add_details_to_data_types_table', 1),
(22, '2018_03_16_000000_make_settings_value_nullable', 1),
(23, '2020_10_19_073251_add_delima_user_tb', 2),
(24, '2020_10_19_085347_add_delima_bidan_tb', 3),
(25, '2020_10_19_094436_add_delima_bumil_tb', 4),
(26, '2020_10_19_094934_add_delima_initial_rekam_tb', 4),
(27, '2020_10_19_095926_add_delima_rekam_medis_tb', 4);

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

--
-- Struktur dari tabel `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `perisalinan`
--

CREATE TABLE `perisalinan` (
  `id_persalinan` int(11) NOT NULL,
  `id_delima_bidan` int(11) DEFAULT NULL,
  `id_delima_bumil` int(11) DEFAULT NULL,
  `dokter_satu` varchar(200) DEFAULT NULL,
  `dokter_dua` varchar(200) DEFAULT NULL,
  `persalinan` varchar(200) DEFAULT NULL,
  `nama_ambulan_satu` varchar(200) DEFAULT NULL,
  `nama_ambulan_dua` varchar(200) DEFAULT NULL,
  `nama_ambulan_tiga` varchar(200) DEFAULT NULL,
  `hp_ambulan_satu` varchar(50) DEFAULT NULL,
  `hp_ambulan_dua` varchar(50) DEFAULT NULL,
  `hp_ambulan_tiga` varchar(50) DEFAULT NULL,
  `metode_kb` varchar(150) DEFAULT NULL,
  `gol_darah` varchar(50) DEFAULT NULL,
  `sumbangan_satu` varchar(150) DEFAULT NULL,
  `sumbangan_dua` varchar(150) DEFAULT NULL,
  `sumbangan_hp_satu` varchar(200) DEFAULT NULL,
  `sumbangan_hp_dua` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data untuk tabel `perisalinan`
--

INSERT INTO `perisalinan` (`id_persalinan`, `id_delima_bidan`, `id_delima_bumil`, `dokter_satu`, `dokter_dua`, `persalinan`, `nama_ambulan_satu`, `nama_ambulan_dua`, `nama_ambulan_tiga`, `hp_ambulan_satu`, `hp_ambulan_dua`, `hp_ambulan_tiga`, `metode_kb`, `gol_darah`, `sumbangan_satu`, `sumbangan_dua`, `sumbangan_hp_satu`, `sumbangan_hp_dua`, `created_at`, `updated_at`) VALUES
(1, NULL, NULL, '45tg', NULL, 'Gdhdh', 'Ggshs', 'Yeye', 'Gsys', '8449', '748494', '7484', 'Hshdh', 'O', 'Ali', 'Sd', '7484994', '74849', '2021-11-05 01:02:32', '2021-11-05 01:02:32'),
(2, NULL, NULL, 'Gjk', NULL, 'Thhh', 'Fgh', 'Ffgg', 'Ggh', '678', '778', '790', 'Fggh', '456', 'Ggh', 'Tgg', '889', '667', '2021-11-05 01:06:19', '2021-11-05 01:06:19'),
(3, NULL, NULL, 'Hhdjd', NULL, 'Hdh', 'Hdhd', 'Shhe', 'Ydhd', '7474', '7474', '747', 'Udud', 'I', 'Hshd', 'Hdhd', '748', '747', '2021-11-06 18:05:30', '2021-11-06 18:05:30'),
(4, NULL, 41, 'Hcuc', NULL, 'Hhfhf', 'Hdydy', 'Ufuf', 'Yfioho', '6778', '5677', '4667', 'O', 'O', 'Fufuf', '7575', '8868', 'I96969', '2021-11-06 18:08:55', '2021-11-06 18:08:55');

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

--
-- Struktur dari tabel `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `table_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `permissions`
--

INSERT INTO `permissions` (`id`, `key`, `table_name`, `created_at`, `updated_at`) VALUES
(1, 'browse_admin', NULL, '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(2, 'browse_bread', NULL, '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(3, 'browse_database', NULL, '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(4, 'browse_media', NULL, '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(5, 'browse_compass', NULL, '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(6, 'browse_menus', 'menus', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(7, 'read_menus', 'menus', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(8, 'edit_menus', 'menus', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(9, 'add_menus', 'menus', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(10, 'delete_menus', 'menus', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(11, 'browse_roles', 'roles', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(12, 'read_roles', 'roles', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(13, 'edit_roles', 'roles', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(14, 'add_roles', 'roles', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(15, 'delete_roles', 'roles', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(16, 'browse_users', 'users', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(17, 'read_users', 'users', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(18, 'edit_users', 'users', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(19, 'add_users', 'users', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(20, 'delete_users', 'users', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(21, 'browse_settings', 'settings', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(22, 'read_settings', 'settings', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(23, 'edit_settings', 'settings', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(24, 'add_settings', 'settings', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(25, 'delete_settings', 'settings', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(26, 'browse_hooks', NULL, '2020-10-18 22:13:11', '2020-10-18 22:13:11'),
(27, 'browse_delimaartikeltb', 'delimaartikeltb', '2021-03-15 04:12:46', '2021-03-15 04:12:46'),
(28, 'read_delimaartikeltb', 'delimaartikeltb', '2021-03-15 04:12:46', '2021-03-15 04:12:46'),
(29, 'edit_delimaartikeltb', 'delimaartikeltb', '2021-03-15 04:12:46', '2021-03-15 04:12:46'),
(30, 'add_delimaartikeltb', 'delimaartikeltb', '2021-03-15 04:12:46', '2021-03-15 04:12:46'),
(31, 'delete_delimaartikeltb', 'delimaartikeltb', '2021-03-15 04:12:46', '2021-03-15 04:12:46');

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

--
-- Struktur dari tabel `permission_role`
--

CREATE TABLE `permission_role` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1);

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

--
-- Struktur dari tabel `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `roles`
--

INSERT INTO `roles` (`id`, `name`, `display_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'Administrator', '2020-10-18 22:13:10', '2020-10-18 22:13:10'),
(2, 'user', 'Normal User', '2020-10-18 22:13:10', '2020-10-18 22:13:10');

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

--
-- Struktur dari tabel `translations`
--

CREATE TABLE `translations` (
  `id` int(10) UNSIGNED NOT NULL,
  `table_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `column_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `foreign_key` int(10) UNSIGNED NOT NULL,
  `locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `user_roles`
--

CREATE TABLE `user_roles` (
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `data_periksa_pertama`
--
ALTER TABLE `data_periksa_pertama`
  ADD PRIMARY KEY (`id_data_periksa_pertama`);

--
-- Indeks untuk tabel `data_rows`
--
ALTER TABLE `data_rows`
  ADD PRIMARY KEY (`id`),
  ADD KEY `data_rows_data_type_id_foreign` (`data_type_id`);

--
-- Indeks untuk tabel `data_types`
--
ALTER TABLE `data_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `data_types_name_unique` (`name`),
  ADD UNIQUE KEY `data_types_slug_unique` (`slug`);

--
-- Indeks untuk tabel `delimaartikeltb`
--
ALTER TABLE `delimaartikeltb`
  ADD PRIMARY KEY (`delima_artikel_id`);

--
-- Indeks untuk tabel `delimabidantb`
--
ALTER TABLE `delimabidantb`
  ADD PRIMARY KEY (`delima_bidan_id`);

--
-- Indeks untuk tabel `delimabumiltb`
--
ALTER TABLE `delimabumiltb`
  ADD PRIMARY KEY (`delima_bumil_id`);

--
-- Indeks untuk tabel `delimarekammedistb`
--
ALTER TABLE `delimarekammedistb`
  ADD PRIMARY KEY (`delima_rekam_medis_id`);

--
-- Indeks untuk tabel `kontrol`
--
ALTER TABLE `kontrol`
  ADD PRIMARY KEY (`id_kontrol`);

--
-- Indeks untuk tabel `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `menus_name_unique` (`name`);

--
-- Indeks untuk tabel `menu_items`
--
ALTER TABLE `menu_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menu_items_menu_id_foreign` (`menu_id`);

--
-- Indeks untuk tabel `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indeks untuk tabel `perisalinan`
--
ALTER TABLE `perisalinan`
  ADD PRIMARY KEY (`id_persalinan`);

--
-- Indeks untuk tabel `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permissions_key_index` (`key`);

--
-- Indeks untuk tabel `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `permission_role_permission_id_index` (`permission_id`),
  ADD KEY `permission_role_role_id_index` (`role_id`);

--
-- Indeks untuk tabel `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_unique` (`name`);

--
-- Indeks untuk tabel `translations`
--
ALTER TABLE `translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `translations_table_name_column_name_foreign_key_locale_unique` (`table_name`,`column_name`,`foreign_key`,`locale`);

--
-- Indeks untuk tabel `user_roles`
--
ALTER TABLE `user_roles`
  ADD PRIMARY KEY (`user_id`,`role_id`),
  ADD KEY `user_roles_user_id_index` (`user_id`),
  ADD KEY `user_roles_role_id_index` (`role_id`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `data_periksa_pertama`
--
ALTER TABLE `data_periksa_pertama`
  MODIFY `id_data_periksa_pertama` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT untuk tabel `data_rows`
--
ALTER TABLE `data_rows`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT untuk tabel `data_types`
--
ALTER TABLE `data_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT untuk tabel `delimaartikeltb`
--
ALTER TABLE `delimaartikeltb`
  MODIFY `delima_artikel_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `delimabidantb`
--
ALTER TABLE `delimabidantb`
  MODIFY `delima_bidan_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT untuk tabel `delimabumiltb`
--
ALTER TABLE `delimabumiltb`
  MODIFY `delima_bumil_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT untuk tabel `delimarekammedistb`
--
ALTER TABLE `delimarekammedistb`
  MODIFY `delima_rekam_medis_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT untuk tabel `kontrol`
--
ALTER TABLE `kontrol`
  MODIFY `id_kontrol` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `menus`
--
ALTER TABLE `menus`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `menu_items`
--
ALTER TABLE `menu_items`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT untuk tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT untuk tabel `perisalinan`
--
ALTER TABLE `perisalinan`
  MODIFY `id_persalinan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT untuk tabel `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `translations`
--
ALTER TABLE `translations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
--

--
-- Ketidakleluasaan untuk tabel `data_rows`
--
ALTER TABLE `data_rows`
  ADD CONSTRAINT `data_rows_data_type_id_foreign` FOREIGN KEY (`data_type_id`) REFERENCES `data_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ketidakleluasaan untuk tabel `menu_items`
--
ALTER TABLE `menu_items`
  ADD CONSTRAINT `menu_items_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `user_roles`
--
ALTER TABLE `user_roles`
  ADD CONSTRAINT `user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_roles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

