| 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 |
text |
65535 |
√ |
|
null |
|
|
| deleted |
bit |
1 |
√ |
|
0 |
|
|
| dataprivacy_number |
int |
11 |
|
√ |
|
|
|
| type |
varchar |
255 |
√ |
|
null |
|
|
| status |
varchar |
100 |
√ |
|
Open |
|
|
| 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 |
|
|
| business_purpose |
text |
65535 |
√ |
|
null |
|
|
| source |
varchar |
255 |
√ |
|
null |
|
|
| requested_by |
varchar |
255 |
√ |
|
null |
|
|
| date_opened |
date |
10 |
√ |
|
null |
|
|
| date_due |
date |
10 |
√ |
|
null |
|
|
| date_closed |
date |
10 |
√ |
|
null |
|
|
| fields_to_erase |
text |
65535 |
√ |
|
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 |
|
|
