Letakkan berkas disini

SQL upload ( 0 ) x-

Server: localhost »Basis data: sik
Pengaturan Terkait dengan HalamanKlik 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 :

Stuktur basis data

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

Dokumentasi Show or hide a column displaying the charset for all tables.
Dokumentasi Menampilkan atau menyembunyikan sebuah kolom yang menampilkan komentar untuk semua tabel.
Dokumentasi Menampilkan atau menyembunyikan sebuah kolom yang menampilkan timestamp pembuatan untuk semua tabel.
Dokumentasi Menampilkan atau menyembunyikan kolom yang menampilkan timestamp Terakhir diperbaharui untuk semua tabel.
Dokumentasi Menampilkan atau menyembunyikan kolom yang menampilkan cek timestamp terakhir untuk semua tabel.
Nomor halaman:
> >>
Filters
Tabel Menaik Menurun 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.0 KB -
akun_aset_inventaris 0 InnoDB latin1_swedish_ci 32.0 KB -
akun_bayar 8 InnoDB latin1_swedish_ci 48.0 KB -
akun_bayar_hutang 0 InnoDB latin1_swedish_ci 32.0 KB -
akun_penagihan_piutang 0 InnoDB latin1_swedish_ci 16.0 KB -
akun_piutang 2 InnoDB latin1_swedish_ci 64.0 KB -
ambil_dankes 0 InnoDB latin1_swedish_ci 48.0 KB -
angsuran_koperasi 0 InnoDB latin1_swedish_ci 64.0 KB -
antrian_loket 8 InnoDB latin1_swedish_ci 16.0 KB -
antrian_referensi 13 InnoDB latin1_swedish_ci 16.0 KB -
antriapotek 1 MyISAM latin1_swedish_ci 3.0 KB -
antriapotek2 1 MyISAM latin1_swedish_ci 1.0 KB -
antriapotek3 1 MyISAM latin1_swedish_ci 1.0 KB -
antriaps 0 MyISAM latin1_swedish_ci 1.0 KB -
antrics 0 MyISAM latin1_swedish_ci 1.0 KB -
antrilabmb 0 MyISAM latin1_swedish_ci 1.0 KB -
antrilabmb2 0 MyISAM latin1_swedish_ci 1.0 KB -
antrilabpa 0 MyISAM latin1_swedish_ci 1.0 KB -
antrilabpa2 0 MyISAM latin1_swedish_ci 1.0 KB -
antrilabpk 0 MyISAM latin1_swedish_ci 1.0 KB -
antrilabpk2 0 MyISAM latin1_swedish_ci 1.0 KB -
antriloket 1 MyISAM latin1_swedish_ci 3.0 KB -
antriloketcetak 0 InnoDB latin1_swedish_ci 16.0 KB -
antripemulangan 0 MyISAM latin1_swedish_ci 1.0 KB -
antripengkajianrestrain 0 MyISAM latin1_swedish_ci 1.0 KB -
antripenolakananjuranmedis 0 MyISAM latin1_swedish_ci 1.0 KB -
antripenundaanpelayanan 0 MyISAM latin1_swedish_ci 1.0 KB -
antripernyataanumum 0 MyISAM latin1_swedish_ci 1.0 KB -
antripersetujuan 0 MyISAM latin1_swedish_ci 1.0 KB -
antripersetujuanrawatinap 0 MyISAM latin1_swedish_ci 1.0 KB -
antripersetujuantransferantarruang 0 MyISAM latin1_swedish_ci 1.0 KB -
antripersetujuanumum 0 MyISAM latin1_swedish_ci 1.0 KB -
antripoli 8 MyISAM latin1_swedish_ci 1.4 KB 40 B
antriprioritas 0 MyISAM latin1_swedish_ci 1.0 KB -
antriradiologi 0 MyISAM latin1_swedish_ci 1.0 KB -
antriradiologi2 1 MyISAM latin1_swedish_ci 1.0 KB -
aplicare_ketersediaan_kamar 0 InnoDB latin1_swedish_ci 112.0 KB -
asuhan_gizi 0 InnoDB latin1_swedish_ci 32.0 KB -
asuransi 5 InnoDB latin1_swedish_ci 32.0 KB -
aturan_pakai ~55,457 InnoDB latin1_swedish_ci 15.5 MB -
audit_bundle_iadp 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_bundle_ido 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_bundle_isk 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_bundle_plabsi 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_bundle_vap 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_cuci_tangan_medis 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_fasilitas_apd 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_fasilitas_kebersihan_tangan 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_kamar_jenazah 0 InnoDB latin1_swedish_ci 16.0 KB -
audit_kepatuhan_apd 0 InnoDB latin1_swedish_ci 16.0 KB -
audit_pembuangan_benda_tajam 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_pembuangan_limbah 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_pembuangan_limbah_cair_infeksius 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_penanganan_darah 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_penempatan_pasien 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_pengelolaan_linen_kotor 0 InnoDB latin1_swedish_ci 32.0 KB -
audit_sterilisasi_alat 0 InnoDB latin1_swedish_ci 32.0 KB -
bahasa_pasien 11 InnoDB latin1_swedish_ci 32.0 KB -
balasan_pengaduan 0 InnoDB latin1_swedish_ci 16.0 KB -
bangsal 12 InnoDB latin1_swedish_ci 48.0 KB -
bank 4 InnoDB latin1_swedish_ci 16.0 KB -
bank_tujuan_transfer_bankmandiri 0 InnoDB latin1_swedish_ci 16.0 KB -
barcode 0 InnoDB latin1_swedish_ci 32.0 KB -
bayar_detail_periksa_lab 0 InnoDB latin1_swedish_ci 80.0 KB -
bayar_detail_periksa_lab_perujuk 0 InnoDB latin1_swedish_ci 80.0 KB -
bayar_jm_dokter 0 InnoDB latin1_swedish_ci 48.0 KB -
bayar_operasi_dokter_anak 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_operasi_dokter_anestesi 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_operasi_dokter_pjanak 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_operasi_dokter_umum 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_operasi_operator1 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_operasi_operator2 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_operasi_operator3 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_pemesanan 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_pemesanan_inventaris 0 InnoDB latin1_swedish_ci 80.0 KB -
bayar_pemesanan_non_medis 0 InnoDB latin1_swedish_ci 80.0 KB -
bayar_periksa_lab 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_periksa_lab_perujuk 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_periksa_radiologi 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_periksa_radiologi_perujuk 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_piutang 0 InnoDB latin1_swedish_ci 144.0 KB -
bayar_piutang_lainlain 0 InnoDB latin1_swedish_ci 80.0 KB -
bayar_rawat_inap_dr 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_rawat_inap_drpr 0 InnoDB latin1_swedish_ci 64.0 KB -
bayar_rawat_jl_dr 0 InnoDB latin1_swedish_ci 48.0 KB -
bayar_rawat_jl_drpr 0 InnoDB latin1_swedish_ci 64.0 KB -
beri_bhp_radiologi 0 InnoDB latin1_swedish_ci 112.0 KB -
beri_obat_operasi 0 InnoDB latin1_swedish_ci 96.0 KB -
berkas_digital_perawatan 13 InnoDB latin1_swedish_ci 32.0 KB -
berkas_pegawai 0 InnoDB latin1_swedish_ci 48.0 KB -
biaya_harian 0 InnoDB latin1_swedish_ci 48.0 KB -
biaya_sekali 0 InnoDB latin1_swedish_ci 48.0 KB -
bidang 8 InnoDB latin1_swedish_ci 16.0 KB -
billing ~1,278,646 InnoDB latin1_swedish_ci 481.6 MB -
booking_operasi 29 InnoDB latin1_swedish_ci 80.0 KB -
booking_periksa 0 InnoDB latin1_swedish_ci 48.0 KB -
booking_periksa_balasan 0 InnoDB latin1_swedish_ci 16.0 KB -
booking_periksa_diterima 0 InnoDB latin1_swedish_ci 32.0 KB -
booking_registrasi 5 InnoDB latin1_swedish_ci 80.0 KB -
bpjs 5 InnoDB latin1_swedish_ci 16.0 KB -
bpjs_prb 24,619 InnoDB latin1_swedish_ci 2.5 MB -
bridging_dukcapil 0 InnoDB latin1_swedish_ci 16.0 KB -
bridging_inhealth 0 InnoDB latin1_swedish_ci 32.0 KB -
bridging_resep_apotek_bpjs 0 InnoDB latin1_swedish_ci 32.0 KB -
bridging_resep_apotek_bpjs_nonracikan 0 InnoDB latin1_swedish_ci 48.0 KB -
bridging_resep_apotek_bpjs_racikan 0 InnoDB latin1_swedish_ci 48.0 KB -
bridging_rujukan_bpjs 13 InnoDB latin1_swedish_ci 32.0 KB -
bridging_rujukan_bpjs_khusus 0 InnoDB latin1_swedish_ci 16.0 KB -
bridging_rujukan_bpjs_khusus_diagnosa 0 InnoDB latin1_swedish_ci 16.0 KB -
bridging_rujukan_bpjs_khusus_prosedur 0 InnoDB latin1_swedish_ci 16.0 KB -
bridging_sep 44,219 InnoDB latin1_swedish_ci 29.1 MB -
bridging_sep_internal 96 InnoDB latin1_swedish_ci 96.0 KB -
bridging_srb_bpjs 0 InnoDB latin1_swedish_ci 16.0 KB -
bridging_srb_bpjs_obat 0 InnoDB latin1_swedish_ci 32.0 KB -
bridging_surat_kontrol_bpjs 33,728 InnoDB latin1_swedish_ci 4.0 MB -
bridging_surat_pri_bpjs 0 InnoDB latin1_swedish_ci 32.0 KB -
bukti_pemesanan 0 InnoDB latin1_swedish_ci 16.0 KB -
bukti_pemesanan_logistik 0 InnoDB latin1_swedish_ci 16.0 KB -
bukti_penagihan_piutang 0 InnoDB latin1_swedish_ci 16.0 KB -
bukti_penyerahan_resep_obat 50,621 InnoDB latin1_swedish_ci 1.5 MB -
bukti_perencanaan_pemulangan_saksikeluarga 0 InnoDB latin1_swedish_ci 16.0 KB -
bukti_persetujuan_penolakan_tindakan_penerimainformasi 0 InnoDB latin1_swedish_ci 16.0 KB -
bukti_persetujuan_penolakan_tindakan_saksikeluarga 0 InnoDB latin1_swedish_ci 16.0 KB -
bukti_persetujuan_penundaan_pelayanan 0 InnoDB latin1_swedish_ci 16.0 KB -
bukti_persetujuan_transfer_pasien_antar_ruang 0 InnoDB latin1_swedish_ci 16.0 KB -
cacat_fisik 6 InnoDB latin1_swedish_ci 32.0 KB -
catatan_adime_gizi 0 InnoDB latin1_swedish_ci 32.0 KB -
catatan_cek_gds 0 InnoDB latin1_swedish_ci 32.0 KB -
catatan_infus_ralan 0 InnoDB latin1_swedish_ci 48.0 KB -
catatan_keperawatan_ralan 0 InnoDB latin1_swedish_ci 48.0 KB -
catatan_keperawatan_ranap 0 InnoDB latin1_swedish_ci 48.0 KB -
catatan_keseimbangan_cairan 0 InnoDB latin1_swedish_ci 48.0 KB -
catatan_observasi_chbp 0 InnoDB latin1_swedish_ci 48.0 KB -
catatan_observasi_igd 0 InnoDB latin1_swedish_ci 48.0 KB -
catatan_observasi_induksi_persalinan 0 InnoDB latin1_swedish_ci 48.0 KB -
catatan_observasi_ranap 0 InnoDB latin1_swedish_ci 48.0 KB -
catatan_observasi_ranap_kebidanan 0 InnoDB latin1_swedish_ci 48.0 KB -
catatan_observasi_ranap_postpartum 0 InnoDB latin1_swedish_ci 48.0 KB -
catatan_pasien 2 InnoDB latin1_swedish_ci 32.0 KB -
catatan_perawatan 0 InnoDB latin1_swedish_ci 48.0 KB -
catatan_persalinan 0 InnoDB latin1_swedish_ci 48.0 KB -
checklist_kriteria_keluar_hcu 0 InnoDB latin1_swedish_ci 32.0 KB -
checklist_kriteria_keluar_icu 0 InnoDB latin1_swedish_ci 32.0 KB -
checklist_kriteria_masuk_hcu 0 InnoDB latin1_swedish_ci 32.0 KB -
checklist_kriteria_masuk_icu 0 InnoDB latin1_swedish_ci 32.0 KB -
checklist_post_operasi 2 InnoDB latin1_swedish_ci 80.0 KB -
checklist_pre_operasi 3 InnoDB latin1_swedish_ci 80.0 KB -
closing_kasir 3 InnoDB latin1_swedish_ci 48.0 KB -
cssd_barang 2 InnoDB latin1_swedish_ci 16.0 KB -
dansos 1 InnoDB latin1_swedish_ci 16.0 KB -
dapurbarang 0 InnoDB latin1_swedish_ci 96.0 KB -
dapurdetailbeli 0 InnoDB latin1_swedish_ci 160.0 KB -
dapurdetailpengeluaran 0 InnoDB latin1_swedish_ci 112.0 KB -
dapuropname 0 InnoDB latin1_swedish_ci 112.0 KB -
dapurpembelian 0 InnoDB latin1_swedish_ci 128.0 KB -
dapurpengeluaran 0 InnoDB latin1_swedish_ci 64.0 KB -
dapursuplier 0 InnoDB latin1_swedish_ci 80.0 KB -
dapur_riwayat_barang 0 InnoDB latin1_swedish_ci 32.0 KB -
databarang 951 InnoDB latin1_swedish_ci 1.3 MB -
datasuplier 47 InnoDB latin1_swedish_ci 80.0 KB -
data_batch 1,641 InnoDB latin1_swedish_ci 224.0 KB -
data_HAIs 0 InnoDB latin1_swedish_ci 272.0 KB -
data_hais 0 InnoDB latin1_swedish_ci 272.0 KB -
data_klasifikasi_pasien_ranap 0 InnoDB latin1_swedish_ci 48.0 KB -
data_tb 0 InnoDB latin1_swedish_ci 32.0 KB -
data_triase_igd 0 InnoDB latin1_swedish_ci 32.0 KB -
data_triase_igddetail_skala1 0 InnoDB latin1_swedish_ci 32.0 KB -
data_triase_igddetail_skala2 0 InnoDB latin1_swedish_ci 32.0 KB -
data_triase_igddetail_skala3 0 InnoDB latin1_swedish_ci 32.0 KB -
data_triase_igddetail_skala4 0 InnoDB latin1_swedish_ci 32.0 KB -
data_triase_igddetail_skala5 0 InnoDB latin1_swedish_ci 32.0 KB -
data_triase_igdprimer 0 InnoDB latin1_swedish_ci 64.0 KB -
data_triase_igdsekunder 0 InnoDB latin1_swedish_ci 32.0 KB -
departemen 9 InnoDB latin1_swedish_ci 32.0 KB -
deposit 0 InnoDB latin1_swedish_ci 80.0 KB -
detailbeli 0 InnoDB latin1_swedish_ci 176.0 KB -
detailhibah_obat_bhp 0 InnoDB latin1_swedish_ci 64.0 KB -
detailjual 2,674 InnoDB latin1_swedish_ci 1.3 MB -
detailjurnal ~696,729 InnoDB latin1_swedish_ci 123.8 MB -
detailpesan 6,878 InnoDB latin1_swedish_ci 3.1 MB -
detailpiutang 0 InnoDB latin1_swedish_ci 176.0 KB -
detail_beri_diet 0 InnoDB latin1_swedish_ci 96.0 KB -
detail_nota_inap 0 InnoDB latin1_swedish_ci 80.0 KB -
detail_nota_jalan 19,221 InnoDB latin1_swedish_ci 7.6 MB -
detail_obat_racikan 0 InnoDB latin1_swedish_ci 48.0 KB -
detail_obat_racikan_jual 0 InnoDB latin1_swedish_ci 32.0 KB -
detail_pemberian_obat ~157,624 InnoDB latin1_swedish_ci 133.8 MB -
detail_penagihan_piutang 0 InnoDB latin1_swedish_ci 32.0 KB -
detail_pengajuan_barang_medis 0 InnoDB latin1_swedish_ci 64.0 KB -
detail_pengajuan_barang_nonmedis 0 InnoDB latin1_swedish_ci 64.0 KB -
detail_pengeluaran_obat_bhp 1,875 InnoDB latin1_swedish_ci 432.0 KB -
detail_periksa_lab 0 InnoDB latin1_swedish_ci 256.0 KB -
detail_periksa_labpa 0 InnoDB latin1_swedish_ci 32.0 KB -
detail_periksa_labpa_gambar 0 InnoDB latin1_swedish_ci 32.0 KB -
detail_permintaan_dapur 0 InnoDB latin1_swedish_ci 64.0 KB -
detail_permintaan_medis 13 InnoDB latin1_swedish_ci 64.0 KB -
detail_permintaan_non_medis 0 InnoDB latin1_swedish_ci 64.0 KB -
detail_permintaan_resep_pulang 0 InnoDB latin1_swedish_ci 48.0 KB -
detail_permintaan_stok_obat_pasien 0 InnoDB latin1_swedish_ci 48.0 KB -
detail_piutang_pasien 80,381 InnoDB latin1_swedish_ci 11.1 MB -
detail_surat_pemesanan_medis 1 InnoDB latin1_swedish_ci 160.0 KB -
detail_surat_pemesanan_non_medis 0 InnoDB latin1_swedish_ci 160.0 KB -
detail_titip_faktur 0 InnoDB latin1_swedish_ci 32.0 KB -
deteksi_dini_corona 0 InnoDB latin1_swedish_ci 32.0 KB -
detreturbeli 0 InnoDB latin1_swedish_ci 176.0 KB -
detreturjual 0 InnoDB latin1_swedish_ci 160.0 KB -
detreturpiutang 0 InnoDB latin1_swedish_ci 160.0 KB -
diagnosa_corona 0 InnoDB latin1_swedish_ci 16.0 KB -
diagnosa_pasien 10,224 InnoDB latin1_swedish_ci 2.3 MB -
diet 42 InnoDB latin1_swedish_ci 32.0 KB -
dokter 10 InnoDB latin1_swedish_ci 240.0 KB -
dpjp_ranap 0 InnoDB latin1_swedish_ci 32.0 KB -
edukasi_pasien_keluarga_rj 0 InnoDB latin1_swedish_ci 32.0 KB -
emergency_index 4 InnoDB latin1_swedish_ci 16.0 KB -
evaluasi_kinerja 5 InnoDB latin1_swedish_ci 16.0 KB -
evaluasi_kinerja_pegawai 0 InnoDB latin1_swedish_ci 32.0 KB -
follow_up_dbd 0 InnoDB latin1_swedish_ci 48.0 KB -
gambar 1 InnoDB latin1_swedish_ci 16.0 KB -
gambar_radiologi 0 InnoDB latin1_swedish_ci 16.0 KB -
golongan_barang 11 InnoDB latin1_swedish_ci 16.0 KB -
golongan_polri 3 InnoDB latin1_swedish_ci 16.0 KB -
golongan_tni 4 InnoDB latin1_swedish_ci 16.0 KB -
gudangbarang 992 InnoDB latin1_swedish_ci 272.0 KB -
harian_kurangi_bulanan 5 InnoDB latin1_swedish_ci 48.0 KB -
hasil_endoskopi_faring_laring 0 InnoDB latin1_swedish_ci 32.0 KB -
hasil_endoskopi_faring_laring_gambar 0 InnoDB latin1_swedish_ci 16.0 KB -
hasil_endoskopi_hidung 0 InnoDB latin1_swedish_ci 32.0 KB -
hasil_endoskopi_hidung_gambar 0 InnoDB latin1_swedish_ci 16.0 KB -
hasil_endoskopi_telinga 0 InnoDB latin1_swedish_ci 32.0 KB -
hasil_endoskopi_telinga_gambar 0 InnoDB latin1_swedish_ci 16.0 KB -
hasil_pemeriksaan_ekg 0 InnoDB latin1_swedish_ci 32.0 KB -
hasil_pemeriksaan_ekg_gambar 0 InnoDB latin1_swedish_ci 16.0 KB -
hasil_pemeriksaan_usg 0 InnoDB latin1_swedish_ci 32.0 KB -
hasil_pemeriksaan_usg_gambar 0 InnoDB latin1_swedish_ci 16.0 KB -
hasil_pemeriksaan_usg_gynecologi 0 InnoDB latin1_swedish_ci 32.0 KB -
hasil_pemeriksaan_usg_gynecologi_gambar 0 InnoDB latin1_swedish_ci 16.0 KB -
hasil_pemeriksaan_usg_neonatus 0 InnoDB latin1_swedish_ci 32.0 KB -
hasil_pemeriksaan_usg_neonatus_gambar 0 InnoDB latin1_swedish_ci 16.0 KB -
hasil_pemeriksaan_usg_urologi 0 InnoDB latin1_swedish_ci 32.0 KB -
hasil_pemeriksaan_usg_urologi_gambar 0 InnoDB latin1_swedish_ci 16.0 KB -
hasil_radiologi 1 InnoDB latin1_swedish_ci 32.0 KB -
hasil_tindakan_eswl 0 InnoDB latin1_swedish_ci 48.0 KB -
hemodialisa 0 InnoDB latin1_swedish_ci 64.0 KB -
hibah_obat_bhp 0 InnoDB latin1_swedish_ci 64.0 KB -
icd9 3,882 InnoDB latin1_swedish_ci 400.0 KB -
inacbg_coder_nik 2 InnoDB latin1_swedish_ci 16.0 KB -
inacbg_data_terkirim 0 InnoDB latin1_swedish_ci 16.0 KB -
inacbg_data_terkirim2 0 InnoDB latin1_swedish_ci 16.0 KB -
inacbg_data_terkirim_internal 0 InnoDB latin1_swedish_ci 16.0 KB -
inacbg_grouping_stage1 0 InnoDB latin1_swedish_ci 16.0 KB -
250 tabel Jumlah ~2,470,785 InnoDB utf8mb4_general_ci 830.1 MB 40 B
Nomor halaman:
> >>

Buat tabel
Nama:
Jumlah kolom: