| 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 |
|
| act_uid |
varchar |
36 |
√ |
|
|
|
|
| prj_id |
varchar |
36 |
√ |
|
|
|
|
| pro_id |
varchar |
36 |
√ |
|
|
|
|
| act_type |
varchar |
30 |
√ |
|
TASK |
|
|
| act_is_for_compensation |
int |
4 |
√ |
|
0 |
|
|
| act_start_quantity |
int |
4 |
√ |
|
1 |
|
|
| act_completion_quantity |
int |
4 |
√ |
|
1 |
|
|
| act_task_type |
varchar |
20 |
√ |
|
EMPTY |
|
|
| act_implementation |
text |
65535 |
√ |
|
null |
|
|
| act_instantiate |
int |
4 |
√ |
|
0 |
|
|
| act_script_type |
varchar |
255 |
√ |
|
|
|
|
| act_script |
text |
65535 |
√ |
|
null |
|
|
| act_loop_type |
varchar |
20 |
√ |
|
NONE |
|
|
| act_test_before |
int |
4 |
√ |
|
0 |
|
|
| act_loop_maximum |
int |
4 |
√ |
|
0 |
|
|
| act_loop_condition |
varchar |
100 |
√ |
|
|
|
|
| act_loop_cardinality |
int |
4 |
√ |
|
0 |
|
|
| act_loop_behavior |
varchar |
20 |
√ |
|
NONE |
|
|
| act_is_adhoc |
int |
4 |
√ |
|
0 |
|
|
| act_is_collapsed |
int |
4 |
√ |
|
1 |
|
|
| act_completion_condition |
varchar |
255 |
√ |
|
|
|
|
| act_ordering |
varchar |
20 |
√ |
|
PARALLEL |
|
|
| act_cancel_remaining_instances |
int |
4 |
√ |
|
1 |
|
|
| act_protocol |
varchar |
255 |
√ |
|
|
|
|
| act_method |
varchar |
255 |
√ |
|
|
|
|
| act_is_global |
int |
4 |
√ |
|
0 |
|
|
| act_referer |
int |
4 |
√ |
|
null |
|
|
| act_default_flow |
int |
4 |
√ |
|
null |
|
|
| act_master_diagram |
int |
4 |
√ |
|
null |
|
|
Analyzed at Mon Jun 15 09:20 UTC 2015
|