id |
char |
36 |
|
|
|
|
|
name |
varchar |
255 |
√ |
|
null |
|
|
date_entered |
datetime |
19 |
√ |
|
null |
|
|
date_modified |
datetime |
19 |
√ |
|
null |
|
|
modified_user_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
created_by |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
description |
longtext |
2147483647 |
√ |
|
null |
|
|
deleted |
bit |
1 |
√ |
|
0 |
|
|
case_number |
int |
11 |
|
√ |
|
|
|
type |
varchar |
255 |
√ |
|
null |
|
|
status |
varchar |
100 |
√ |
|
null |
|
|
priority |
varchar |
100 |
√ |
|
null |
|
|
resolution |
text |
65535 |
√ |
|
null |
|
|
work_log |
text |
65535 |
√ |
|
null |
|
|
follow_up_datetime |
datetime |
19 |
√ |
|
null |
|
|
resolved_datetime |
datetime |
19 |
√ |
|
null |
|
|
hours_to_resolution |
decimal |
12,2 |
√ |
|
null |
|
|
business_hours_to_resolution |
decimal |
12,2 |
√ |
|
null |
|
|
pending_processing |
bit |
1 |
√ |
|
0 |
|
|
account_id |
char |
36 |
√ |
|
null |
|
|
business_center_id |
char |
36 |
√ |
|
null |
|
|
source |
varchar |
255 |
√ |
|
null |
|
|
request_close |
bit |
1 |
√ |
|
0 |
|
|
request_close_date |
datetime |
19 |
√ |
|
null |
|
|
portal_viewable |
bit |
1 |
√ |
|
1 |
|
|
primary_contact_id |
char |
36 |
√ |
|
null |
|
|
sync_key |
varchar |
100 |
√ |
|
null |
|
|
assigned_user_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
team_id |
char |
36 |
√ |
|
null |
|
teams.id
|
Defined in XML R |
|
team_set_id |
char |
36 |
√ |
|
null |
|
|
acl_team_set_id |
char |
36 |
√ |
|
null |
|
|
first_response_target_datetime |
datetime |
19 |
√ |
|
null |
|
|
first_response_actual_datetime |
datetime |
19 |
√ |
|
null |
|
|
hours_to_first_response |
decimal |
12,2 |
√ |
|
null |
|
|
business_hrs_to_first_response |
decimal |
12,2 |
√ |
|
null |
|
|
first_response_var_from_target |
decimal |
12,2 |
√ |
|
null |
|
|
first_response_sla_met |
varchar |
100 |
√ |
|
null |
|
|
first_response_user_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
first_response_sent |
bit |
1 |
√ |
|
0 |
|
|
is_escalated |
bit |
1 |
√ |
|
0 |
|
|