-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 25 Sep 2020 pada 13.14
-- Versi server: 10.4.6-MariaDB
-- Versi PHP: 7.1.32

START TRANSACTION;



--
-- Database: `db_antrianqu`
--

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

--
-- Struktur dari tabel `global_parameter`
--

CREATE TABLE `global_parameter` (
  `auto_id` int(11) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `flag` varchar(255) DEFAULT NULL,
  `reff_id` varchar(25) DEFAULT NULL,
  `desc_text` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `global_parameter`
--

INSERT INTO `global_parameter` (`auto_id`, `label`, `value`, `flag`, `reff_id`, `desc_text`) VALUES
(1, 'Ayah', '1', 'hubungan_keluarga', NULL, NULL),
(2, 'Ibu', '2', 'hubungan_keluarga', NULL, NULL),
(3, 'Anak', '3', 'hubungan_keluarga', NULL, NULL),
(4, 'Adik', '4', 'hubungan_keluarga', NULL, NULL),
(5, 'Kakak', '5', 'hubungan_keluarga', NULL, NULL),
(6, 'Teman', '6', 'hubungan_keluarga', NULL, NULL),
(7, 'Kerabat Lainnya', '7', 'hubungan_keluarga', NULL, NULL),
(8, 'Rumah Sakit', 'Rumah Sakit', 'rujukan_dari', NULL, NULL),
(9, 'Bidan', 'Bidan', 'rujukan_dari', NULL, NULL),
(10, 'Puskesmas', 'Puskesmas', 'rujukan_dari', NULL, NULL),
(11, 'Faskes Lainnya', 'Faskes Lainnya', 'rujukan_dari', NULL, NULL),
(12, 'Non Rujukan', 'Non Rujukan', 'rujukan_dari', NULL, NULL),
(13, 'Kemauan sendiri/Keluarga', 'Kemauan sendiri/Keluarga', 'rujukan_igd', NULL, NULL),
(14, 'Instansi Kesehatan', 'Instansi Kesehatan', 'rujukan_igd', NULL, NULL),
(20, 'Tn.', 'Tn.', 'gelar_nama', NULL, NULL),
(21, 'Ny.', 'Ny.', 'gelar_nama', NULL, NULL),
(22, 'Nn.', 'Nn.', 'gelar_nama', NULL, NULL),
(23, 'An.', 'An.', 'gelar_nama', NULL, NULL),
(24, 'Jasa Raharja', '1', 'penjamin_ws_bpjs', NULL, NULL),
(25, 'BPJS Ketenagakerjaan', '2', 'penjamin_ws_bpjs', NULL, NULL),
(26, 'TASPEN PT', '3', 'penjamin_ws_bpjs', NULL, NULL),
(27, 'ASABRI PT', '4', 'penjamin_ws_bpjs', NULL, NULL),
(15, 'Petugas Kesehatan', 'Petugas Kesehatan', 'rujukan_igd', NULL, NULL),
(16, 'Polisi', 'Polisi', 'rujukan_igd', NULL, NULL),
(17, 'Hukum', 'Hukum', 'rujukan_igd', NULL, NULL),
(18, 'Hidup', 'Hidup', 'status_igd', NULL, NULL),
(19, 'DOA/Death On Arrival', 'Meninggal', 'status_igd', NULL, NULL),
(28, 'Atas Persetujuan Dokter', '1', 'cara_keluar', NULL, NULL),
(29, 'Atas Permintaan Sendiri', '2', 'cara_keluar', NULL, NULL),
(30, 'Rujuk ke Rawat Inap', '3', 'cara_keluar', NULL, NULL),
(31, 'Rujuk ke Poli Lain', '4', 'cara_keluar', NULL, NULL),
(32, 'Meninggal', '5', 'cara_keluar', NULL, NULL),
(33, 'Lain-lain', '6', 'cara_keluar', NULL, NULL),
(34, 'Sembuh', '1', 'pasca_pulang', NULL, NULL),
(35, 'Dirujuk', '2', 'pasca_pulang', NULL, NULL),
(36, 'Pulang Paksa', '3', 'pasca_pulang', NULL, NULL),
(37, 'Dalam Masa Pengobatan', '4', 'pasca_pulang', NULL, NULL),
(38, 'Meninggal', '5', 'pasca_pulang', NULL, NULL),
(39, 'Lain-lain', '6', 'pasca_pulang', NULL, NULL),
(45, 'Hari', 'hari', 'satuan_tindakan', NULL, NULL),
(41, 'Pcs', 'Pcs', 'satuan_tindakan', NULL, NULL),
(42, 'Liter', 'Liter', 'satuan_tindakan', NULL, NULL),
(43, 'Gram', 'gr', 'satuan_tindakan', NULL, NULL),
(44, 'Jam', 'jam', 'satuan_tindakan', NULL, NULL),
(46, 'Merah', '1', 'kategori_tindakan', NULL, NULL),
(47, 'Kuning', '2', 'kategori_tindakan', NULL, NULL),
(48, 'Hijau', '3', 'kategori_tindakan', NULL, NULL),
(49, 'Hitam', '4', 'kategori_tindakan', NULL, NULL),
(50, 'Bedah', 'Bedah', 'jenis_kasus_igd', NULL, NULL),
(51, 'Non Bedah', 'Non Bedah', 'jenis_kasus_igd', NULL, NULL),
(52, 'Kebidanan', 'Kebidanan', 'jenis_kasus_igd', NULL, NULL),
(53, 'Psikiatrik', 'Psikiatrik', 'jenis_kasus_igd', NULL, NULL),
(54, 'Anak', 'Anak', 'jenis_kasus_igd', NULL, NULL),
(55, 'Baik', 'Baik', 'keadaan_umum_igd', NULL, NULL),
(56, 'Sedang', 'Sedang', 'keadaan_umum_igd', NULL, NULL),
(57, 'Berat', 'Berat', 'keadaan_umum_igd', NULL, NULL),
(58, 'Compos Menthis', 'Compos Menthis', 'kesadaran_pasien', NULL, NULL),
(59, 'Apatis', 'Apatis', 'kesadaran_pasien', NULL, NULL),
(60, 'Somnolen', 'Somnolen', 'kesadaran_pasien', NULL, NULL),
(61, 'Sopor', 'Sopor', 'kesadaran_pasien', NULL, NULL),
(62, 'Coma', 'Coma', 'kesadaran_pasien', NULL, NULL),
(63, 'Rumah', 'Rumah', 'tempat_kejadian', NULL, NULL),
(64, 'Kantor/kerja', 'Kantor/kerja', 'tempat_kejadian', NULL, NULL),
(65, 'Tempat Hiburan', 'Tempat Hiburan', 'tempat_kejadian', NULL, NULL),
(66, 'Lain - lain', 'Lain - lain', 'tempat_kejadian', NULL, NULL),
(67, 'Melalui Mulut', 'Melalui Mulut', 'tipe_pemaparan', NULL, NULL),
(68, 'Melalui Inhalasi', 'Melalui Inhalasi', 'tipe_pemaparan', NULL, NULL),
(69, 'Melalui Kulit', 'Melalui Kulit', 'tipe_pemaparan', NULL, NULL),
(70, 'Melalui Injeksi', 'Melalui Injeksi', 'tipe_pemaparan', NULL, NULL),
(71, 'Melalui Mata', 'Melalui Mata', 'tipe_pemaparan', NULL, NULL),
(72, 'Sengatan', 'Sengatan', 'tipe_pemaparan', NULL, NULL),
(73, 'Gigitan', 'Gigitan', 'tipe_pemaparan', NULL, NULL),
(74, 'Tidak Disengaja', 'Tidak Disengaja', 'tipe_kejadian', NULL, NULL),
(75, 'Disengaja', 'Disengaja', 'tipe_kejadian', NULL, NULL),
(76, 'Tidak Diketahui', 'Tidak Diketahui', 'tipe_kejadian', NULL, NULL),
(77, 'Normal', 'Normal', 'kondisi_pupil', NULL, NULL),
(78, 'Isokor', 'Isokor', 'kondisi_pupil', NULL, NULL),
(79, 'Unisokor', 'Unisokor', 'kondisi_pupil', NULL, NULL),
(80, 'Miosis', 'Miosis', 'kondisi_pupil', NULL, NULL),
(81, 'Midriasis', 'Midriasis', 'kondisi_pupil', NULL, NULL),
(82, 'Pendaftaran', 'register', 'sess_unit', NULL, NULL),
(83, 'Inst Rawat Inap (LA/LB)', 'ri', 'sess_unit', NULL, NULL),
(84, 'Inst Rawat Jalan', 'rj', 'sess_unit', NULL, NULL),
(85, 'Laboratorium', 'lab', 'sess_unit', NULL, NULL),
(86, 'Radiologi', 'rad', 'sess_unit', NULL, NULL),
(87, 'Fisioterapi', 'fis', 'sess_unit', NULL, NULL),
(88, 'Apotik', 'apt', 'sess_unit', NULL, NULL),
(89, 'Gudang Farmasi', 'gdg_far', 'sess_unit', NULL, NULL),
(90, 'Hemodialisa', 'hd', 'sess_unit', NULL, NULL),
(91, 'Instalasi Gawat Darurat (IGD)', 'igd', 'sess_unit', NULL, NULL),
(92, 'Kamar Bedah', 'ok', 'sess_unit', NULL, NULL),
(93, 'ICU', 'icu', 'sess_unit', NULL, NULL),
(94, 'VK', 'vk', 'sess_unit', NULL, NULL),
(95, 'Underweight', 'Underweight', 'status_gizi', NULL, NULL),
(96, 'Normal', 'Normal', 'status_gizi', NULL, NULL),
(97, 'Overweight', 'Overweight', 'status_gizi', NULL, NULL),
(98, 'Obesitas', 'Obesitas', 'status_gizi', NULL, NULL),
(99, 'Ya', 'Ya', 'buta_warna', NULL, NULL),
(100, 'Tidak', 'Tidak', 'buta_warna', NULL, NULL),
(101, 'Sebagian', 'Sebagian', 'buta_warna', NULL, NULL),
(102, 'Total', 'Total', 'buta_warna', NULL, NULL),
(103, 'Normal', 'Normal', 'pemeriksaan_fisik_hidung', NULL, NULL),
(104, 'Sinusitis', 'Sinusitis', 'pemeriksaan_fisik_hidung', NULL, NULL),
(105, 'Rhinitis', 'Rhinitis', 'pemeriksaan_fisik_hidung', NULL, NULL),
(106, 'Polip', 'Polip', 'pemeriksaan_fisik_hidung', NULL, NULL),
(107, 'Normal', 'Normal', 'pemeriksaan_fisik_gigi', NULL, NULL),
(108, 'Kalkulus', 'Kalkulus', 'pemeriksaan_fisik_gigi', NULL, NULL),
(109, 'Caries', 'Caries', 'pemeriksaan_fisik_gigi', NULL, NULL),
(110, 'Pulpitis', 'Pulpitis', 'pemeriksaan_fisik_gigi', NULL, NULL),
(111, 'Impacted', 'Impacted', 'pemeriksaan_fisik_gigi', NULL, NULL),
(112, 'Missing', 'Missing', 'pemeriksaan_fisik_gigi', NULL, NULL),
(113, 'Radix', 'Radix', 'pemeriksaan_fisik_gigi', NULL, NULL),
(114, 'Crowding', 'Crowding', 'pemeriksaan_fisik_gigi', NULL, NULL),
(115, 'Gingifitis', 'Gingifitis', 'pemeriksaan_fisik_gigi', NULL, NULL),
(116, 'Normal', 'Normal', 'pemeriksaan_fisik_lidah', NULL, NULL),
(117, 'Coated', 'Coated', 'pemeriksaan_fisik_lidah', NULL, NULL),
(118, 'Normal', 'Normal', 'pemeriksaan_fisik', NULL, NULL),
(119, 'Tak Normal', 'Tak Normal', 'pemeriksaan_fisik', NULL, NULL),
(120, 'Teraba', 'Teraba', 'pemeriksaan_fisik', NULL, NULL),
(121, 'Tak Teraba', 'Tak Teraba', 'pemeriksaan_fisik', NULL, NULL),
(122, 'Normal', 'Normal', 'pemeriksaan_JVP', NULL, NULL),
(123, 'Meningkat', 'Meningkat', 'pemeriksaan_JVP', NULL, NULL),
(124, 'Dalam Batas Normal', 'Dalam Batas Normal', 'pemeriksaan_jantung_besar', NULL, NULL),
(125, 'Hipertropi', 'Hipertropi', 'pemeriksaan_jantung_besar', NULL, NULL),
(126, 'Reguler', 'Reguler', 'pemeriksaan_jantung_bunyi_S1_S2', NULL, NULL),
(127, 'Irreguler', 'Irreguler', 'pemeriksaan_jantung_bunyi_S1_S2', NULL, NULL),
(128, 'Negatif', 'Negatif', 'pemeriksaan_jantung_bising', NULL, NULL),
(129, 'Murmur', 'Murmur', 'pemeriksaan_jantung_bising', NULL, NULL),
(130, 'Gallop', 'Gallop', 'pemeriksaan_jantung_bising', NULL, NULL),
(131, 'Tak Ada', 'Tak Ada', 'pemeriksaan_abdomen_lainnya', NULL, NULL),
(132, 'Hernia', 'Hernia', 'pemeriksaan_abdomen_lainnya', NULL, NULL),
(133, 'Ambeien', 'Ambeien', 'pemeriksaan_abdomen_lainnya', NULL, NULL),
(137, 'FIT FOR THE JOB', 'Sehat dapat bekerja normal', 'kesan_mcu', NULL, NULL),
(138, 'FIT WITH RESTRICTION', 'Sehat dapat bekerja dengan catatan', 'kesan_mcu', NULL, NULL),
(139, 'TEMPORARY UNFIT', 'Sakit saat pemeriksaan & memerlukan pengobatan', 'kesan_mcu', NULL, NULL),
(140, 'FREQUENT HOSPITALIZED', 'Dalam 1th terakhir > 2 x dirawat', 'kesan_mcu', NULL, NULL),
(141, 'UNFIT', 'Ketidakmampuan untuk bekerja seperti biasa', 'kesan_mcu', NULL, NULL),
(134, 'Sinus', 'Sinus', 'pemeriksaan_irama_ekg', NULL, NULL),
(135, 'Aritmia', 'Aritmia', 'pemeriksaan_irama_ekg', NULL, NULL),
(136, 'Lainnya', 'Lainnya', 'pemeriksaan_irama_ekg', NULL, NULL),
(142, 'Rahmi Chairina, SE', 'Kasubag Gudang Non Medik', 'ttd_ka_gdg_nm', '302', NULL),
(143, 'Sofyan Halim, SE, M.Ak', 'Waka RS Bid Adm & Keu', 'ttd_waka_rs_bid_adm', '308', NULL),
(144, 'Hadiana Bostonita, SE', 'Ketua Tim Perencanaan Brg & Jasa', 'ttd_ka_tim_barjas', '304', NULL),
(145, 'Dr. Untung Sugiharto, MARS', 'Kepala Rumah Sakit', 'ttd_ka_rs', NULL, NULL),
(146, 'Zora Almira, S.Farm., Apt', 'Ka. Instalasi Farmasi', 'ttd_ka_gdg_m', '289', NULL),
(147, 'Dr. Muarifa M.MMR', 'Ka. Bid. Penunjang Medis', 'ttd_ka_bid_pm', '301', NULL),
(148, 'Dr. Indra Joko Mulyono, MARS', 'Waka RS Bid Pelayanan', 'ttd_waka_rs_bid_pl', '299', NULL),
(149, 'Hadiana Bostonita, SE', 'Ketua Tim Perencanaan Brg & Jasa', 'verifikator_m_1', '304', NULL),
(150, 'Dr. Indra Joko Mulyono, MARS', 'Waka RS Bid Pelayanan', 'verifikator_m_2', '299', NULL),
(151, 'Hadiana Bostonita, SE', 'Ketua Tim Perencanaan Brg & Jasa', 'verifikator_nm_1', '274', NULL),
(152, 'Sofyan Halim, SE., M.Ak., CA, CIBA', 'Waka RS Bid Adm dan Keuangan', 'verifikator_nm_2', '308', NULL),
(153, 'Pristiantoro', 'Ka Subbag Pengadaan', 'ttd_kasubag_pengadaan', '274', NULL),
(154, 'Tablet', 'Tab', 'satuan_obat', 'tab', NULL),
(155, 'Kapsul', 'Kap', 'satuan_obat', 'cap', NULL),
(156, 'Bungkus', 'Bks', 'satuan_obat', 'pulv', NULL),
(157, 'ML', 'Ml', 'satuan_obat', 'ml', NULL),
(158, 'Sesudah Makan', 'Sesudah Makan', 'anjuran_pakai_obat', 'p.c', NULL),
(159, 'Sebelum Makan', 'Sebelum Makan', 'anjuran_pakai_obat', 'a.c', NULL),
(160, 'Bersamaan', 'Bersamaan', 'anjuran_pakai_obat', 'd.c', NULL),
(161, 'Dr. Arlis FS. Reksoprodjo, Sp.PD', 'Direktur Operasional PT. SML', 'ttd_dir_opr_sml', NULL, NULL),
(162, 'Resep Kronis', 'res_k', 'jenis_resep', NULL, NULL),
(163, 'Resep Non Kronis', 'res_non_k', 'jenis_resep', NULL, NULL),
(164, 'Nerawati N. Amir Thayeb', 'Direktur Keuangan PT. SML', 'ttd_dir_keu_rssm', NULL, NULL),
(165, 'Botol', 'Btl', 'satuan_obat', 'botol', NULL),
(166, 'IU', 'IU', 'satuan_obat', 'iu', NULL),
(167, 'Sendok Makan', 'SM', 'satuan_obat', 'c.', NULL),
(168, 'Sendok Teh', 'ST', 'satuan_obat', 'c.th', NULL),
(169, 'Tube', 'Tube', 'satuan_obat', 'tube', NULL),
(170, 'Ampul', 'Ampul', 'satuan_obat', 'amp', NULL),
(171, 'Vial', 'Vial', 'satuan_obat', 'vial', NULL),
(172, 'Box', 'Box', 'satuan_obat', 'box', NULL),
(173, 'Lotion', 'Lotion', 'satuan_obat', 'lot', NULL);

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

--
-- Struktur dari tabel `log`
--

CREATE TABLE `log` (
  `id` int(11) NOT NULL,
  `ref_table` varchar(45) DEFAULT NULL,
  `ref_id` varchar(45) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `data` text DEFAULT NULL,
  `query_executed` text DEFAULT NULL,
  `ip_address` varchar(25) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `modul_id` int(11) DEFAULT NULL,
  `menu_id` int(11) DEFAULT NULL,
  `full_modul` text DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by` varchar(255) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;














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

--
-- Struktur dari tabel `log_antrian`
--

CREATE TABLE `log_antrian` (
  `id` int(11) NOT NULL,
  `tanggal` date DEFAULT NULL,
  `jumlah_umum` int(11) DEFAULT NULL,
  `log_umum` longtext DEFAULT NULL,
  `jumlah_bpjs` int(11) DEFAULT NULL,
  `log_bpjs` longtext DEFAULT NULL,
  `created_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktur dari tabel `log_kuota_dokter`
--

CREATE TABLE `log_kuota_dokter` (
  `tanggal` date DEFAULT NULL,
  `kode_dokter` int(11) DEFAULT NULL,
  `kode_spesialis` varchar(15) DEFAULT NULL,
  `status` varchar(1) DEFAULT NULL,
  `id` int(11) NOT NULL,
  `keterangan` longtext DEFAULT NULL,
  `flag` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `log_kuota_dokter`
--

INSERT INTO `log_kuota_dokter` (`tanggal`, `kode_dokter`, `kode_spesialis`, `status`, `id`, `keterangan`, `flag`) VALUES
('2020-07-15', 7, '010401', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 7, '010401', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 7, '010401', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 7, '010401', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 6, '010401', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 6, '010401', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 6, '010401', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 10, '010201', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 10, '010201', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 13, '011301', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 13, '011301', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 13, '011301', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 10, '010201', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 10, '010201', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 13, '011301', NULL, 0, NULL, 'mesin_antrian'),
('2020-07-15', 13, '011301', NULL, 0, NULL, 'mesin_antrian'),
('2020-09-25', 1, '010101', NULL, 0, NULL, 'mesin_antrian'),
('2020-09-25', 1, '010101', NULL, 0, NULL, 'mesin_antrian'),
('2020-09-25', 12, '011101', NULL, 0, NULL, 'mesin_antrian'),
('2020-09-25', 13, '011301', NULL, 0, NULL, 'mesin_antrian'),
('2020-09-25', 15, '012501', NULL, 0, NULL, 'mesin_antrian'),
('2020-09-25', 15, '012501', NULL, 0, NULL, 'mesin_antrian'),
('2020-09-25', 15, '012501', NULL, 0, NULL, 'mesin_antrian');

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

--
-- Struktur dari tabel `mt_bagian`
--

CREATE TABLE `mt_bagian` (
  `id_mt_bagian` int(11) NOT NULL,
  `kode_bagian` varchar(18) NOT NULL,
  `nama_bagian` varchar(255) DEFAULT NULL,
  `pelayanan` int(11) DEFAULT NULL,
  `status_aktif` smallint(6) DEFAULT NULL,
  `kode_poli_bpjs` varchar(25) DEFAULT NULL,
  `validasi` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `mt_bagian`
--

INSERT INTO `mt_bagian` (`id_mt_bagian`, `kode_bagian`, `nama_bagian`, `pelayanan`, `status_aktif`, `kode_poli_bpjs`, `validasi`) VALUES
(2, '010101', 'klinik Spesialis Kebidanan & Kandungan', 1, 1, 'OBG', 100),
(3, '010201', 'klinik Spesialis Penyakit Dalam', 1, 1, 'INT', 100),
(4, '010301', 'klinik Spesialis Bedah Anak', 1, 1, 'BDA', 100),
(5, '010401', 'klinik Spesialis Anak', 1, 1, 'ANA', 100),
(6, '010501', 'klinik Spesialis Jantung & Pembuluh Darah', 1, 1, 'JAN', 100),
(7, '010601', 'klinik Spesialis Bedah Vaskuler', 1, 1, '132', 100),
(8, '010701', 'klinik Spesialis THT', 1, 1, 'THT', 100),
(9, '010801', 'klinik Spesialis Bedah Urologi', 1, 1, 'URO', 100),
(10, '010901', 'Medical Check Up', 1, 1, NULL, 100),
(78, '012701', 'ODC Bedah', 1, 1, NULL, 100),
(83, '011001', 'klinik Spesialis Gigi Umum', 1, 1, 'GIG', 100),
(84, '011101', 'klinik Spesialis Bedah Umum', 1, 1, 'BED', 100),
(85, '011201', 'klinik Spesialis Kulit dan Kelamin', 1, 1, 'KLT', 100),
(86, '011301', 'klinik Spesialis Mata', 1, 1, 'MAT', 100),
(90, '011401', 'klinik Spesialis Paru', 1, 1, 'PAR', 100),
(93, '011501', 'klinik Spesialis Gigi Bedah Mulut', 1, 1, 'BDM', 100),
(94, '011601', 'klinik Spesialis Gigi Orthodonti', 1, 1, 'GOR', 100),
(95, '011701', 'klinik Spesialis Bedah Digestif', 1, 1, '018', 100),
(96, '011801', 'klinik Spesialis Bedah Orthopedi', 1, 1, 'ORT', 100),
(97, '011901', 'klinik Spesialis Bedah Plastik', 1, 1, 'BDP', 100),
(98, '012001', 'klinik Spesialis Bedah Saraf', 1, 1, 'BSY', 100),
(99, '012101', 'klinik Gizi', 1, 1, 'GIZ', 100),
(100, '012201', 'klinik Psikologi', 1, 1, NULL, 100),
(101, '012301', 'klinik Kesehatan Ibu dan Anak', 1, 1, NULL, 100),
(102, '012401', 'klinik Spesialis Akupunktur', 1, 1, NULL, 100),
(103, '012501', 'klinik Spesialis Saraf', 1, 1, 'SAR', 100),
(104, '012601', 'klinik Umum', 1, 0, NULL, 100),
(108, '012801', 'Klinik Ruangan Bedah', 1, 1, NULL, 100),
(109, '012901', 'Klinik Ruangan Kebidanan', 1, 1, NULL, 100),
(110, '013001', 'Klinik Spesialis Jiwa', 1, 1, NULL, 100),
(111, '013101', 'Hemodialis', 1, 1, 'HDL', 100),
(112, '013201', 'ODC VK', 1, 1, NULL, 100),
(131, '013301', 'Klinik Spesialis Konservasi Gigi', 1, 1, NULL, 100),
(132, '013401 ', 'Klinik Rehabilitasi Medik', 1, 1, 'IRM', 100),
(133, '013501', 'Klinik Urologi (Uroflometri)', 1, 1, NULL, 100);

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

--
-- Struktur dari tabel `mt_dokter`
--

CREATE TABLE `mt_dokter` (
  `id_dokter` int(11) NOT NULL,
  `kode_dokter` varchar(10) DEFAULT NULL,
  `nama_dokter` varchar(50) DEFAULT NULL,
  `kode_bagian` varchar(18) DEFAULT NULL,
  `is_active` enum('N','Y') DEFAULT 'Y',
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `mt_dokter`
--

INSERT INTO `mt_dokter` (`id_dokter`, `kode_dokter`, `nama_dokter`, `kode_bagian`, `is_active`, `created_date`, `created_by`, `updated_date`, `updated_by`, `log_id`) VALUES
(1, '01', 'dr Tagor P Sidabutar SpOG', '10101', 'Y', NULL, NULL, NULL, NULL, NULL),
(2, '02', 'dr. H.M. Husni Shihab, SpOG', '10101', 'Y', NULL, NULL, NULL, NULL, NULL),
(3, '03', 'dr. Dian Indah P, SpOG', '10101', 'Y', NULL, NULL, NULL, NULL, NULL),
(4, '04', 'dr. M. Fadli, SpOG', '10101', 'Y', NULL, NULL, NULL, NULL, NULL),
(5, '05', 'dr. Hj. Syamsinar Hasan, SpA', '10401', 'Y', NULL, NULL, NULL, NULL, NULL),
(6, '06', 'dr. Efriyanti, SpA. Mkes', '10401', 'Y', NULL, NULL, NULL, NULL, NULL),
(7, '07', 'dr. Charles, Sp.A', '10401', 'Y', NULL, NULL, NULL, NULL, NULL),
(8, '08', 'dr. Agus Widodo, SpPD', '10201', 'Y', NULL, NULL, NULL, NULL, NULL),
(9, '09', 'dr. Dwi Edi Wahono, SpPD', '10201', 'Y', NULL, NULL, NULL, NULL, NULL),
(10, '010', 'dr.Melsa Aprima Sp.PD', '10201', 'Y', NULL, NULL, NULL, NULL, NULL),
(11, '011', 'dr. D. Hendrashto,SpB', '11101', 'Y', NULL, NULL, NULL, NULL, NULL),
(12, '012', 'dr. Raditya Pratama, SpB', '11101', 'Y', NULL, NULL, NULL, NULL, NULL),
(13, '013', 'dr. Elisabeth Irma Dewi K,.SpM', '11301', 'Y', NULL, NULL, NULL, NULL, NULL),
(14, '014', 'dr. Yessi Haryanti, SpP ', '11401', 'Y', NULL, NULL, NULL, NULL, NULL),
(15, '015', 'dr. Clara Krishanti Koestoer, SpS', '12501', 'Y', NULL, NULL, NULL, NULL, NULL),
(16, '016', 'dr. Budi Santoso,MKed,Sp.THT-KL', '10701', 'Y', NULL, NULL, NULL, NULL, NULL),
(17, '017', 'dr. Sasa Khairunisa, SpKK', '11201', 'Y', NULL, NULL, NULL, NULL, NULL);

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

--
-- Struktur dari tabel `regon_booking`
--

CREATE TABLE `regon_booking` (
  `regon_booking_kode` varchar(50) NOT NULL,
  `regon_booking_tanggal_perjanjian` date NOT NULL,
  `regon_booking_no_mr` varchar(25) NOT NULL,
  `regon_booking_instalasi` varchar(255) DEFAULT NULL,
  `regon_booking_klinik` varchar(10) DEFAULT NULL,
  `regon_booking_kode_dokter` int(11) NOT NULL,
  `regon_booking_hari` varchar(55) DEFAULT NULL,
  `regon_booking_jam` varchar(20) DEFAULT NULL,
  `regon_booking_keterangan` longtext DEFAULT NULL,
  `regon_booking_jenis_penjamin` varchar(255) DEFAULT NULL,
  `regon_booking_penjamin` varchar(255) DEFAULT NULL,
  `regon_booking_status` int(11) DEFAULT NULL,
  `regon_booking_urutan` int(11) NOT NULL,
  `status_dilayani` smallint(6) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL,
  `log_detail_pasien` longtext DEFAULT NULL,
  `log_transaksi` longtext DEFAULT NULL,
  `is_deleted` char(1) DEFAULT NULL,
  `regon_booking_waktu_datang` datetime DEFAULT NULL,
  `regon_booking_no_mr_ref` varchar(50) DEFAULT NULL,
  `regon_via` varchar(255) DEFAULT NULL,
  `jd_id` int(11) DEFAULT NULL,
  `regon_booking_id` int(11) NOT NULL,
  `regon_booking_tgl_registrasi_ulang` date DEFAULT NULL,
  `regon_booking_nama_pasien` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `regon_booking`
--

INSERT INTO `regon_booking` (`regon_booking_kode`, `regon_booking_tanggal_perjanjian`, `regon_booking_no_mr`, `regon_booking_instalasi`, `regon_booking_klinik`, `regon_booking_kode_dokter`, `regon_booking_hari`, `regon_booking_jam`, `regon_booking_keterangan`, `regon_booking_jenis_penjamin`, `regon_booking_penjamin`, `regon_booking_status`, `regon_booking_urutan`, `status_dilayani`, `created_date`, `created_by`, `updated_date`, `updated_by`, `log_id`, `log_detail_pasien`, `log_transaksi`, `is_deleted`, `regon_booking_waktu_datang`, `regon_booking_no_mr_ref`, `regon_via`, `jd_id`, `regon_booking_id`, `regon_booking_tgl_registrasi_ulang`, `regon_booking_nama_pasien`) VALUES
('L7ZAG3', '2020-07-06', '00222969', 'RJ', '010201', 226, 'Rabu', '16:00 s/d 18:00', 'Antrian Online Mobile JKN', 'Jaminan Perusahaan', '120', 1, 0, 1, '2020-06-15 13:44:48', '{\"user_id\":0,\"fullname\":\"mjkn\"}', NULL, NULL, NULL, '{\"nama_pasien\":\"YORKIE YANWIJNA, TN.\",\"tgl_lahir\":\"29 Januari 1987\",\"alamat\":\"JL BAMBU KUNING NO.50\",\"telp\":\"81210800910\",\"jk\":\"L\"}', '{\"klinik\":{\"nama_bagian\":\"klinik Spesialis Penyakit Dalam\",\"kode_bagian\":\"010201\"},\"dokter\":{\"nama_dokter\":\"Elizabeth Yasmine Wardoyo,dr.Sp.PD\",\"kode_dokter\":\"226\"},\"penjamin\":{\"nama_perusahaan\":\"BPJS KESEHATAN\"}}', NULL, '2020-06-03 14:00:00', NULL, 'mjkn', 652, 44, '2020-07-06', 'YORKIE YANWIJNA W'),
('8SVML8', '2020-07-01', '00222969', 'RJ', '012501', 25, 'Rabu', '17:00 s/d 19:00', 'Antrian Online Mobile JKN', 'Jaminan Perusahaan', '120', 0, 0, NULL, '2020-07-01 09:33:40', '{\"user_id\":0,\"fullname\":\"mjkn\"}', NULL, NULL, NULL, '{\"no_mr\":\"00222969\",\"nama_pasien\":\"YORKIE YANWIJNA W\",\"tgl_lahir\":\"29 Januari 1987\",\"telp\":\"081210800910\",\"jk\":\"L\"}', '{\"klinik\":{\"nama_bagian\":\"klinik Spesialis Saraf\",\"kode_bagian\":\"012501\"},\"dokter\":{\"nama_dokter\":\"Arfan Mappalilu,dr Sp.S\",\"kode_dokter\":\"25\"},\"penjamin\":120}', NULL, '2020-07-01 15:00:00', NULL, 'mjkn', 744, 0, NULL, 'YORKIE YANWIJNA W');

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

--
-- Struktur dari tabel `tc_pesanan`
--

CREATE TABLE `tc_pesanan` (
  `id_tc_pesanan` int(11) NOT NULL,
  `tgl_pesanan` datetime DEFAULT NULL,
  `no_mr` varchar(50) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `alamat` varchar(255) DEFAULT NULL,
  `umur` varchar(50) DEFAULT NULL,
  `no_poli` int(11) DEFAULT NULL,
  `kode_dokter` varchar(50) DEFAULT NULL,
  `tgl_masuk` datetime DEFAULT NULL,
  `jam_pesanan` datetime DEFAULT NULL,
  `input_tgl` datetime DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL,
  `flag` varchar(50) DEFAULT NULL,
  `diagnosa` longtext DEFAULT NULL,
  `kode_perjanjian` varchar(50) DEFAULT NULL,
  `unique_code_counter` int(11) DEFAULT NULL,
  `selected_day` varchar(255) DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL,
  `kode_perusahaan` int(11) DEFAULT NULL,
  `penjamin` varchar(25) DEFAULT NULL,
  `no_telp` varchar(25) DEFAULT NULL,
  `no_hp` varchar(25) DEFAULT NULL,
  `bulan_kunjungan` varchar(25) DEFAULT NULL,
  `status_konfirmasi_kedatangan` int(11) DEFAULT NULL,
  `referensi_no_kunjungan` int(11) DEFAULT NULL,
  `nopesertabpjs` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tc_pesanan`
--

INSERT INTO `tc_pesanan` (`id_tc_pesanan`, `tgl_pesanan`, `no_mr`, `nama`, `alamat`, `umur`, `no_poli`, `kode_dokter`, `tgl_masuk`, `jam_pesanan`, `input_tgl`, `keterangan`, `flag`, `diagnosa`, `kode_perjanjian`, `unique_code_counter`, `selected_day`, `log_id`, `kode_perusahaan`, `penjamin`, `no_telp`, `no_hp`, `bulan_kunjungan`, `status_konfirmasi_kedatangan`, `referensi_no_kunjungan`, `nopesertabpjs`) VALUES
(329079, '2020-07-21 00:00:00', NULL, 'Muhammad Amin Lubis', 'Jl. Fatmawati Raya', NULL, 30901, '248', NULL, '2020-07-21 01:00:00', '2020-07-06 10:54:03', '', 'bedah', 'Luka bakar', '0112R0340720000001', 1, NULL, NULL, NULL, 'BPJS Kesehatan', '087776328487', '0215925780', NULL, NULL, NULL, '01234567885');

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

--
-- Struktur dari tabel `tmp_mst_function`
--

CREATE TABLE `tmp_mst_function` (
  `code` varchar(5) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `is_active` varchar(255) DEFAULT NULL,
  `is_deleted` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL,
  `function_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tmp_mst_function`
--

INSERT INTO `tmp_mst_function` (`code`, `name`, `description`, `is_active`, `is_deleted`, `created_date`, `created_by`, `updated_date`, `updated_by`, `log_id`, `function_id`) VALUES
('C', 'Create', 'Function for create new record', 'Y', 'N', '2017-12-18 14:41:56', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-02-15 06:23:27', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 1),
('R', 'Read', 'Function for read record', 'Y', 'N', '2017-12-18 14:42:08', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-10-11 07:29:49', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 202, 2),
('U', 'Update', 'Function for update record', 'Y', 'N', '2017-12-18 14:42:18', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-02-15 00:18:40', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 3),
('D', 'Delete', 'Function for delete record', 'Y', 'N', '2017-12-18 14:42:26', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-10-11 07:29:45', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 201, 4);

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

--
-- Struktur dari tabel `tmp_mst_group_modul`
--

CREATE TABLE `tmp_mst_group_modul` (
  `group_modul_name` varchar(255) DEFAULT NULL,
  `group_modul_description` longtext DEFAULT NULL,
  `is_active` varchar(255) DEFAULT NULL,
  `is_deleted` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL,
  `group_modul_id` int(11) NOT NULL,
  `group_modul_icon` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tmp_mst_group_modul`
--

INSERT INTO `tmp_mst_group_modul` (`group_modul_name`, `group_modul_description`, `is_active`, `is_deleted`, `created_date`, `created_by`, `updated_date`, `updated_by`, `log_id`, `group_modul_id`, `group_modul_icon`) VALUES
('Administrator Sistem', 'Pengaturan sistem administrator dan aplikasi', 'Y', 'N', '2018-10-17 06:51:11', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-12-19 06:29:06', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 1628, 3, 'fa fa-bookmark'),
('Registrasi Online', 'Booking Rawat Jalan', 'Y', 'N', '2018-10-17 08:20:41', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-12-28 03:52:37', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 1743, 6, 'fa fa-gavel'),
('Registrasi Pasien', 'Registrasi Pasien, vClaim BPJS dan Antrian', 'Y', 'N', '2018-11-01 03:20:58', '{\"user_id\":\"30\",\"fullname\":\"Muhammad Amin Lubis\"}', '2018-12-19 07:44:05', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 1641, 7, 'fa fa-leaf');

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

--
-- Struktur dari tabel `tmp_mst_level`
--

CREATE TABLE `tmp_mst_level` (
  `name` varchar(55) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `is_active` varchar(255) DEFAULT NULL,
  `is_deleted` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL,
  `level_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tmp_mst_level`
--

INSERT INTO `tmp_mst_level` (`name`, `description`, `is_active`, `is_deleted`, `created_date`, `created_by`, `updated_date`, `updated_by`, `log_id`, `level_id`) VALUES
('Sysadmin', 'System adminisrator (Admin Level 1)', 'Y', 'N', '2017-12-18 14:42:35', NULL, '2018-02-14 23:46:43', 'Amin Lubis', NULL, 1),
('Admin', 'Admin level 2', 'Y', 'N', '2017-12-18 14:54:56', NULL, '2018-02-14 23:46:23', 'Amin Lubis', NULL, 2),
('Publik', 'Pengguna publik', 'Y', 'N', '2018-02-14 23:47:44', 'Amin Lubis', '2018-07-18 05:20:15', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 2, 3);

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

--
-- Struktur dari tabel `tmp_mst_menu`
--

CREATE TABLE `tmp_mst_menu` (
  `id` int(11) NOT NULL,
  `modul_id` int(11) NOT NULL,
  `name` varchar(55) DEFAULT NULL,
  `class` varchar(45) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `level` smallint(6) DEFAULT NULL,
  `parent` int(11) DEFAULT NULL,
  `icon` varchar(45) DEFAULT NULL,
  `set_shortcut` varchar(255) DEFAULT NULL,
  `counter` int(11) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `is_active` varchar(255) DEFAULT NULL,
  `is_deleted` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL,
  `menu_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tmp_mst_menu`
--

INSERT INTO `tmp_mst_menu` (`id`, `modul_id`, `name`, `class`, `link`, `level`, `parent`, `icon`, `set_shortcut`, `counter`, `description`, `is_active`, `is_deleted`, `created_date`, `created_by`, `updated_date`, `updated_by`, `log_id`, `menu_id`) VALUES
(1, 1, 'Menu', 'Tmp_mst_menu', 'setting/Tmp_mst_menu', 1, 8, 'fa fa-circle-o', '', 3, '', 'Y', 'N', '2017-12-18 15:06:53', NULL, '2018-10-17 09:33:30', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 2),
(2, 1, 'Role Management', '#', '#', 0, 0, 'fa fa-cogs', 'N', 2, '', 'Y', 'N', '2018-02-14 16:46:11', 'Amin Lubis', '2018-10-17 09:27:41', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 6),
(3, 1, 'Role', 'Tmp_mst_role', 'setting/Tmp_mst_role', 1, 6, 'fa fa-circle-o', 'N', 2, '', 'Y', 'N', '2018-02-14 16:46:53', 'Amin Lubis', '2018-10-17 09:44:58', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 7),
(4, 1, 'Module Management', '#', '#', 0, 0, 'fa fa-book', 'N', 1, NULL, 'Y', 'N', '2018-02-14 17:08:38', 'Amin Lubis', '2018-02-14 23:08:38', NULL, NULL, 8),
(5, 1, 'User Group', 'Tmp_user_has_role', 'setting/Tmp_user_has_role', 1, 6, 'fa fa-circle-o', 'N', 5, '', 'Y', 'N', '2018-02-14 23:50:55', 'Amin Lubis', '2018-10-17 09:42:45', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 9),
(6, 1, 'Role Privileges', 'Tmp_role_has_menu', 'setting/Tmp_role_has_menu', 1, 6, 'fa fa-circle-o', 'Y', 3, '', 'Y', 'N', '2018-02-14 23:52:53', 'Amin Lubis', '2018-10-17 09:32:00', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 64, 10),
(7, 1, 'Modul', 'Tmp_mst_modul', 'setting/Tmp_mst_modul', 1, 8, 'fa fa-circle-o', 'N', 2, '', 'Y', 'N', '2018-02-14 23:55:14', 'Amin Lubis', '2018-10-17 09:34:57', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 11),
(8, 1, 'User', 'Tmp_user', 'setting/Tmp_user', 1, 6, 'fa fa-users', 'Y', 4, '', 'Y', 'N', '2018-02-15 00:24:20', 'Amin Lubis', '2018-10-17 09:42:33', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 63, 13),
(9, 1, 'Apps Config', 'tmp_apps_config', 'setting/tmp_apps_config', 0, 0, 'fa fa-lock', 'Y', 3, 'Apps Configuration', 'Y', 'N', '2018-04-02 16:55:04', 'Amin Lubis', '2018-10-17 09:31:50', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 60, 27),
(10, 1, 'Group Modul', 'tmp_mst_group_modul', 'setting/tmp_mst_group_modul', 1, 8, 'fa fa-circle-o', 'N', 3, '', 'Y', 'N', '2018-04-02 17:48:15', 'Amin Lubis', '2018-10-17 09:40:28', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 28),
(11, 3, 'Referensi', '#', '#', 0, 0, 'fa fa-list', 'N', 1, 'Referensi Modul', 'Y', 'N', '2018-07-23 03:00:05', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 86, 31),
(12, 3, 'Diagnosa', 'ws_index', 'ws_bpjs/ws_index?modWs=RefDiagnosa', 1, 31, 'fa fa-circle-o', 'N', 1, '', 'Y', 'N', '2018-07-23 03:00:42', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-11-19 02:40:24', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 89, 32),
(13, 3, 'Poli', 'ws_index', 'ws_bpjs/ws_index?modWs=RefPoli', 1, 31, 'fa fa-circle-o', 'N', 2, '', 'Y', 'N', '2018-07-23 04:18:31', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-11-19 02:40:35', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 93, 33),
(14, 3, 'Fasilitas Kesehatan', 'ws_index', 'ws_bpjs/ws_index?modWs=RefFaskes', 1, 31, 'fa fa-circle-o', 'N', 3, '', 'Y', 'N', '2018-07-23 04:19:09', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-11-19 02:40:52', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 94, 34),
(15, 3, 'Procedure / Tindakan', 'ws_index', 'ws_bpjs/ws_index?modWs=RefProcedure', 1, 31, 'fa fa-circle-o', 'N', 4, '', 'Y', 'N', '2018-07-23 04:21:45', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-11-19 02:41:09', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 96, 35),
(16, 3, 'Kelas Rawat', 'ws_index', 'ws_bpjs/ws_index?modWs=RefKelasRawat', 1, 31, 'fa fa-circle-o', 'Y', 5, '', 'Y', 'N', '2018-07-23 04:56:07', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-11-19 02:42:05', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 103, 36),
(17, 3, 'Dokter', 'ws_index', 'ws_bpjs/ws_index?modWs=RefDokterDPJP', 1, 31, 'fa fa-circle-o', 'Y', 6, '', 'Y', 'N', '2018-07-23 04:56:37', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2020-01-14 09:13:20', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 108, 37),
(18, 3, 'Spesialistik', 'ws_indexw', 'ws_bpjs/ws_index?modWs=RefSpesialistik', 1, 31, 'fa fa-circle-o', 'Y', 7, '', 'Y', 'N', '2018-07-23 04:57:14', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-11-19 02:42:34', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 107, 38),
(19, 3, 'Ruang Rawat', 'ws_index', 'ws_bpjs/ws_index?modWs=RefRuangRawat', 1, 31, 'fa fa-circle-o', 'Y', 8, '', 'Y', 'N', '2018-07-23 04:57:55', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-11-19 02:43:06', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 106, 39),
(20, 3, 'Cara Keluar', 'ws_index', 'ws_bpjs/ws_index?modWs=RefCaraKeluar', 1, 31, 'fa fa-circle-o', 'Y', 9, '', 'Y', 'N', '2018-07-23 04:58:38', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-11-19 02:43:22', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 105, 40),
(21, 3, 'Pasca Pulang', 'ws_index', 'ws_bpjs/ws_index?modWs=RefPascaPulang', 1, 31, 'fa fa-circle-o', 'Y', 10, '', 'Y', 'N', '2018-07-23 04:59:11', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-11-19 02:56:06', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 104, 41),
(22, 3, 'Kepesertaan', '#', '#', 0, 0, 'fa fa-user', 'N', 2, '', 'Y', 'N', '2018-07-23 05:27:50', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-11-19 02:45:22', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 109, 42),
(23, 3, 'No Kartu BPJS', 'ws_index', 'ws_bpjs/ws_index?modWs=MemberByNoCard', 1, 42, 'fa fa-circle-o', 'N', 1, '', 'Y', 'N', '2018-07-23 05:29:03', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-11-19 02:45:48', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 110, 43),
(24, 3, 'NIK / No KTP', 'ws_index', 'ws_bpjs/ws_index?modWs=MemberByNik', 1, 42, 'fa fa-circle-o', 'N', 2, '', 'Y', 'N', '2018-07-23 05:29:57', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-11-19 02:45:34', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 111, 44),
(25, 3, 'Cari dengan No. Kartu', 'ws_index', 'ws_bpjs/ws_index?modWs=searchRujukanByNoKartu', 1, 79, 'fa fa-circle-o', 'N', 2, '', 'Y', 'N', '2018-07-23 07:39:09', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-07-31 08:35:37', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 162, 51),
(26, 9, 'Booking', 'regon_booking', 'booking/regon_booking', 0, 0, 'fa fa-edit', 'Y', 1, 'dashboard mobile', 'Y', 'N', '2018-10-17 09:24:35', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-10-23 11:30:08', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 70),
(27, 9, 'Riwayat', 'regon_riwayat', 'booking/regon_riwayat', 0, 0, 'fa fa-history', 'Y', 2, 'Riwayat Booking', 'Y', 'N', '2018-10-23 11:30:01', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2019-01-09 08:17:39', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 72),
(28, 1, 'Loket Pendaftaran', 'reg_loket', 'registration/reg_loket', 0, 0, 'fa fa-briefcase', 'Y', 6, '', 'Y', 'N', '2018-11-02 03:16:56', '{\"user_id\":\"30\",\"fullname\":\"Muhammad Amin Lubis\"}', '2020-07-04 22:27:45', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 74),
(29, 11, 'Via Online (Web/Mobile)', 'Reg_on_dashboard', 'registration/Reg_on_dashboard', 1, 143, 'fa fa-globe', 'Y', 3, 'Perjanjian pasien via online dan onsite', 'Y', 'N', '2018-11-16 03:23:18', '{\"user_id\":\"30\",\"fullname\":\"Muhammad Amin Lubis\"}', '2019-01-16 08:09:08', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 75),
(30, 11, 'Form Pendaftaran', 'Reg_klinik', 'registration/Reg_klinik', 0, 0, 'fa fa-edit', 'Y', 2, '', 'Y', 'N', '2018-11-19 01:59:11', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2019-01-29 15:10:50', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 76),
(31, 11, 'Informasi Umum', '#', '#', 0, 0, 'fa fa-info', 'N', 9, '', 'Y', 'N', '2018-11-19 02:01:44', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, NULL, 77),
(32, 1, 'Jadwal Dokter', 'Regon_info_jadwal_dr', 'information/regon_info_jadwal_dr', 0, 0, 'fa fa-circle-o', 'Y', 5, '', 'Y', 'N', '2018-11-19 02:02:13', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2020-07-04 22:27:12', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 78),
(33, 1, 'Loket Pendaftaran', 'information', 'information/information/loket_pendaftaran', 0, 0, 'fa fa-glass', 'Y', 6, '', 'N', 'N', '2019-01-09 08:09:18', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2020-07-15 10:28:35', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, 141),
(34, 9, 'Jadwal Operasi', 'Input_perjanjian', 'registration/Input_perjanjian', 1, 0, 'fa fa-cirle-o', 'Y', 1, '', 'Y', 'N', '2019-09-30 08:18:22', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2020-07-06 09:57:47', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 2940, 212),
(35, 9, 'Cek Kode Booking', 'Reg_klinik', 'Registration/Reg_klinik', 0, 0, 'fa fa-circle-o', 'Y', 1, '', 'Y', 'N', '2020-07-04 22:13:10', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, NULL, 0),
(36, 9, 'Data Booking', 'Reg_on_dashboard', 'registration/Reg_on_dashboard', 0, 0, 'fa fa-circle-o', 'Y', 2, '', 'Y', 'N', '2020-07-04 22:14:43', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, NULL, 0),
(37, 3, 'SEP', '#', '#', 0, 0, 'fa fa-circle', 'Y', 3, '', 'Y', 'N', '2020-07-06 20:30:17', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, NULL, 79),
(40, 3, 'Input Sep', 'Ws_index', 'ws_bpjs/ws_index?modWs=insertSep', 1, 79, '', 'Y', 1, '', 'Y', 'N', '2020-07-06 20:49:55', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, NULL, 0);

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

--
-- Struktur dari tabel `tmp_mst_modul`
--

CREATE TABLE `tmp_mst_modul` (
  `name` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `icon` varchar(45) DEFAULT NULL,
  `group_modul_id` int(11) DEFAULT NULL,
  `is_new_tab` varchar(255) DEFAULT NULL,
  `link_on_new_tab` longtext DEFAULT NULL,
  `is_active` varchar(255) DEFAULT NULL,
  `is_deleted` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL,
  `modul_id` int(11) NOT NULL,
  `counter` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tmp_mst_modul`
--

INSERT INTO `tmp_mst_modul` (`name`, `title`, `description`, `icon`, `group_modul_id`, `is_new_tab`, `link_on_new_tab`, `is_active`, `is_deleted`, `created_date`, `created_by`, `updated_date`, `updated_by`, `log_id`, `modul_id`, `counter`) VALUES
('Setting', 'Application Setting', '-', 'fa fa-cogs', 3, 'N', NULL, 'Y', 'N', '2017-12-18 14:42:59', NULL, '2020-07-04 22:09:53', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 2954, 1, NULL),
('vClaim BPJS', 'Virtual Claim BPJS', 'Katalog Web Service BPJS', 'fa fa-globe', 7, 'N', NULL, 'Y', 'N', '2018-07-23 02:59:19', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-12-19 02:29:14', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 1612, 3, NULL),
('Booking', 'Perjanjian Rawat Jalan', 'Pendaftaran Rawat Jalan Online', 'fa fa-stetoscope', 6, 'N', NULL, 'Y', 'N', '2018-10-17 08:23:39', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 249, 9, NULL),
('Display', 'Display', '-', 'fa fa-monitor', 3, 'N', NULL, 'Y', 'N', '2020-07-04 22:15:59', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 2955, 0, NULL);

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

--
-- Struktur dari tabel `tmp_mst_role`
--

CREATE TABLE `tmp_mst_role` (
  `level_id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `is_active` varchar(255) DEFAULT NULL,
  `is_deleted` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL,
  `role_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tmp_mst_role`
--

INSERT INTO `tmp_mst_role` (`level_id`, `name`, `description`, `is_active`, `is_deleted`, `created_date`, `created_by`, `updated_date`, `updated_by`, `log_id`, `role_id`) VALUES
(1, 'Admin Sistem', '', 'Y', 'N', '2017-12-18 14:43:15', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-07-18 06:04:48', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 6, 1);

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

--
-- Struktur dari tabel `tmp_profile_app`
--

CREATE TABLE `tmp_profile_app` (
  `app_name` varchar(255) DEFAULT NULL,
  `header_title` varchar(255) DEFAULT NULL,
  `footer` varchar(255) DEFAULT NULL,
  `running_text` longtext DEFAULT NULL,
  `author` varchar(45) DEFAULT NULL,
  `developer_name` varchar(255) DEFAULT NULL,
  `db_name` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `app_logo` varchar(255) DEFAULT NULL,
  `cover_login` varchar(255) DEFAULT NULL,
  `footer_text_form_login` longtext DEFAULT NULL,
  `app_description` longtext DEFAULT NULL,
  `style_header_color` varchar(45) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL,
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tmp_profile_app`
--

INSERT INTO `tmp_profile_app` (`app_name`, `header_title`, `footer`, `running_text`, `author`, `developer_name`, `db_name`, `company_name`, `icon`, `app_logo`, `cover_login`, `footer_text_form_login`, `app_description`, `style_header_color`, `is_active`, `created_date`, `created_by`, `updated_date`, `updated_by`, `log_id`, `id`) VALUES
('AntrianQu', 'AQ - AntrianQu', '2020 © Copyright AQ Team', 'Selamat Datang di Aplkasi AntrianQu', 'AQ Team', 'AQ', 'db_template_v2', 'RS ANDHIKA', 'fa fa-leaf', '12729iconphone.png', '53bg2.jpg', 'Jl. Warung Sila No. 8, RT.06/RW.04, Gudang Baru Ciganjur, Jagakarsa, Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12630', 'Built on Custom up to CI 3.0 Framework', 'blue', 'Y', '2018-07-17 12:13:38', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2020-07-08 21:56:56', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', 2994, 1);

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

--
-- Struktur dari tabel `tmp_role_has_menu`
--

CREATE TABLE `tmp_role_has_menu` (
  `role_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  `action_code` varchar(25) DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tmp_role_has_menu`
--

INSERT INTO `tmp_role_has_menu` (`role_id`, `menu_id`, `action_code`, `log_id`) VALUES
(1, 6, 'C,R,U,D', NULL),
(1, 7, 'C,R,U,D', NULL),
(1, 9, 'C,R,U,D', NULL),
(1, 10, 'C,R,U,D', NULL),
(1, 13, 'C,R,U,D', NULL),
(1, 8, 'C,R,U,D', NULL),
(1, 2, 'C,R,U,D', NULL),
(1, 11, 'C,R,U,D', NULL),
(1, 28, 'C,R,U,D', NULL),
(1, 27, 'C,R,U,D', NULL),
(1, 74, 'C,R,U,D', NULL),
(1, 78, 'C,R,U,D', NULL),
(1, 141, 'C,R,U,D', NULL),
(1, 31, 'C,R,U,D', NULL),
(1, 32, 'C,R,U,D', NULL),
(1, 33, 'C,R,U,D', NULL),
(1, 34, 'C,R,U,D', NULL),
(1, 35, 'C,R,U,D', NULL),
(1, 36, 'C,R,U,D', NULL),
(1, 37, 'C,R,U,D', NULL),
(1, 38, 'C,R,U,D', NULL),
(1, 39, 'C,R,U,D', NULL),
(1, 40, 'C,R,U,D', NULL),
(1, 41, 'C,R,U,D', NULL),
(1, 42, 'C,R,U,D', NULL),
(1, 43, 'C,R,U,D', NULL),
(1, 44, 'C,R,U,D', NULL),
(1, 0, 'C,R,U,D,C,R,U,D,C,R,U,D', NULL),
(1, 79, 'C,R,U,D', NULL),
(1, 51, 'C,R,U,D', NULL),
(1, 70, 'C,R,U,D', NULL),
(1, 72, 'C,R,U,D', NULL),
(1, 212, 'C,R,U,D', NULL),
(1, 0, 'C,R,U,D,C,R,U,D,C,R,U,D', NULL),
(1, 0, 'C,R,U,D,C,R,U,D,C,R,U,D', NULL),
(1, 76, 'C,R,U,D', NULL);

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

--
-- Struktur dari tabel `tmp_user`
--

CREATE TABLE `tmp_user` (
  `email` varchar(255) DEFAULT NULL,
  `fullname` varchar(45) DEFAULT NULL,
  `username` varchar(45) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT NULL,
  `is_deleted` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `last_logon` datetime DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL,
  `flag_user` varchar(255) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tmp_user`
--

INSERT INTO `tmp_user` (`email`, `fullname`, `username`, `password`, `is_active`, `is_deleted`, `created_date`, `created_by`, `updated_date`, `updated_by`, `last_logon`, `log_id`, `flag_user`, `user_id`) VALUES
('aminlubis23@gmail.com', 'Amin Lubis', 'sysadmin', '$2a$08$cyhwt7/b9jIC6K1Krm635es/.0LDEzMb6uLJOqvhZmV0ud6Ee0ZQG', 'Y', 'N', '2017-12-18 14:45:30', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2018-07-17 11:26:41', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', '2020-09-25 10:53:49', 3071, NULL, 1),
('dede.zyland@gmail.com', 'Tauchid A', 'dedezyland', '$2a$08$AhT3ZfKSprHj135LWZzN6Orui4TEuZA6bX5RSnj7oPIwpS23yrd3G', 'Y', 'N', '2020-07-06 18:40:37', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, '2020-07-06 19:03:43', 2982, '', 0);

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

--
-- Struktur dari tabel `tmp_user_has_role`
--

CREATE TABLE `tmp_user_has_role` (
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `log_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tmp_user_has_role`
--

INSERT INTO `tmp_user_has_role` (`user_id`, `role_id`, `log_id`) VALUES
(1, 1, NULL);

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

--
-- Struktur dari tabel `tmp_user_profile`
--

CREATE TABLE `tmp_user_profile` (
  `fullname` varchar(255) DEFAULT NULL,
  `pob` varchar(55) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `address` longtext DEFAULT NULL,
  `no_telp` varchar(15) DEFAULT NULL,
  `no_hp` varchar(15) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `about_me` longtext DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `path_foto` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL,
  `up_id` int(11) NOT NULL,
  `no_mr` varchar(25) DEFAULT NULL,
  `no_ktp` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tmp_user_profile`
--

INSERT INTO `tmp_user_profile` (`fullname`, `pob`, `dob`, `address`, `no_telp`, `no_hp`, `gender`, `about_me`, `instagram`, `twitter`, `facebook`, `path_foto`, `user_id`, `created_date`, `created_by`, `updated_date`, `updated_by`, `log_id`, `up_id`, `no_mr`, `no_ktp`) VALUES
('RENDY APRIYANDO, TN.', 'JAKARTA', '1990-04-05', 'BUMI PELITA KENCANA B RT 05 RW 18', '081223016413', '081223016413', 'L', NULL, NULL, NULL, NULL, NULL, 57, NULL, NULL, NULL, NULL, NULL, 140, '00221353', '11'),
('NUR FAJAR, Tn.', 'Purwakarta', '1960-01-12', 'JL GUNUK II NO 10 B,RT 05/003', '08561441969', '08561441969', 'L', NULL, NULL, NULL, NULL, NULL, 110, NULL, NULL, NULL, NULL, NULL, 146, '00231510', '3174011201600003'),
('ALIAH, Ny.', 'Jakarta', '1946-11-30', 'KOMP.BINTARO RT003/RW002 NO.34 PESANGGRAHAN', '089679812247', '089679812247', 'P', NULL, NULL, NULL, NULL, NULL, 123, NULL, NULL, NULL, NULL, NULL, 147, '00180283', '3174107011460002'),
('MARISA NATALIA, Nn.', 'JAKARTA', '1991-12-21', 'JL SINGOSARI RAYA NO 45 BENCONGAN', '085217768700', '085217768700', 'P', NULL, NULL, NULL, NULL, NULL, 131, NULL, NULL, NULL, NULL, NULL, 155, '00208282', '3603826112910003'),
('MISKIYAH, Ny.', 'Cikampek', '1950-12-11', 'JL KEMANDORAN 8 RT.05/11 NO. 149', '0215363608', '0215363608', 'P', NULL, NULL, NULL, NULL, NULL, 80, NULL, NULL, NULL, NULL, NULL, 168, '00223685', '3174055112500002'),
('WAHAB, Tn.', '-jakarta', '1975-10-09', 'JL. BAHARI RT 014/007 GANDARIA SELATAN JAKARTA SELATAN', '081513239833', '081513239833', 'L', NULL, NULL, NULL, NULL, NULL, 210, NULL, NULL, NULL, NULL, NULL, 169, '00178708', '3174040910750010'),
('GHAZALI ALI', '-Manado', '1981-01-09', 'JL. KRAMAT I/11 RT/RW 009/001\r\nKELURAHAN PONDOK PINANG \r\nKECAMATAN KEBAYORAN LAMA \r\nKOTA JAKARTA SELATAN \r\n12310', '088901101445', '088901101445', 'L', NULL, NULL, NULL, NULL, NULL, 201, NULL, NULL, NULL, NULL, NULL, 170, '00235875', '3174050901810004'),
('DIMAS PUTRA DWI TAMA, An.', 'Jakarta', '2001-10-17', 'JL.MPR III DALAM CILANDAK RT004/RW013 CILANDAK BARAT JAKARTA SELATAN 12430', '087884466127', '087884466127', 'L', NULL, NULL, NULL, NULL, NULL, 217, NULL, NULL, NULL, NULL, NULL, 302, '00180007', '3174061710010002'),
('SLAMET', 'DKI JAKARTA', '1951-11-01', 'JL H JIAN RT 011/003 CIPETE UTARA', '083898091208', '083898091208', 'L', NULL, NULL, NULL, NULL, NULL, 219, NULL, NULL, NULL, NULL, NULL, 303, '00234637', '3174072011510003'),
('ILHAM BACHTIAR', '-', '1989-06-06', 'JL KRAMAT GG MUSHOLA RT 006/01 NO 34 CILANDAK TIMUR', '085778950577', '085778950577', 'L', NULL, NULL, NULL, NULL, NULL, 227, NULL, NULL, NULL, NULL, NULL, 306, '00237361', '-'),
('MUHAMMAD AMIN LUBIS, Tn.', 'Tangerang', '1990-09-23', 'JL.KERINCI E36/10 RT2/9 PONDOK INDAH', '085819655296', '085819655296', 'L', NULL, NULL, NULL, NULL, NULL, 59, NULL, NULL, NULL, NULL, NULL, 135, '00211762', '3603122311900004'),
('MAEMUNAWATI, Nn.', '-', '1990-05-06', 'JL. KAMPUNG BARU I 09/09 NO. 69 KELAPA DUA WETAN CIRACAS', '085881800072', '085881800072', 'P', NULL, NULL, NULL, NULL, NULL, 65, NULL, NULL, NULL, NULL, NULL, 137, '00220879', '-'),
('PUPUT INDRIANI, Ny.', 'JAKARTA', '1983-04-21', 'WISATA NO 11', '7495058', '7495058', 'P', NULL, NULL, NULL, NULL, NULL, 68, NULL, NULL, NULL, NULL, NULL, 138, '00080683', '3603122311900004'),
('IRWAN RUSWANDI, Tn.', 'MAJALENGKA', '1989-05-30', 'JL KOMP PONDOK SAFARI INDAH WIJAYA KUSUMA NO.104 006/0011', '081392700277', '081392700277', 'L', NULL, NULL, NULL, NULL, NULL, 69, NULL, NULL, NULL, NULL, NULL, 139, '00127203', '3210213005890041'),
('RHAMA TRIASTA NURSATYO', 'KOTA JAKARTA SELATAN', '1983-02-02', 'CIPETE V RT 008 RW 003', '08562106351', '08562106351', 'L', NULL, NULL, NULL, NULL, NULL, 225, NULL, NULL, NULL, NULL, NULL, 304, '00234698', '3174060202830004'),
('NURYATI', 'TANGERANG', '1941-03-13', 'JL. PRATAMA RAYA GG. H. RISIN NO. 8 RT 05/04', '085717475574', '085717475574', 'P', NULL, NULL, NULL, NULL, NULL, 134, NULL, NULL, NULL, NULL, NULL, 156, '00233206', '3671135303410001'),
('MUHAMMAD SYARIF', '-', '1996-06-05', 'JL. PONDOK HIJAU VI/23', '081212493669', '081212493669', 'L', NULL, NULL, NULL, NULL, NULL, 147, NULL, NULL, NULL, NULL, NULL, 159, '00233753', '3174050506960001'),
('SAMSURI', 'DKI JAKARTA', '1978-05-20', 'JATI PADANG,RT006/003', '089510146293', '089510146293', 'L', NULL, NULL, NULL, NULL, NULL, 228, NULL, NULL, NULL, NULL, NULL, 305, '00237342', '3174042005780008'),
('DJALINAR', '-', '1956-04-01', 'JL PEJATEN RAYA KOMPLEK DEPDIKBUD P&K BLOK B2 NO 15', '087882222347', '087882222347', 'P', NULL, NULL, NULL, NULL, NULL, 229, NULL, NULL, NULL, NULL, NULL, 307, '00236196', '-'),
('NURDEWI YUNITA, Ny.', '-bogor', '1987-06-06', 'GG KAMBOJA NO 29 RT 010/003 MAMPANG PRAPATAN', '087873750765', '087873750765', 'P', NULL, NULL, NULL, NULL, NULL, 197, NULL, NULL, NULL, NULL, NULL, 308, '00226690', '3271054606870005'),
('MUINAH', 'JAKARTA', '1966-12-03', 'JL.BAHARI 2 JAK.SELATAN', '75988662', '75988662', 'P', NULL, NULL, NULL, NULL, NULL, 230, NULL, NULL, NULL, NULL, NULL, 309, '00098074', '-');

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

--
-- Struktur dari tabel `token`
--

CREATE TABLE `token` (
  `id` int(11) NOT NULL,
  `token` varchar(255) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `token`
--

INSERT INTO `token` (`id`, `token`, `type`, `created_date`, `user_id`) VALUES
(72, 'f5bcc6dddb7c0e9fda65c6ba2de96dd4', 'Login', '2019-05-29 13:02:22', 5),
(216, '5446225916e886db490655318f6292b6', 'Login', '2019-09-12 03:40:44', 10),
(245, 'f3027df7cbe23d3b0e322e1bbf6e8013', 'Login', '2019-09-18 23:28:16', 23),
(247, '29921d98070d3ea85e5f52b1189ec03e', 'Login', '2019-09-18 23:29:39', 11),
(343, '6ff050580f04c637f6b523c0de67c88b', 'Login', '2019-09-27 22:19:50', 16),
(698, 'a85556f959679857fd06f20bdbae303c', 'Login', '2020-01-09 20:47:30', 32),
(1271, '81bae5230ae72274cb4f54c7b431cd19', 'Login', '2020-03-03 10:24:17', 24),
(1439, 'e93096e38b92bff1ca2e81f2c3ee21ac', 'Login', '2020-03-16 15:38:26', 106),
(1637, 'a1ba3f278e3ba105181614934196ce7d', 'Login', '2020-06-16 14:24:12', 104),
(1690, '0146c988dc3c4d7eda8e4e1ff10ebff1', 'Login', '2020-06-23 13:09:43', 14),
(1692, '7d2e7d13503bd360f68abf26f0a77e40', 'Login', '2020-06-23 17:49:56', 178),
(1697, '1023731255d7d99b378f806386aacea5', 'Login', '2020-06-24 04:50:54', 177),
(1699, '723cc8788d60fbcd877a6c669af79dfc', 'Login', '2020-06-24 09:15:26', 156),
(1701, '375419b335c3158d81b1bdfc172331ed', 'Login', '2020-06-24 11:13:23', 173),
(1718, '05e1385dfd6ab188648ea4f5ec9cc787', 'Login', '2020-09-25 10:53:48', 1);

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

--
-- Struktur dari tabel `tr_antrian`
--

CREATE TABLE `tr_antrian` (
  `ant_id` int(11) NOT NULL,
  `ant_kode_spesialis` varchar(50) DEFAULT NULL,
  `ant_kode_dokter` int(11) DEFAULT NULL,
  `ant_status` int(11) DEFAULT NULL,
  `ant_type` varchar(50) DEFAULT NULL,
  `ant_date` datetime DEFAULT NULL,
  `ant_no` int(11) DEFAULT NULL,
  `log` longtext DEFAULT NULL,
  `ant_loket` int(11) DEFAULT NULL,
  `ant_panggil` char(10) DEFAULT NULL,
  `ant_aktif` char(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tr_antrian`
--

INSERT INTO `tr_antrian` (`ant_id`, `ant_kode_spesialis`, `ant_kode_dokter`, `ant_status`, `ant_type`, `ant_date`, `ant_no`, `log`, `ant_loket`, `ant_panggil`, `ant_aktif`) VALUES
(0, '010401', 7, 1, 'umum', '2020-07-15 15:49:17', 1, '{\"dokter\":\"dr. Charles, Sp.A\",\"klinik\":\"klinik Spesialis Anak\",\"jam_praktek\":\"13:00\"}', 2, '1', '2'),
(0, '010401', 7, 1, 'umum', '2020-07-15 15:49:22', 2, '{\"dokter\":\"dr. Charles, Sp.A\",\"klinik\":\"klinik Spesialis Anak\",\"jam_praktek\":\"13:00\"}', 2, '1', '2'),
(0, '010401', 7, 1, 'umum', '2020-07-15 15:49:25', 3, '{\"dokter\":\"dr. Charles, Sp.A\",\"klinik\":\"klinik Spesialis Anak\",\"jam_praktek\":\"13:00\"}', 2, '1', '2'),
(0, '010401', 7, 0, 'umum', '2020-07-15 15:49:28', 4, '{\"dokter\":\"dr. Charles, Sp.A\",\"klinik\":\"klinik Spesialis Anak\",\"jam_praktek\":\"13:00\"}', 2, '1', '1'),
(0, '010401', 6, 1, 'bpjs', '2020-07-15 15:49:34', 1, '{\"dokter\":\"dr. Efriyanti, SpA. Mkes\",\"klinik\":\"klinik Spesialis Anak\",\"jam_praktek\":\"14:00\"}', 1, '1', '2'),
(0, '010401', 6, 1, 'bpjs', '2020-07-15 15:49:37', 2, '{\"dokter\":\"dr. Efriyanti, SpA. Mkes\",\"klinik\":\"klinik Spesialis Anak\",\"jam_praktek\":\"14:00\"}', 1, '1', '2'),
(0, '010401', 6, 1, 'bpjs', '2020-07-15 15:49:40', 3, '{\"dokter\":\"dr. Efriyanti, SpA. Mkes\",\"klinik\":\"klinik Spesialis Anak\",\"jam_praktek\":\"14:00\"}', 1, '1', '2'),
(0, '010201', 10, 1, 'bpjs', '2020-07-15 15:49:47', 4, '{\"dokter\":\"dr.Melsa Aprima Sp.PD\",\"klinik\":\"klinik Spesialis Penyakit Dalam\",\"jam_praktek\":\"15:00\"}', 1, '1', '2'),
(0, '010201', 10, 0, 'bpjs', '2020-07-15 15:49:53', 5, '{\"dokter\":\"dr.Melsa Aprima Sp.PD\",\"klinik\":\"klinik Spesialis Penyakit Dalam\",\"jam_praktek\":\"15:00\"}', 1, '1', '1'),
(0, '011301', 13, 0, 'bpjs', '2020-07-15 15:49:59', 6, '{\"dokter\":\"dr. Elisabeth Irma Dewi K,.SpM\",\"klinik\":\"klinik Spesialis Mata\",\"jam_praktek\":\"15:00\"}', NULL, '0', NULL),
(0, '011301', 13, 0, 'bpjs', '2020-07-15 15:50:02', 7, '{\"dokter\":\"dr. Elisabeth Irma Dewi K,.SpM\",\"klinik\":\"klinik Spesialis Mata\",\"jam_praktek\":\"15:00\"}', NULL, '0', NULL),
(0, '011301', 13, 0, 'bpjs', '2020-07-15 16:11:07', 8, '{\"dokter\":\"dr. Elisabeth Irma Dewi K,.SpM\",\"klinik\":\"klinik Spesialis Mata\",\"jam_praktek\":\"15:00\"}', NULL, '0', NULL),
(0, '010201', 10, 0, 'bpjs', '2020-07-15 16:11:09', 9, '{\"dokter\":\"dr.Melsa Aprima Sp.PD\",\"klinik\":\"klinik Spesialis Penyakit Dalam\",\"jam_praktek\":\"15:00\"}', NULL, '0', NULL),
(0, '010201', 10, 0, 'bpjs', '2020-07-15 16:11:11', 10, '{\"dokter\":\"dr.Melsa Aprima Sp.PD\",\"klinik\":\"klinik Spesialis Penyakit Dalam\",\"jam_praktek\":\"15:00\"}', NULL, '0', NULL),
(0, '011301', 13, 0, 'bpjs', '2020-07-15 16:11:14', 11, '{\"dokter\":\"dr. Elisabeth Irma Dewi K,.SpM\",\"klinik\":\"klinik Spesialis Mata\",\"jam_praktek\":\"15:00\"}', NULL, '0', NULL),
(0, '011301', 13, 0, 'bpjs', '2020-07-15 16:11:16', 12, '{\"dokter\":\"dr. Elisabeth Irma Dewi K,.SpM\",\"klinik\":\"klinik Spesialis Mata\",\"jam_praktek\":\"15:00\"}', NULL, '0', NULL),
(0, '010101', 1, 0, 'bpjs', '2020-09-25 16:44:07', 13, '{\"dokter\":\"dr Tagor P Sidabutar SpOG\",\"klinik\":\"klinik Spesialis Kebidanan & Kandungan\",\"jam_praktek\":\"09:00\"}', NULL, '0', NULL),
(0, '010101', 1, 0, 'bpjs', '2020-09-25 16:44:12', 14, '{\"dokter\":\"dr Tagor P Sidabutar SpOG\",\"klinik\":\"klinik Spesialis Kebidanan & Kandungan\",\"jam_praktek\":\"09:00\"}', NULL, '0', NULL),
(0, '011101', 12, 0, 'umum', '2020-09-25 16:44:34', 5, '{\"dokter\":\"dr. Raditya Pratama, SpB\",\"klinik\":\"klinik Spesialis Bedah Umum\",\"jam_praktek\":\"13:00\"}', NULL, '0', NULL),
(0, '011301', 13, 0, 'umum', '2020-09-25 16:44:38', 6, '{\"dokter\":\"dr. Elisabeth Irma Dewi K,.SpM\",\"klinik\":\"klinik Spesialis Mata\",\"jam_praktek\":\"15:00\"}', NULL, '0', NULL),
(0, '012501', 15, 0, 'bpjs', '2020-09-25 16:44:47', 15, '{\"dokter\":\"dr. Clara Krishanti Koestoer, SpS\",\"klinik\":\"klinik Spesialis Saraf\",\"jam_praktek\":\"19:00\"}', NULL, '0', NULL),
(0, '012501', 15, 0, 'bpjs', '2020-09-25 16:44:49', 16, '{\"dokter\":\"dr. Clara Krishanti Koestoer, SpS\",\"klinik\":\"klinik Spesialis Saraf\",\"jam_praktek\":\"19:00\"}', NULL, '0', NULL),
(0, '012501', 15, 0, 'bpjs', '2020-09-25 16:44:52', 17, '{\"dokter\":\"dr. Clara Krishanti Koestoer, SpS\",\"klinik\":\"klinik Spesialis Saraf\",\"jam_praktek\":\"19:00\"}', NULL, '0', NULL);

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

--
-- Struktur dari tabel `tr_jadwal_dokter`
--

CREATE TABLE `tr_jadwal_dokter` (
  `jd_id` int(11) NOT NULL,
  `jd_kode_dokter` int(11) NOT NULL,
  `jd_kode_spesialis` varchar(25) DEFAULT NULL,
  `jd_hari` varchar(25) DEFAULT NULL,
  `jd_jam_mulai` time DEFAULT NULL,
  `jd_jam_selesai` time DEFAULT NULL,
  `jd_keterangan` varchar(255) DEFAULT NULL,
  `is_active` char(5) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `jd_kuota` int(11) DEFAULT NULL,
  `status_jadwal` varchar(255) DEFAULT NULL,
  `status_loket` varchar(25) DEFAULT NULL,
  `keterangan` longtext DEFAULT NULL,
  `log_id` int(11) DEFAULT NULL,
  `flag` varchar(255) DEFAULT NULL,
  `ref_jd_id` int(11) DEFAULT NULL,
  `is_reschedule` char(50) DEFAULT NULL,
  `jd_kode_spesialis_bpjs` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `tr_jadwal_dokter`
--

INSERT INTO `tr_jadwal_dokter` (`jd_id`, `jd_kode_dokter`, `jd_kode_spesialis`, `jd_hari`, `jd_jam_mulai`, `jd_jam_selesai`, `jd_keterangan`, `is_active`, `created_date`, `created_by`, `updated_date`, `updated_by`, `jd_kuota`, `status_jadwal`, `status_loket`, `keterangan`, `log_id`, `flag`, `ref_jd_id`, `is_reschedule`, `jd_kode_spesialis_bpjs`) VALUES
(0, 6, '010401', 'Senin', '14:00:00', '16:00:00', '(Jadwal sementara dalam situasi COVID-19)', NULL, '2020-07-15 13:19:32', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 6, '010401', 'Selasa', '10:00:00', '12:00:00', '', NULL, '2020-07-15 13:19:32', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 6, '010401', 'Rabu', '14:00:00', '16:00:00', '', NULL, '2020-07-15 13:19:32', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 6, '010401', 'Kamis', '10:00:00', '12:00:00', '', NULL, '2020-07-15 13:19:32', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 6, '010401', 'Minggu', '11:00:00', '13:00:00', '', NULL, '2020-07-15 13:19:32', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 7, '010401', 'Senin', '11:00:00', '14:00:00', '', NULL, '2020-07-15 13:23:30', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 7, '010401', 'Rabu', '13:00:00', '16:00:00', '', NULL, '2020-07-15 13:23:30', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 7, '010401', 'Kamis', '11:00:00', '14:00:00', '', NULL, '2020-07-15 13:23:30', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 7, '010401', 'Jumat', '14:00:00', '17:00:00', '', NULL, '2020-07-15 13:23:31', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 7, '010401', 'Sabtu', '10:00:00', '12:00:00', '', NULL, '2020-07-15 13:23:31', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 1, '010101', 'Senin', '09:00:00', '14:00:00', '', NULL, '2020-07-15 13:41:44', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 1, '010101', 'Selasa', '09:00:00', '12:00:00', '', NULL, '2020-07-15 13:41:44', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 1, '010101', 'Jumat', '09:00:00', '14:00:00', '', NULL, '2020-07-15 13:41:44', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 1, '010101', 'Sabtu', '09:00:00', '14:00:00', '', NULL, '2020-07-15 13:41:44', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 2, '010101', 'Senin', '08:00:00', '00:00:00', '', NULL, '2020-07-15 13:43:08', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 2, '010101', 'Selasa', '08:00:00', '00:00:00', '', NULL, '2020-07-15 13:43:08', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 2, '010101', 'Kamis', '08:00:00', '00:00:00', '', NULL, '2020-07-15 13:43:08', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 2, '010101', 'Sabtu', '09:00:00', '00:00:00', '', NULL, '2020-07-15 13:43:08', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 3, '010101', 'Kamis', '13:00:00', '00:00:00', '(Jadwal sementara dalam situasi COVID-19)', NULL, '2020-07-15 13:44:40', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 4, '010101', 'Selasa', '18:00:00', '00:00:00', '', NULL, '2020-07-15 13:45:29', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 4, '010101', 'Kamis', '18:00:00', '00:00:00', '', NULL, '2020-07-15 13:45:29', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 4, '010101', 'Jumat', '18:00:00', '00:00:00', '', NULL, '2020-07-15 13:45:30', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 8, '010201', 'Selasa', '16:00:00', '00:00:00', '', NULL, '2020-07-15 13:46:18', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 8, '010201', 'Kamis', '16:00:00', '00:00:00', '', NULL, '2020-07-15 13:46:18', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 8, '010201', 'Sabtu', '09:00:00', '00:00:00', '', NULL, '2020-07-15 13:46:19', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 0, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 10, '010201', 'Senin', '15:00:00', '17:00:00', '(Jadwal sementara dalam situasi COVID-19)', NULL, '2020-07-15 13:50:15', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 10, '010201', 'Selasa', '09:00:00', '11:00:00', '', NULL, '2020-07-15 13:50:15', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 10, '010201', 'Rabu', '15:00:00', '17:00:00', '', NULL, '2020-07-15 13:50:15', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 10, '010201', 'Kamis', '09:00:00', '11:00:00', '', NULL, '2020-07-15 13:50:15', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 10, '010201', 'Jumat', '15:00:00', '17:00:00', '', NULL, '2020-07-15 13:50:15', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 13, '011301', 'Senin', '14:00:00', '18:00:00', '(Jadwal sementara dalam situasi COVID-19)', NULL, '2020-07-15 13:52:05', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 13, '011301', 'Selasa', '15:00:00', '18:00:00', '(Jadwal sementara dalam situasi COVID-19)', NULL, '2020-07-15 13:52:05', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 13, '011301', 'Rabu', '15:00:00', '18:00:00', '(Jadwal sementara dalam situasi COVID-19)', NULL, '2020-07-15 13:52:05', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 13, '011301', 'Jumat', '15:00:00', '18:00:00', '(Jadwal sementara dalam situasi COVID-19)', NULL, '2020-07-15 13:52:05', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 11, '011101', 'Selasa', '10:00:00', '00:00:00', 'Konfirmasi', NULL, '2020-07-15 15:57:54', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 11, '011101', 'Kamis', '10:00:00', '00:00:00', 'konfirmasi', NULL, '2020-07-15 15:57:54', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 12, '011101', 'Senin', '14:00:00', '16:00:00', '', NULL, '2020-07-15 15:59:02', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 12, '011101', 'Rabu', '13:00:00', '16:00:00', '', NULL, '2020-07-15 15:59:02', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 12, '011101', 'Jumat', '13:00:00', '16:00:00', '', NULL, '2020-07-15 15:59:02', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 15, '012501', 'Senin', '19:00:00', '22:00:00', '', NULL, '2020-07-15 16:00:29', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 15, '012501', 'Rabu', '19:00:00', '22:00:00', '', NULL, '2020-07-15 16:00:29', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 15, '012501', 'Jumat', '19:00:00', '22:00:00', '', NULL, '2020-07-15 16:00:29', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 14, '011401', 'Senin', '19:00:00', '22:00:00', '', NULL, '2020-07-15 16:01:26', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 14, '011401', 'Rabu', '19:00:00', '22:00:00', '', NULL, '2020-07-15 16:01:26', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 14, '011401', 'Jumat', '19:00:00', '22:00:00', '', NULL, '2020-07-15 16:01:26', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 16, '010701', 'Senin', '13:00:00', '17:00:00', '', NULL, '2020-07-15 16:02:48', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL),
(0, 16, '010701', 'Jumat', '13:00:00', '17:00:00', '', NULL, '2020-07-15 16:02:48', '{\"user_id\":\"1\",\"fullname\":\"Amin Lubis\"}', NULL, NULL, 30, 'Loket dibuka', 'on', '', 3068, NULL, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

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

--
-- Indeks untuk tabel `mt_bagian`
--
ALTER TABLE `mt_bagian`
  ADD PRIMARY KEY (`id_mt_bagian`,`kode_bagian`);

--
-- Indeks untuk tabel `mt_dokter`
--
ALTER TABLE `mt_dokter`
  ADD PRIMARY KEY (`id_dokter`);

--
-- Indeks untuk tabel `tc_pesanan`
--
ALTER TABLE `tc_pesanan`
  ADD PRIMARY KEY (`id_tc_pesanan`);

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

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

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `log`
--
ALTER TABLE `log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3072;

--
-- AUTO_INCREMENT untuk tabel `mt_dokter`
--
ALTER TABLE `mt_dokter`
  MODIFY `id_dokter` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT untuk tabel `tc_pesanan`
--
ALTER TABLE `tc_pesanan`
  MODIFY `id_tc_pesanan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=329080;

--
-- AUTO_INCREMENT untuk tabel `tmp_mst_menu`
--
ALTER TABLE `tmp_mst_menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT untuk tabel `token`
--
ALTER TABLE `token`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1719;
COMMIT;

