Suelte aquí los archivos

SQL upload ( 0 ) x-

Servidor: localhost »Base de datos: sik2
Ajustes de página relacionadaPulse en la barra para deslizarse al tope de la página
Presione Ctrl+Enter para ejecutar la consulta Presione Enter para ejecutar la consulta
ascendente
descendente
Orden:
Depuración SQL
Cantidad
Orden de ejecución
Tiempo necesario
Ordenar por:
Consultas grupales
Desagrupar las consultas
Colapsar Expandir Mostrar rastro Ocultar rastro Cantidad Tiempo necesario
Favoritos
Actualizar
Agregar
Ningún favorito
Agregar favorito
Opciones
Definir predeterminado





Colapsar Expandir Reconsultar Editar Explicar Perfilando Agregar a favoritos Falló la consulta Base de datos : Fecha y hora la consulta :

Estructura de base de datos

Elija los detalles a mostrar en la estructura de base de datos (lista de tablas).

Documentación Mostrar u ocultar una columna, mostrando conjunto de caracteres de todas las tablas.
Documentación Mostrar u ocultar una columna, mostrando los comentarios de todas las tablas.
Documentación Mostrar o esconder una columna con las marcas temporales de creación para todas las tablas.
Documentación Mostrar o esconder una columna con la marca temporal de la última actualización para todas las tablas.
Documentación Mostrar o esconder una columna con la marca temporal de la última revisión para todas las tablas.
Número de página:<< <
> >>
Filtros
Tabla Ascendente Descendente Acción Filas Podría ser aproximado. Pulse en el número para obtener la cantidad exacta. Ver FAQ 3.11. Tipo Cotejamiento Tamaño Residuo a depurar
set_akun_bankpapua 0 InnoDB latin1_swedish_ci 32.0 KB -
set_akun_mandiri 0 InnoDB latin1_swedish_ci 16.0 KB -
set_akun_ralan 1 InnoDB latin1_swedish_ci 1.0 MB -
set_akun_ranap 1 InnoDB latin1_swedish_ci 1.0 MB -
set_akun_ranap2 0 InnoDB latin1_swedish_ci 96.0 KB -
set_alamat_pasien 1 MyISAM latin1_swedish_ci 1.0 KB -
set_depo_ralan 0 InnoDB latin1_swedish_ci 32.0 KB -
set_depo_ranap 0 InnoDB latin1_swedish_ci 32.0 KB -
set_embalase 1 InnoDB latin1_swedish_ci 16.0 KB -
set_hadir 1 InnoDB latin1_swedish_ci 16.0 KB -
set_harga_kamar 0 InnoDB latin1_swedish_ci 48.0 KB -
set_harga_obat 1 InnoDB latin1_swedish_ci 16.0 KB -
set_harga_obat_ralan 1 InnoDB latin1_swedish_ci 16.0 KB -
set_harga_obat_ranap 0 InnoDB latin1_swedish_ci 16.0 KB -
set_hari_libur 6 InnoDB latin1_swedish_ci 16.0 KB -
set_input_parsial 2 InnoDB latin1_swedish_ci 16.0 KB -
set_insentif 11 InnoDB latin1_swedish_ci 16.0 KB -
set_jam_minimal 1 MyISAM latin1_swedish_ci 1.0 KB -
set_jgmlm 1 InnoDB latin1_swedish_ci 16.0 KB -
set_jgtambah 0 InnoDB latin1_swedish_ci 16.0 KB -
set_kelengkapan_data_pasien 1 MyISAM latin1_swedish_ci 1.0 KB -
set_keterlambatan 1 MyISAM latin1_swedish_ci 1.0 KB -
set_lemburhb 1 InnoDB latin1_swedish_ci 16.0 KB -
set_lemburhr 1 InnoDB latin1_swedish_ci 16.0 KB -
set_lokasi 1 InnoDB latin1_swedish_ci 32.0 KB -
set_modal_payment 1 MyISAM latin1_swedish_ci 1.0 KB -
set_nota 1 MyISAM latin1_swedish_ci 1.1 KB -
set_no_rkm_medis 1 InnoDB latin1_swedish_ci 16.0 KB -
set_otomatis_tindakan_ralan 44 InnoDB latin1_swedish_ci 64.0 KB -
set_otomatis_tindakan_ralan_dokterpetugas 0 InnoDB latin1_swedish_ci 48.0 KB -
set_otomatis_tindakan_ralan_petugas 3 InnoDB latin1_swedish_ci 32.0 KB -
set_pjlab 0 InnoDB latin1_swedish_ci 80.0 KB -
set_resume 4 InnoDB latin1_swedish_ci 16.0 KB -
set_service_ranap 0 InnoDB latin1_swedish_ci 16.0 KB -
set_service_ranap_piutang 0 InnoDB latin1_swedish_ci 16.0 KB -
set_tahun 1 InnoDB latin1_swedish_ci 16.0 KB -
set_tarif 1 InnoDB latin1_swedish_ci 32.0 KB -
set_tarif_online 0 InnoDB latin1_swedish_ci 16.0 KB -
set_tni_polri 1 MyISAM latin1_swedish_ci 1.0 KB -
set_tnjanak 0 InnoDB latin1_swedish_ci 16.0 KB -
set_tnjnikah 0 InnoDB latin1_swedish_ci 16.0 KB -
set_tuslah 4 InnoDB latin1_swedish_ci 16.0 KB -
set_urut_no_rkm_medis 1 MyISAM latin1_swedish_ci 2.0 KB -
set_validasi_catatan 1 MyISAM latin1_swedish_ci 1.0 KB -
set_validasi_registrasi 1 MyISAM latin1_swedish_ci 1.0 KB -
set_warung 1 InnoDB latin1_swedish_ci 16.0 KB -
sidikjari 0 InnoDB latin1_swedish_ci 16.0 KB -
sidikjaripasien 0 InnoDB latin1_swedish_ci 16.0 KB -
signin_sebelum_anestesi 0 InnoDB latin1_swedish_ci 64.0 KB -
signout_sebelum_menutup_luka 0 InnoDB latin1_swedish_ci 64.0 KB -
siranap_ketersediaan_kamar 0 InnoDB latin1_swedish_ci 112.0 KB -
sisa_diet_pasien 0 InnoDB latin1_swedish_ci 80.0 KB -
sisrute_rujukan_keluar 0 InnoDB latin1_swedish_ci 16.0 KB -
skdp_bpjs 0 InnoDB latin1_swedish_ci 48.0 KB -
skor_aldrette_pasca_anestesi 0 InnoDB latin1_swedish_ci 48.0 KB -
skor_bromage_pasca_anestesi 0 InnoDB latin1_swedish_ci 48.0 KB -
skor_steward_pasca_anestesi 0 InnoDB latin1_swedish_ci 48.0 KB -
skp_detail_penilaian 0 InnoDB latin1_swedish_ci 32.0 KB -
skp_detail_rekapitulasi_penilaian 0 InnoDB latin1_swedish_ci 32.0 KB -
skp_kategori_penilaian 0 InnoDB latin1_swedish_ci 16.0 KB -
skp_kriteria_penilaian 0 InnoDB latin1_swedish_ci 32.0 KB -
skp_penilaian 0 InnoDB latin1_swedish_ci 48.0 KB -
skp_rekapitulasi_penilaian 0 InnoDB latin1_swedish_ci 48.0 KB -
skrining_gizi 0 InnoDB latin1_swedish_ci 32.0 KB -
skrining_nutrisi_anak 0 InnoDB latin1_swedish_ci 32.0 KB -
skrining_nutrisi_dewasa 0 InnoDB latin1_swedish_ci 32.0 KB -
skrining_nutrisi_lansia 0 InnoDB latin1_swedish_ci 32.0 KB -
skrining_rawat_jalan 0 InnoDB latin1_swedish_ci 48.0 KB -
sms 0 InnoDB latin1_swedish_ci 16.0 KB -
spesialis 18 InnoDB latin1_swedish_ci 16.0 KB -
stok_obat_pasien 0 InnoDB latin1_swedish_ci 64.0 KB -
stts_kerja 13 InnoDB latin1_swedish_ci 16.0 KB -
stts_wp 10 InnoDB latin1_swedish_ci 16.0 KB -
subrekening 157 InnoDB latin1_swedish_ci 32.0 KB -
suku_bangsa 14 InnoDB latin1_swedish_ci 32.0 KB -
suratsakit 0 InnoDB latin1_swedish_ci 32.0 KB -
suratsakitpihak2 0 InnoDB latin1_swedish_ci 32.0 KB -
surat_balas 2 InnoDB latin1_swedish_ci 16.0 KB -
surat_bebas_tato 0 InnoDB latin1_swedish_ci 32.0 KB -
surat_bebas_tbc 0 InnoDB latin1_swedish_ci 48.0 KB -
surat_buta_warna 0 InnoDB latin1_swedish_ci 32.0 KB -
surat_cuti_hamil 0 InnoDB latin1_swedish_ci 32.0 KB -
surat_hamil 0 InnoDB latin1_swedish_ci 32.0 KB -
surat_indeks 3 InnoDB latin1_swedish_ci 16.0 KB -
surat_keluar 0 InnoDB latin1_swedish_ci 144.0 KB -
surat_keluar_disposisi 0 InnoDB latin1_swedish_ci 48.0 KB -
surat_keluar_kendali 0 InnoDB latin1_swedish_ci 48.0 KB -
surat_keluar_set_nomor 1 InnoDB latin1_swedish_ci 16.0 KB -
surat_keterangan_covid 0 InnoDB latin1_swedish_ci 64.0 KB -
surat_keterangan_rawat_inap 0 InnoDB latin1_swedish_ci 32.0 KB -
surat_keterangan_sehat 0 InnoDB latin1_swedish_ci 32.0 KB -
surat_kewaspadaan_kesehatan 0 InnoDB latin1_swedish_ci 32.0 KB -
surat_klasifikasi 3 InnoDB latin1_swedish_ci 16.0 KB -
surat_lemari 2 InnoDB latin1_swedish_ci 16.0 KB -
surat_map 2 InnoDB latin1_swedish_ci 16.0 KB -
surat_masuk 11 InnoDB latin1_swedish_ci 144.0 KB -
surat_masuk_disposisi 0 InnoDB latin1_swedish_ci 48.0 KB -
surat_masuk_kendali 0 InnoDB latin1_swedish_ci 48.0 KB -
surat_pemesanan_medis 1 InnoDB latin1_swedish_ci 48.0 KB -
surat_pemesanan_non_medis 0 InnoDB latin1_swedish_ci 48.0 KB -
surat_penolakan_anjuran_medis 0 InnoDB latin1_swedish_ci 64.0 KB -
surat_penolakan_anjuran_medis_pembuat_pernyataan 0 InnoDB latin1_swedish_ci 16.0 KB -
surat_pernyataan_pasien_umum 0 InnoDB latin1_swedish_ci 48.0 KB -
surat_pernyataan_pasien_umum_pembuat_pernyataan 0 InnoDB latin1_swedish_ci 16.0 KB -
surat_persetujuan_rawat_inap 0 InnoDB latin1_swedish_ci 48.0 KB -
surat_persetujuan_rawat_inap_pembuat_pernyataan 0 InnoDB latin1_swedish_ci 16.0 KB -
surat_persetujuan_umum 0 InnoDB latin1_swedish_ci 48.0 KB -
surat_persetujuan_umum_pembuat_pernyataan 0 InnoDB latin1_swedish_ci 16.0 KB -
surat_pulang_atas_permintaan_sendiri 0 InnoDB latin1_swedish_ci 48.0 KB -
surat_pulang_atas_permintaan_sendiri_pembuat_pernyataan 0 InnoDB latin1_swedish_ci 16.0 KB -
surat_pulang_atas_permintaan_sendiri_saksi_keluarga 0 InnoDB latin1_swedish_ci 16.0 KB -
surat_rak 2 InnoDB latin1_swedish_ci 16.0 KB -
surat_ruang 4 InnoDB latin1_swedish_ci 16.0 KB -
surat_sifat 3 InnoDB latin1_swedish_ci 16.0 KB -
surat_skbn 0 InnoDB latin1_swedish_ci 48.0 KB -
surat_status 5 InnoDB latin1_swedish_ci 16.0 KB -
surat_sub_klasifikasi 0 InnoDB latin1_swedish_ci 32.0 KB -
tagihan_bpd_jabar 0 InnoDB latin1_swedish_ci 48.0 KB -
tagihan_bpd_jateng 6 InnoDB latin1_swedish_ci 32.0 KB -
tagihan_bpd_papua 0 InnoDB latin1_swedish_ci 32.0 KB -
tagihan_briva 0 InnoDB latin1_swedish_ci 32.0 KB -
tagihan_mandiri 0 InnoDB latin1_swedish_ci 32.0 KB -
tagihan_obat_langsung 0 InnoDB latin1_swedish_ci 32.0 KB -
tagihan_sadewa 21,015 InnoDB latin1_swedish_ci 3.5 MB -
tambahanpotongan 0 InnoDB latin1_swedish_ci 16.0 KB -
tambahan_biaya 18 InnoDB latin1_swedish_ci 16.0 KB -
tambahjaga 0 InnoDB latin1_swedish_ci 32.0 KB -
tampbeli1 0 InnoDB latin1_swedish_ci 32.0 KB -
tampjual1 0 InnoDB latin1_swedish_ci 32.0 KB -
tampjurnal 0 MEMORY latin1_swedish_ci 0 B -
tampjurnal2 0 MEMORY latin1_swedish_ci 0 B -
tamppiutang 0 InnoDB latin1_swedish_ci 32.0 KB -
tampreturbeli 0 InnoDB latin1_swedish_ci 48.0 KB -
tampreturjual 0 InnoDB latin1_swedish_ci 48.0 KB -
tampreturpiutang 0 InnoDB latin1_swedish_ci 32.0 KB -
telaah_farmasi 33,156 InnoDB latin1_swedish_ci 4.0 MB -
template_hasil_radiologi 0 InnoDB latin1_swedish_ci 16.0 KB -
template_laboratorium 0 InnoDB latin1_swedish_ci 272.0 KB -
template_laporan_operasi 7 InnoDB latin1_swedish_ci 16.0 KB -
template_pemeriksaan_dokter 0 InnoDB latin1_swedish_ci 32.0 KB -
template_pemeriksaan_dokter_detail_permintaan_lab 0 InnoDB latin1_swedish_ci 48.0 KB -
template_pemeriksaan_dokter_penyakit 0 InnoDB latin1_swedish_ci 32.0 KB -
template_pemeriksaan_dokter_permintaan_lab 0 InnoDB latin1_swedish_ci 32.0 KB -
template_pemeriksaan_dokter_permintaan_radiologi 0 InnoDB latin1_swedish_ci 32.0 KB -
template_pemeriksaan_dokter_prosedur 0 InnoDB latin1_swedish_ci 32.0 KB -
template_pemeriksaan_dokter_resep 0 InnoDB latin1_swedish_ci 32.0 KB -
template_pemeriksaan_dokter_resep_racikan 0 InnoDB latin1_swedish_ci 32.0 KB -
template_pemeriksaan_dokter_resep_racikan_detail 0 InnoDB latin1_swedish_ci 32.0 KB -
template_pemeriksaan_dokter_tindakan 0 InnoDB latin1_swedish_ci 32.0 KB -
template_persetujuan_penolakan_tindakan 0 MyISAM latin1_swedish_ci 1.0 KB -
template_utd 0 InnoDB latin1_swedish_ci 32.0 KB -
temporary 28 MyISAM latin1_swedish_ci 4.1 KB -
temporary2 2 MyISAM latin1_swedish_ci 1.4 KB -
temporary_bayar_ralan 188 MyISAM latin1_swedish_ci 13.0 KB -
temporary_bayar_ranap 18 MyISAM latin1_swedish_ci 2.0 KB -
temporary_booking_registrasi 1 MyISAM latin1_swedish_ci 2.2 KB -
temporary_gizi 43 MyISAM latin1_swedish_ci 5.8 KB -
temporary_grafik 4 MyISAM latin1_swedish_ci 2.2 KB -
temporary_lab 9 MyISAM latin1_swedish_ci 1.6 KB -
temporary_lama_pelayanan_radiologi 7 MyISAM latin1_swedish_ci 2.7 KB -
temporary_payment 12 MyISAM latin1_swedish_ci 3.2 KB -
temporary_permintaan_lab 0 MyISAM latin1_swedish_ci 1.0 KB -
temporary_permintaan_labmb 0 MyISAM latin1_swedish_ci 1.0 KB -
temporary_permintaan_radiologi 0 MyISAM latin1_swedish_ci 1.0 KB -
temporary_presensi 0 InnoDB latin1_swedish_ci 16.0 KB -
temporary_radiologi 2 MyISAM latin1_swedish_ci 1.2 KB -
temporary_resep 218 MyISAM latin1_swedish_ci 32.6 KB -
temporary_resume 5 MyISAM latin1_swedish_ci 2.7 KB -
temporary_sensus_harian 0 MyISAM latin1_swedish_ci 1.0 KB -
temporary_surveilens_penyakit 0 InnoDB latin1_swedish_ci 48.0 KB -
temporary_tambahan_potongan 3 MyISAM latin1_swedish_ci 2.2 KB -
temporary_toko 0 MyISAM latin1_swedish_ci 1.0 KB -
temppanggilnorawat 1 MyISAM latin1_swedish_ci 1.0 KB -
temppanggilrm 1 MyISAM latin1_swedish_ci 2.0 KB -
timeout_sebelum_insisi 0 InnoDB latin1_swedish_ci 64.0 KB -
tindakan 0 InnoDB latin1_swedish_ci 48.0 KB -
titip_faktur 0 InnoDB latin1_swedish_ci 32.0 KB -
tokobarang 0 InnoDB latin1_swedish_ci 64.0 KB -
tokojenisbarang 0 InnoDB latin1_swedish_ci 16.0 KB -
tokomember 0 InnoDB latin1_swedish_ci 16.0 KB -
tokoopname 0 InnoDB latin1_swedish_ci 112.0 KB -
tokopembelian 0 InnoDB latin1_swedish_ci 128.0 KB -
tokopemesanan 0 InnoDB latin1_swedish_ci 48.0 KB -
tokopenjualan 0 InnoDB latin1_swedish_ci 80.0 KB -
tokopiutang 0 InnoDB latin1_swedish_ci 48.0 KB -
tokoreturbeli 0 InnoDB latin1_swedish_ci 48.0 KB -
tokoreturjual 0 InnoDB latin1_swedish_ci 48.0 KB -
tokoreturpiutang 0 InnoDB latin1_swedish_ci 48.0 KB -
tokosetharga 0 MyISAM latin1_swedish_ci 1.0 KB -
tokosuplier 0 InnoDB latin1_swedish_ci 80.0 KB -
toko_bayar_pemesanan 0 InnoDB latin1_swedish_ci 80.0 KB -
toko_bayar_piutang 0 InnoDB latin1_swedish_ci 80.0 KB -
toko_detail_beli 0 InnoDB latin1_swedish_ci 160.0 KB -
toko_detail_jual 0 InnoDB latin1_swedish_ci 64.0 KB -
toko_detail_pengajuan_barang 0 InnoDB latin1_swedish_ci 64.0 KB -
toko_detail_pesan 0 InnoDB latin1_swedish_ci 64.0 KB -
toko_detail_piutang 0 InnoDB latin1_swedish_ci 64.0 KB -
toko_detail_returbeli 0 InnoDB latin1_swedish_ci 64.0 KB -
toko_detail_returjual 0 InnoDB latin1_swedish_ci 64.0 KB -
toko_detail_returpiutang 0 InnoDB latin1_swedish_ci 64.0 KB -
toko_detail_surat_pemesanan 0 InnoDB latin1_swedish_ci 160.0 KB -
toko_pengajuan_barang 0 InnoDB latin1_swedish_ci 32.0 KB -
toko_riwayat_barang 0 InnoDB latin1_swedish_ci 32.0 KB -
toko_surat_pemesanan 0 InnoDB latin1_swedish_ci 48.0 KB -
tracker 792 InnoDB latin1_swedish_ci 64.0 KB -
trackersql ~189,605 InnoDB latin1_swedish_ci 31.6 MB -
transfer_pasien_antar_ruang 0 InnoDB latin1_swedish_ci 48.0 KB -
ubah_penjab 0 InnoDB latin1_swedish_ci 80.0 KB -
uji_fungsi_kfr 0 InnoDB latin1_swedish_ci 32.0 KB -
user 39 MyISAM latin1_swedish_ci 56.7 KB -
utd_cekal_darah 0 InnoDB latin1_swedish_ci 32.0 KB -
utd_detail_pemisahan_komponen 0 InnoDB latin1_swedish_ci 32.0 KB -
utd_donor 0 InnoDB latin1_swedish_ci 48.0 KB -
utd_komponen_darah 7 InnoDB latin1_swedish_ci 16.0 KB -
utd_medis_rusak 0 InnoDB latin1_swedish_ci 32.0 KB -
utd_pemisahan_komponen 0 InnoDB latin1_swedish_ci 32.0 KB -
utd_pendonor 0 InnoDB latin1_swedish_ci 80.0 KB -
utd_pengambilan_medis 0 InnoDB latin1_swedish_ci 96.0 KB -
utd_pengambilan_penunjang 0 InnoDB latin1_swedish_ci 80.0 KB -
utd_penggunaan_medis_donor 0 InnoDB latin1_swedish_ci 32.0 KB -
utd_penggunaan_medis_pemisahan_komponen 0 InnoDB latin1_swedish_ci 32.0 KB -
utd_penggunaan_medis_penyerahan_darah 0 InnoDB latin1_swedish_ci 32.0 KB -
utd_penggunaan_penunjang_donor 0 InnoDB latin1_swedish_ci 32.0 KB -
utd_penggunaan_penunjang_pemisahan_komponen 0 InnoDB latin1_swedish_ci 32.0 KB -
utd_penggunaan_penunjang_penyerahan_darah 0 InnoDB latin1_swedish_ci 32.0 KB -
utd_penunjang_rusak 0 InnoDB latin1_swedish_ci 32.0 KB -
utd_penyerahan_darah 0 InnoDB latin1_swedish_ci 48.0 KB -
utd_penyerahan_darah_detail 0 InnoDB latin1_swedish_ci 32.0 KB -
utd_stok_darah 12 InnoDB latin1_swedish_ci 32.0 KB -
utd_stok_medis 0 InnoDB latin1_swedish_ci 16.0 KB -
utd_stok_penunjang 2 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_atap_rumah_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_dapur_rumah_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_dinding_rumah_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_elektronik_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_jenis_simpanan_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_kamar_mandi_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_kategori_asnaf_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_kategori_phbs_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_kursi_rumah_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_lantai_rumah_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_patologis_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_pengeluaran_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_penghasilan_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_ternak_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
zis_keterangan_ukuran_rumah_penerima_dankes 0 InnoDB latin1_swedish_ci 16.0 KB -
_temp_audit_kepatuhan_apd 0 InnoDB latin1_swedish_ci 16.0 KB -
_temp_data_batch 0 InnoDB latin1_swedish_ci 32.0 KB -
_temp_data_hais 0 InnoDB latin1_swedish_ci 272.0 KB -
_temp_data_triase_igdprimer 0 InnoDB latin1_swedish_ci 32.0 KB -
250 tablas Número de filas ~245,550 InnoDB utf8mb4_general_ci 49.4 MB 0 B
Número de página:<< <
> >>

Crear tabla
Nombre:
Número de columnas: