no_rawat
varchar(17)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
Mostrar los valores foráneos
tanggal
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kd_dokter
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - 20232047 - 20232047 D0000001 - D0000001 D0000002 - D0000002 D0000003 - D0000003 D0000004 - D0000004 D0000005 - D0000005 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D0000009 - D0000009 - - - 20232047 - 20232047 D0000001 - D0000001 D0000002 - D0000002 D0000003 - D0000003 D0000004 - D0000004 D0000005 - D0000005 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D0000009 - D0000009
anamnesis
enum('Autoanamnesis', 'Alloanamnesis')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Autoanamnesis
Alloanamnesis
hubungan
varchar(30)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
keluhan_utama
varchar(2000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
gejala_menyertai
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
faktor_pencetus
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
riwayat_penyakit_dahulu
enum('Tidak Ada', 'Ada')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Tidak Ada
Ada
keterangan_riwayat_penyakit_dahulu
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
riwayat_kehamilan
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
riwayat_sosial
enum('Bergaul', 'Tidak Bergaul', 'Lain-lain')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Bergaul
Tidak Bergaul
Lain-lain
keterangan_riwayat_sosial
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
riwayat_pekerjaan
enum('Bekerja', 'Tidak Bekerja', 'Ganti-gantian Pekerjaan')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Bekerja
Tidak Bekerja
Ganti-gantian Pekerjaan
keterangan_riwayat_pekerjaan
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
riwayat_obat_diminum
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
faktor_kepribadian_premorbid
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
faktor_keturunan
enum('Tidak Ada', 'Ada')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Tidak Ada
Ada
keterangan_faktor_keturunan
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
faktor_organik
enum('Tidak Ada', 'Ada')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Tidak Ada
Ada
keterangan_faktor_organik
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
riwayat_alergi
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
fisik_kesadaran
enum('Compos Mentis', 'Apatis', 'Somnolen', 'Sopor', 'Koma')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Compos Mentis
Apatis
Somnolen
Sopor
Koma
fisik_td
varchar(8)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
fisik_rr
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
fisik_suhu
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
fisik_nyeri
enum('Tidak Nyeri', 'Nyeri Ringan', 'Nyeri Sedang', 'Nyeri Berat', 'Nyeri Sangat Berat', 'Nyeri Tak Tertahankan')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Tidak Nyeri
Nyeri Ringan
Nyeri Sedang
Nyeri Berat
Nyeri Sangat Berat
Nyeri Tak Tertahankan
fisik_nadi
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
fisik_bb
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
fisik_tb
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
fisik_status_nutrisi
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
fisik_gcs
varchar(8)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
status_kelainan_kepala
enum('Normal', 'Abnormal', 'Tidak Diperiksa')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Normal
Abnormal
Tidak Diperiksa
keterangan_status_kelainan_kepala
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
status_kelainan_leher
enum('Normal', 'Abnormal', 'Tidak Diperiksa')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Normal
Abnormal
Tidak Diperiksa
keterangan_status_kelainan_leher
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
status_kelainan_dada
enum('Normal', 'Abnormal', 'Tidak Diperiksa')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Normal
Abnormal
Tidak Diperiksa
keterangan_status_kelainan_dada
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
status_kelainan_perut
enum('Normal', 'Abnormal', 'Tidak Diperiksa')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Normal
Abnormal
Tidak Diperiksa
keterangan_status_kelainan_perut
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
status_kelainan_anggota_gerak
enum('Normal', 'Abnormal', 'Tidak Diperiksa')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Normal
Abnormal
Tidak Diperiksa
keterangan_status_kelainan_anggota_gerak
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
status_lokalisata
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
psikiatrik_kesan_umum
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
psikiatrik_sikap_prilaku
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
psikiatrik_kesadaran
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
psikiatrik_orientasi
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
psikiatrik_daya_ingat
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
psikiatrik_persepsi
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
psikiatrik_pikiran
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
psikiatrik_insight
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
laborat
varchar(300)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
radiologi
varchar(200)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ekg
varchar(200)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
diagnosis
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
permasalahan
varchar(500)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
instruksi_medis
varchar(600)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
rencana_target
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
pulang_dipulangkan
enum('Tidak Perlu Kontrol', 'Kontrol/Berobat Jalan', 'Rawat Inap', '-')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Tidak Perlu Kontrol
Kontrol/Berobat Jalan
Rawat Inap
-
keterangan_pulang_dipulangkan
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
pulang_dirawat_diruang
varchar(30)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
pulang_indikasi_ranap
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
pulang_dirujuk_ke
varchar(70)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
pulang_alasan_dirujuk
enum('-', 'Tempat Penuh', 'Perlu Fasilitas Lebih', 'Permintaan Pasien/Keluarga')
latin1_swedish_ci
= != IS NULL IS NOT NULL
-
Tempat Penuh
Perlu Fasilitas Lebih
Permintaan Pasien/Keluarga
pulang_paksa
enum('-', 'Masalah Biaya', 'Kondisi Pasien', 'Masalah Lokasi Rumah', 'Lain-lain')
latin1_swedish_ci
= != IS NULL IS NOT NULL
-
Masalah Biaya
Kondisi Pasien
Masalah Lokasi Rumah
Lain-lain
keterangan_pulang_paksa
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
pulang_meninggal_igd
enum('-', '<= 2 Jam', '> 2 Jam')
latin1_swedish_ci
= != IS NULL IS NOT NULL
-
<= 2 Jam
> 2 Jam
pulang_penyebab_kematian
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
fisik_pulang_kesadaran
enum('Compos Mentis', 'Apatis', 'Somnolen', 'Sopor', 'Koma')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Compos Mentis
Apatis
Somnolen
Sopor
Koma
fisik_pulang_td
varchar(8)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
fisik_pulang_nadi
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
fisik_pulang_gcs
varchar(8)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
fisik_pulang_suhu
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
fisik_pulang_rr
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
edukasi
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL