no_surat
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
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
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nama_pj
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
no_ktppj
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
pendidikan_pj
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
-
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
no_telppj
varchar(30)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ruang
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kelas
enum('Kelas 1', 'Kelas 2', 'Kelas 3', 'Kelas Utama', 'Kelas VIP', 'Kelas VVIP')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Kelas 1
Kelas 2
Kelas 3
Kelas Utama
Kelas VIP
Kelas VVIP
hubungan
enum('Suami', 'Istri', 'Anak', 'Ayah', 'Ibu', 'Saudara', 'Keponakan', 'Diri Saya')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Suami
Istri
Anak
Ayah
Ibu
Saudara
Keponakan
Diri Saya
hak_kelas
enum('Kelas 1', 'Kelas 2', 'Kelas 3', 'Kelas Utama', 'Kelas VIP', 'Kelas VVIP', '-')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Kelas 1
Kelas 2
Kelas 3
Kelas Utama
Kelas VIP
Kelas VVIP
-
nama_alamat_keluarga_terdekat
varchar(130)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
bayar_secara
varchar(30)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' 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
