| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| 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 |
|
|
| assigned_user_id |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| pro_id |
varchar |
36 |
√ |
|
|
|
|
| act_type |
varchar |
32 |
√ |
|
TASK |
|
|
| act_duration |
int |
4 |
√ |
|
0 |
|
|
| act_duration_unit |
varchar |
32 |
√ |
|
DAYS |
|
|
| act_send_notification |
int |
4 |
√ |
|
0 |
|
|
| act_assignment_method |
varchar |
32 |
√ |
|
BALANCED |
|
|
| act_assign_team |
varchar |
40 |
√ |
|
|
|
|
| act_assign_user |
varchar |
40 |
√ |
|
|
|
|
| act_value_based_assignment |
varchar |
255 |
√ |
|
|
|
|
| act_reassign |
int |
4 |
√ |
|
0 |
|
|
| act_reassign_team |
varchar |
40 |
√ |
|
|
|
|
| act_adhoc |
int |
4 |
√ |
|
0 |
|
|
| act_adhoc_behavior |
varchar |
40 |
√ |
|
|
|
|
| act_adhoc_team |
varchar |
40 |
√ |
|
|
|
|
| act_response_buttons |
varchar |
40 |
√ |
|
|
|
|
| act_last_user_assigned |
varchar |
40 |
√ |
|
|
|
|
| act_field_module |
varchar |
100 |
√ |
|
|
|
|
| act_fields |
text |
65535 |
√ |
|
null |
|
|
| act_readonly_fields |
text |
65535 |
√ |
|
null |
|
|
| act_expected_time |
text |
65535 |
√ |
|
null |
|
|
| act_required_fields |
text |
65535 |
√ |
|
null |
|
|
| act_related_modules |
text |
65535 |
√ |
|
null |
|
|
| act_service_url |
text |
65535 |
√ |
|
null |
|
|
| act_service_params |
text |
65535 |
√ |
|
null |
|
|
| act_service_method |
text |
65535 |
√ |
|
null |
|
|
| act_update_record_owner |
int |
4 |
√ |
|
0 |
|
|
| execution_mode |
varchar |
10 |
√ |
|
DEFAULT |
|
|
Analyzed at Mon Jun 15 09:20 UTC 2015
|
