|
ticket_id
|
int(11)
|
|
|
|
|
customer_id
|
int(11)
|
|
|
|
|
trdr
|
varchar(32)
|
|
|
|
|
soft1_id
|
varchar(32)
|
|
|
|
|
number
|
varchar(64)
|
|
|
|
|
subject
|
varchar(255)
|
|
|
|
|
description
|
text
|
|
|
|
|
category
|
varchar(128)
|
|
|
|
|
category_value
|
varchar(64)
|
|
|
|
|
priority
|
varchar(128)
|
|
|
|
|
priority_value
|
varchar(64)
|
|
|
|
|
state
|
varchar(16)
|
|
|
pending
|
|
status_value
|
varchar(64)
|
|
|
|
|
status_text
|
varchar(128)
|
|
|
|
|
attempts
|
int(11)
|
|
|
0
|
|
last_error
|
text
|
|
|
|
|
file_token
|
varchar(64)
|
|
|
|
|
file_name
|
varchar(255)
|
|
|
|
|
file_path
|
varchar(255)
|
|
|
|
|
mail_open
|
tinyint(1)
|
|
|
0
|
|
mail_close
|
tinyint(1)
|
|
|
0
|
|
date_added
|
datetime
|
|
|
2026-11-07 20:21:53.000000
|
|
date_sent
|
datetime
|
|
|
|
|
date_checked
|
datetime
|
|
|
|
|
date_closed
|
datetime
|
|
|
|
|
pending_close
|
datetime
|
|
|
|
|
reopen_count
|
int(11)
|
|
|
0
|
|
date_reopened
|
datetime
|
|
|
|
|
close_duration
|
varchar(64)
|
|
|
|
|
close_billing
|
text
|
|
|
|
|
mail_cancel
|
tinyint(1)
|
|
|
0
|
|
anydesk
|
varchar(64)
|
|
|
|
|
department
|
varchar(64)
|
|
|
|
|
dept_close
|
tinyint(1)
|
|
|
1
|
|
requester
|
varchar(128)
|
|
|
|
|
contact_phone
|
varchar(32)
|
|
|
|
|
billable
|
tinyint(1)
|
|
|
|
|
contact_mobile
|
varchar(32)
|
|
|
|
|
parent_id
|
int(11)
|
|
|
0
|
|
child_id
|
int(11)
|
|
|
0
|
|
inherit
|
text
|
|
|
|
|
accept_charge
|
tinyint(1)
|
|
|
0
|
|
staff_mailed
|
tinyint(1)
|
|
|
0
|