root
182 lines
7.4 KiB
XML
182 lines
7.4 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<schemadesigner version="6.5">
|
|
<source>
|
|
<database charset="utf8mb4" collation="utf8mb4_general_ci">antrian_rssa</database>
|
|
</source>
|
|
<canvas zoom="70">
|
|
<tables>
|
|
<table name="master_klinik" view="colnames">
|
|
<left>65</left>
|
|
<top>7</top>
|
|
<width>100</width>
|
|
<height>161</height>
|
|
<sql_create_table>CREATE 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</sql_create_table>
|
|
</table>
|
|
<table name="master_loket" view="colnames">
|
|
<left>535</left>
|
|
<top>11</top>
|
|
<width>100</width>
|
|
<height>100</height>
|
|
<sql_create_table>CREATE 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</sql_create_table>
|
|
</table>
|
|
<table name="master_menu" view="colnames">
|
|
<left>64</left>
|
|
<top>260</top>
|
|
<width>101</width>
|
|
<height>154</height>
|
|
<sql_create_table>CREATE 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</sql_create_table>
|
|
</table>
|
|
<table name="master_tipeuser" view="colnames">
|
|
<left>80</left>
|
|
<top>174</top>
|
|
<width>84</width>
|
|
<height>77</height>
|
|
<sql_create_table>CREATE 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</sql_create_table>
|
|
</table>
|
|
<table name="master_user" view="colnames">
|
|
<left>317</left>
|
|
<top>9</top>
|
|
<width>126</width>
|
|
<height>133</height>
|
|
<sql_create_table>CREATE 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</sql_create_table>
|
|
</table>
|
|
<table name="proses_pengunjung" view="colnames">
|
|
<left>500</left>
|
|
<top>122</top>
|
|
<width>154</width>
|
|
<height>210</height>
|
|
<sql_create_table>CREATE 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</sql_create_table>
|
|
</table>
|
|
<table name="master_user_menu" view="colnames">
|
|
<left>210</left>
|
|
<top>291</top>
|
|
<width>102</width>
|
|
<height>138</height>
|
|
<sql_create_table>CREATE 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</sql_create_table>
|
|
</table>
|
|
<table name="proses_kunjung_klinik" view="colnames">
|
|
<left>334</left>
|
|
<top>245</top>
|
|
<width>113</width>
|
|
<height>114</height>
|
|
<sql_create_table>CREATE 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</sql_create_table>
|
|
</table>
|
|
<table name="proses_kunjung_loket" view="colnames">
|
|
<left>669</left>
|
|
<top>8</top>
|
|
<width>111</width>
|
|
<height>114</height>
|
|
<sql_create_table>CREATE 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</sql_create_table>
|
|
</table>
|
|
<table name="proses_ruang_tunggu" view="colnames">
|
|
<left>709</left>
|
|
<top>139</top>
|
|
<width>107</width>
|
|
<height>114</height>
|
|
<sql_create_table>CREATE 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</sql_create_table>
|
|
</table>
|
|
</tables>
|
|
</canvas>
|
|
</schemadesigner> |