antrian_rssa 657100161CREATE TABLE `master_klinik` ( `mk_id` int(11) NOT NULL AUTO_INCREMENT, `mk_nama` varchar(50) DEFAULT NULL, `mk_kode` varchar(50) DEFAULT NULL, `mk_shift` int(5) DEFAULT NULL, `mk_jam` int(5) DEFAULT NULL, `mk_quota` int(5) DEFAULT NULL, `mk_quota_bangku` int(5) DEFAULT NULL, `mk_status_shift` int(5) DEFAULT NULL, `mk_aktif` int(5) DEFAULT NULL, PRIMARY KEY (`mk_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 53511100100CREATE TABLE `master_loket` ( `ml_id` int(11) NOT NULL AUTO_INCREMENT, `ml_nama` varchar(50) DEFAULT NULL, `ml_pelayanan` text, `ml_quota_bangku` int(5) DEFAULT NULL, PRIMARY KEY (`ml_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 64260101154CREATE TABLE `master_menu` ( `mm_id` int(11) NOT NULL AUTO_INCREMENT, `mm_nama` varchar(50) DEFAULT NULL, `mm_link` varchar(50) DEFAULT NULL, `mm_icon` varchar(50) DEFAULT NULL, `mm_parent` int(5) DEFAULT NULL, `mm_level` int(5) DEFAULT NULL, `mm_action` varchar(15) DEFAULT NULL, PRIMARY KEY (`mm_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 801748477CREATE TABLE `master_tipeuser` ( `mt_id` int(11) NOT NULL AUTO_INCREMENT, `mt_nama` varchar(20) DEFAULT NULL, PRIMARY KEY (`mt_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 3179126133CREATE TABLE `master_user` ( `mu_id` int(11) NOT NULL AUTO_INCREMENT, `mu_nama_lengkap` varchar(50) DEFAULT NULL, `mu_nama_user` varchar(50) DEFAULT NULL, `mu_password` varchar(50) DEFAULT NULL, `mu_klinik_id` int(11) DEFAULT NULL, `mu_loket_id` int(11) DEFAULT NULL, `mu_tipeuser_id` int(11) DEFAULT NULL, PRIMARY KEY (`mu_id`), KEY `user_loket_FK` (`mu_loket_id`), KEY `user_tipeuser_FK` (`mu_tipeuser_id`), KEY `user_kunjunganklinik_FK` (`mu_klinik_id`), CONSTRAINT `user_kunjunganklinik_FK` FOREIGN KEY (`mu_klinik_id`) REFERENCES `master_klinik` (`mk_id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `user_loket_FK` FOREIGN KEY (`mu_loket_id`) REFERENCES `master_loket` (`ml_id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `user_tipeuser_FK` FOREIGN KEY (`mu_tipeuser_id`) REFERENCES `master_tipeuser` (`mt_id`) ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 500122154210CREATE TABLE `proses_pengunjung` ( `pp_id` int(11) NOT NULL AUTO_INCREMENT, `pp_nomor_antrian` varchar(10) DEFAULT NULL, `pp_shift` int(5) DEFAULT NULL, `pp_tanggal_periksa` datetime DEFAULT NULL, `pp_tanggal_datang` datetime DEFAULT NULL, `pp_posisi_status` int(5) DEFAULT NULL, `pp_pendaftaran_online` varchar(10) DEFAULT NULL, `pp_rekamedik` int(10) DEFAULT NULL, `pp_status` int(5) DEFAULT NULL, `pp_aktif` int(5) DEFAULT NULL, `pp_klinik_id` int(11) DEFAULT NULL, PRIMARY KEY (`pp_id`), KEY `pengunjung_klinik_FK` (`pp_klinik_id`), CONSTRAINT `pengunjung_klinik_FK` FOREIGN KEY (`pp_klinik_id`) REFERENCES `master_klinik` (`mk_id`) ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 210291102138CREATE TABLE `master_user_menu` ( `mum_id` int(11) NOT NULL AUTO_INCREMENT, `mum_tambah` varchar(10) DEFAULT NULL, `mum_ubah` varchar(10) DEFAULT NULL, `mum_hapus` varchar(10) DEFAULT NULL, `mum_lihat` varchar(10) DEFAULT NULL, `mum_tipeuser_id` int(11) DEFAULT NULL, `mum_menu_id` int(11) DEFAULT NULL, PRIMARY KEY (`mum_id`), KEY `usermenu_tipeuser_FK` (`mum_tipeuser_id`), KEY `usermenu_menu_FK` (`mum_menu_id`), CONSTRAINT `usermenu_menu_FK` FOREIGN KEY (`mum_menu_id`) REFERENCES `master_menu` (`mm_id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `usermenu_tipeuser_FK` FOREIGN KEY (`mum_tipeuser_id`) REFERENCES `master_tipeuser` (`mt_id`) ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 334245113114CREATE TABLE `proses_kunjung_klinik` ( `pkk_id` int(11) NOT NULL AUTO_INCREMENT, `pkk_tanggal_datang` datetime DEFAULT NULL, `pkk_tanggal_selesai` datetime DEFAULT NULL, `pkk_klinik_id` int(11) DEFAULT NULL, `pkk_pengunjung_id` int(11) DEFAULT NULL, PRIMARY KEY (`pkk_id`), KEY `kunjunganklinik_pengunjung_FK` (`pkk_klinik_id`), CONSTRAINT `kunjunganklinik_klinik_FK` FOREIGN KEY (`pkk_klinik_id`) REFERENCES `master_klinik` (`mk_id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `kunjunganklinik_pengunjung_FK` FOREIGN KEY (`pkk_klinik_id`) REFERENCES `proses_pengunjung` (`pp_id`) ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 6698111114CREATE TABLE `proses_kunjung_loket` ( `pkl_id` int(11) NOT NULL AUTO_INCREMENT, `pkl_tanggal_datang` datetime DEFAULT NULL, `pkl_tanggal_selesai` datetime DEFAULT NULL, `pkl_loket_id` int(11) DEFAULT NULL, `pkl_pengunjung_id` int(11) DEFAULT NULL, PRIMARY KEY (`pkl_id`), KEY `kunjunganloket_loket_FK` (`pkl_loket_id`), KEY `kunjunganloket_pengunjung_FK` (`pkl_pengunjung_id`), CONSTRAINT `kunjunganloket_loket_FK` FOREIGN KEY (`pkl_loket_id`) REFERENCES `master_loket` (`ml_id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `kunjunganloket_pengunjung_FK` FOREIGN KEY (`pkl_pengunjung_id`) REFERENCES `proses_pengunjung` (`pp_id`) ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 709139107114CREATE TABLE `proses_ruang_tunggu` ( `prt_id` int(11) DEFAULT NULL, `prt_status` int(5) DEFAULT NULL, `prt_tanggal` datetime DEFAULT NULL, `prt_aktif` int(5) DEFAULT NULL, `prt_pengunjung_id` int(5) DEFAULT NULL, KEY `ruangtunggu_pengunjung_FK` (`prt_pengunjung_id`), CONSTRAINT `ruangtunggu_pengunjung_FK` FOREIGN KEY (`prt_pengunjung_id`) REFERENCES `proses_pengunjung` (`pp_id`) ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4