no_k3rs
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tgl_insiden
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
waktu_insiden
time
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kode_pekerjaan
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
PK001 - PK001 PK002 - PK002 PK003 - PK003 PK004 - PK004 PK005 - PK005 PK006 - PK006 PK001 - PK001 PK002 - PK002 PK003 - PK003 PK004 - PK004 PK005 - PK005 PK006 - PK006
tgl_pelaporan
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
waktu_pelaporan
time
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kode_lokasi
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
LK001 - LK001 LK002 - LK002 LK003 - LK003 LK004 - LK004 LK001 - LK001 LK002 - LK002 LK003 - LK003 LK004 - LK004
kronologi_kejadian
varchar(300)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kode_penyebab
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
PK001 - PK001 PK002 - PK002 PK003 - PK003 PK001 - PK001 PK002 - PK002 PK003 - PK003
nik
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 20232047 - 20232047 200808006 - 200808006 200808007 - 200808007 200808009 - 200808009 200808012 - 200808012 200809009 - 200809009 200909009 - 200909009 201201013 - 201201013 201202011 - 201202011 201305014 - 201305014 201408015 - 201408015 201604018 - 201604018 201703019 - 201703019 201704020 - 201704020 201801023 - 201801023 201808025 - 201808025 201811026 - 201811026 201901028 - 201901028 201902029 - 201902029 201903027 - 201903027 202201035 - 202201035 202201044 - 202201044 202204036 - 202204036 202205039 - 202205039 202206040 - 202206040 202208042 - 202208042 202209043 - 202209043 202210044 - 202210044 202211039 - 202211039 202211045 - 202211045 202211046 - 202211046 202302045 - 202302045 202303051 - 202303051 202306049 - 202306049 202406052 - 202406052 202406053 - 202406053 202409054 - 202409054 202409056 - 202409056 202412057 - 202412057 202412058 - 202412058 202503059 - 202503059 D0000001 - D0000001 D0000002 - D0000002 D0000003 - D0000003 D0000004 - D0000004 D0000005 - D0000005 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D0000009 - D0000009 D0000014 - D0000014 D0000055 - D0000055 D0000059 - D0000059 D000009 - D000009 D08 - D08 - - - 013 - 013 123 - 123 012345678 - 012345678 20232047 - 20232047 200808006 - 200808006 200808007 - 200808007 200808009 - 200808009 200808012 - 200808012 200809009 - 200809009 200909009 - 200909009 201201013 - 201201013 201202011 - 201202011 201305014 - 201305014 201408015 - 201408015 201604018 - 201604018 201703019 - 201703019 201704020 - 201704020 201801023 - 201801023 201808025 - 201808025 201811026 - 201811026 201901028 - 201901028 201902029 - 201902029 201903027 - 201903027 202201035 - 202201035 202201044 - 202201044 202204036 - 202204036 202205039 - 202205039 202206040 - 202206040 202208042 - 202208042 202209043 - 202209043 202210044 - 202210044 202211039 - 202211039 202211045 - 202211045 202211046 - 202211046 202302045 - 202302045 202303051 - 202303051 202306049 - 202306049 202406052 - 202406052 202406053 - 202406053 202409054 - 202409054 202409056 - 202409056 202412057 - 202412057 202412058 - 202412058 202503059 - 202503059 D0000001 - D0000001 D0000002 - D0000002 D0000003 - D0000003 D0000004 - D0000004 D0000005 - D0000005 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D0000009 - D0000009 D0000014 - D0000014 D0000055 - D0000055 D0000059 - D0000059 D000009 - D000009 D08 - D08
kategori_cidera
enum('Ringan', 'Sedang', 'Berat', 'Fatal')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Ringan
Sedang
Berat
Fatal
kode_cidera
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
CK001 - CK001 CK002 - CK002 CK003 - CK003 CK001 - CK001 CK002 - CK002 CK003 - CK003
kode_luka
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
LK001 - LK001 LK002 - LK002 LK003 - LK003 LK004 - LK004 LK005 - LK005 LK001 - LK001 LK002 - LK002 LK003 - LK003 LK004 - LK004 LK005 - LK005
kode_bagian
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
BK001 - BK001 BK002 - BK002 BK003 - BK003 BK004 - BK004 BK005 - BK005 BK001 - BK001 BK002 - BK002 BK003 - BK003 BK004 - BK004 BK005 - BK005
lt
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
penyebab_langsung_kondisi
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
penyebab_langsung_tindakan
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
penyebab_tidak_langsung_pribadi
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
penyebab_tidak_langsung_pekerjaan
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
barang_bukti
enum('Ya', 'Tidak')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Ya
Tidak
kode_dampak
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
DK001 - DK001 DK002 - DK002 DK003 - DK003 DK004 - DK004 DK005 - DK005 DK001 - DK001 DK002 - DK002 DK003 - DK003 DK004 - DK004 DK005 - DK005
nik_pelapor
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 20232047 - 20232047 200808006 - 200808006 200808007 - 200808007 200808009 - 200808009 200808012 - 200808012 200809009 - 200809009 200909009 - 200909009 201201013 - 201201013 201202011 - 201202011 201305014 - 201305014 201408015 - 201408015 201604018 - 201604018 201703019 - 201703019 201704020 - 201704020 201801023 - 201801023 201808025 - 201808025 201811026 - 201811026 201901028 - 201901028 201902029 - 201902029 201903027 - 201903027 202201035 - 202201035 202201044 - 202201044 202204036 - 202204036 202205039 - 202205039 202206040 - 202206040 202208042 - 202208042 202209043 - 202209043 202210044 - 202210044 202211039 - 202211039 202211045 - 202211045 202211046 - 202211046 202302045 - 202302045 202303051 - 202303051 202306049 - 202306049 202406052 - 202406052 202406053 - 202406053 202409054 - 202409054 202409056 - 202409056 202412057 - 202412057 202412058 - 202412058 202503059 - 202503059 D0000001 - D0000001 D0000002 - D0000002 D0000003 - D0000003 D0000004 - D0000004 D0000005 - D0000005 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D0000009 - D0000009 D0000014 - D0000014 D0000055 - D0000055 D0000059 - D0000059 D000009 - D000009 D08 - D08 - - - 013 - 013 123 - 123 012345678 - 012345678 20232047 - 20232047 200808006 - 200808006 200808007 - 200808007 200808009 - 200808009 200808012 - 200808012 200809009 - 200809009 200909009 - 200909009 201201013 - 201201013 201202011 - 201202011 201305014 - 201305014 201408015 - 201408015 201604018 - 201604018 201703019 - 201703019 201704020 - 201704020 201801023 - 201801023 201808025 - 201808025 201811026 - 201811026 201901028 - 201901028 201902029 - 201902029 201903027 - 201903027 202201035 - 202201035 202201044 - 202201044 202204036 - 202204036 202205039 - 202205039 202206040 - 202206040 202208042 - 202208042 202209043 - 202209043 202210044 - 202210044 202211039 - 202211039 202211045 - 202211045 202211046 - 202211046 202302045 - 202302045 202303051 - 202303051 202306049 - 202306049 202406052 - 202406052 202406053 - 202406053 202409054 - 202409054 202409056 - 202409056 202412057 - 202412057 202412058 - 202412058 202503059 - 202503059 D0000001 - D0000001 D0000002 - D0000002 D0000003 - D0000003 D0000004 - D0000004 D0000005 - D0000005 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D0000009 - D0000009 D0000014 - D0000014 D0000055 - D0000055 D0000059 - D0000059 D000009 - D000009 D08 - D08
perbaikan_jenis_tindakan
enum('Tindakan Perbaikan', 'Tindakan Pencegahan')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Tindakan Perbaikan
Tindakan Pencegahan
perbaikan_rencana_tindakan
varchar(200)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
perbaikan_target
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
perbaikan_wewenang
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nik_timk3
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 20232047 - 20232047 200808006 - 200808006 200808007 - 200808007 200808009 - 200808009 200808012 - 200808012 200809009 - 200809009 200909009 - 200909009 201201013 - 201201013 201202011 - 201202011 201305014 - 201305014 201408015 - 201408015 201604018 - 201604018 201703019 - 201703019 201704020 - 201704020 201801023 - 201801023 201808025 - 201808025 201811026 - 201811026 201901028 - 201901028 201902029 - 201902029 201903027 - 201903027 202201035 - 202201035 202201044 - 202201044 202204036 - 202204036 202205039 - 202205039 202206040 - 202206040 202208042 - 202208042 202209043 - 202209043 202210044 - 202210044 202211039 - 202211039 202211045 - 202211045 202211046 - 202211046 202302045 - 202302045 202303051 - 202303051 202306049 - 202306049 202406052 - 202406052 202406053 - 202406053 202409054 - 202409054 202409056 - 202409056 202412057 - 202412057 202412058 - 202412058 202503059 - 202503059 D0000001 - D0000001 D0000002 - D0000002 D0000003 - D0000003 D0000004 - D0000004 D0000005 - D0000005 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D0000009 - D0000009 D0000014 - D0000014 D0000055 - D0000055 D0000059 - D0000059 D000009 - D000009 D08 - D08 - - - 013 - 013 123 - 123 012345678 - 012345678 20232047 - 20232047 200808006 - 200808006 200808007 - 200808007 200808009 - 200808009 200808012 - 200808012 200809009 - 200809009 200909009 - 200909009 201201013 - 201201013 201202011 - 201202011 201305014 - 201305014 201408015 - 201408015 201604018 - 201604018 201703019 - 201703019 201704020 - 201704020 201801023 - 201801023 201808025 - 201808025 201811026 - 201811026 201901028 - 201901028 201902029 - 201902029 201903027 - 201903027 202201035 - 202201035 202201044 - 202201044 202204036 - 202204036 202205039 - 202205039 202206040 - 202206040 202208042 - 202208042 202209043 - 202209043 202210044 - 202210044 202211039 - 202211039 202211045 - 202211045 202211046 - 202211046 202302045 - 202302045 202303051 - 202303051 202306049 - 202306049 202406052 - 202406052 202406053 - 202406053 202409054 - 202409054 202409056 - 202409056 202412057 - 202412057 202412058 - 202412058 202503059 - 202503059 D0000001 - D0000001 D0000002 - D0000002 D0000003 - D0000003 D0000004 - D0000004 D0000005 - D0000005 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D0000009 - D0000009 D0000014 - D0000014 D0000055 - D0000055 D0000059 - D0000059 D000009 - D000009 D08 - D08
catatan
varchar(200)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
