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
001 - 2025/09/11/000002 001 - 2025/05/27/000001 001 - 2025/08/26/000001 001 - 2025/08/25/000002 001 - 2025/08/25/000001 001 - 2025/06/30/000004 001 - 2025/08/11/000001 001 - 2025/05/15/000001 001 - 2025/05/26/000001 001 - 2025/05/22/000001 001 - 2025/06/11/000001 001 - 2025/06/18/000001 001 - 2025/06/04/000001 001 - 2025/09/02/000001 001 - 2025/06/19/000001 001 - 2025/06/20/000001 001 - 2025/06/09/000001 001 - 2025/08/11/000004 001 - 2025/06/28/000001 001 - 2025/04/25/000001 001 - 2025/06/25/000001 001 - 2025/06/23/000001 001 - 2025/04/26/000001 001 - 2025/04/27/000001 001 - 2025/06/03/000001 001 - 2025/08/27/000001 001 - 2025/06/30/000001 001 - 2025/09/03/000001 001 - 2025/07/04/000001 001 - 2025/09/04/000001 001 - 2025/08/04/000001 001 - 2025/07/29/000001 001 - 2025/07/23/000001 001 - 2025/07/21/000001 001 - 2025/07/16/000001 001 - 2025/07/14/000001 001 - 2025/07/08/000001 001 - 2025/07/07/000001 001 - 2025/07/05/000001 001 - 2025/07/08/000004 001 - 2025/07/03/000001 001 - 2025/09/08/000001 001 - 2025/08/13/000001 001 - 2025/08/19/000001 001 - 2025/08/21/000001 001 - 2025/09/11/000001 001 - 2025/09/10/000006 001 - 2025/09/10/000004 001 - 2025/09/10/000001 001 - 2025/09/08/000003 001 - 2025/09/15/000001 001 - 2025/06/30/000005 002 - 2025/06/20/000002 002 - 2025/07/07/000002 002 - 2025/06/20/000003 002 - 2025/07/03/000002 002 - 2025/08/11/000002 002 - 2025/06/30/000002 002 - 2025/06/09/000002 002 - 2025/07/29/000002 002 - 2025/05/27/000002 002 - 2025/06/03/000002 002 - 2025/06/18/000002 002 - 2025/07/08/000002 002 - 2025/09/10/000002 002 - 2025/07/16/000002 002 - 2025/09/12/000001 002 - 2025/07/23/000002 002 - 2025/05/26/000002 002 - 2025/08/21/000002 002 - 2025/09/02/000002 002 - 2025/09/02/000003 002 - 2025/04/28/000001 002 - 2025/09/08/000002 002 - 2025/04/27/000002 002 - 2025/08/19/000003 002 - 2025/08/19/000002 003 - 2025/08/26/000002 003 - 2025/09/10/000003 003 - 2025/05/26/000003 003 - 2025/04/28/000002 003 - 2025/09/08/000004 003 - 2025/07/29/000003 003 - 2025/08/11/000003 003 - 2025/06/30/000003 003 - 2025/05/27/000003 003 - 2025/08/21/000003 003 - 2025/06/03/000003 004 - 2025/04/28/000003 2025/04/25/000001 - 001 2025/04/26/000001 - 001 2025/04/27/000001 - 001 2025/04/27/000002 - 002 2025/04/28/000001 - 002 2025/04/28/000002 - 003 2025/04/28/000003 - 004 2025/05/15/000001 - 001 2025/05/22/000001 - 001 2025/05/26/000001 - 001 2025/05/26/000002 - 002 2025/05/26/000003 - 003 2025/05/27/000001 - 001 2025/05/27/000002 - 002 2025/05/27/000003 - 003 2025/06/03/000001 - 001 2025/06/03/000002 - 002 2025/06/03/000003 - 003 2025/06/04/000001 - 001 2025/06/09/000001 - 001 2025/06/09/000002 - 002 2025/06/11/000001 - 001 2025/06/18/000001 - 001 2025/06/18/000002 - 002 2025/06/19/000001 - 001 2025/06/20/000001 - 001 2025/06/20/000002 - 002 2025/06/20/000003 - 002 2025/06/23/000001 - 001 2025/06/25/000001 - 001 2025/06/28/000001 - 001 2025/06/30/000001 - 001 2025/06/30/000002 - 002 2025/06/30/000003 - 003 2025/06/30/000004 - 001 2025/06/30/000005 - 001 2025/07/03/000001 - 001 2025/07/03/000002 - 002 2025/07/04/000001 - 001 2025/07/05/000001 - 001 2025/07/07/000001 - 001 2025/07/07/000002 - 002 2025/07/08/000001 - 001 2025/07/08/000002 - 002 2025/07/08/000004 - 001 2025/07/14/000001 - 001 2025/07/16/000001 - 001 2025/07/16/000002 - 002 2025/07/21/000001 - 001 2025/07/23/000001 - 001 2025/07/23/000002 - 002 2025/07/29/000001 - 001 2025/07/29/000002 - 002 2025/07/29/000003 - 003 2025/08/04/000001 - 001 2025/08/11/000001 - 001 2025/08/11/000002 - 002 2025/08/11/000003 - 003 2025/08/11/000004 - 001 2025/08/13/000001 - 001 2025/08/19/000001 - 001 2025/08/19/000002 - 002 2025/08/19/000003 - 002 2025/08/21/000001 - 001 2025/08/21/000002 - 002 2025/08/21/000003 - 003 2025/08/25/000001 - 001 2025/08/25/000002 - 001 2025/08/26/000001 - 001 2025/08/26/000002 - 003 2025/08/27/000001 - 001 2025/09/02/000001 - 001 2025/09/02/000002 - 002 2025/09/02/000003 - 002 2025/09/03/000001 - 001 2025/09/04/000001 - 001 2025/09/08/000001 - 001 2025/09/08/000002 - 002 2025/09/08/000003 - 001 2025/09/08/000004 - 003 2025/09/10/000001 - 001 2025/09/10/000002 - 002 2025/09/10/000003 - 003 2025/09/10/000004 - 001 2025/09/10/000006 - 001 2025/09/11/000001 - 001 2025/09/11/000002 - 001 2025/09/12/000001 - 002 2025/09/15/000001 - 001
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
- - - D0000002 - D0000002 D0000003 - D0000003 D0000004 - D0000004 D0000005 - D0000005 - - - D0000002 - D0000002 D0000003 - D0000003 D0000004 - D0000004 D0000005 - D0000005
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
pasien_mengetahui_kondisi_penyakitnya
enum('Ya', 'Tidak')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Ya
Tidak
penyakit_sama_serumah
enum('Ya', 'Tidak')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Ya
Tidak
riwayat_kontak
enum('Bekerja Di Daerah KLB', 'Merawat Pasien Penyakit Infeksi', 'Berkunjung Ke Daerah Endemik Dalam 2 Minggu Terakhir', 'Bekerja Di Laboratorium', 'Kontak Langsung', 'Lain-lain')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Bekerja Di Daerah KLB
Merawat Pasien Penyakit Infeksi
Berkunjung Ke Daerah Endemik Dalam 2 Minggu Terakhir
Bekerja Di Laboratorium
Kontak Langsung
Lain-lain
keterangan_riwayat_kontak
varchar(70)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
transmisi_penularan_penyakit
enum('Airborne', 'Droplet', 'Kontak Langsung', 'Cairan Tubuh Lainnya', 'Lain-lain')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Airborne
Droplet
Kontak Langsung
Cairan Tubuh Lainnya
Lain-lain
keterangan_transmisi_penularan_penyakit
varchar(70)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kebutuhan_ruang_rawat
enum('Isolasi', 'Ruang Biasa', 'ICU', 'ICU Isolasi')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Isolasi
Ruang Biasa
ICU
ICU Isolasi
keluhan_yang_dirasakan_saat_ini
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_keluarga
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_alergi
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
riwayat_vaksinasi
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
riwayat_pengobatan
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
diagnosa_utama
varchar(500)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
diagnosa_tambahan
varchar(500)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL