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
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 tablas Número de filas ~3,535,502 InnoDB utf8mb4_general_ci 1.2 GB 0 B
Número de página:
> >>

Crear tabla
Nombre:
Número de columnas: