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