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
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 31 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 1,000 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_echo 0 InnoDB latin1_swedish_ci 32.0 KiB -
hasil_pemeriksaan_echo_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_oct 0 InnoDB latin1_swedish_ci 32.0 KiB -
hasil_pemeriksaan_oct_gambar 0 InnoDB latin1_swedish_ci 16.0 KiB -
hasil_pemeriksaan_slit_lamp 0 InnoDB latin1_swedish_ci 32.0 KiB -
hasil_pemeriksaan_slit_lamp_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 -
inacbg_grouping_stage1_internal 0 InnoDB latin1_swedish_ci 16.0 KiB -
inacbg_grouping_stage12 0 InnoDB latin1_swedish_ci 16.0 KiB -
inacbg_klaim_baru 75 InnoDB latin1_swedish_ci 16.0 KiB -
inacbg_klaim_baru2 5 InnoDB latin1_swedish_ci 32.0 KiB -
inacbg_klaim_baru_internal 0 InnoDB latin1_swedish_ci 16.0 KiB -
inacbg_noklaim_corona 0 InnoDB latin1_swedish_ci 32.0 KiB -
indekref 82 InnoDB latin1_swedish_ci 64.0 KiB -
indexins 3 InnoDB latin1_swedish_ci 32.0 KiB -
indextotal 82 InnoDB latin1_swedish_ci 48.0 KiB -
industrifarmasi 8 InnoDB latin1_swedish_ci 80.0 KiB -
inhealth_jenpel_ruang_rawat 0 InnoDB latin1_swedish_ci 16.0 KiB -
inhealth_maping_dokter 0 InnoDB latin1_swedish_ci 16.0 KiB -
inhealth_maping_poli 0 InnoDB latin1_swedish_ci 16.0 KiB -
inhealth_tindakan_laborat 0 InnoDB latin1_swedish_ci 16.0 KiB -
inhealth_tindakan_operasi 0 InnoDB latin1_swedish_ci 16.0 KiB -
inhealth_tindakan_radiologi 0 InnoDB latin1_swedish_ci 16.0 KiB -
inhealth_tindakan_ralan 0 InnoDB latin1_swedish_ci 16.0 KiB -
inhealth_tindakan_ranap 0 InnoDB latin1_swedish_ci 16.0 KiB -
insiden_keselamatan 5 InnoDB latin1_swedish_ci 16.0 KiB -
insiden_keselamatan_pasien 0 InnoDB latin1_swedish_ci 64.0 KiB -
inventaris 13 InnoDB latin1_swedish_ci 144.0 KiB -
inventaris_ambil_cssd 0 InnoDB latin1_swedish_ci 48.0 KiB -
inventaris_barang 5 InnoDB latin1_swedish_ci 144.0 KiB -
inventaris_bukti_pemesanan 0 InnoDB latin1_swedish_ci 16.0 KiB -
inventaris_detail_beli 0 InnoDB latin1_swedish_ci 32.0 KiB -
inventaris_detail_hibah 0 InnoDB latin1_swedish_ci 48.0 KiB -
inventaris_detail_pesan 0 InnoDB latin1_swedish_ci 48.0 KiB -
inventaris_detail_titip_faktur 0 InnoDB latin1_swedish_ci 32.0 KiB -
inventaris_gambar 0 InnoDB latin1_swedish_ci 16.0 KiB -
inventaris_hibah 0 InnoDB latin1_swedish_ci 64.0 KiB -
inventaris_jenis 3 InnoDB latin1_swedish_ci 32.0 KiB -
inventaris_kategori 2 InnoDB latin1_swedish_ci 32.0 KiB -
inventaris_kembali_cssd 0 InnoDB latin1_swedish_ci 32.0 KiB -
inventaris_merk 3 InnoDB latin1_swedish_ci 32.0 KiB -
inventaris_pembelian 0 InnoDB latin1_swedish_ci 144.0 KiB -
inventaris_pemesanan 0 InnoDB latin1_swedish_ci 48.0 KiB -
inventaris_peminjaman 0 InnoDB latin1_swedish_ci 80.0 KiB -
inventaris_produsen 3 InnoDB latin1_swedish_ci 96.0 KiB -
inventaris_ruang 3 InnoDB latin1_swedish_ci 32.0 KiB -
inventaris_sterilisasi_cssd 0 InnoDB latin1_swedish_ci 32.0 KiB -
inventaris_suplier 0 InnoDB latin1_swedish_ci 80.0 KiB -
inventaris_titip_faktur 0 InnoDB latin1_swedish_ci 32.0 KiB -
ipsrsbarang 9 InnoDB latin1_swedish_ci 112.0 KiB -
ipsrsdetailbeli 0 InnoDB latin1_swedish_ci 160.0 KiB -
ipsrsdetailpengeluaran 0 InnoDB latin1_swedish_ci 112.0 KiB -
ipsrsdetailpesan 0 InnoDB latin1_swedish_ci 64.0 KiB -
ipsrsjenisbarang 8 InnoDB latin1_swedish_ci 16.0 KiB -
ipsrsopname 10 InnoDB latin1_swedish_ci 112.0 KiB -
ipsrspembelian 0 InnoDB latin1_swedish_ci 128.0 KiB -
ipsrspemesanan 0 InnoDB latin1_swedish_ci 48.0 KiB -
ipsrspengeluaran 0 InnoDB latin1_swedish_ci 64.0 KiB -
ipsrsreturbeli 0 InnoDB latin1_swedish_ci 48.0 KiB -
ipsrssuplier 5 InnoDB latin1_swedish_ci 80.0 KiB -
ipsrs_detail_hibah 0 InnoDB latin1_swedish_ci 64.0 KiB -
ipsrs_detail_returbeli 0 InnoDB latin1_swedish_ci 64.0 KiB -
ipsrs_detail_titip_faktur 0 InnoDB latin1_swedish_ci 32.0 KiB -
ipsrs_hibah 0 InnoDB latin1_swedish_ci 48.0 KiB -
ipsrs_riwayat_barang 0 InnoDB latin1_swedish_ci 32.0 KiB -
ipsrs_titip_faktur 0 InnoDB latin1_swedish_ci 32.0 KiB -
jabatan 20 InnoDB latin1_swedish_ci 32.0 KiB -
jabatan_polri 3 InnoDB latin1_swedish_ci 16.0 KiB -
jabatan_tni 3 InnoDB latin1_swedish_ci 16.0 KiB -
jadwal 34 InnoDB latin1_swedish_ci 80.0 KiB -
jadwal_pegawai 23 InnoDB latin1_swedish_ci 176.0 KiB -
jadwal_tambahan 0 InnoDB latin1_swedish_ci 16.0 KiB -
jamsostek 4 InnoDB latin1_swedish_ci 32.0 KiB -
jam_diet_pasien 0 InnoDB latin1_swedish_ci 16.0 KiB -
jam_jaga 7 InnoDB latin1_swedish_ci 96.0 KiB -
jam_masuk 10 InnoDB latin1_swedish_ci 16.0 KiB -
jasa_lain 0 InnoDB latin1_swedish_ci 32.0 KiB -
jawaban_konsultasi_medik 0 InnoDB latin1_swedish_ci 16.0 KiB -
jawaban_pio_apoteker 0 InnoDB latin1_swedish_ci 32.0 KiB -
jenis 47 InnoDB latin1_swedish_ci 48.0 KiB -
jgmlm 0 InnoDB latin1_swedish_ci 48.0 KiB -
jnj_jabatan 14 InnoDB latin1_swedish_ci 48.0 KiB -
jns_perawatan 181 InnoDB latin1_swedish_ci 288.0 KiB -
jns_perawatan_inap 0 InnoDB latin1_swedish_ci 240.0 KiB -
jns_perawatan_lab 0 InnoDB latin1_swedish_ci 192.0 KiB -
jns_perawatan_radiologi 52 InnoDB latin1_swedish_ci 192.0 KiB -
jns_perawatan_utd 0 InnoDB latin1_swedish_ci 32.0 KiB -
jumpasien 0 InnoDB latin1_swedish_ci 48.0 KiB -
jurnal ~174,610 InnoDB latin1_swedish_ci 92.5 MiB -
k3rs_bagian_tubuh 5 InnoDB latin1_swedish_ci 16.0 KiB -
k3rs_dampak_cidera 5 InnoDB latin1_swedish_ci 16.0 KiB -
k3rs_jenis_cidera 3 InnoDB latin1_swedish_ci 16.0 KiB -
k3rs_jenis_luka 5 InnoDB latin1_swedish_ci 16.0 KiB -
k3rs_jenis_pekerjaan 6 InnoDB latin1_swedish_ci 16.0 KiB -
k3rs_lokasi_kejadian 4 InnoDB latin1_swedish_ci 16.0 KiB -
k3rs_penyebab 3 InnoDB latin1_swedish_ci 16.0 KiB -
k3rs_peristiwa 0 InnoDB latin1_swedish_ci 176.0 KiB -
kabupaten 101 InnoDB latin1_swedish_ci 32.0 KiB -
kamar 11 InnoDB latin1_swedish_ci 96.0 KiB -
kamar_inap 0 InnoDB latin1_swedish_ci 160.0 KiB -
kasift 0 InnoDB latin1_swedish_ci 48.0 KiB -
kategori_barang 2 InnoDB latin1_swedish_ci 16.0 KiB -
kategori_pemasukan_lain 4 InnoDB latin1_swedish_ci 48.0 KiB -
kategori_pengeluaran_harian 8 InnoDB latin1_swedish_ci 48.0 KiB -
kategori_penyakit 1 InnoDB latin1_swedish_ci 48.0 KiB -
kategori_perawatan 6 InnoDB latin1_swedish_ci 32.0 KiB -
kategori_piutang_jasa_perusahaan 0 InnoDB latin1_swedish_ci 16.0 KiB -
keanggotaan 0 InnoDB latin1_swedish_ci 64.0 KiB -
kecamatan 173 InnoDB latin1_swedish_ci 32.0 KiB -
kelompok_jabatan 8 InnoDB latin1_swedish_ci 16.0 KiB -
kelurahan 436 InnoDB latin1_swedish_ci 32.0 KiB -
kesling_limbah_b3medis 0 InnoDB latin1_swedish_ci 16.0 KiB -
kesling_limbah_b3medis_cair 0 InnoDB latin1_swedish_ci 16.0 KiB -
kesling_limbah_domestik 0 InnoDB latin1_swedish_ci 16.0 KiB -
kesling_mutu_air_limbah 0 InnoDB latin1_swedish_ci 16.0 KiB -
kesling_pemakaian_air_pdam 0 InnoDB latin1_swedish_ci 16.0 KiB -
kesling_pemakaian_air_tanah 0 InnoDB latin1_swedish_ci 16.0 KiB -
kesling_pest_control 0 InnoDB latin1_swedish_ci 16.0 KiB -
ketidakhadiran 0 InnoDB latin1_swedish_ci 64.0 KiB -
kodesatuan 48 InnoDB latin1_swedish_ci 32.0 KiB -
kodetransaksi_tujuan_transfer_bankmandiri 0 InnoDB latin1_swedish_ci 48.0 KiB -
konseling_farmasi 0 InnoDB latin1_swedish_ci 32.0 KiB -
konsultasi_medik 0 InnoDB latin1_swedish_ci 64.0 KiB -
konver_sat 7 InnoDB latin1_swedish_ci 64.0 KiB -
koperasi 2 InnoDB latin1_swedish_ci 32.0 KiB -
laborat_kesling_master_sampel 0 InnoDB latin1_swedish_ci 16.0 KiB -
laborat_kesling_pelanggan 0 InnoDB latin1_swedish_ci 16.0 KiB -
laporan_anestesi 0 InnoDB latin1_swedish_ci 128.0 KiB -
laporan_operasi 184 InnoDB latin1_swedish_ci 128.0 KiB -
laporan_tindakan 0 InnoDB latin1_swedish_ci 48.0 KiB -
layanan_kedokteran_fisik_rehabilitasi 0 InnoDB latin1_swedish_ci 32.0 KiB -
layanan_program_kfr 0 InnoDB latin1_swedish_ci 48.0 KiB -
log_dukcapil_aceh 0 InnoDB latin1_swedish_ci 16.0 KiB -
maping_dokter_dpjpvclaim 8 InnoDB latin1_swedish_ci 16.0 KiB -
maping_dokter_pcare 0 InnoDB latin1_swedish_ci 16.0 KiB -
maping_obat_apotek_bpjs 0 InnoDB latin1_swedish_ci 32.0 KiB -
maping_obat_pcare 0 InnoDB latin1_swedish_ci 16.0 KiB -
maping_poliklinik_pcare 0 InnoDB latin1_swedish_ci 16.0 KiB -
maping_poli_bpjs 1 InnoDB latin1_swedish_ci 32.0 KiB -
maping_tindakan_pcare 0 InnoDB latin1_swedish_ci 16.0 KiB -
maping_tindakan_ranap_pcare 0 InnoDB latin1_swedish_ci 16.0 KiB -
master_aturan_pakai 85 MyISAM latin1_swedish_ci 9.5 KiB -
master_berkas_digital 12 InnoDB latin1_swedish_ci 16.0 KiB -
master_berkas_pegawai 14 InnoDB latin1_swedish_ci 16.0 KiB -
master_imunisasi 0 InnoDB latin1_swedish_ci 16.0 KiB -
master_kesimpulan_anjuran_mcu 0 MyISAM latin1_swedish_ci 2.0 KiB -
master_masalah_keperawatan 5 InnoDB latin1_swedish_ci 16.0 KiB -
master_masalah_keperawatan_anak 0 InnoDB latin1_swedish_ci 16.0 KiB -
master_masalah_keperawatan_geriatri 0 InnoDB latin1_swedish_ci 16.0 KiB -
master_masalah_keperawatan_gigi 0 InnoDB latin1_swedish_ci 16.0 KiB -
master_masalah_keperawatan_igd 0 InnoDB latin1_swedish_ci 16.0 KiB -
master_masalah_keperawatan_mata 0 InnoDB latin1_swedish_ci 16.0 KiB -
master_masalah_keperawatan_neonatus 0 InnoDB latin1_swedish_ci 16.0 KiB -
master_masalah_keperawatan_psikiatri 0 InnoDB latin1_swedish_ci 16.0 KiB -
master_masalah_mpp 0 InnoDB latin1_swedish_ci 16.0 KiB -
master_menolak_anjuran_medis 0 InnoDB latin1_swedish_ci 16.0 KiB -
master_rencana_keperawatan 5 InnoDB latin1_swedish_ci 32.0 KiB -
master_rencana_keperawatan_anak 0 InnoDB latin1_swedish_ci 32.0 KiB -
master_rencana_keperawatan_geriatri 0 InnoDB latin1_swedish_ci 32.0 KiB -
master_rencana_keperawatan_gigi 0 InnoDB latin1_swedish_ci 32.0 KiB -
master_rencana_keperawatan_igd 0 InnoDB latin1_swedish_ci 32.0 KiB -
master_rencana_keperawatan_mata 0 InnoDB latin1_swedish_ci 32.0 KiB -
master_rencana_keperawatan_neonatus 0 InnoDB latin1_swedish_ci 32.0 KiB -
master_rencana_keperawatan_psikiatri 0 InnoDB latin1_swedish_ci 32.0 KiB -
master_sekolah 0 InnoDB latin1_swedish_ci 16.0 KiB -
master_tindakan 4 InnoDB latin1_swedish_ci 64.0 KiB -
master_triase_macam_kasus 4 InnoDB latin1_swedish_ci 16.0 KiB -
master_triase_pemeriksaan 8 InnoDB latin1_swedish_ci 16.0 KiB -
master_triase_skala1 13 InnoDB latin1_swedish_ci 32.0 KiB -
master_triase_skala2 14 InnoDB latin1_swedish_ci 32.0 KiB -
master_triase_skala3 13 InnoDB latin1_swedish_ci 32.0 KiB -
master_triase_skala4 12 InnoDB latin1_swedish_ci 32.0 KiB -
master_triase_skala5 12 InnoDB latin1_swedish_ci 32.0 KiB -
master_tunjangan_bulanan 6 InnoDB latin1_swedish_ci 48.0 KiB -
master_tunjangan_harian 3 InnoDB latin1_swedish_ci 48.0 KiB -
matrik_akun_jns_perawatan 0 InnoDB latin1_swedish_ci 224.0 KiB -
matrik_akun_jns_perawatan_inap 0 InnoDB latin1_swedish_ci 224.0 KiB -
metode_pembayaran_bankmandiri 0 InnoDB latin1_swedish_ci 16.0 KiB -
metode_racik 5 InnoDB latin1_swedish_ci 16.0 KiB -
monitoring_asuhan_gizi 0 InnoDB latin1_swedish_ci 32.0 KiB -
monitoring_reaksi_tranfusi 0 InnoDB latin1_swedish_ci 48.0 KiB -
mpp_evaluasi 0 InnoDB latin1_swedish_ci 64.0 KiB -
mpp_evaluasi_catatan 0 InnoDB latin1_swedish_ci 48.0 KiB -
mpp_evaluasi_masalah 0 InnoDB latin1_swedish_ci 32.0 KiB -
mpp_skrining 0 InnoDB latin1_swedish_ci 32.0 KiB -
mutasibarang 1 InnoDB latin1_swedish_ci 96.0 KiB -
mutasi_berkas 58,562 InnoDB latin1_swedish_ci 4.5 MiB -
nota_inap 0 InnoDB latin1_swedish_ci 80.0 KiB -
nota_jalan ~66,174 InnoDB latin1_swedish_ci 16.1 MiB -
obatbhp_ok 3 InnoDB latin1_swedish_ci 64.0 KiB -
obat_penyakit 0 InnoDB latin1_swedish_ci 48.0 KiB -
obat_racikan 0 InnoDB latin1_swedish_ci 64.0 KiB -
obat_racikan_jual 0 InnoDB latin1_swedish_ci 32.0 KiB -
operasi 184 InnoDB latin1_swedish_ci 464.0 KiB -
opname 6,528 InnoDB latin1_swedish_ci 2.8 MiB -
paket_operasi 25 InnoDB latin1_swedish_ci 480.0 KiB -
pangkat_polri 3 InnoDB latin1_swedish_ci 16.0 KiB -
pangkat_tni 3 InnoDB latin1_swedish_ci 16.0 KiB -
parkir 0 InnoDB latin1_swedish_ci 64.0 KiB -
parkir_barcode 1 InnoDB latin1_swedish_ci 32.0 KiB -
parkir_jenis 2 InnoDB latin1_swedish_ci 16.0 KiB -
pasien ~54,015 InnoDB latin1_swedish_ci 44.1 MiB -
pasien_bayi 0 InnoDB latin1_swedish_ci 192.0 KiB -
pasien_corona 0 InnoDB latin1_swedish_ci 16.0 KiB -
pasien_mati 0 InnoDB latin1_swedish_ci 48.0 KiB -
pasien_polri 0 InnoDB latin1_swedish_ci 80.0 KiB -
pasien_tni 0 InnoDB latin1_swedish_ci 80.0 KiB -
password_asuransi 1 InnoDB latin1_swedish_ci 32.0 KiB -
password_perusahaan_pasien 0 InnoDB latin1_swedish_ci 16.0 KiB -
pcare_kegiatan_kelompok 2 InnoDB latin1_swedish_ci 16.0 KiB -
pcare_kunjungan_umum 0 InnoDB latin1_swedish_ci 16.0 KiB -
pcare_obat_diberikan 0 InnoDB latin1_swedish_ci 48.0 KiB -
pcare_pendaftaran 0 InnoDB latin1_swedish_ci 16.0 KiB -
pcare_peserta_kegiatan_kelompok 0 InnoDB latin1_swedish_ci 32.0 KiB -
250 tables Sum ~367,031 InnoDB utf8mb4_general_ci 171.8 MiB 0 B
Page number:<< <
> >>

Create table
Name:
Number of columns: