Letakkan berkas disini

SQL upload ( 0 ) x-

Server: localhost »Basis data: sik2
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.3 KB -
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 ~114,433 InnoDB latin1_swedish_ci 29.7 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,841,141 InnoDB latin1_swedish_ci 691.9 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,844 InnoDB latin1_swedish_ci 1.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 14 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,556 InnoDB latin1_swedish_ci 26.1 MB -
bridging_sep_internal 96 InnoDB latin1_swedish_ci 112.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,980 InnoDB latin1_swedish_ci 8.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,932 InnoDB latin1_swedish_ci 3.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,645 InnoDB latin1_swedish_ci 416.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 32.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,677 InnoDB latin1_swedish_ci 1.5 MB -
detailjurnal ~1,065,002 InnoDB latin1_swedish_ci 186.9 MB -
detailpesan 6,886 InnoDB latin1_swedish_ci 3.7 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,265 InnoDB latin1_swedish_ci 8.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 ~231,200 InnoDB latin1_swedish_ci 196.0 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,881 InnoDB latin1_swedish_ci 656.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,539 InnoDB latin1_swedish_ci 16.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,272 InnoDB latin1_swedish_ci 2.0 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 240.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 ~3,535,502 InnoDB utf8mb4_general_ci 1.2 GB 0 B
Nomor halaman:
> >>

Buat tabel
Nama:
Jumlah kolom: