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
tanggal
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nip
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - 013 - 013 123 - 123 012345678 - 012345678 200808006 - 200808006 200808007 - 200808007 200808009 - 200808009 201201013 - 201201013 201305014 - 201305014 201408015 - 201408015 201703019 - 201703019 201704020 - 201704020 201808025 - 201808025 201811026 - 201811026 201901028 - 201901028 202201035 - 202201035 202201044 - 202201044 202204036 - 202204036 202206040 - 202206040 202208042 - 202208042 202209043 - 202209043 202210044 - 202210044 202211039 - 202211039 202302045 - 202302045 202306049 - 202306049 202406052 - 202406052 202406053 - 202406053 202409054 - 202409054 202409056 - 202409056 202412057 - 202412057 202412058 - 202412058 202503059 - 202503059 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D000009 - D000009 D08 - D08 - - - 013 - 013 123 - 123 012345678 - 012345678 200808006 - 200808006 200808007 - 200808007 200808009 - 200808009 201201013 - 201201013 201305014 - 201305014 201408015 - 201408015 201703019 - 201703019 201704020 - 201704020 201808025 - 201808025 201811026 - 201811026 201901028 - 201901028 202201035 - 202201035 202201044 - 202201044 202204036 - 202204036 202206040 - 202206040 202208042 - 202208042 202209043 - 202209043 202210044 - 202210044 202211039 - 202211039 202302045 - 202302045 202306049 - 202306049 202406052 - 202406052 202406053 - 202406053 202409054 - 202409054 202409056 - 202409056 202412057 - 202412057 202412058 - 202412058 202503059 - 202503059 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D000009 - D000009 D08 - D08
anamnesis
enum('Autoanamnesis', 'Alloanamnesis')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Autoanamnesis
Alloanamnesis
dikirim_dari
enum('Ruang Rawat', 'Poliklinik', 'Rehabilitasi', 'After Care', 'Dokter')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Ruang Rawat
Poliklinik
Rehabilitasi
After Care
Dokter
tujuan_pemeriksaan
enum('Klinik', 'Bimbingan', 'Forensik')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Klinik
Bimbingan
Forensik
ket_anamnesis
varchar(200)
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
riwayat_penyakit
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_keluhan
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_saat_ini
enum('Sangat Serius', 'Serius', 'Cukup Serius')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Sangat Serius
Serius
Cukup Serius
permasalahan_alasan
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
permasalahan_ekspektasi
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_hidup_singkat
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_psikologis_penampilan
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_psikologis_ekspresi_wajah
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_psikologis_suasana_hati
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_psikologis_tingkah_laku
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_psikologis_fungsi_umum
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_psikologis_fungsi_intelektual
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_psikologis_pengalaman
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_psikologis_lainnya
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_patologis_delusi
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_patologis_proses_pikiran
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_patologis_halusinasi
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_patologis_afek
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_patologis_insight
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_patologis_kesadaran
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_patologis_orientasi
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_patologis_atensi
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kondisi_patologis_kontrol_impuls
varchar(150)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
psikotes_tanggal_pelaksanaan
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
psikotes_nama_tes
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
psikotes_hasil
varchar(200)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
dinamika_psikologis
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_psikologis
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
manifestasi_fungsi_psikologis
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
rencana_intervensi
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tahapan_intervensi1
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
target_terapi1
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tahapan_intervensi2
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
target_terapi2
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tahapan_intervensi3
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
target_terapi3
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tahapan_intervensi4
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
target_terapi4
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tahapan_intervensi5
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
target_terapi5
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tahapan_intervensi6
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
target_terapi6
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tahapan_intervensi7
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
target_terapi7
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
evaluasi
varchar(1000)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
