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
- 4 - - 1 1 - 160 4 - 2870 ACEH BESAR - 155 ASAS - 9 BANDA ACEH - 154 BANTUL - 232 BANYUMAS - 6 BELOPA UTARA - 173 BOGOR - 142 BOGORPERUM KOSTRAD - 143 BUMIAYU - 25 BUNGO - 194 CILACAP - 187 D - 144 DEPOK - 120 GERUNG - 80 JAKARTA TIMUR - 152 JATENG - 147 KAB. BANGKA BARAT - 7826 KAB. BANJARNEGARA - 5225 KAB. BANYUMAS - 9504 KAB. BEKASI - 6122 KAB. BLORA - 6532 KAB. BREBES - 5670 KAB. GROBOGAN - 9644 KAB. INDRAMAYU - 7698 KAB. KEBUMEN - 1006 KAB. KLATEN - 4729 KAB. KOTAWARINGIN TIMUR - 9374 KAB. KULON PROGO - 3320 KAB. LOMBOK TEBNGAH - 231 KAB. LOMBOK TENGAH - 227 KAB. MAGELANG - 9043 KAB. MIMIKA - 8235 KAB. MOJOKERTO - 2514 KAB. MUSI BANYUASIN - 7413 KAB. PURWOREJO - 4288 KAB. SERANG - 9030 KAB. SIDOARJO - 5069 KAB. SLEMAN - 2268 KAB. SRAGEN - 5261 KAB. SUKOHARJO - 4966 KAB. TANGERANG - 3046 KAB. TANGGAMUS - 5769 KAB. TEGAL - 5867 KAB. WONOSOBO - 3392 KABUPATEN - 443 KARTASURA - 12 KLATEN - 2 KOTA BANDUNG - 4386 KOTA BEKASI - 5086 KOTA BOGOR - 3068 KOTA DEPOK - 1794 KOTA JAKARTA BARAT - 5990 KOTA JAKARTA PUSAT - 9757 KOTA JAKARTA SELATAN - 4767 KOTA JAKARTA TIMUR - 4129 KOTA MAGELANG - 18 KOTA MAKASSAR - 4835 KOTA PADANG - 5893 KOTA SEMARANG - 7900 KOTA SURABAYA - 9319 KOTA TANGERANG - 4787 KOTA TANGERANG SELATAN - 4719 KOTA YOGYAKARTA - 7325 KULONPROGO - 15 LB LINTAH - 235 LHOKSEUMAMWE - 158 LHOKSEUMAWE - 156 LOBAR - 39 LOMBOK BARAT - 48 LOMBOK TENGAH - 198 LOMBOK TENGAHG - 207 LOMBOK UTARA - 224 LOTENG - 74 LOTIM - 60 LUWU - 170 MADIUN - 11 MADURA - 212 MAGELANG - 153 MAGETAN - 3 MALANG - 197 MATARAM - 30 NTB - 32 PAMULANG - 93 PRAYA - 90 PRINGSEWU - 159 SAWANGAN - 97 SENGKOL - 225 SUKMAJAYA - 108 TULUNGAGUNG - 24 WONOGIRI - 8 WQWQW - 10 YOGYAKARTA - 91 1 - - 2 - KLATEN 3 - MAGETAN 4 - 6 - BANYUMAS 8 - WONOGIRI 9 - ASAS 10 - WQWQW 11 - MADIUN 12 - KARTASURA 15 - KULONPROGO 18 - KOTA MAGELANG 24 - TULUNGAGUNG 25 - BUMIAYU 30 - MATARAM 32 - NTB 39 - LOBAR 48 - LOMBOK BARAT 60 - LOTIM 74 - LOTENG 80 - GERUNG 90 - PRAYA 91 - YOGYAKARTA 93 - PAMULANG 97 - SAWANGAN 108 - SUKMAJAYA 120 - DEPOK 142 - BOGOR 143 - BOGORPERUM KOSTRAD 144 - D 147 - JATENG 152 - JAKARTA TIMUR 153 - MAGELANG 154 - BANDA ACEH 155 - ACEH BESAR 156 - LHOKSEUMAWE 158 - LHOKSEUMAMWE 159 - PRINGSEWU 160 - 1 170 - LUWU 173 - BELOPA UTARA 187 - CILACAP 194 - BUNGO 197 - MALANG 198 - LOMBOK TENGAH 207 - LOMBOK TENGAHG 212 - MADURA 224 - LOMBOK UTARA 225 - SENGKOL 227 - KAB. LOMBOK TENGAH 231 - KAB. LOMBOK TEBNGAH 232 - BANTUL 235 - LB LINTAH 443 - KABUPATEN 1006 - KAB. KEBUMEN 1794 - KOTA DEPOK 2268 - KAB. SLEMAN 2514 - KAB. MOJOKERTO 2870 - 4 3046 - KAB. TANGERANG 3068 - KOTA BOGOR 3320 - KAB. KULON PROGO 3392 - KAB. WONOSOBO 4129 - KOTA JAKARTA TIMUR 4288 - KAB. PURWOREJO 4386 - KOTA BANDUNG 4719 - KOTA TANGERANG SELATAN 4729 - KAB. KLATEN 4767 - KOTA JAKARTA SELATAN 4787 - KOTA TANGERANG 4835 - KOTA MAKASSAR 4966 - KAB. SUKOHARJO 5069 - KAB. SIDOARJO 5086 - KOTA BEKASI 5225 - KAB. BANJARNEGARA 5261 - KAB. SRAGEN 5670 - KAB. BREBES 5769 - KAB. TANGGAMUS 5867 - KAB. TEGAL 5893 - KOTA PADANG 5990 - KOTA JAKARTA BARAT 6122 - KAB. BEKASI 6532 - KAB. BLORA 7325 - KOTA YOGYAKARTA 7413 - KAB. MUSI BANYUASIN 7698 - KAB. INDRAMAYU 7826 - KAB. BANGKA BARAT 7900 - KOTA SEMARANG 8235 - KAB. MIMIKA 9030 - KAB. SERANG 9043 - KAB. MAGELANG 9319 - KOTA SURABAYA 9374 - KAB. KOTAWARINGIN TIMUR 9504 - KAB. BANYUMAS 9644 - KAB. GROBOGAN 9757 - KOTA JAKARTA PUSAT
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 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
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
