Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: sik
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 11 MyISAM latin1_swedish_ci 1.6 KiB 108 B
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 ~55,457 InnoDB latin1_swedish_ci 15.5 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 11 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,278,646 InnoDB latin1_swedish_ci 481.6 MiB -
booking_operasi 28 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 18,895 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 5 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 35,345 InnoDB latin1_swedish_ci 14.1 MiB -
bridging_sep_internal 91 InnoDB latin1_swedish_ci 96.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 27,040 InnoDB latin1_swedish_ci 4.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 40,913 InnoDB latin1_swedish_ci 1.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 0 InnoDB latin1_swedish_ci 80.0 KiB -
checklist_pre_operasi 0 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 943 InnoDB latin1_swedish_ci 1.3 MiB -
datasuplier 47 InnoDB latin1_swedish_ci 80.0 KiB -
data_batch 1,218 InnoDB latin1_swedish_ci 224.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 64.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,523 InnoDB latin1_swedish_ci 1.3 MiB -
detailjurnal ~696,729 InnoDB latin1_swedish_ci 123.8 MiB -
detailpesan 6,344 InnoDB latin1_swedish_ci 3.1 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 18,088 InnoDB latin1_swedish_ci 7.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 ~157,624 InnoDB latin1_swedish_ci 133.8 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,385 InnoDB latin1_swedish_ci 432.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 6 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 71,489 InnoDB latin1_swedish_ci 11.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 7,457 InnoDB latin1_swedish_ci 1.3 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 985 InnoDB latin1_swedish_ci 272.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 ~2,425,361 InnoDB utf8mb4_general_ci 813.1 MiB 108 B
Page number:
> >>

Create table
Name:
Number of columns: