Letakkan berkas disini

SQL upload ( 0 ) x -

Pengaturan Terkait dengan Halaman Klik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueri Press Enter to execute query
ascending
descending
Order:
Men-Debug SQL
Jumlah
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Tampilkan Buka Show trace Hide trace Jumlah Time taken
Bookmark
Segarkan
Tambah
Tidak ada penanda
Tambah bookmark
Opsi
Kembalikan nilai bawaan





Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Bookmarks Kueri gagal Basis data : Waktu eksekusi kueri :
Belum ada nama *
v Show/Hide tables list View in fullscreen Tambahkan tabel dari database lainya New page Buka halaman Simpan halaman Simpan halaman sebagai Delete pages Buat tabel Create relationship Pilih kolom untuk ditampilkan Muat ulang Bantuan Tautan angular / Tautan langsung Lekatkan kepada kisi v Small/Big All Toggle small/big Toggle relationship lines Export schema > Pindahkan Menu > Sematkan teks
v v
Number of tables: 0
v mlite aturan_pakai
* tgl_perawatan : date
* jam : time
* no_rawat : varchar(17)
* kode_brng : varchar(15)
* aturan : varchar(150)
v mlite bahasa_pasien
* id : int(11)
* nama_bahasa : varchar(30)
v mlite bangsal
* kd_bangsal : char(5)
* nm_bangsal : varchar(30)
* status : enum('0','1')
v mlite bank
* namabank : varchar(50)
v mlite barcode
* id : int(11)
* barcode : varchar(25)
v mlite beri_obat_operasi
* no_rawat : varchar(17)
* tanggal : datetime
* kd_obat : varchar(15)
* hargasatuan : double
* jumlah : double
v mlite berkas_digital_perawatan
* no_rawat : varchar(17)
* kode : varchar(10)
* lokasi_file : varchar(600)
v mlite bidang
* nama : varchar(15)
v mlite booking_operasi
* no_rawat : varchar(17)
* kode_paket : varchar(15)
* tanggal : date
* jam_mulai : time
* jam_selesai : time
* status : enum('Menunggu','Proses Operasi','Selesai')
* kd_dokter : varchar(20)
v mlite booking_periksa
* no_booking : varchar(17)
* tanggal : date
* nama : varchar(40)
* alamat : varchar(200)
* no_telp : varchar(40)
* email : varchar(50)
* kd_poli : varchar(5)
* tambahan_pesan : varchar(400)
* status : enum('Diterima','Ditolak','Belum Dibalas')
* tanggal_booking : datetime
v mlite booking_periksa_balasan
* no_booking : varchar(17)
* balasan : text
v mlite booking_periksa_diterima
* no_booking : varchar(17)
* no_rkm_medis : varchar(15)
v mlite booking_registrasi
* tanggal_booking : date
* jam_booking : time
* no_rkm_medis : varchar(15)
* tanggal_periksa : date
* kd_dokter : varchar(20)
* kd_poli : varchar(5)
* no_reg : varchar(8)
* kd_pj : char(3)
* limit_reg : int(1)
* waktu_kunjungan : datetime
* status : enum('Terdaftar','Belum','Batal','Dokter Berhalangan')
v mlite bpjs_prb
* no_sep : varchar(40)
* prb : varchar(50)
v mlite bridging_sep
* no_sep : varchar(40)
* no_rawat : varchar(17)
* tglsep : date
* tglrujukan : date
* no_rujukan : varchar(40)
* kdppkrujukan : varchar(12)
* nmppkrujukan : varchar(200)
* kdppkpelayanan : varchar(12)
* nmppkpelayanan : varchar(200)
* jnspelayanan : enum('1','2')
* catatan : varchar(100)
* diagawal : varchar(10)
* nmdiagnosaawal : varchar(400)
* kdpolitujuan : varchar(15)
* nmpolitujuan : varchar(50)
* klsrawat : enum('1','2','3')
* klsnaik : enum('','1','2')
* pembiayaan : enum('','1','2','3')
* pjnaikkelas : varchar(100)
* lakalantas : enum('0','1')
* user : varchar(25)
* nomr : varchar(15)
* nama_pasien : varchar(100)
* tanggal_lahir : date
* peserta : varchar(100)
* jkel : enum('L','P')
* no_kartu : varchar(25)
* tglpulang : datetime
* asal_rujukan : enum('1. Faskes 1','2. Faskes 2(RS)')
* eksekutif : enum('0. Tidak','1.Ya')
* cob : enum('0. Tidak','1.Ya')
* notelep : varchar(40)
* katarak : enum('0. Tidak','1.Ya')
* tglkkl : date
* keterangankkl : varchar(100)
* suplesi : enum('0. Tidak','1.Ya')
* no_sep_suplesi : varchar(40)
* kdprop : varchar(10)
* nmprop : varchar(50)
* kdkab : varchar(10)
* nmkab : varchar(50)
* kdkec : varchar(10)
* nmkec : varchar(50)
* noskdp : varchar(40)
* kddpjp : varchar(10)
* nmdpdjp : varchar(100)
* tujuankunjungan : enum('0','1','2')
* flagprosedur : enum('','0','1')
* penunjang : enum('','1','2','3','4','5','6','7','8','9','10','11','12')
* asesmenpelayanan : enum('','1','2','3','4')
* kddpjplayanan : varchar(10)
* nmdpjplayanan : varchar(100)
v mlite bridging_sep_internal
* no_sep : varchar(40)
* no_rawat : varchar(17)
* tglsep : date
* tglrujukan : date
* no_rujukan : varchar(40)
* kdppkrujukan : varchar(12)
* nmppkrujukan : varchar(200)
* kdppkpelayanan : varchar(12)
* nmppkpelayanan : varchar(200)
* jnspelayanan : enum('1','2')
* catatan : varchar(100)
* diagawal : varchar(10)
* nmdiagnosaawal : varchar(400)
* kdpolitujuan : varchar(15)
* nmpolitujuan : varchar(50)
* klsrawat : enum('1','2','3')
* klsnaik : enum('','1','2')
* pembiayaan : enum('','1','2','3')
* pjnaikkelas : varchar(100)
* lakalantas : enum('0','1')
* user : varchar(25)
* nomr : varchar(15)
* nama_pasien : varchar(100)
* tanggal_lahir : date
* peserta : varchar(100)
* jkel : enum('L','P')
* no_kartu : varchar(25)
* tglpulang : datetime
* asal_rujukan : enum('1. Faskes 1','2. Faskes 2(RS)')
* eksekutif : enum('0. Tidak','1.Ya')
* cob : enum('0. Tidak','1.Ya')
* notelep : varchar(40)
* katarak : enum('0. Tidak','1.Ya')
* tglkkl : date
* keterangankkl : varchar(100)
* suplesi : enum('0. Tidak','1.Ya')
* no_sep_suplesi : varchar(40)
* kdprop : varchar(10)
* nmprop : varchar(50)
* kdkab : varchar(10)
* nmkab : varchar(50)
* kdkec : varchar(10)
* nmkec : varchar(50)
* noskdp : varchar(40)
* kddpjp : varchar(10)
* nmdpdjp : varchar(100)
* tujuankunjungan : enum('0','1','2')
* flagprosedur : enum('','0','1')
* penunjang : enum('','1','2','3','4','5','6','7','8','9','10','11','12')
* asesmenpelayanan : enum('','1','2','3','4')
* kddpjplayanan : varchar(10)
* nmdpjplayanan : varchar(100)
v mlite bridging_surat_kontrol_bpjs
* no_sep : varchar(40)
* tgl_surat : date
* no_surat : varchar(40)
* tgl_rencana : date
* kd_dokter_bpjs : varchar(20)
* nm_dokter_bpjs : varchar(50)
* kd_poli_bpjs : varchar(15)
* nm_poli_bpjs : varchar(40)
v mlite bridging_surat_pri_bpjs
* no_rawat : varchar(17)
* no_kartu : varchar(25)
* tgl_surat : date
* no_surat : varchar(40)
* tgl_rencana : date
* kd_dokter_bpjs : varchar(20)
* nm_dokter_bpjs : varchar(50)
* kd_poli_bpjs : varchar(15)
* nm_poli_bpjs : varchar(40)
* diagnosa : varchar(130)
* no_sep : varchar(40)
v mlite cacat_fisik
* id : int(11)
* nama_cacat : varchar(30)
v mlite catatan_perawatan
* tanggal : date
* jam : time
* no_rawat : varchar(17)
* kd_dokter : varchar(20)
* catatan : varchar(700)
v mlite databarang
* kode_brng : varchar(15)
* nama_brng : varchar(80)
* kode_satbesar : char(4)
* kode_sat : char(4)
* letak_barang : varchar(50)
* dasar : double
* h_beli : double
* ralan : double
* kelas1 : double
* kelas2 : double
* kelas3 : double
* utama : double
* vip : double
* vvip : double
* beliluar : double
* jualbebas : double
* karyawan : double
* stokminimal : double
* kdjns : char(4)
* isi : double
* kapasitas : double
* expire : date
* status : enum('0','1')
* kode_industri : char(5)
* kode_kategori : char(4)
* kode_golongan : char(4)
v mlite departemen
* dep_id : char(4)
* nama : varchar(25)
v mlite detail_pemberian_obat
* tgl_perawatan : date
* jam : time
* no_rawat : varchar(17)
* kode_brng : varchar(15)
* h_beli : double
* biaya_obat : double
* jml : double
* embalase : double
* tuslah : double
* total : double
* status : enum('Ralan','Ranap')
* kd_bangsal : char(5)
* no_batch : varchar(20)
* no_faktur : varchar(20)
v mlite detail_periksa_lab
* no_rawat : varchar(17)
* kd_jenis_prw : varchar(15)
* tgl_periksa : date
* jam : time
* id_template : int(11)
* nilai : varchar(60)
* nilai_rujukan : varchar(30)
* keterangan : varchar(60)
* bagian_rs : double
* bhp : double
* bagian_perujuk : double
* bagian_dokter : double
* bagian_laborat : double
* kso : double
* menejemen : double
* biaya_item : double
v mlite diagnosa_pasien
* no_rawat : varchar(17)
* kd_penyakit : varchar(10)
* status : enum('Ralan','Ranap')
* prioritas : tinyint(4)
* status_penyakit : enum('Lama','Baru')
v mlite dokter
* kd_dokter : varchar(20)
* nm_dokter : varchar(50)
* jk : enum('L','P')
* tmp_lahir : varchar(20)
* tgl_lahir : date
* gol_drh : enum('A','B','O','AB','-')
* agama : varchar(12)
* almt_tgl : varchar(60)
* no_telp : varchar(13)
* stts_nikah : enum('BELUM MENIKAH','MENIKAH','JANDA','DUDHA','JOMBLO')
* kd_sps : char(5)
* alumni : varchar(60)
* no_ijn_praktek : varchar(40)
* status : enum('0','1')
v mlite dpjp_ranap
* no_rawat : varchar(17)
* kd_dokter : varchar(20)
v mlite emergency_index
* kode_emergency : varchar(3)
* nama_emergency : varchar(200)
* indek : tinyint(4)
v mlite gambar_radiologi
* no_rawat : varchar(17)
* tgl_periksa : date
* jam : time
* lokasi_gambar : varchar(500)
v mlite golongan_barang
* kode : char(4)
* nama : varchar(30)
v mlite gudangbarang
* kode_brng : varchar(15)
* kd_bangsal : char(5)
* stok : double
* no_batch : varchar(20)
* no_faktur : varchar(20)
v mlite hasil_radiologi
* no_rawat : varchar(17)
* tgl_periksa : date
* jam : time
* hasil : text
v mlite icd9
* kode : varchar(8)
* deskripsi_panjang : varchar(250)
* deskripsi_pendek : varchar(40)
v mlite industrifarmasi
* kode_industri : char(5)
* nama_industri : varchar(50)
* alamat : varchar(50)
* kota : varchar(20)
* no_telp : varchar(20)
v mlite jabatan
* kd_jbtn : char(4)
* nm_jbtn : varchar(25)
v mlite jadwal
* kd_dokter : varchar(20)
* hari_kerja : enum('SENIN','SELASA','RABU','KAMIS','JUMAT','SABTU','AKHAD')
* jam_mulai : time
* jam_selesai : time
* kd_poli : char(5)
* kuota : int(11)
v mlite jadwal_pegawai
* id : int(11)
* tahun : year(4)
* bulan : enum('01','02','03','04','05','06','07','08','09','10','11','12')
* h1 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h2 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h3 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h4 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h5 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h6 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h7 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h8 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h9 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h10 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h11 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h12 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h13 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h14 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h15 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h16 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h17 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h18 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h19 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h20 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h21 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h22 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h23 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h24 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h25 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h26 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h27 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h28 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h29 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h30 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h31 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
v mlite jadwal_tambahan
* id : int(11)
* tahun : year(4)
* bulan : enum('01','02','03','04','05','06','07','08','09','10','11','12')
* h1 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h2 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h3 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h4 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h5 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h6 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h7 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h8 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h9 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h10 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h11 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h12 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h13 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h14 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h15 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h16 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h17 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h18 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h19 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h20 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h21 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h22 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h23 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h24 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h25 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h26 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h27 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h28 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h29 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h30 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
* h31 : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10','')
v mlite jam_jaga
* no_id : int(11)
* dep_id : char(4)
* shift : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10')
* jam_masuk : time
* jam_pulang : time
v mlite jam_masuk
* shift : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10')
* jam_masuk : time
* jam_pulang : time
v mlite jenis
* kdjns : char(4)
* nama : varchar(30)
* keterangan : varchar(50)
v mlite jnj_jabatan
* kode : varchar(10)
* nama : varchar(50)
* tnj : double
* indek : tinyint(4)
v mlite jns_perawatan
* kd_jenis_prw : varchar(15)
* nm_perawatan : varchar(80)
* kd_kategori : char(5)
* material : double
* bhp : double
* tarif_tindakandr : double
* tarif_tindakanpr : double
* kso : double
* menejemen : double
* total_byrdr : double
* total_byrpr : double
* total_byrdrpr : double
* kd_pj : char(3)
* kd_poli : char(5)
* status : enum('0','1')
v mlite jns_perawatan_inap
* kd_jenis_prw : varchar(15)
* nm_perawatan : varchar(80)
* kd_kategori : char(5)
* material : double
* bhp : double
* tarif_tindakandr : double
* tarif_tindakanpr : double
* kso : double
* menejemen : double
* total_byrdr : double
* total_byrpr : double
* total_byrdrpr : double
* kd_pj : char(3)
* kd_bangsal : char(5)
* status : enum('0','1')
* kelas : enum('-','Kelas 1','Kelas 2','Kelas 3','Kelas Utama','Kelas VIP','Kelas VVIP')
v mlite jns_perawatan_lab
* kd_jenis_prw : varchar(15)
* nm_perawatan : varchar(80)
* bagian_rs : double
* bhp : double
* tarif_perujuk : double
* tarif_tindakan_dokter : double
* tarif_tindakan_petugas : double
* kso : double
* menejemen : double
* total_byr : double
* kd_pj : char(3)
* status : enum('0','1')
* kelas : enum('-','Rawat Jalan','Kelas 1','Kelas 2','Kelas 3','Kelas Utama','Kelas VIP','Kelas VVIP')
* kategori : enum('PK','PA')
v mlite jns_perawatan_radiologi
* kd_jenis_prw : varchar(15)
* nm_perawatan : varchar(80)
* bagian_rs : double
* bhp : double
* tarif_perujuk : double
* tarif_tindakan_dokter : double
* tarif_tindakan_petugas : double
* kso : double
* menejemen : double
* total_byr : double
* kd_pj : char(3)
* status : enum('0','1')
* kelas : enum('-','Rawat Jalan','Kelas 1','Kelas 2','Kelas 3','Kelas Utama','Kelas VIP','Kelas VVIP')
v mlite kabupaten
* kd_kab : int(11)
* nm_kab : varchar(60)
v mlite kamar
* kd_kamar : varchar(15)
* kd_bangsal : char(5)
* trf_kamar : double
* status : enum('ISI','KOSONG','DIBERSIHKAN','DIBOOKING')
* kelas : enum('Kelas 1','Kelas 2','Kelas 3','Kelas Utama','Kelas VIP','Kelas VVIP')
* statusdata : enum('0','1')
v mlite kamar_inap
* no_rawat : varchar(17)
* kd_kamar : varchar(15)
* trf_kamar : double
* diagnosa_awal : varchar(100)
* diagnosa_akhir : varchar(100)
* tgl_masuk : date
* jam_masuk : time
* tgl_keluar : date
* jam_keluar : time
* lama : double
* ttl_biaya : double
* stts_pulang : enum('Sehat','Rujuk','APS','+','Meninggal','Sembuh','Membaik','Pulang Paksa','-','Pindah Kamar','Status Belum Lengkap','Atas Persetujuan Dokter','Atas Permintaan Sendiri','Lain-lain')
v mlite kategori_barang
* kode : char(4)
* nama : varchar(30)
v mlite kategori_penyakit
* kd_ktg : varchar(8)
* nm_kategori : varchar(30)
* ciri_umum : varchar(200)
v mlite kategori_perawatan
* kd_kategori : char(5)
* nm_kategori : varchar(30)
v mlite kecamatan
* kd_kec : int(11)
* nm_kec : varchar(60)
v mlite kelompok_jabatan
* kode_kelompok : varchar(3)
* nama_kelompok : varchar(100)
* indek : tinyint(4)
v mlite kelurahan
* kd_kel : varchar(11)
* nm_kel : varchar(60)
v mlite kodesatuan
* kode_sat : char(4)
* satuan : varchar(30)
v mlite laporan_operasi
* no_rawat : varchar(17)
* tanggal : datetime
* diagnosa_preop : varchar(100)
* diagnosa_postop : varchar(100)
* jaringan_dieksekusi : varchar(100)
* selesaioperasi : datetime
* permintaan_pa : enum('Ya','Tidak')
* laporan_operasi : text
v mlite maping_dokter_dpjpvclaim
* kd_dokter : varchar(20)
* kd_dokter_bpjs : varchar(20)
* nm_dokter_bpjs : varchar(50)
v mlite maping_poli_bpjs
* kd_poli_rs : varchar(5)
* kd_poli_bpjs : varchar(15)
* nm_poli_bpjs : varchar(40)
v mlite master_aturan_pakai
* aturan : varchar(150)
v mlite master_berkas_digital
* kode : varchar(10)
* nama : varchar(100)
v mlite metode_racik
* kd_racik : varchar(3)
* nm_racik : varchar(30)
v mlite mlite_akun_kegiatan
* id : int(11)
* kegiatan : varchar(200)
* kd_rek : varchar(20)
v mlite mlite_antrian_loket
* kd : int(50)
* type : varchar(50)
* noantrian : varchar(50)
* no_rkm_medis : varchar(50)
* postdate : date
* start_time : time
* end_time : time
* status : varchar(10)
* loket : varchar(10)
v mlite mlite_antrian_referensi
* tanggal_periksa : date
* nomor_kartu : varchar(50)
* nomor_referensi : varchar(50)
* jenis_kunjungan : varchar(10)
* status_kirim : varchar(20)
v mlite mlite_antrian_referensi_batal
* tanggal_batal : date
* nomor_referensi : varchar(50)
* keterangan : varchar(250)
v mlite mlite_antrian_referensi_taskid
* tanggal_periksa : date
* nomor_referensi : varchar(50)
* taskid : varchar(50)
* waktu : varchar(50)
v mlite mlite_apamregister
* nama_lengkap : varchar(225)
* email : varchar(225)
* nomor_ktp : varchar(225)
* nomor_telepon : varchar(225)
v mlite mlite_billing
* id_billing : int(11)
* kd_billing : varchar(100)
* no_rawat : varchar(17)
* jumlah_total : int(100)
* potongan : int(100)
* jumlah_harus_bayar : int(100)
* jumlah_bayar : int(100)
* tgl_billing : date
* jam_billing : time
* id_user : int(11)
* keterangan : varchar(100)
v mlite mlite_detailjurnal
* no_jurnal : varchar(20)
* kd_rek : varchar(15)
* debet : double
* kredit : double
v mlite mlite_duitku
* id : int(10)
* tanggal : datetime
* no_rkm_medis : varchar(15)
* paymentUrl : varchar(255)
* merchantCode : varchar(255)
* reference : varchar(255)
* vaNumber : varchar(255)
* amount : varchar(255)
* statusCode : varchar(255)
* statusMessage : varchar(255)
v mlite mlite_geolocation_presensi
* id : int(11)
* tanggal : date
* latitude : varchar(200)
* longitude : varchar(200)
v mlite mlite_jurnal
* no_jurnal : varchar(20)
* no_bukti : varchar(20)
* tgl_jurnal : date
* jenis : enum('U','P')
* keterangan : varchar(350)
v mlite mlite_login_attempts
* ip : text
* attempts : int(100)
* expires : int(100)
v mlite mlite_modules
* id : int(11)
* dir : text
* sequence : text
v mlite mlite_news
* id : int(11)
* title : varchar(225)
* slug : varchar(225)
* user_id : int(11)
* content : text
* intro : text
* cover_photo : text
* status : int(11)
* comments : int(11)
* markdown : int(11)
* published_at : int(11)
* updated_at : int(11)
* created_at : int(11)
v mlite mlite_news_tags
* id : int(11)
* name : varchar(225)
* slug : varchar(225)
v mlite mlite_news_tags_relationship
* news_id : int(11)
* tag_id : int(11)
v mlite mlite_notifications
* id : int(11)
* judul : varchar(250)
* pesan : text
* tanggal : timestamp
* no_rkm_medis : varchar(255)
* status : varchar(250)
v mlite mlite_pasien_galleries
* id : int(11)
* name : text
* slug : text
* img_per_page : varchar(50)
* sort : varchar(50)
v mlite mlite_pasien_galleries_items
* id : int(11)
* gallery : varchar(50)
* src : text
* title : varchar(50)
v mlite mlite_pengaduan
* id : varchar(15)
* tanggal : datetime
* no_rkm_medis : varchar(15)
* pesan : varchar(255)
v mlite mlite_pengaduan_detail
* id : int(10)
* pengaduan_id : varchar(15)
* tanggal : datetime
* no_rkm_medis : varchar(15)
* pesan : varchar(225)
v mlite mlite_rekening
* kd_rek : varchar(15)
* nm_rek : varchar(100)
* tipe : enum('N','M','R')
* balance : enum('D','K')
* level : enum('0','1')
v mlite mlite_rekeningtahun
* thn : year(4)
* kd_rek : varchar(15)
* saldo_awal : double
v mlite mlite_remember_me
* id : int(11)
* token : text
* user_id : int(10)
* expiry : int(100)
v mlite mlite_settings
* id : int(11)
* module : text
* field : text
* value : text
v mlite mlite_subrekening
* kd_rek : varchar(15)
* kd_rek2 : varchar(15)
v mlite mlite_temporary
* temp1 : text
* temp2 : text
* temp3 : text
* temp4 : text
* temp5 : text
* temp6 : text
* temp7 : text
* temp8 : text
* temp9 : text
* temp10 : text
* temp11 : text
* temp12 : text
* temp13 : text
* temp14 : text
* temp15 : text
* temp16 : text
* temp17 : text
* temp18 : text
* temp19 : text
* temp20 : text
* temp21 : text
* temp22 : text
* temp23 : text
* temp24 : text
* temp25 : text
* temp26 : text
* temp27 : text
* temp28 : text
* temp29 : text
* temp30 : text
* temp31 : text
* temp32 : text
* temp33 : text
* temp34 : text
* temp35 : text
* temp36 : text
* temp37 : text
* temp38 : text
* temp39 : text
* temp40 : text
* temp41 : text
* temp42 : text
* temp43 : text
* temp44 : text
* temp45 : text
* temp46 : text
* temp47 : text
* temp48 : text
* temp49 : text
* temp50 : text
* temp51 : text
* temp52 : text
* temp53 : text
* temp54 : text
* temp55 : text
* temp56 : text
* temp57 : text
* temp58 : text
* temp59 : text
* temp60 : text
* temp61 : text
* temp62 : text
* temp63 : text
* temp64 : text
* temp65 : text
* temp66 : text
* temp67 : text
* temp68 : text
* temp69 : text
* temp70 : text
* temp71 : text
* temp72 : text
* temp73 : text
* temp74 : text
* temp75 : text
* temp76 : text
* temp77 : text
* temp78 : text
* temp79 : text
* temp80 : text
* temp81 : text
* temp82 : text
* temp83 : text
* temp84 : text
* temp85 : text
* temp86 : text
* temp87 : text
* temp88 : text
* temp89 : text
* temp90 : text
* temp91 : text
* temp92 : text
* temp93 : text
* temp94 : text
* temp95 : text
* temp96 : text
* temp97 : text
* temp98 : text
* temp99 : text
* temp100 : text
v mlite mlite_users
* id : int(11)
* username : text
* fullname : text
* description : text
* password : text
* avatar : text
* email : text
* role : varchar(100)
* cap : varchar(100)
* access : varchar(500)
v mlite mlite_vedika
* id : int(11)
* tanggal : date
* no_rkm_medis : varchar(6)
* no_rawat : varchar(100)
* tgl_registrasi : varchar(100)
* nosep : varchar(100)
* jenis : varchar(100)
* status : varchar(100)
* username : varchar(100)
v mlite mlite_vedika_feedback
* id : int(11)
* nosep : varchar(100)
* tanggal : date
* catatan : text
* username : varchar(100)
v mlite mutasi_berkas
* no_rawat : varchar(17)
* status : enum('Sudah Dikirim','Sudah Diterima','Sudah Kembali','Tidak Ada','Masuk Ranap')
* dikirim : datetime
* diterima : datetime
* kembali : datetime
* tidakada : datetime
* ranap : datetime
v mlite obatbhp_ok
* kd_obat : varchar(15)
* nm_obat : varchar(50)
* kode_sat : char(4)
* hargasatuan : double
v mlite operasi
* no_rawat : varchar(17)
* tgl_operasi : datetime
* jenis_anasthesi : varchar(8)
* kategori : enum('-','Khusus','Besar','Sedang','Kecil','Elektive','Emergency')
* operator1 : varchar(20)
* operator2 : varchar(20)
* operator3 : varchar(20)
* asisten_operator1 : varchar(20)
* asisten_operator2 : varchar(20)
* asisten_operator3 : varchar(20)
* instrumen : varchar(20)
* dokter_anak : varchar(20)
* perawaat_resusitas : varchar(20)
* dokter_anestesi : varchar(20)
* asisten_anestesi : varchar(20)
* asisten_anestesi2 : varchar(20)
* bidan : varchar(20)
* bidan2 : varchar(20)
* bidan3 : varchar(20)
* perawat_luar : varchar(20)
* omloop : varchar(20)
* omloop2 : varchar(20)
* omloop3 : varchar(20)
* omloop4 : varchar(20)
* omloop5 : varchar(20)
* dokter_pjanak : varchar(20)
* dokter_umum : varchar(20)
* kode_paket : varchar(15)
* biayaoperator1 : double
* biayaoperator2 : double
* biayaoperator3 : double
* biayaasisten_operator1 : double
* biayaasisten_operator2 : double
* biayaasisten_operator3 : double
* biayainstrumen : double
* biayadokter_anak : double
* biayaperawaat_resusitas : double
* biayadokter_anestesi : double
* biayaasisten_anestesi : double
* biayaasisten_anestesi2 : double
* biayabidan : double
* biayabidan2 : double
* biayabidan3 : double
* biayaperawat_luar : double
* biayaalat : double
* biayasewaok : double
* akomodasi : double
* bagian_rs : double
* biaya_omloop : double
* biaya_omloop2 : double
* biaya_omloop3 : double
* biaya_omloop4 : double
* biaya_omloop5 : double
* biayasarpras : double
* biaya_dokter_pjanak : double
* biaya_dokter_umum : double
* status : enum('Ranap','Ralan')
v mlite opname
* kode_brng : varchar(15)
* h_beli : double
* tanggal : date
* stok : double
* real : double
* selisih : double
* nomihilang : double
* lebih : double
* nomilebih : double
* keterangan : varchar(60)
* kd_bangsal : char(5)
* no_batch : varchar(20)
* no_faktur : varchar(20)
v mlite paket_operasi
* kode_paket : varchar(15)
* nm_perawatan : varchar(80)
* kategori : enum('Kebidanan','Operasi')
* operator1 : double
* operator2 : double
* operator3 : double
* asisten_operator1 : double
* asisten_operator2 : double
* asisten_operator3 : double
* instrumen : double
* dokter_anak : double
* perawaat_resusitas : double
* dokter_anestesi : double
* asisten_anestesi : double
* asisten_anestesi2 : double
* bidan : double
* bidan2 : double
* bidan3 : double
* perawat_luar : double
* sewa_ok : double
* alat : double
* akomodasi : double
* bagian_rs : double
* omloop : double
* omloop2 : double
* omloop3 : double
* omloop4 : double
* omloop5 : double
* sarpras : double
* dokter_pjanak : double
* dokter_umum : double
* kd_pj : char(3)
* status : enum('0','1')
* kelas : enum('-','Rawat Jalan','Kelas 1','Kelas 2','Kelas 3','Kelas Utama','Kelas VIP','Kelas VVIP')
v mlite pasien
* no_rkm_medis : varchar(15)
* nm_pasien : varchar(40)
* no_ktp : varchar(20)
* jk : enum('L','P')
* tmp_lahir : varchar(15)
* tgl_lahir : date
* nm_ibu : varchar(40)
* alamat : varchar(200)
* gol_darah : enum('A','B','O','AB','-')
* pekerjaan : varchar(35)
* stts_nikah : enum('BELUM MENIKAH','MENIKAH','JANDA','DUDHA','JOMBLO')
* agama : varchar(12)
* tgl_daftar : date
* no_tlp : varchar(40)
* umur : varchar(20)
* pnd : enum('TS','TK','SD','SMP','SMA','SLTA/SEDERAJAT','D1','D2','D3','D4','S1','S2','S3','-')
* keluarga : enum('AYAH','IBU','ISTRI','SUAMI','SAUDARA','ANAK')
* namakeluarga : varchar(50)
* kd_pj : char(3)
* no_peserta : varchar(25)
* kd_kel : int(11)
* kd_kec : int(11)
* kd_kab : int(11)
* pekerjaanpj : varchar(35)
* alamatpj : varchar(100)
* kelurahanpj : varchar(60)
* kecamatanpj : varchar(60)
* kabupatenpj : varchar(60)
* perusahaan_pasien : varchar(8)
* suku_bangsa : int(11)
* bahasa_pasien : int(11)
* cacat_fisik : int(11)
* email : varchar(50)
* nip : varchar(30)
* kd_prop : int(11)
* propinsipj : varchar(30)
v mlite pegawai
* id : int(11)
* nik : varchar(20)
* nama : varchar(50)
* jk : enum('Pria','Wanita')
* jbtn : varchar(25)
* jnj_jabatan : varchar(5)
* kode_kelompok : varchar(3)
* kode_resiko : varchar(3)
* kode_emergency : varchar(3)
* departemen : char(4)
* bidang : varchar(15)
* stts_wp : char(5)
* stts_kerja : char(3)
* npwp : varchar(15)
* pendidikan : varchar(80)
* gapok : double
* tmp_lahir : varchar(20)
* tgl_lahir : date
* alamat : varchar(60)
* kota : varchar(20)
* mulai_kerja : date
* ms_kerja : enum('<1','PT','FT>1')
* indexins : char(4)
* bpd : varchar(50)
* rekening : varchar(25)
* stts_aktif : enum('AKTIF','CUTI','KELUAR','TENAGA LUAR')
* wajibmasuk : tinyint(2)
* pengurang : double
* indek : tinyint(4)
* mulai_kontrak : date
* cuti_diambil : int(11)
* dankes : double
* photo : varchar(500)
* no_ktp : varchar(20)
v mlite pemeriksaan_ralan
* no_rawat : varchar(17)
* tgl_perawatan : date
* jam_rawat : time
* suhu_tubuh : char(5)
* tensi : char(8)
* nadi : char(3)
* respirasi : char(3)
* tinggi : char(5)
* berat : char(5)
* spo2 : char(3)
* gcs : varchar(10)
* kesadaran : enum('Compos Mentis','Somnolence','Sopor','Coma')
* keluhan : varchar(400)
* pemeriksaan : varchar(400)
* alergi : varchar(50)
* imun_ke : enum('-','1','2','3','4','5','6','7','8','10','11','12','13')
* rtl : varchar(400)
* penilaian : varchar(400)
* instruksi : varchar(400)
* evaluasi : varchar(400)
* nip : varchar(20)
v mlite pemeriksaan_ranap
* no_rawat : varchar(17)
* tgl_perawatan : date
* jam_rawat : time
* suhu_tubuh : char(5)
* tensi : char(8)
* nadi : char(3)
* respirasi : char(3)
* tinggi : char(5)
* berat : char(5)
* spo2 : char(3)
* gcs : varchar(10)
* kesadaran : enum('Compos Mentis','Somnolence','Sopor','Coma')
* keluhan : varchar(400)
* pemeriksaan : varchar(400)
* alergi : varchar(50)
* penilaian : varchar(400)
* rtl : varchar(400)
* instruksi : varchar(400)
* evaluasi : varchar(400)
* nip : varchar(20)
v mlite pendidikan
* tingkat : varchar(80)
* indek : tinyint(4)
* gapok1 : double
* kenaikan : double
* maksimal : int(11)
v mlite pengajuan_cuti
* no_pengajuan : varchar(17)
* tanggal : date
* tanggal_awal : date
* tanggal_akhir : date
* nik : varchar(20)
* urgensi : enum('Tahunan','Besar','Sakit','Bersalin','Alasan Penting','Keterangan Lainnya')
* alamat : varchar(100)
* jumlah : int(11)
* kepentingan : varchar(70)
* nik_pj : varchar(20)
* status : enum('Proses Pengajuan','Disetujui','Ditolak')
v mlite penjab
* kd_pj : char(3)
* png_jawab : varchar(30)
* nama_perusahaan : varchar(60)
* alamat_asuransi : varchar(130)
* no_telp : varchar(40)
* attn : varchar(60)
v mlite penyakit
* kd_penyakit : varchar(10)
* nm_penyakit : varchar(100)
* ciri_ciri : text
* keterangan : varchar(60)
* kd_ktg : varchar(8)
* status : enum('Menular','Tidak Menular')
v mlite periksa_lab
* no_rawat : varchar(17)
* nip : varchar(20)
* kd_jenis_prw : varchar(15)
* tgl_periksa : date
* jam : time
* dokter_perujuk : varchar(20)
* bagian_rs : double
* bhp : double
* tarif_perujuk : double
* tarif_tindakan_dokter : double
* tarif_tindakan_petugas : double
* kso : double
* menejemen : double
* biaya : double
* kd_dokter : varchar(20)
* status : enum('Ralan','Ranap')
v mlite periksa_radiologi
* no_rawat : varchar(17)
* nip : varchar(20)
* kd_jenis_prw : varchar(15)
* tgl_periksa : date
* jam : time
* dokter_perujuk : varchar(20)
* bagian_rs : double
* bhp : double
* tarif_perujuk : double
* tarif_tindakan_dokter : double
* tarif_tindakan_petugas : double
* kso : double
* menejemen : double
* biaya : double
* kd_dokter : varchar(20)
* status : enum('Ranap','Ralan')
* proyeksi : varchar(50)
* kV : varchar(10)
* mAS : varchar(10)
* FFD : varchar(10)
* BSF : varchar(10)
* inak : varchar(10)
* jml_penyinaran : varchar(10)
* dosis : varchar(20)
v mlite permintaan_detail_permintaan_lab
* noorder : varchar(16)
* kd_jenis_prw : varchar(15)
* id_template : int(11)
* stts_bayar : enum('Sudah','Belum')
v mlite permintaan_lab
* noorder : varchar(15)
* no_rawat : varchar(17)
* tgl_permintaan : date
* jam_permintaan : time
* tgl_sampel : date
* jam_sampel : time
* tgl_hasil : date
* jam_hasil : time
* dokter_perujuk : varchar(20)
* status : enum('ralan','ranap')
* informasi_tambahan : varchar(60)
* diagnosa_klinis : varchar(80)
v mlite permintaan_pemeriksaan_lab
* noorder : varchar(15)
* kd_jenis_prw : varchar(15)
* stts_bayar : enum('Sudah','Belum')
v mlite permintaan_pemeriksaan_radiologi
* noorder : varchar(15)
* kd_jenis_prw : varchar(15)
* stts_bayar : enum('Sudah','Belum')
v mlite permintaan_radiologi
* noorder : varchar(15)
* no_rawat : varchar(17)
* tgl_permintaan : date
* jam_permintaan : time
* tgl_sampel : date
* jam_sampel : time
* tgl_hasil : date
* jam_hasil : time
* dokter_perujuk : varchar(20)
* status : enum('ralan','ranap')
* informasi_tambahan : varchar(60)
* diagnosa_klinis : varchar(80)
v mlite personal_pasien
* no_rkm_medis : varchar(15)
* gambar : varchar(1000)
* password : varchar(1000)
v mlite perusahaan_pasien
* kode_perusahaan : varchar(8)
* nama_perusahaan : varchar(70)
* alamat : varchar(100)
* kota : varchar(40)
* no_telp : varchar(27)
v mlite petugas
* nip : varchar(20)
* nama : varchar(50)
* jk : enum('L','P')
* tmp_lahir : varchar(20)
* tgl_lahir : date
* gol_darah : enum('A','B','O','AB','-')
* agama : varchar(12)
* stts_nikah : enum('BELUM MENIKAH','MENIKAH','JANDA','DUDHA','JOMBLO')
* alamat : varchar(60)
* kd_jbtn : char(4)
* no_telp : varchar(13)
* status : enum('0','1')
v mlite poliklinik
* kd_poli : char(5)
* nm_poli : varchar(50)
* registrasi : double
* registrasilama : double
* status : enum('0','1')
v mlite propinsi
* kd_prop : int(11)
* nm_prop : varchar(60)
v mlite prosedur_pasien
* no_rawat : varchar(17)
* kode : varchar(8)
* status : enum('Ralan','Ranap')
* prioritas : tinyint(4)
v mlite rawat_inap_dr
* no_rawat : varchar(17)
* kd_jenis_prw : varchar(15)
* kd_dokter : varchar(20)
* tgl_perawatan : date
* jam_rawat : time
* material : double
* bhp : double
* tarif_tindakandr : double
* kso : double
* menejemen : double
* biaya_rawat : double
v mlite rawat_inap_drpr
* no_rawat : varchar(17)
* kd_jenis_prw : varchar(15)
* kd_dokter : varchar(20)
* nip : varchar(20)
* tgl_perawatan : date
* jam_rawat : time
* material : double
* bhp : double
* tarif_tindakandr : double
* tarif_tindakanpr : double
* kso : double
* menejemen : double
* biaya_rawat : double
v mlite rawat_inap_pr
* no_rawat : varchar(17)
* kd_jenis_prw : varchar(15)
* nip : varchar(20)
* tgl_perawatan : date
* jam_rawat : time
* material : double
* bhp : double
* tarif_tindakanpr : double
* kso : double
* menejemen : double
* biaya_rawat : double
v mlite rawat_jl_dr
* no_rawat : varchar(17)
* kd_jenis_prw : varchar(15)
* kd_dokter : varchar(20)
* tgl_perawatan : date
* jam_rawat : time
* material : double
* bhp : double
* tarif_tindakandr : double
* kso : double
* menejemen : double
* biaya_rawat : double
* stts_bayar : enum('Sudah','Belum','Suspen')
v mlite rawat_jl_drpr
* no_rawat : varchar(17)
* kd_jenis_prw : varchar(15)
* kd_dokter : varchar(20)
* nip : varchar(20)
* tgl_perawatan : date
* jam_rawat : time
* material : double
* bhp : double
* tarif_tindakandr : double
* tarif_tindakanpr : double
* kso : double
* menejemen : double
* biaya_rawat : double
* stts_bayar : enum('Sudah','Belum','Suspen')
v mlite rawat_jl_pr
* no_rawat : varchar(17)
* kd_jenis_prw : varchar(15)
* nip : varchar(20)
* tgl_perawatan : date
* jam_rawat : time
* material : double
* bhp : double
* tarif_tindakanpr : double
* kso : double
* menejemen : double
* biaya_rawat : double
* stts_bayar : enum('Sudah','Belum','Suspen')
v mlite reg_periksa
* no_reg : varchar(8)
* no_rawat : varchar(17)
* tgl_registrasi : date
* jam_reg : time
* kd_dokter : varchar(20)
* no_rkm_medis : varchar(15)
* kd_poli : char(5)
* p_jawab : varchar(100)
* almt_pj : varchar(200)
* hubunganpj : varchar(20)
* biaya_reg : double
* stts : enum('Belum','Sudah','Batal','Berkas Diterima','Dirujuk','Meninggal','Dirawat','Pulang Paksa')
* stts_daftar : enum('-','Lama','Baru')
* status_lanjut : enum('Ralan','Ranap')
* kd_pj : char(3)
* umurdaftar : int(11)
* sttsumur : enum('Th','Bl','Hr')
* status_bayar : enum('Sudah Bayar','Belum Bayar')
* status_poli : enum('Lama','Baru')
v mlite rekap_presensi
* id : int(10)
* shift : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10')
* jam_datang : datetime
* jam_pulang : datetime
* status : enum('Tepat Waktu','Terlambat Toleransi','Terlambat I','Terlambat II','Tepat Waktu & PSW','Terlambat Toleransi & PSW','Terlambat I & PSW','Terlambat II & PSW')
* keterlambatan : varchar(20)
* durasi : varchar(20)
* keterangan : varchar(100)
* photo : varchar(500)
v mlite resep_dokter
* no_resep : varchar(14)
* kode_brng : varchar(15)
* jml : double
* aturan_pakai : varchar(150)
v mlite resep_dokter_racikan
* no_resep : varchar(14)
* no_racik : varchar(2)
* nama_racik : varchar(100)
* kd_racik : varchar(3)
* jml_dr : int(11)
* aturan_pakai : varchar(150)
* keterangan : varchar(50)
v mlite resep_dokter_racikan_detail
* no_resep : varchar(14)
* no_racik : varchar(2)
* kode_brng : varchar(15)
* p1 : double
* p2 : double
* kandungan : varchar(10)
* jml : double
v mlite resep_obat
* no_resep : varchar(14)
* tgl_perawatan : date
* jam : time
* no_rawat : varchar(17)
* kd_dokter : varchar(20)
* tgl_peresepan : date
* jam_peresepan : time
* status : enum('ralan','ranap')
v mlite resiko_kerja
* kode_resiko : varchar(3)
* nama_resiko : varchar(200)
* indek : tinyint(4)
v mlite riwayat_barang_medis
* kode_brng : varchar(15)
* stok_awal : double
* masuk : double
* keluar : double
* stok_akhir : double
* posisi : enum('Pemberian Obat','Pengadaan','Penerimaan','Piutang','Retur Beli','Retur Jual','Retur Piutang','Mutasi','Opname','Resep Pulang','Retur Pasien','Stok Pasien Ranap','Pengambilan Medis','Penjualan','Stok Keluar','Hibah')
* tanggal : date
* jam : time
* petugas : varchar(20)
* kd_bangsal : char(5)
* status : enum('Simpan','Hapus')
* no_batch : varchar(20)
* no_faktur : varchar(20)
v mlite set_keterlambatan
* toleransi : int(11)
* terlambat1 : int(11)
* terlambat2 : int(11)
v mlite set_no_rkm_medis
* no_rkm_medis : varchar(15)
v mlite skdp_bpjs
* tahun : year(4)
* no_rkm_medis : varchar(15)
* diagnosa : varchar(50)
* terapi : varchar(50)
* alasan1 : varchar(50)
* alasan2 : varchar(50)
* rtl1 : varchar(50)
* rtl2 : varchar(50)
* tanggal_datang : date
* tanggal_rujukan : date
* no_antrian : varchar(6)
* kd_dokter : varchar(20)
* status : enum('Menunggu','Sudah Periksa','Batal Periksa')
v mlite spesialis
* kd_sps : char(5)
* nm_sps : varchar(30)
v mlite stts_kerja
* stts : char(3)
* ktg : varchar(20)
* indek : tinyint(4)
v mlite stts_wp
* stts : char(5)
* ktg : varchar(50)
v mlite suku_bangsa
* id : int(11)
* nama_suku_bangsa : varchar(30)
v mlite tambahan_biaya
* no_rawat : varchar(17)
* nama_biaya : varchar(60)
* besar_biaya : double
* status : enum('ralan','ranap')
v mlite template_laboratorium
* kd_jenis_prw : varchar(15)
* id_template : int(11)
* Pemeriksaan : varchar(200)
* satuan : varchar(20)
* nilai_rujukan_ld : varchar(30)
* nilai_rujukan_la : varchar(30)
* nilai_rujukan_pd : varchar(30)
* nilai_rujukan_pa : varchar(30)
* bagian_rs : double
* bhp : double
* bagian_perujuk : double
* bagian_dokter : double
* bagian_laborat : double
* kso : double
* menejemen : double
* biaya_item : double
* urut : int(4)
v mlite temporary_presensi
* id : int(11)
* shift : enum('Pagi','Pagi2','Pagi3','Pagi4','Pagi5','Pagi6','Pagi7','Pagi8','Pagi9','Pagi10','Siang','Siang2','Siang3','Siang4','Siang5','Siang6','Siang7','Siang8','Siang9','Siang10','Malam','Malam2','Malam3','Malam4','Malam5','Malam6','Malam7','Malam8','Malam9','Malam10','Midle Pagi1','Midle Pagi2','Midle Pagi3','Midle Pagi4','Midle Pagi5','Midle Pagi6','Midle Pagi7','Midle Pagi8','Midle Pagi9','Midle Pagi10','Midle Siang1','Midle Siang2','Midle Siang3','Midle Siang4','Midle Siang5','Midle Siang6','Midle Siang7','Midle Siang8','Midle Siang9','Midle Siang10','Midle Malam1','Midle Malam2','Midle Malam3','Midle Malam4','Midle Malam5','Midle Malam6','Midle Malam7','Midle Malam8','Midle Malam9','Midle Malam10')
* jam_datang : datetime
* jam_pulang : datetime
* status : enum('Tepat Waktu','Terlambat Toleransi','Terlambat I','Terlambat II','Tepat Waktu & PSW','Terlambat Toleransi & PSW','Terlambat I & PSW','Terlambat II & PSW')
* keterlambatan : varchar(20)
* durasi : varchar(20)
* photo : varchar(500)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship