no_rkm_medis
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nm_pasien
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
no_ktp
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
jk
enum('L', 'P')
latin1_swedish_ci
= != IS NULL IS NOT NULL
L
P
tmp_lahir
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tgl_lahir
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nm_ibu
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
alamat
varchar(200)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
gol_darah
enum('A', 'B', 'O', 'AB', '-')
latin1_swedish_ci
= != IS NULL IS NOT NULL
A
B
O
AB
-
pekerjaan
varchar(60)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
stts_nikah
enum('BELUM MENIKAH', 'MENIKAH', 'JANDA', 'DUDHA', 'JOMBLO')
latin1_swedish_ci
= != IS NULL IS NOT NULL
BELUM MENIKAH
MENIKAH
JANDA
DUDHA
JOMBLO
agama
varchar(12)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tgl_daftar
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
no_tlp
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
umur
varchar(30)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
pnd
enum('TS', 'TK', 'SD', 'SMP', 'SMA', 'SLTA/SEDERAJAT', 'D1', 'D2', 'D3', 'D4', 'S1', 'S2', 'S3', '-')
latin1_swedish_ci
= != IS NULL IS NOT NULL
TS
TK
SD
SMP
SMA
SLTA/SEDERAJAT
D1
D2
D3
D4
S1
S2
S3
-
keluarga
enum('AYAH', 'IBU', 'ISTRI', 'SUAMI', 'SAUDARA', 'ANAK', 'DIRI SENDIRI', 'LAIN-LAIN')
latin1_swedish_ci
= != IS NULL IS NOT NULL
AYAH
IBU
ISTRI
SUAMI
SAUDARA
ANAK
DIRI SENDIRI
LAIN-LAIN
namakeluarga
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kd_pj
char(3)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
A09 - A09 A65 - A65 INH - INH L4S - L4S A09 - A09 A65 - A65 INH - INH L4S - L4S
no_peserta
varchar(25)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kd_kel
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kd_kec
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kd_kab
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
pekerjaanpj
varchar(35)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
alamatpj
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kelurahanpj
varchar(60)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kecamatanpj
varchar(60)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kabupatenpj
varchar(60)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
perusahaan_pasien
varchar(8)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - 1 - 1 2 - 2 3 - 3 4 - 4 321 - 321 S0006 - S0006 S0007 - S0007 S0008 - S0008 S0009 - S0009 S0011 - S0011 S0012 - S0012 S0014 - S0014 S0015 - S0015 S0016 - S0016 S0017 - S0017 S0018 - S0018 S0019 - S0019 - - - 1 - 1 2 - 2 3 - 3 4 - 4 321 - 321 S0006 - S0006 S0007 - S0007 S0008 - S0008 S0009 - S0009 S0011 - S0011 S0012 - S0012 S0014 - S0014 S0015 - S0015 S0016 - S0016 S0017 - S0017 S0018 - S0018 S0019 - S0019
suku_bangsa
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - 1 ARAB - 16 ASMAT - 18 BALI - 15 BUGIS - 9 DAYAK - 12 INGGRIS - 17 JAWA - 5 LUWU - 11 MADURA - 8 MELAYU - 13 SASAK - 3 SUNDA - 4 SUNDU BUHUN - 14 1 - - 3 - SASAK 4 - SUNDA 5 - JAWA 8 - MADURA 9 - BUGIS 11 - LUWU 12 - DAYAK 13 - MELAYU 14 - SUNDU BUHUN 15 - BALI 16 - ARAB 17 - INGGRIS 18 - ASMAT
bahasa_pasien
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - 1 BANJAR - 6 INDONESIA - 5 JAWA - 11 MADURA - 2 MELAYU - 7 NGAPAK - 3 SASAK - 10 SUNDA BUHUN - 9 SUNDA JAWA - 8 SUROBOYOAN - 4 1 - - 2 - MADURA 3 - NGAPAK 4 - SUROBOYOAN 5 - INDONESIA 6 - BANJAR 7 - MELAYU 8 - SUNDA JAWA 9 - SUNDA BUHUN 10 - SASAK 11 - JAWA
cacat_fisik
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - 1 Bisu - 3 Buta - 2 Lumpuh - 8 TIDAK ADA - 5 Tidak Punya Tangan Kanan - 4 1 - - 2 - Buta 3 - Bisu 4 - Tidak Punya Tangan Kanan 5 - TIDAK ADA 8 - Lumpuh
email
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nip
varchar(30)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kd_prop
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - 1 -NTB - 286 1 - 2 BANTEN - 3142 DAERAH ISTIMEWA YOGYAKARTA - 2362 DKI JAKARTA - 3964 JATENG - 66 JAWA BARAT - 1885 JAWA TENGAH - 3 JAWA TENGAHJL ANGGUR NO.36 RT - 207 JAWA TIMUR - 267 KALIMANTAN TENGAH - 9316 KEP. BANGKA BELITUNG - 7743 KEPULAUAN RIAU - 11697 KURANJI - 320 LAMPUNG - 5630 MADURA - 300 MALUKU - 312 NTB - 268 NUSA TENGGARA BARAT - 313 NUSA TENGGARA BARATT - 315 NUSA TENGGARA BARRATT - 316 PAPUA TENGAH - 8165 PRAYA - 292 PROPINSI - 527 SUL-SEL - 13 SUL-SELBELOPA - 48 SUL-SELBELOPAJ - 264 SULAWESI SELATAN - 4684 SULSEL - 43 SUMATERA BARAT - 5754 SUMATERA SELATAN - 7316 YOGYAKARTA - 317 1 - - 2 - 1 3 - JAWA TENGAH 13 - SUL-SEL 43 - SULSEL 48 - SUL-SELBELOPA 66 - JATENG 207 - JAWA TENGAHJL ANGGUR NO.36 RT 264 - SUL-SELBELOPAJ 267 - JAWA TIMUR 268 - NTB 286 - -NTB 292 - PRAYA 300 - MADURA 312 - MALUKU 313 - NUSA TENGGARA BARAT 315 - NUSA TENGGARA BARATT 316 - NUSA TENGGARA BARRATT 317 - YOGYAKARTA 320 - KURANJI 527 - PROPINSI 1885 - JAWA BARAT 2362 - DAERAH ISTIMEWA YOGYAKARTA 3142 - BANTEN 3964 - DKI JAKARTA 4684 - SULAWESI SELATAN 5630 - LAMPUNG 5754 - SUMATERA BARAT 7316 - SUMATERA SELATAN 7743 - KEP. BANGKA BELITUNG 8165 - PAPUA TENGAH 9316 - KALIMANTAN TENGAH 11697 - KEPULAUAN RIAU
propinsipj
varchar(30)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
