tb_aspekpenyebab
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_aspekpenyebab (Primary) | int(11) | No | ||||
| nama_aspekpenyebab | varchar(25) | No | ||||
| keterangan | text | No | ||||
| id_katinvestigasi | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_aspekpenyebab | 0 | A | No |
tb_bagian
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_bagian (Primary) | int(11) | No | ||||
| nama_bagian | varchar(50) | No | ||||
| keterangan | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_bagian | 64 | A | No |
tb_bagtubuh
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_bagtubuh (Primary) | int(11) | No | ||||
| nama_bagtubuh | varchar(20) | No | ||||
| keterangan | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_bagtubuh | 4 | A | No |
tb_cidera
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_cidera (Primary) | int(11) | No | ||||
| id_bagtubuh | int(11) | No | ||||
| id_jcidera | int(11) | No | ||||
| kanan | int(11) | No | ||||
| kiri | int(11) | No | ||||
| id_kecelakaan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_cidera | 0 | A | No | |
| id_kecelakaan | BTREE | No | No | id_kecelakaan | A | No |
tb_department
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_department (Primary) | int(11) | No | ||||
| nama_department | varchar(100) | No | ||||
| keterangan | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_department | 72 | A | No |
tb_emisi
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_emisi (Primary) | int(11) | No | ||||
| id_samplingemisi | int(11) | No | ||||
| kadar | float | No | ||||
| bulan | int(20) | No | ||||
| tahun | int(11) | No | ||||
| tanggal | datetime | No | ||||
| author | enum('internal', 'eksternal') | No | ||||
| pabrik | enum('I', 'II A', 'II B', 'III') | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_emisi | 35 | A | No |
tb_foto
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_foto (Primary) | int(11) | No | ||||
| path | text | No | ||||
| keterangan | text | No | ||||
| id_kecelakaan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_foto | 10 | A | No |
tb_gas
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_gas (Primary) | int(11) | No | ||||
| nama_gas | varchar(20) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_gas | 5 | A | No |
tb_hakakses
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_hakakses (Primary) | int(11) | No | ||||
| id_menu | int(11) | No | ||||
| id_level | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_hakakses | 12 | A | No | |
| id_menu | BTREE | No | No | id_menu | A | No | ||
| id_level | BTREE | No | No | id_level | A | No |
tb_investigasi
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_investigasi (Primary) | int(11) | No | ||||
| hasil_investigasi | text | No | ||||
| id_katinvestigasi | int(11) | No | ||||
| id_kecelakaan | int(11) | No | ||||
| status | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_investigasi | 3 | A | No | |
| id_kecelakaan | BTREE | No | No | id_kecelakaan | 1 | A | No | |
| id_katinvestigasi | BTREE | No | No | id_katinvestigasi | 1 | A | No |
tb_jabatan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_jabatan (Primary) | int(11) | No | ||||
| nama_jabatan | varchar(20) | No | ||||
| keterangan | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_jabatan | 10 | A | No |
tb_jcidera
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_jcidera (Primary) | int(11) | No | ||||
| nama_jcidera | varchar(20) | No | ||||
| keterangan | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_jcidera | 22 | A | No |
tb_jkecel
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_jkecel (Primary) | int(11) | No | ||||
| nama_jkecel | varchar(50) | No | ||||
| ket_jkecel | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_jkecel | 2 | A | No |
tb_jkecelx
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_jkecel (Primary) | int(11) | No | ||||
| jeniskecel | varchar(20) | No | ||||
| sub_jeniskecel | text | No | ||||
| keterangan | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_jkecel | 24 | A | No |
tb_jlampiran
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_jlampiran (Primary) | int(11) | No | ||||
| nama_jlampiran | varchar(100) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_jlampiran | 9 | A | No |
tb_kajiulang
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| nm_kabagk3 | varchar(50) | No | ||||
| nm_kadeplk3 | varchar(50) | No | ||||
| nm_kakomp | varchar(50) | No | ||||
| nm_dproduksi | varchar(50) | No | ||||
| tgl_kabagk3 | varchar(50) | No | ||||
| tgl_kadeplk3 | varchar(50) | No | ||||
| tgl_kakomp | varchar(50) | No | ||||
| tgl_dproduksi | varchar(50) | No | ||||
| kom_kabagk3 | varchar(50) | No | ||||
| kom_kadeplk3 | varchar(50) | No | ||||
| kom_kakomp | varchar(50) | No | ||||
| kom_dproduksi | varchar(50) | No | ||||
| id_kecelakaan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| id_kecelakaan | BTREE | No | No | id_kecelakaan | 1 | A | No | |
| id_kecelakaan_2 | BTREE | No | No | id_kecelakaan | 1 | A | No |
tb_katinvestigasi
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_katinvestigasi (Primary) | int(11) | No | ||||
| nama_katinvestigasi | varchar(20) | No | ||||
| keterangan | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_katinvestigasi | 5 | A | No |
tb_kecelakaan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_kecelakaan (Primary) | int(11) | No | ||||
| no_ref | varchar(30) | No | ||||
| id_subjkecel | int(11) | Yes | NULL | |||
| id_subjkecel2 | int(11) | Yes | NULL | |||
| tgl_kejadian | date | No | ||||
| tgl_lapor | date | No | ||||
| judul_kejadian | text | No | ||||
| tempat | text | No | ||||
| jam_kejadian | varchar(50) | No | ||||
| jam_lapor | varchar(50) | No | ||||
| pelapor | varchar(100) | No | ||||
| laporke | varchar(100) | No | ||||
| uraian | text | No | ||||
| kerugian | text | No | ||||
| nama_pjlokasi | varchar(50) | No | ||||
| saksi1 | varchar(50) | No | ||||
| saksi2 | varchar(50) | No | ||||
| jabatan_saksi1 | varchar(50) | No | ||||
| jabatan_saksi2 | varchar(50) | No | ||||
| kontak_saksi1 | varchar(50) | No | ||||
| kontak_saksi2 | varchar(50) | No | ||||
| ketua_timinv | varchar(50) | No | ||||
| tglmulai_timinv | varchar(50) | No | ||||
| tglakhir_timinv | varchar(50) | No | ||||
| status | int(11) | No | ||||
| jabatan_pjlokasi | varchar(50) | No | ||||
| kontak_pjlokasi | varchar(50) | No | ||||
| jabatan_pelapor | varchar(50) | No | ||||
| jabatan_laporke | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_kecelakaan | 4 | A | No | |
| id_subjkecel | BTREE | No | No | id_subjkecel | 4 | A | Yes | |
| id_subjkecel2 | BTREE | No | No | id_subjkecel2 | 4 | A | Yes |
tb_kerusakanalat
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_kerusakanalat (Primary) | int(11) | No | ||||
| nama_alat | varchar(50) | No | ||||
| deskripsi | text | No | ||||
| biaya | enum('1', '2', '3', '4', '5') | No | ||||
| mekanisme | text | No | ||||
| id_kecelakaan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_kerusakanalat | 2 | A | No | |
| id_kecelakaan | BTREE | No | No | id_kecelakaan | A | No |
tb_kerusakanling
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_kerusakanling (Primary) | int(11) | No | ||||
| id_kecelakaan | int(11) | No | ||||
| id_tipedampak | enum('water-ground', 'water-surface', 'land-undisturbed', 'land-rehabilited', 'land-general', 'culture', 'heritage', 'air-quality', 'fauna', 'community', 'others') | No | ||||
| agen_pencemar | varchar(25) | No | ||||
| volume | int(11) | No | ||||
| area_terpapar | int(11) | No | ||||
| durasi_terpapar | int(11) | No | ||||
| durasi_dampak_papar | int(11) | No | ||||
| komen_tambahan | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_kerusakanling | 0 | A | No | |
| id_kecelakaan | BTREE | No | No | id_kecelakaan | A | No | ||
| id_kecelakaan_2 | BTREE | No | No | id_kecelakaan | A | No | ||
| id_kecelakaan_3 | BTREE | No | No | id_kecelakaan | A | No |
tb_lampiran
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_lampiran (Primary) | int(11) | No | ||||
| id_kecelakaan | int(11) | No | ||||
| jsa | int(11) | No | ||||
| saksi | int(11) | No | ||||
| sketsa | int(11) | No | ||||
| foto | int(11) | No | ||||
| training | int(11) | No | ||||
| perbaikan | int(11) | No | ||||
| prosedur | int(11) | No | ||||
| keterampilan | int(11) | No | ||||
| pemberitahuan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_lampiran | 3 | A | No | |
| id_kecelakaan | BTREE | No | No | id_kecelakaan | 1 | A | No |
tb_laporan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_kecelakaan | int(11) | No | ||||
| nm_korban | varchar(50) | No | ||||
| kom_korban | text | No | ||||
| tgl_korban | varchar(50) | No | ||||
| nm_atasan | varchar(50) | No | ||||
| kom_atasan | text | No | ||||
| tgl_atasan | varchar(50) | No | ||||
| nm_pjlokasi | varchar(50) | No | ||||
| kom_pjlokasi | text | No | ||||
| tgl_pjlokasi | varchar(50) | No | ||||
| nm_LK3 | varchar(50) | No | ||||
| kom_LK3 | text | No | ||||
| tgl_LK3 | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| id_kecelakaan | BTREE | No | No | id_kecelakaan | A | No | ||
| id_kecelakaan_2 | BTREE | No | No | id_kecelakaan | A | No |
tb_level
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_level (Primary) | int(11) | No | ||||
| nama_level | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_level | 2 | A | No |
tb_menu
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_menu (Primary) | int(11) | No | ||||
| nama_menu | varchar(50) | No | ||||
| link | text | No | ||||
| sub | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_menu | 32 | A | No |
tb_orgterlibat
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_kecelakaan | int(11) | No | ||||
| aktivitas | text | No | ||||
| nama_orgterlibat | varchar(50) | No | ||||
| nama_jabatan | varchar(50) | No | ||||
| nama_shiftkerja | varchar(50) | No | ||||
| nama_bagian | varchar(50) | No | ||||
| nama_department | varchar(50) | No | ||||
| tgllahir | varchar(50) | No | ||||
| jkelamin | varchar(50) | No | ||||
| id_orgterlibat (Primary) | int(11) | No | ||||
| NIK | varchar(10) | No | ||||
| nama_statuskerja | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_orgterlibat | 2 | A | No | |
| id_kecelakaan | BTREE | No | No | id_kecelakaan | A | No |
tb_pekerja
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_pekerja (Primary) | int(11) | No | ||||
| NIK | varchar(10) | No | ||||
| nama_pekerja | varchar(50) | No | ||||
| jkelamin | varchar(10) | No | ||||
| tgllahir | varchar(10) | No | ||||
| alamat | text | No | ||||
| kota | varchar(20) | No | ||||
| id_jabatan | int(11) | Yes | NULL | |||
| id_bagian | int(11) | Yes | NULL | |||
| id_department | int(11) | Yes | NULL | |||
| id_statuskerja | int(11) | Yes | NULL | |||
| id_shiftkerja | int(11) | Yes | NULL | |||
| tgl_masuk | date | No | ||||
| tgl_keluar | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_pekerja | 25 | A | No | |
| id_shiftkerja | BTREE | No | No | id_shiftkerja | A | Yes | ||
| id_jabatan | BTREE | No | No | id_jabatan | A | Yes | ||
| id_bagian | A | Yes | ||||||
| id_department | A | Yes | ||||||
| id_statuskerja | A | Yes | ||||||
| id_shiftkerja | A | Yes | ||||||
| id_shiftkerja_2 | BTREE | No | No | id_shiftkerja | A | Yes | ||
| id_bagian | BTREE | No | No | id_bagian | A | Yes | ||
| id_department | BTREE | No | No | id_department | A | Yes | ||
| id_statuskerja | BTREE | No | No | id_statuskerja | A | Yes |
tb_pemberitahuan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| instansi | text | No | ||||
| dilaporkanke | text | No | ||||
| komentar | text | No | ||||
| tgl | varchar(11) | No | ||||
| jam | varchar(11) | No | ||||
| id_kecelakaan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| id_kecelakaan | BTREE | No | No | id_kecelakaan | A | No |
tb_pengkajiulang
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_pengkajiulang (Primary) | int(11) | No | ||||
| NIK | varchar(11) | No | ||||
| komentar | text | No | ||||
| tanggal | varchar(11) | No | ||||
| id_kecelakaan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_pengkajiulang | 0 | A | No |
tb_penyebabdasar
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_penyebabdasar (Primary) | int(11) | No | ||||
| id_subsebabdasar | int(11) | No | ||||
| penyebab | text | No | ||||
| id_kecelakaan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_penyebabdasar | 3 | A | No | |
| id_kecelakaan | BTREE | No | No | id_kecelakaan | 1 | A | No |
tb_perawatan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_perawatan (Primary) | int(11) | No | ||||
| pj_per | varchar(20) | No | ||||
| tgl_per | int(11) | No | ||||
| jam_per | varchar(20) | No | ||||
| tempat_per | varchar(30) | No | ||||
| contactper_per | varchar(20) | No | ||||
| contactno_per | varchar(20) | No | ||||
| hasil_per | enum('p1', 'p2', 'p3', 'p4', 'p5', 'p6') | No | ||||
| deskripsi_per | text | No | ||||
| id_kecelakaan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_perawatan | 0 | A | No | |
| id_kecelakaan | BTREE | No | No | id_kecelakaan | A | No | ||
| id_kecelakaan_2 | BTREE | No | No | id_kecelakaan | A | No |
tb_perbaikan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_perbaikan (Primary) | int(11) | No | ||||
| id_investigasi | int(11) | No | ||||
| tindakan | text | No | ||||
| nama_petugas | varchar(11) | No | ||||
| tgl_target | varchar(11) | No | ||||
| id_kecelakaan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_perbaikan | 2 | A | No |
tb_produk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_produk (Primary) | int(11) | No | ||||
| nama_produk | varchar(100) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_produk | 5 | A | No |
tb_safetyp
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_safetyp (Primary) | int(11) | No | ||||
| jam_normal | int(11) | No | ||||
| jam_lembur | int(11) | No | ||||
| jam_absen | int(11) | No | ||||
| uac | int(11) | No | ||||
| near_miss | int(11) | No | ||||
| bulan | int(11) | No | ||||
| tahun | int(11) | No | ||||
| fatality | int(11) | No | ||||
| ldwc | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_safetyp | 15 | A | No |
tb_saksi
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_saksi (Primary) | int(11) | No | ||||
| id_kecelakaan | int(11) | No | ||||
| NIK | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_saksi | 0 | A | No |
tb_samplingemisi
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_samplingemisi (Primary) | int(11) | No | ||||
| id_gas | int(11) | No | ||||
| id_tempatsampling | int(11) | No | ||||
| baku_mutu | int(11) | No | ||||
| id_produk | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_samplingemisi | 15 | A | No |
tb_sebabdasar
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_sebabdasar (Primary) | int(11) | No | ||||
| nm_sebabdasar | varchar(100) | No | ||||
| keterangan | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_sebabdasar | 4 | A | No |
tb_shiftkerja
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_shiftkerja (Primary) | int(11) | No | ||||
| nama_shiftkerja | varchar(20) | No | ||||
| keterangan | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_shiftkerja | 5 | A | No |
tb_statuskerja
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_statuskerja (Primary) | int(11) | No | ||||
| nama_statuskerja | varchar(20) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_statuskerja | 4 | A | No |
tb_subjkecel
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_subjkecel (Primary) | int(11) | No | ||||
| nama_subjkecel | varchar(50) | No | ||||
| ket_subjkecel | text | No | ||||
| id_jkecel | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_subjkecel | 9 | A | No | |
| id_jkecel | BTREE | No | No | id_jkecel | A | No |
tb_subjkecel2
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_subjkecel2 (Primary) | int(11) | No | ||||
| nama_subjkecel2 | varchar(50) | No | ||||
| ket_subjkecel2 | text | No | ||||
| id_subjkecel | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_subjkecel2 | 4 | A | No | |
| id_subjkecel | BTREE | No | No | id_subjkecel | A | No |
tb_subsebabdasar
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_subsebabdasar (Primary) | int(11) | No | ||||
| nm_subsebabdasar | varchar(50) | No | ||||
| id_sebabdasar | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_subsebabdasar | 7 | A | No |
tb_tempatsampling
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| keterangan | text | No | ||||
| id_tempatsampling (Primary) | int(20) | No | ||||
| nama_tempatsampling | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_tempatsampling | 10 | A | No |
tb_timinvestigasi
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| nm_anggota1 | varchar(50) | No | ||||
| nm_anggota2 | varchar(50) | No | ||||
| nm_anggota3 | varchar(50) | No | ||||
| nm_anggota4 | varchar(50) | No | ||||
| per_anggota1 | varchar(50) | No | ||||
| per_anggota2 | varchar(50) | No | ||||
| per_anggota3 | varchar(50) | No | ||||
| per_anggota4 | varchar(50) | No | ||||
| jab_anggota1 | varchar(50) | No | ||||
| jab_anggota2 | varchar(50) | No | ||||
| jab_anggota3 | varchar(50) | No | ||||
| jab_anggota4 | varchar(50) | No | ||||
| id_kecelakaan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| id_kecelakaan | BTREE | No | No | id_kecelakaan | 1 | A | No |
tb_timinvestigasix
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_timinvestigasi (Primary) | int(11) | No | ||||
| id_pekerja | int(11) | No | ||||
| id_kecelakaan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_timinvestigasi | 0 | A | No |
tb_tindakan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_tindakan (Primary) | int(11) | No | ||||
| penindak | varchar(11) | No | ||||
| tindakan | text | No | ||||
| tanggal_tindakan | varchar(11) | No | ||||
| id_kecelakaan | int(11) | No | ||||
| jam_tindakan | varchar(10) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_tindakan | 6 | A | No | |
| id_kecelakaan | BTREE | No | No | id_kecelakaan | A | No |
tb_tingkatresiko
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_kecelakaan | int(11) | No | ||||
| konsekuensi_aktual | enum('catastrophic', 'major', 'moderate', 'minor', 'insignificant') | No | ||||
| konsekuensi_potensial | enum('catastrophic', 'major', 'moderate', 'minor', 'insignificant') | No | ||||
| kemungkinan | enum('almost certain', 'likely', 'possible', 'unlikely', 'rare') | No | ||||
| tingkat_resiko_aktual | enum('low', 'medium', 'high', 'extreme') | No | ||||
| tingkat_resiko_potensial | enum('low', 'medium', 'high', 'extreme') | No | ||||
| status | enum('awal', 'akhir') | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| id_kecelakaan | BTREE | No | No | id_kecelakaan | 2 | A | No |
tb_tipedampak
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_tipedampak (Primary) | int(11) | No | ||||
| nama_tipedampak | varchar(20) | No | ||||
| keterangan | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_tipedampak | 12 | A | No |
tb_users
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| username (Primary) | varchar(50) | No | ||||
| password | varchar(50) | No | ||||
| nama_lengkap | varchar(100) | No | ||||
| varchar(100) | No | |||||
| no_telp | varchar(20) | No | ||||
| id_level | varchar(20) | No | user | |||
| blokir | enum('Y', 'N') | No | N | |||
| id_session | varchar(100) | No | ||||
| foto | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | username | 7 | A | No |