Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: sik2
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Database structure

Choose which details to show in the database structure (list of tables).

Documentation Show or hide a column displaying the charset for all tables.
Documentation Show or hide a column displaying the comments for all tables.
Documentation Show or hide a column displaying the Creation timestamp for all tables.
Documentation Show or hide a column displaying the Last update timestamp for all tables.
Documentation Show or hide a column displaying the Last check timestamp for all tables.
Page number:
> >>
Filters
Table Ascending Descending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
admin 1 InnoDB latin1_swedish_ci 16.0 KiB -
akun_aset_inventaris 0 InnoDB latin1_swedish_ci 32.0 KiB -
akun_bayar 8 InnoDB latin1_swedish_ci 48.0 KiB -
akun_bayar_hutang 0 InnoDB latin1_swedish_ci 32.0 KiB -
akun_penagihan_piutang 0 InnoDB latin1_swedish_ci 16.0 KiB -
akun_piutang 2 InnoDB latin1_swedish_ci 64.0 KiB -
ambil_dankes 0 InnoDB latin1_swedish_ci 48.0 KiB -
angsuran_koperasi 0 InnoDB latin1_swedish_ci 64.0 KiB -
antrian_loket 8 InnoDB latin1_swedish_ci 16.0 KiB -
antrian_referensi 13 InnoDB latin1_swedish_ci 16.0 KiB -
antriapotek 1 MyISAM latin1_swedish_ci 3.0 KiB -
antriapotek2 1 MyISAM latin1_swedish_ci 1.0 KiB -
antriapotek3 1 MyISAM latin1_swedish_ci 1.0 KiB -
antriaps 0 MyISAM latin1_swedish_ci 1.0 KiB -
antrics 0 MyISAM latin1_swedish_ci 1.0 KiB -
antrilabmb 0 MyISAM latin1_swedish_ci 1.0 KiB -
antrilabmb2 0 MyISAM latin1_swedish_ci 1.0 KiB -
antrilabpa 0 MyISAM latin1_swedish_ci 1.0 KiB -
antrilabpa2 0 MyISAM latin1_swedish_ci 1.0 KiB -
antrilabpk 0 MyISAM latin1_swedish_ci 1.0 KiB -
antrilabpk2 0 MyISAM latin1_swedish_ci 1.0 KiB -
antriloket 1 MyISAM latin1_swedish_ci 3.0 KiB -
antriloketcetak 0 InnoDB latin1_swedish_ci 16.0 KiB -
antripemulangan 0 MyISAM latin1_swedish_ci 1.0 KiB -
antripengkajianrestrain 0 MyISAM latin1_swedish_ci 1.0 KiB -
antripenolakananjuranmedis 0 MyISAM latin1_swedish_ci 1.0 KiB -
antripenundaanpelayanan 0 MyISAM latin1_swedish_ci 1.0 KiB -
antripernyataanumum 0 MyISAM latin1_swedish_ci 1.0 KiB -
antripersetujuan 0 MyISAM latin1_swedish_ci 1.0 KiB -
antripersetujuanrawatinap 0 MyISAM latin1_swedish_ci 1.0 KiB -
antripersetujuantransferantarruang 0 MyISAM latin1_swedish_ci 1.0 KiB -
antripersetujuanumum 0 MyISAM latin1_swedish_ci 1.0 KiB -
antripoli 8 MyISAM latin1_swedish_ci 1.3 KiB -
antriprioritas 0 MyISAM latin1_swedish_ci 1.0 KiB -
antriradiologi 0 MyISAM latin1_swedish_ci 1.0 KiB -
antriradiologi2 1 MyISAM latin1_swedish_ci 1.0 KiB -
aplicare_ketersediaan_kamar 0 InnoDB latin1_swedish_ci 112.0 KiB -
asuhan_gizi 0 InnoDB latin1_swedish_ci 32.0 KiB -
asuransi 5 InnoDB latin1_swedish_ci 32.0 KiB -
aturan_pakai ~114,433 InnoDB latin1_swedish_ci 29.7 MiB -
audit_bundle_iadp 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_bundle_ido 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_bundle_isk 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_bundle_plabsi 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_bundle_vap 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_cuci_tangan_medis 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_fasilitas_apd 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_fasilitas_kebersihan_tangan 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_kamar_jenazah 0 InnoDB latin1_swedish_ci 16.0 KiB -
audit_kepatuhan_apd 0 InnoDB latin1_swedish_ci 16.0 KiB -
audit_pembuangan_benda_tajam 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_pembuangan_limbah 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_pembuangan_limbah_cair_infeksius 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_penanganan_darah 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_penempatan_pasien 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_pengelolaan_linen_kotor 0 InnoDB latin1_swedish_ci 32.0 KiB -
audit_sterilisasi_alat 0 InnoDB latin1_swedish_ci 32.0 KiB -
bahasa_pasien 11 InnoDB latin1_swedish_ci 32.0 KiB -
balasan_pengaduan 0 InnoDB latin1_swedish_ci 16.0 KiB -
bangsal 12 InnoDB latin1_swedish_ci 48.0 KiB -
bank 4 InnoDB latin1_swedish_ci 16.0 KiB -
bank_tujuan_transfer_bankmandiri 0 InnoDB latin1_swedish_ci 16.0 KiB -
barcode 0 InnoDB latin1_swedish_ci 32.0 KiB -
bayar_detail_periksa_lab 0 InnoDB latin1_swedish_ci 80.0 KiB -
bayar_detail_periksa_lab_perujuk 0 InnoDB latin1_swedish_ci 80.0 KiB -
bayar_jm_dokter 0 InnoDB latin1_swedish_ci 48.0 KiB -
bayar_operasi_dokter_anak 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_operasi_dokter_anestesi 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_operasi_dokter_pjanak 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_operasi_dokter_umum 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_operasi_operator1 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_operasi_operator2 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_operasi_operator3 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_pemesanan 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_pemesanan_inventaris 0 InnoDB latin1_swedish_ci 80.0 KiB -
bayar_pemesanan_non_medis 0 InnoDB latin1_swedish_ci 80.0 KiB -
bayar_periksa_lab 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_periksa_lab_perujuk 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_periksa_radiologi 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_periksa_radiologi_perujuk 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_piutang 0 InnoDB latin1_swedish_ci 144.0 KiB -
bayar_piutang_lainlain 0 InnoDB latin1_swedish_ci 80.0 KiB -
bayar_rawat_inap_dr 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_rawat_inap_drpr 0 InnoDB latin1_swedish_ci 64.0 KiB -
bayar_rawat_jl_dr 0 InnoDB latin1_swedish_ci 48.0 KiB -
bayar_rawat_jl_drpr 0 InnoDB latin1_swedish_ci 64.0 KiB -
beri_bhp_radiologi 0 InnoDB latin1_swedish_ci 112.0 KiB -
beri_obat_operasi 0 InnoDB latin1_swedish_ci 96.0 KiB -
berkas_digital_perawatan 13 InnoDB latin1_swedish_ci 32.0 KiB -
berkas_pegawai 0 InnoDB latin1_swedish_ci 48.0 KiB -
biaya_harian 0 InnoDB latin1_swedish_ci 48.0 KiB -
biaya_sekali 0 InnoDB latin1_swedish_ci 48.0 KiB -
bidang 8 InnoDB latin1_swedish_ci 16.0 KiB -
billing ~1,841,141 InnoDB latin1_swedish_ci 691.9 MiB -
booking_operasi 29 InnoDB latin1_swedish_ci 80.0 KiB -
booking_periksa 0 InnoDB latin1_swedish_ci 48.0 KiB -
booking_periksa_balasan 0 InnoDB latin1_swedish_ci 16.0 KiB -
booking_periksa_diterima 0 InnoDB latin1_swedish_ci 32.0 KiB -
booking_registrasi 5 InnoDB latin1_swedish_ci 80.0 KiB -
bpjs 5 InnoDB latin1_swedish_ci 16.0 KiB -
bpjs_prb 24,844 InnoDB latin1_swedish_ci 1.5 MiB -
bridging_dukcapil 0 InnoDB latin1_swedish_ci 16.0 KiB -
bridging_inhealth 0 InnoDB latin1_swedish_ci 32.0 KiB -
bridging_resep_apotek_bpjs 0 InnoDB latin1_swedish_ci 32.0 KiB -
bridging_resep_apotek_bpjs_nonracikan 0 InnoDB latin1_swedish_ci 48.0 KiB -
bridging_resep_apotek_bpjs_racikan 0 InnoDB latin1_swedish_ci 48.0 KiB -
bridging_rujukan_bpjs 14 InnoDB latin1_swedish_ci 32.0 KiB -
bridging_rujukan_bpjs_khusus 0 InnoDB latin1_swedish_ci 16.0 KiB -
bridging_rujukan_bpjs_khusus_diagnosa 0 InnoDB latin1_swedish_ci 16.0 KiB -
bridging_rujukan_bpjs_khusus_prosedur 0 InnoDB latin1_swedish_ci 16.0 KiB -
bridging_sep 44,556 InnoDB latin1_swedish_ci 26.1 MiB -
bridging_sep_internal 96 InnoDB latin1_swedish_ci 112.0 KiB -
bridging_srb_bpjs 0 InnoDB latin1_swedish_ci 16.0 KiB -
bridging_srb_bpjs_obat 0 InnoDB latin1_swedish_ci 32.0 KiB -
bridging_surat_kontrol_bpjs 33,980 InnoDB latin1_swedish_ci 8.0 MiB -
bridging_surat_pri_bpjs 0 InnoDB latin1_swedish_ci 32.0 KiB -
bukti_pemesanan 0 InnoDB latin1_swedish_ci 16.0 KiB -
bukti_pemesanan_logistik 0 InnoDB latin1_swedish_ci 16.0 KiB -
bukti_penagihan_piutang 0 InnoDB latin1_swedish_ci 16.0 KiB -
bukti_penyerahan_resep_obat ~50,932 InnoDB latin1_swedish_ci 3.5 MiB -
bukti_perencanaan_pemulangan_saksikeluarga 0 InnoDB latin1_swedish_ci 16.0 KiB -
bukti_persetujuan_penolakan_tindakan_penerimainformasi 0 InnoDB latin1_swedish_ci 16.0 KiB -
bukti_persetujuan_penolakan_tindakan_saksikeluarga 0 InnoDB latin1_swedish_ci 16.0 KiB -
bukti_persetujuan_penundaan_pelayanan 0 InnoDB latin1_swedish_ci 16.0 KiB -
bukti_persetujuan_transfer_pasien_antar_ruang 0 InnoDB latin1_swedish_ci 16.0 KiB -
cacat_fisik 6 InnoDB latin1_swedish_ci 32.0 KiB -
catatan_adime_gizi 0 InnoDB latin1_swedish_ci 32.0 KiB -
catatan_cek_gds 0 InnoDB latin1_swedish_ci 32.0 KiB -
catatan_infus_ralan 0 InnoDB latin1_swedish_ci 48.0 KiB -
catatan_keperawatan_ralan 0 InnoDB latin1_swedish_ci 48.0 KiB -
catatan_keperawatan_ranap 0 InnoDB latin1_swedish_ci 48.0 KiB -
catatan_keseimbangan_cairan 0 InnoDB latin1_swedish_ci 48.0 KiB -
catatan_observasi_chbp 0 InnoDB latin1_swedish_ci 48.0 KiB -
catatan_observasi_igd 0 InnoDB latin1_swedish_ci 48.0 KiB -
catatan_observasi_induksi_persalinan 0 InnoDB latin1_swedish_ci 48.0 KiB -
catatan_observasi_ranap 0 InnoDB latin1_swedish_ci 48.0 KiB -
catatan_observasi_ranap_kebidanan 0 InnoDB latin1_swedish_ci 48.0 KiB -
catatan_observasi_ranap_postpartum 0 InnoDB latin1_swedish_ci 48.0 KiB -
catatan_pasien 2 InnoDB latin1_swedish_ci 32.0 KiB -
catatan_perawatan 0 InnoDB latin1_swedish_ci 48.0 KiB -
catatan_persalinan 0 InnoDB latin1_swedish_ci 48.0 KiB -
checklist_kriteria_keluar_hcu 0 InnoDB latin1_swedish_ci 32.0 KiB -
checklist_kriteria_keluar_icu 0 InnoDB latin1_swedish_ci 32.0 KiB -
checklist_kriteria_masuk_hcu 0 InnoDB latin1_swedish_ci 32.0 KiB -
checklist_kriteria_masuk_icu 0 InnoDB latin1_swedish_ci 32.0 KiB -
checklist_post_operasi 2 InnoDB latin1_swedish_ci 80.0 KiB -
checklist_pre_operasi 3 InnoDB latin1_swedish_ci 80.0 KiB -
closing_kasir 3 InnoDB latin1_swedish_ci 48.0 KiB -
cssd_barang 2 InnoDB latin1_swedish_ci 16.0 KiB -
dansos 1 InnoDB latin1_swedish_ci 16.0 KiB -
dapurbarang 0 InnoDB latin1_swedish_ci 96.0 KiB -
dapurdetailbeli 0 InnoDB latin1_swedish_ci 160.0 KiB -
dapurdetailpengeluaran 0 InnoDB latin1_swedish_ci 112.0 KiB -
dapuropname 0 InnoDB latin1_swedish_ci 112.0 KiB -
dapurpembelian 0 InnoDB latin1_swedish_ci 128.0 KiB -
dapurpengeluaran 0 InnoDB latin1_swedish_ci 64.0 KiB -
dapursuplier 0 InnoDB latin1_swedish_ci 80.0 KiB -
dapur_riwayat_barang 0 InnoDB latin1_swedish_ci 32.0 KiB -
databarang 951 InnoDB latin1_swedish_ci 1.3 MiB -
datasuplier 47 InnoDB latin1_swedish_ci 80.0 KiB -
data_batch 1,645 InnoDB latin1_swedish_ci 416.0 KiB -
data_hais 0 InnoDB latin1_swedish_ci 272.0 KiB -
data_HAIs 0 InnoDB latin1_swedish_ci 272.0 KiB -
data_klasifikasi_pasien_ranap 0 InnoDB latin1_swedish_ci 48.0 KiB -
data_tb 0 InnoDB latin1_swedish_ci 32.0 KiB -
data_triase_igd 0 InnoDB latin1_swedish_ci 32.0 KiB -
data_triase_igddetail_skala1 0 InnoDB latin1_swedish_ci 32.0 KiB -
data_triase_igddetail_skala2 0 InnoDB latin1_swedish_ci 32.0 KiB -
data_triase_igddetail_skala3 0 InnoDB latin1_swedish_ci 32.0 KiB -
data_triase_igddetail_skala4 0 InnoDB latin1_swedish_ci 32.0 KiB -
data_triase_igddetail_skala5 0 InnoDB latin1_swedish_ci 32.0 KiB -
data_triase_igdprimer 0 InnoDB latin1_swedish_ci 32.0 KiB -
data_triase_igdsekunder 0 InnoDB latin1_swedish_ci 32.0 KiB -
departemen 9 InnoDB latin1_swedish_ci 32.0 KiB -
deposit 0 InnoDB latin1_swedish_ci 80.0 KiB -
detailbeli 0 InnoDB latin1_swedish_ci 176.0 KiB -
detailhibah_obat_bhp 0 InnoDB latin1_swedish_ci 64.0 KiB -
detailjual 2,677 InnoDB latin1_swedish_ci 1.5 MiB -
detailjurnal ~1,065,002 InnoDB latin1_swedish_ci 186.9 MiB -
detailpesan 6,886 InnoDB latin1_swedish_ci 3.7 MiB -
detailpiutang 0 InnoDB latin1_swedish_ci 176.0 KiB -
detail_beri_diet 0 InnoDB latin1_swedish_ci 96.0 KiB -
detail_nota_inap 0 InnoDB latin1_swedish_ci 80.0 KiB -
detail_nota_jalan 19,265 InnoDB latin1_swedish_ci 8.6 MiB -
detail_obat_racikan 0 InnoDB latin1_swedish_ci 48.0 KiB -
detail_obat_racikan_jual 0 InnoDB latin1_swedish_ci 32.0 KiB -
detail_pemberian_obat ~231,200 InnoDB latin1_swedish_ci 196.0 MiB -
detail_penagihan_piutang 0 InnoDB latin1_swedish_ci 32.0 KiB -
detail_pengajuan_barang_medis 0 InnoDB latin1_swedish_ci 64.0 KiB -
detail_pengajuan_barang_nonmedis 0 InnoDB latin1_swedish_ci 64.0 KiB -
detail_pengeluaran_obat_bhp 1,881 InnoDB latin1_swedish_ci 656.0 KiB -
detail_periksa_lab 0 InnoDB latin1_swedish_ci 256.0 KiB -
detail_periksa_labpa 0 InnoDB latin1_swedish_ci 32.0 KiB -
detail_periksa_labpa_gambar 0 InnoDB latin1_swedish_ci 32.0 KiB -
detail_permintaan_dapur 0 InnoDB latin1_swedish_ci 64.0 KiB -
detail_permintaan_medis 13 InnoDB latin1_swedish_ci 64.0 KiB -
detail_permintaan_non_medis 0 InnoDB latin1_swedish_ci 64.0 KiB -
detail_permintaan_resep_pulang 0 InnoDB latin1_swedish_ci 48.0 KiB -
detail_permintaan_stok_obat_pasien 0 InnoDB latin1_swedish_ci 48.0 KiB -
detail_piutang_pasien ~80,539 InnoDB latin1_swedish_ci 16.1 MiB -
detail_surat_pemesanan_medis 1 InnoDB latin1_swedish_ci 160.0 KiB -
detail_surat_pemesanan_non_medis 0 InnoDB latin1_swedish_ci 160.0 KiB -
detail_titip_faktur 0 InnoDB latin1_swedish_ci 32.0 KiB -
deteksi_dini_corona 0 InnoDB latin1_swedish_ci 32.0 KiB -
detreturbeli 0 InnoDB latin1_swedish_ci 176.0 KiB -
detreturjual 0 InnoDB latin1_swedish_ci 160.0 KiB -
detreturpiutang 0 InnoDB latin1_swedish_ci 160.0 KiB -
diagnosa_corona 0 InnoDB latin1_swedish_ci 16.0 KiB -
diagnosa_pasien 10,272 InnoDB latin1_swedish_ci 2.0 MiB -
diet 42 InnoDB latin1_swedish_ci 32.0 KiB -
dokter 10 InnoDB latin1_swedish_ci 240.0 KiB -
dpjp_ranap 0 InnoDB latin1_swedish_ci 32.0 KiB -
edukasi_pasien_keluarga_rj 0 InnoDB latin1_swedish_ci 32.0 KiB -
emergency_index 4 InnoDB latin1_swedish_ci 16.0 KiB -
evaluasi_kinerja 5 InnoDB latin1_swedish_ci 16.0 KiB -
evaluasi_kinerja_pegawai 0 InnoDB latin1_swedish_ci 32.0 KiB -
follow_up_dbd 0 InnoDB latin1_swedish_ci 48.0 KiB -
gambar 1 InnoDB latin1_swedish_ci 16.0 KiB -
gambar_radiologi 0 InnoDB latin1_swedish_ci 16.0 KiB -
golongan_barang 11 InnoDB latin1_swedish_ci 16.0 KiB -
golongan_polri 3 InnoDB latin1_swedish_ci 16.0 KiB -
golongan_tni 4 InnoDB latin1_swedish_ci 16.0 KiB -
gudangbarang 992 InnoDB latin1_swedish_ci 240.0 KiB -
harian_kurangi_bulanan 5 InnoDB latin1_swedish_ci 48.0 KiB -
hasil_endoskopi_faring_laring 0 InnoDB latin1_swedish_ci 32.0 KiB -
hasil_endoskopi_faring_laring_gambar 0 InnoDB latin1_swedish_ci 16.0 KiB -
hasil_endoskopi_hidung 0 InnoDB latin1_swedish_ci 32.0 KiB -
hasil_endoskopi_hidung_gambar 0 InnoDB latin1_swedish_ci 16.0 KiB -
hasil_endoskopi_telinga 0 InnoDB latin1_swedish_ci 32.0 KiB -
hasil_endoskopi_telinga_gambar 0 InnoDB latin1_swedish_ci 16.0 KiB -
hasil_pemeriksaan_ekg 0 InnoDB latin1_swedish_ci 32.0 KiB -
hasil_pemeriksaan_ekg_gambar 0 InnoDB latin1_swedish_ci 16.0 KiB -
hasil_pemeriksaan_usg 0 InnoDB latin1_swedish_ci 32.0 KiB -
hasil_pemeriksaan_usg_gambar 0 InnoDB latin1_swedish_ci 16.0 KiB -
hasil_pemeriksaan_usg_gynecologi 0 InnoDB latin1_swedish_ci 32.0 KiB -
hasil_pemeriksaan_usg_gynecologi_gambar 0 InnoDB latin1_swedish_ci 16.0 KiB -
hasil_pemeriksaan_usg_neonatus 0 InnoDB latin1_swedish_ci 32.0 KiB -
hasil_pemeriksaan_usg_neonatus_gambar 0 InnoDB latin1_swedish_ci 16.0 KiB -
hasil_pemeriksaan_usg_urologi 0 InnoDB latin1_swedish_ci 32.0 KiB -
hasil_pemeriksaan_usg_urologi_gambar 0 InnoDB latin1_swedish_ci 16.0 KiB -
hasil_radiologi 1 InnoDB latin1_swedish_ci 32.0 KiB -
hasil_tindakan_eswl 0 InnoDB latin1_swedish_ci 48.0 KiB -
hemodialisa 0 InnoDB latin1_swedish_ci 64.0 KiB -
hibah_obat_bhp 0 InnoDB latin1_swedish_ci 64.0 KiB -
icd9 3,882 InnoDB latin1_swedish_ci 400.0 KiB -
inacbg_coder_nik 2 InnoDB latin1_swedish_ci 16.0 KiB -
inacbg_data_terkirim 0 InnoDB latin1_swedish_ci 16.0 KiB -
inacbg_data_terkirim2 0 InnoDB latin1_swedish_ci 16.0 KiB -
inacbg_data_terkirim_internal 0 InnoDB latin1_swedish_ci 16.0 KiB -
inacbg_grouping_stage1 0 InnoDB latin1_swedish_ci 16.0 KiB -
250 tables Sum ~3,535,502 InnoDB utf8mb4_general_ci 1.2 GiB 0 B
Page number:
> >>

Create table
Name:
Number of columns: