|
id
|
bigint(20)
|
|
|
|
|
ticket_number
|
varchar(50)
|
|
|
|
|
requester_name
|
varchar(255)
|
|
|
|
|
department
|
varchar(255)
|
|
|
|
|
phone
|
varchar(100)
|
|
|
|
|
issue_type
|
varchar(255)
|
|
|
|
|
urgency
|
varchar(100)
|
|
|
|
|
description
|
longtext
|
|
|
|
|
image_url
|
varchar(500)
|
|
|
|
|
status
|
varchar(100)
|
|
|
เปิดรายการใหม่
|
|
technician
|
varchar(255)
|
|
|
|
|
solution
|
longtext
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|