| id | int(10) unsigned |
|
|
|
| nomor | varchar(20) |
|
|
|
| judul | varchar(255) |
|
|
|
| deskripsi | text |
|
|
|
| kategori_id | int(10) unsigned |
|
|
|
| prioritas | enum | -- |
|
Sedang
|
| status | enum | -- |
|
menunggu
|
| user_id | int(10) unsigned |
|
|
|
| teknisi_id | int(10) unsigned |
|
|
|
| lokasi | varchar(255) |
|
|
|
| aset_id | int(11) |
|
|
|
| aset_nama_cache | varchar(200) |
|
|
|
| catatan_penolakan | text |
|
|
|
| waktu_submit | datetime |
|
|
current_timestamp()
|
| waktu_diproses | datetime |
|
|
|
| waktu_selesai | datetime |
|
|
|
| durasi_respon_menit | int(11) |
|
|
|
| durasi_selesai_menit | int(11) |
|
|
|
| created_at | datetime |
|
|
current_timestamp()
|
| updated_at | datetime |
|
|
|