|
id
|
bigint(20)
|
|
|
|
|
ticket_no
|
varchar(30)
|
|
|
|
|
requester_name
|
varchar(120)
|
|
|
|
|
requester_phone
|
varchar(30)
|
|
|
|
|
category_id
|
int(11)
|
|
|
|
|
title
|
varchar(200)
|
|
|
|
|
description
|
text
|
|
|
|
|
priority
|
enum
|
-- |
|
MEDIUM
|
|
status
|
enum
|
-- |
|
OPEN
|
|
created_by_user_id
|
int(11)
|
|
|
|
|
assigned_to
|
int(11)
|
|
|
|
|
pic_id
|
int(11)
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
|