Letakkan berkas disini

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Basis data: sik
Page-related settingsKlik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueriPress 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 Count: Time taken:
Bookmark
Segarkan
Tambah
Tidak ada bookmark
Tambah bookmark
Opsi
Kembalikan nilai bawaan





Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Bookmarks Kueri gagal Basis data: Waktu eksekusi kueri:

Stuktur basis data

Pilih detail mana untuk menampilkan struktur database (daftar tabel).

Dokumentasi Show or hide a column displaying the comments for all tables.
Dokumentasi Show or hide a column displaying the Creation timestamp for all tables.
Dokumentasi Show or hide a column displaying the Last update timestamp for all tables.
Dokumentasi Show or hide a column displaying the Last check timestamp for all tables.
Nomor halaman:
> >>
Tabel MenaikMenurun Tindakan Baris May be approximate. Click on the number to get the exact count. See FAQ 3.11. Jenis Penyortiran Ukuran Beban
admin 1 InnoDB latin1_swedish_ci 16 KB -
akun_aset_inventaris 6 InnoDB latin1_swedish_ci 32 KB -
akun_bayar 13 InnoDB latin1_swedish_ci 48 KB -
akun_bayar_hutang 2 InnoDB latin1_swedish_ci 32 KB -
akun_penagihan_piutang 1 InnoDB latin1_swedish_ci 16 KB -
akun_piutang 7 InnoDB latin1_swedish_ci 64 KB -
ambil_dankes 0 InnoDB latin1_swedish_ci 48 KB -
angsuran_koperasi 0 InnoDB latin1_swedish_ci 64 KB -
antriapotek 1 MyISAM latin1_swedish_ci 3 KB -
antriapotek2 1 MyISAM latin1_swedish_ci 1 KB -
antriapotek3 1 MyISAM latin1_swedish_ci 1 KB -
antriaps 1 MyISAM latin1_swedish_ci 1 KB -
antrilabmb 0 MyISAM latin1_swedish_ci 1 KB -
antrilabmb2 0 MyISAM latin1_swedish_ci 1 KB -
antrilabpa 1 MyISAM latin1_swedish_ci 1 KB -
antrilabpa2 1 MyISAM latin1_swedish_ci 1 KB -
antrilabpk 1 MyISAM latin1_swedish_ci 1 KB -
antrilabpk2 1 MyISAM latin1_swedish_ci 1 KB -
antriloket 1 MyISAM latin1_swedish_ci 3 KB -
antriloketcetak 8 InnoDB latin1_swedish_ci 16 KB -
antripemulangan 1 MyISAM latin1_swedish_ci 1 KB -
antripengkajianrestrain 1 MyISAM latin1_swedish_ci 2 KB -
antripenolakananjuranmedis 1 MyISAM latin1_swedish_ci 2 KB -
antripenundaanpelayanan 1 MyISAM latin1_swedish_ci 1 KB -
antripernyataanumum 1 MyISAM latin1_swedish_ci 1 KB -
antripersetujuan 1 MyISAM latin1_swedish_ci 1 KB -
antripersetujuanrawatinap 1 MyISAM latin1_swedish_ci 1 KB -
antripersetujuantransferantarruang 1 MyISAM latin1_swedish_ci 1 KB -
antripersetujuanumum 1 MyISAM latin1_swedish_ci 1 KB -
antripoli 3 MyISAM latin1_swedish_ci 1.1 KB -
antriradiologi 1 MyISAM latin1_swedish_ci 1 KB -
antriradiologi2 1 MyISAM latin1_swedish_ci 1 KB -
aplicare_ketersediaan_kamar 0 InnoDB latin1_swedish_ci 112 KB -
asuhan_gizi 0 InnoDB latin1_swedish_ci 32 KB -
asuransi 5 InnoDB latin1_swedish_ci 32 KB -
aturan_pakai 32 InnoDB latin1_swedish_ci 48 KB -
audit_bundle_iadp 0 InnoDB latin1_swedish_ci 32 KB -
audit_bundle_ido 0 InnoDB latin1_swedish_ci 32 KB -
audit_bundle_isk 3 InnoDB latin1_swedish_ci 32 KB -
audit_bundle_plabsi 0 InnoDB latin1_swedish_ci 32 KB -
audit_bundle_vap 3 InnoDB latin1_swedish_ci 32 KB -
audit_cuci_tangan_medis 1 InnoDB latin1_swedish_ci 32 KB -
audit_fasilitas_apd 0 InnoDB latin1_swedish_ci 32 KB -
audit_fasilitas_kebersihan_tangan 0 InnoDB latin1_swedish_ci 32 KB -
audit_kamar_jenazah 0 InnoDB latin1_swedish_ci 16 KB -
audit_kepatuhan_apd 8 InnoDB latin1_swedish_ci 16 KB -
audit_pembuangan_benda_tajam 0 InnoDB latin1_swedish_ci 32 KB -
audit_pembuangan_limbah 0 InnoDB latin1_swedish_ci 32 KB -
audit_pembuangan_limbah_cair_infeksius 1 InnoDB latin1_swedish_ci 32 KB -
audit_penanganan_darah 2 InnoDB latin1_swedish_ci 32 KB -
audit_penempatan_pasien 0 InnoDB latin1_swedish_ci 32 KB -
audit_pengelolaan_linen_kotor 0 InnoDB latin1_swedish_ci 32 KB -
audit_sterilisasi_alat 4 InnoDB latin1_swedish_ci 32 KB -
bahasa_pasien 12 InnoDB latin1_swedish_ci 32 KB -
balasan_pengaduan 3 InnoDB latin1_swedish_ci 16 KB -
bangsal 14 InnoDB latin1_swedish_ci 48 KB -
bank 4 InnoDB latin1_swedish_ci 16 KB -
barcode 1 InnoDB latin1_swedish_ci 32 KB -
bayar_detail_periksa_lab 0 InnoDB latin1_swedish_ci 80 KB -
bayar_detail_periksa_lab_perujuk 0 InnoDB latin1_swedish_ci 80 KB -
bayar_jm_dokter 2 InnoDB latin1_swedish_ci 48 KB -
bayar_operasi_dokter_anak 0 InnoDB latin1_swedish_ci 64 KB -
bayar_operasi_dokter_anestesi 0 InnoDB latin1_swedish_ci 64 KB -
bayar_operasi_dokter_pjanak 0 InnoDB latin1_swedish_ci 64 KB -
bayar_operasi_dokter_umum 0 InnoDB latin1_swedish_ci 64 KB -
bayar_operasi_operator1 0 InnoDB latin1_swedish_ci 64 KB -
bayar_operasi_operator2 0 InnoDB latin1_swedish_ci 64 KB -
bayar_operasi_operator3 0 InnoDB latin1_swedish_ci 64 KB -
bayar_pemesanan 4 InnoDB latin1_swedish_ci 64 KB -
bayar_pemesanan_inventaris 1 InnoDB latin1_swedish_ci 80 KB -
bayar_pemesanan_non_medis 1 InnoDB latin1_swedish_ci 80 KB -
bayar_periksa_lab 0 InnoDB latin1_swedish_ci 64 KB -
bayar_periksa_lab_perujuk 6 InnoDB latin1_swedish_ci 64 KB -
bayar_periksa_radiologi 2 InnoDB latin1_swedish_ci 64 KB -
bayar_periksa_radiologi_perujuk 0 InnoDB latin1_swedish_ci 64 KB -
bayar_piutang 8 InnoDB latin1_swedish_ci 144 KB -
bayar_piutang_lainlain 0 InnoDB latin1_swedish_ci 80 KB -
bayar_rawat_inap_dr 0 InnoDB latin1_swedish_ci 64 KB -
bayar_rawat_inap_drpr 0 InnoDB latin1_swedish_ci 64 KB -
bayar_rawat_jl_dr 2 InnoDB latin1_swedish_ci 48 KB -
bayar_rawat_jl_drpr 0 InnoDB latin1_swedish_ci 64 KB -
beri_bhp_radiologi 0 InnoDB latin1_swedish_ci 112 KB -
beri_obat_operasi 0 InnoDB latin1_swedish_ci 96 KB -
berkas_digital_perawatan 1 InnoDB latin1_swedish_ci 32 KB -
berkas_pegawai 0 InnoDB latin1_swedish_ci 48 KB -
biaya_harian 0 InnoDB latin1_swedish_ci 48 KB -
biaya_sekali 0 InnoDB latin1_swedish_ci 48 KB -
bidang 8 InnoDB latin1_swedish_ci 16 KB -
billing 247 InnoDB latin1_swedish_ci 224 KB -
booking_operasi 5 InnoDB latin1_swedish_ci 80 KB -
booking_periksa 5 InnoDB latin1_swedish_ci 48 KB -
booking_periksa_balasan 0 InnoDB latin1_swedish_ci 16 KB -
booking_periksa_diterima 0 InnoDB latin1_swedish_ci 32 KB -
booking_registrasi 41 InnoDB latin1_swedish_ci 80 KB -
bpjs 2 InnoDB latin1_swedish_ci 16 KB -
bpjs_prb 0 InnoDB latin1_swedish_ci 16 KB -
bridging_dukcapil 0 InnoDB latin1_swedish_ci 16 KB -
bridging_inhealth 0 InnoDB latin1_swedish_ci 32 KB -
bridging_resep_apotek_bpjs 0 InnoDB latin1_swedish_ci 32 KB -
bridging_resep_apotek_bpjs_nonracikan 0 InnoDB latin1_swedish_ci 48 KB -
bridging_resep_apotek_bpjs_racikan 0 InnoDB latin1_swedish_ci 48 KB -
bridging_rujukan_bpjs 1 InnoDB latin1_swedish_ci 32 KB -
bridging_rujukan_bpjs_khusus 0 InnoDB latin1_swedish_ci 16 KB -
bridging_rujukan_bpjs_khusus_diagnosa 0 InnoDB latin1_swedish_ci 16 KB -
bridging_rujukan_bpjs_khusus_prosedur 0 InnoDB latin1_swedish_ci 16 KB -
bridging_sep 1 InnoDB latin1_swedish_ci 32 KB -
bridging_sep_internal 0 InnoDB latin1_swedish_ci 48 KB -
bridging_srb_bpjs 0 InnoDB latin1_swedish_ci 16 KB -
bridging_srb_bpjs_obat 0 InnoDB latin1_swedish_ci 32 KB -
bridging_surat_kontrol_bpjs 0 InnoDB latin1_swedish_ci 32 KB -
bridging_surat_pri_bpjs 0 InnoDB latin1_swedish_ci 32 KB -
bukti_pemesanan 19 InnoDB latin1_swedish_ci 16 KB -
bukti_pemesanan_logistik 1 InnoDB latin1_swedish_ci 16 KB -
bukti_penagihan_piutang 2 InnoDB latin1_swedish_ci 16 KB -
bukti_penyerahan_resep_obat 8 InnoDB latin1_swedish_ci 16 KB -
bukti_perencanaan_pemulangan_saksikeluarga 0 InnoDB latin1_swedish_ci 16 KB -
bukti_persetujuan_penolakan_tindakan_penerimainformasi 6 InnoDB latin1_swedish_ci 16 KB -
bukti_persetujuan_penolakan_tindakan_saksikeluarga 6 InnoDB latin1_swedish_ci 16 KB -
bukti_persetujuan_penundaan_pelayanan 1 InnoDB latin1_swedish_ci 16 KB -
bukti_persetujuan_transfer_pasien_antar_ruang 0 InnoDB latin1_swedish_ci 16 KB -
cacat_fisik 6 InnoDB latin1_swedish_ci 32 KB -
catatan_adime_gizi 1 InnoDB latin1_swedish_ci 32 KB -
catatan_cek_gds 0 InnoDB latin1_swedish_ci 32 KB -
catatan_keperawatan_ralan 0 InnoDB latin1_swedish_ci 48 KB -
catatan_keperawatan_ranap 0 InnoDB latin1_swedish_ci 48 KB -
catatan_observasi_igd 0 InnoDB latin1_swedish_ci 48 KB -
catatan_observasi_ranap 0 InnoDB latin1_swedish_ci 48 KB -
catatan_observasi_ranap_kebidanan 0 InnoDB latin1_swedish_ci 48 KB -
catatan_observasi_ranap_postpartum 0 InnoDB latin1_swedish_ci 48 KB -
catatan_pasien 5 InnoDB latin1_swedish_ci 32 KB -
catatan_perawatan 0 InnoDB latin1_swedish_ci 48 KB -
catatan_persalinan 1 InnoDB latin1_swedish_ci 48 KB -
checklist_kriteria_keluar_hcu 0 InnoDB latin1_swedish_ci 32 KB -
checklist_kriteria_keluar_icu 0 InnoDB latin1_swedish_ci 32 KB -
checklist_kriteria_masuk_hcu 0 InnoDB latin1_swedish_ci 32 KB -
checklist_kriteria_masuk_icu 0 InnoDB latin1_swedish_ci 32 KB -
checklist_post_operasi 0 InnoDB latin1_swedish_ci 80 KB -
checklist_pre_operasi 0 InnoDB latin1_swedish_ci 80 KB -
closing_kasir 3 InnoDB latin1_swedish_ci 48 KB -
cssd_barang 1 InnoDB latin1_swedish_ci 16 KB -
dansos 1 InnoDB latin1_swedish_ci 16 KB -
dapurbarang 1 InnoDB latin1_swedish_ci 96 KB -
dapurdetailbeli 1 InnoDB latin1_swedish_ci 160 KB -
dapurdetailpengeluaran 0 InnoDB latin1_swedish_ci 112 KB -
dapuropname 0 InnoDB latin1_swedish_ci 112 KB -
dapurpembelian 1 InnoDB latin1_swedish_ci 128 KB -
dapurpengeluaran 0 InnoDB latin1_swedish_ci 64 KB -
dapursuplier 1 InnoDB latin1_swedish_ci 80 KB -
dapur_riwayat_barang 8 InnoDB latin1_swedish_ci 32 KB -
databarang 2,013 InnoDB latin1_swedish_ci 2.4 MB -
datasuplier 6 InnoDB latin1_swedish_ci 80 KB -
data_batch 49 InnoDB latin1_swedish_ci 32 KB -
data_hais 0 InnoDB latin1_swedish_ci 272 KB -
data_klasifikasi_pasien_ranap 0 InnoDB latin1_swedish_ci 48 KB -
data_tb 0 InnoDB latin1_swedish_ci 32 KB -
data_triase_igd 0 InnoDB latin1_swedish_ci 32 KB -
data_triase_igddetail_skala1 0 InnoDB latin1_swedish_ci 32 KB -
data_triase_igddetail_skala2 0 InnoDB latin1_swedish_ci 32 KB -
data_triase_igddetail_skala3 0 InnoDB latin1_swedish_ci 32 KB -
data_triase_igddetail_skala4 0 InnoDB latin1_swedish_ci 32 KB -
data_triase_igddetail_skala5 0 InnoDB latin1_swedish_ci 32 KB -
data_triase_igdprimer 0 InnoDB latin1_swedish_ci 32 KB -
data_triase_igdsekunder 0 InnoDB latin1_swedish_ci 32 KB -
departemen 10 InnoDB latin1_swedish_ci 32 KB -
deposit 0 InnoDB latin1_swedish_ci 80 KB -
detailbeli 5 InnoDB latin1_swedish_ci 176 KB -
detailhibah_obat_bhp 0 InnoDB latin1_swedish_ci 64 KB -
detailjual 15 InnoDB latin1_swedish_ci 192 KB -
detailjurnal 1,170 InnoDB latin1_swedish_ci 320 KB -
detailpesan 220 InnoDB latin1_swedish_ci 224 KB -
detailpiutang 2 InnoDB latin1_swedish_ci 176 KB -
detail_beri_diet 10 InnoDB latin1_swedish_ci 96 KB -
detail_nota_inap 0 InnoDB latin1_swedish_ci 80 KB -
detail_nota_jalan 8 InnoDB latin1_swedish_ci 80 KB -
detail_obat_racikan 18 InnoDB latin1_swedish_ci 48 KB -
detail_obat_racikan_jual 5 InnoDB latin1_swedish_ci 32 KB -
detail_pemberian_obat 57 InnoDB latin1_swedish_ci 192 KB -
detail_penagihan_piutang 8 InnoDB latin1_swedish_ci 32 KB -
detail_pengajuan_barang_medis 8 InnoDB latin1_swedish_ci 64 KB -
detail_pengajuan_barang_nonmedis 0 InnoDB latin1_swedish_ci 64 KB -
detail_pengeluaran_obat_bhp 4 InnoDB latin1_swedish_ci 112 KB -
detail_periksa_lab 126 InnoDB latin1_swedish_ci 288 KB -
detail_periksa_labpa 0 InnoDB latin1_swedish_ci 32 KB -
detail_periksa_labpa_gambar 0 InnoDB latin1_swedish_ci 32 KB -
detail_permintaan_dapur 0 InnoDB latin1_swedish_ci 64 KB -
detail_permintaan_medis 9 InnoDB latin1_swedish_ci 64 KB -
detail_permintaan_non_medis 0 InnoDB latin1_swedish_ci 64 KB -
detail_permintaan_resep_pulang 2 InnoDB latin1_swedish_ci 48 KB -
detail_permintaan_stok_obat_pasien 6 InnoDB latin1_swedish_ci 48 KB -
detail_piutang_pasien 6 InnoDB latin1_swedish_ci 48 KB -
detail_surat_pemesanan_medis 13 InnoDB latin1_swedish_ci 160 KB -
detail_surat_pemesanan_non_medis 0 InnoDB latin1_swedish_ci 160 KB -
detail_titip_faktur 4 InnoDB latin1_swedish_ci 32 KB -
deteksi_dini_corona 0 InnoDB latin1_swedish_ci 32 KB -
detreturbeli 0 InnoDB latin1_swedish_ci 176 KB -
detreturjual 2 InnoDB latin1_swedish_ci 160 KB -
detreturpiutang 0 InnoDB latin1_swedish_ci 160 KB -
diagnosa_corona 0 InnoDB latin1_swedish_ci 16 KB -
diagnosa_pasien 19 InnoDB latin1_swedish_ci 80 KB -
diet 3 InnoDB latin1_swedish_ci 32 KB -
dokter 4 InnoDB latin1_swedish_ci 240 KB -
dpjp_ranap 1 InnoDB latin1_swedish_ci 32 KB -
edukasi_pasien_keluarga_rj 0 InnoDB latin1_swedish_ci 32 KB -
emergency_index 4 InnoDB latin1_swedish_ci 16 KB -
evaluasi_kinerja 5 InnoDB latin1_swedish_ci 16 KB -
evaluasi_kinerja_pegawai 0 InnoDB latin1_swedish_ci 32 KB -
follow_up_dbd 0 InnoDB latin1_swedish_ci 48 KB -
gambar 1 InnoDB latin1_swedish_ci 16 KB -
gambar_radiologi 2 InnoDB latin1_swedish_ci 16 KB -
golongan_barang 9 InnoDB latin1_swedish_ci 16 KB -
golongan_polri 3 InnoDB latin1_swedish_ci 16 KB -
golongan_tni 4 InnoDB latin1_swedish_ci 16 KB -
gudangbarang 2,225 InnoDB latin1_swedish_ci 528 KB -
harian_kurangi_bulanan 5 InnoDB latin1_swedish_ci 48 KB -
hasil_endoskopi_faring_laring 0 InnoDB latin1_swedish_ci 32 KB -
hasil_endoskopi_faring_laring_gambar 0 InnoDB latin1_swedish_ci 16 KB -
hasil_endoskopi_hidung 0 InnoDB latin1_swedish_ci 32 KB -
hasil_endoskopi_hidung_gambar 0 InnoDB latin1_swedish_ci 16 KB -
hasil_pemeriksaan_ekg 1 InnoDB latin1_swedish_ci 32 KB -
hasil_pemeriksaan_ekg_gambar 1 InnoDB latin1_swedish_ci 16 KB -
hasil_pemeriksaan_usg 0 InnoDB latin1_swedish_ci 32 KB -
hasil_pemeriksaan_usg_gambar 0 InnoDB latin1_swedish_ci 16 KB -
hasil_pemeriksaan_usg_gynecologi 0 InnoDB latin1_swedish_ci 32 KB -
hasil_pemeriksaan_usg_gynecologi_gambar 0 InnoDB latin1_swedish_ci 16 KB -
hasil_pemeriksaan_usg_neonatus 0 InnoDB latin1_swedish_ci 32 KB -
hasil_pemeriksaan_usg_neonatus_gambar 0 InnoDB latin1_swedish_ci 16 KB -
hasil_pemeriksaan_usg_urologi 0 InnoDB latin1_swedish_ci 32 KB -
hasil_pemeriksaan_usg_urologi_gambar 0 InnoDB latin1_swedish_ci 16 KB -
hasil_radiologi 6 InnoDB latin1_swedish_ci 32 KB -
hasil_tindakan_eswl 0 InnoDB latin1_swedish_ci 48 KB -
hemodialisa 0 InnoDB latin1_swedish_ci 64 KB -
hibah_obat_bhp 0 InnoDB latin1_swedish_ci 64 KB -
icd9 3,882 InnoDB latin1_swedish_ci 400 KB -
inacbg_coder_nik 1 InnoDB latin1_swedish_ci 16 KB -
inacbg_data_terkirim 0 InnoDB latin1_swedish_ci 16 KB -
inacbg_data_terkirim2 6 InnoDB latin1_swedish_ci 16 KB -
inacbg_data_terkirim_internal 0 InnoDB latin1_swedish_ci 16 KB -
inacbg_grouping_stage1 0 InnoDB latin1_swedish_ci 16 KB -
inacbg_grouping_stage1_internal 0 InnoDB latin1_swedish_ci 16 KB -
inacbg_grouping_stage12 6 InnoDB latin1_swedish_ci 16 KB -
inacbg_klaim_baru 0 InnoDB latin1_swedish_ci 16 KB -
inacbg_klaim_baru2 6 InnoDB latin1_swedish_ci 32 KB -
inacbg_klaim_baru_internal 0 InnoDB latin1_swedish_ci 16 KB -
inacbg_noklaim_corona 0 InnoDB latin1_swedish_ci 32 KB -
indekref 8 InnoDB latin1_swedish_ci 64 KB -
indexins 1 InnoDB latin1_swedish_ci 32 KB -
indextotal 8 InnoDB latin1_swedish_ci 48 KB -
industrifarmasi 12 InnoDB latin1_swedish_ci 80 KB -
inhealth_jenpel_ruang_rawat 0 InnoDB latin1_swedish_ci 16 KB -
inhealth_maping_dokter 0 InnoDB latin1_swedish_ci 16 KB -
250 tabel Jumlah 10,563 InnoDB latin1_swedish_ci 15.1 MB 0 B
Nomor halaman:
> >>

  Buat tabel
Nama:
Jumlah kolom: