|
id
|
bigint(20) unsigned
|
|
|
|
|
no_ticket
|
varchar(255)
|
|
|
|
|
pegawai_id
|
bigint(20) unsigned
|
|
|
|
|
tanggal_keluhan
|
date
|
|
|
|
|
jam_keluhan
|
time
|
|
|
|
|
tanggal_jam_kejadian
|
datetime
|
|
|
|
|
bidang_tujuan
|
varchar(255)
|
|
|
|
|
nama_ruangan
|
varchar(255)
|
|
|
|
|
kategori_keluhan
|
varchar(255)
|
|
|
|
|
alasan
|
text
|
|
|
|
|
foto
|
varchar(255)
|
|
|
|
|
status
|
enum
|
-- |
|
pending
|
|
prioritas
|
enum
|
-- |
|
sedang
|
|
created_at
|
timestamp
|
|
|
|
|
updated_at
|
timestamp
|
|
|
|