id
|
bigint(20) unsigned
|
|
|
|
company_id
|
bigint(20) unsigned
|
|
|
|
subject
|
varchar(500)
|
|
|
|
customer_name
|
varchar(191)
|
|
|
|
customer_email
|
varchar(191)
|
|
|
|
order_number
|
varchar(100)
|
|
|
|
status
|
enum
|
-- |
|
open
|
priority
|
enum
|
-- |
|
medium
|
ai_category
|
varchar(191)
|
|
|
|
ai_overview
|
text
|
|
|
|
order_id
|
bigint(20) unsigned
|
|
|
Browse foreign values
|
priority_id
|
smallint(5) unsigned
|
|
|
|
owner_username
|
varchar(191)
|
|
|
|
assigned_agent
|
varchar(100)
|
|
|
|
language_code
|
varchar(10)
|
|
|
|
inbox_category_id
|
smallint(5) unsigned
|
|
|
|
source
|
enum
|
-- |
|
email
|
last_update_preview
|
varchar(1000)
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|
closed_at
|
datetime
|
|
|
|