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
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
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
- - - 12/09/1988/001 - 12/09/1988/001 123124 - 123124 156798 - 156798 01010101 - 01010101 - - - 12/09/1988/001 - 12/09/1988/001 123124 - 123124 156798 - 156798 01010101 - 01010101
