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 |
|
|
cas_id |
int |
4 |
√ |
|
null |
|
|
cas_index |
int |
4 |
√ |
|
null |
|
|
pro_id |
varchar |
36 |
√ |
|
|
|
|
cas_previous |
int |
4 |
√ |
|
0 |
|
|
cas_reassign_level |
int |
4 |
√ |
|
0 |
|
|
bpmn_id |
varchar |
36 |
√ |
|
|
|
|
bpmn_type |
varchar |
32 |
√ |
|
|
|
|
cas_assignment_method |
varchar |
32 |
√ |
|
|
|
|
cas_user_id |
varchar |
40 |
√ |
|
|
|
|
cas_thread |
int |
4 |
√ |
|
0 |
|
|
cas_flow_status |
varchar |
32 |
√ |
|
OPEN |
|
|
cas_sugar_module |
varchar |
128 |
√ |
|
ProcessMaker |
|
|
cas_sugar_object_id |
varchar |
40 |
√ |
|
|
|
|
cas_sugar_action |
varchar |
40 |
√ |
|
DetailView |
|
|
cas_adhoc_type |
varchar |
40 |
√ |
|
|
|
|
cas_adhoc_parent_id |
varchar |
40 |
√ |
|
|
|
|
cas_adhoc_actions |
varchar |
255 |
√ |
|
|
|
|
cas_task_start_date |
datetime |
19 |
√ |
|
null |
|
|
cas_delegate_date |
datetime |
19 |
√ |
|
null |
|
|
cas_start_date |
datetime |
19 |
√ |
|
null |
|
|
cas_finish_date |
datetime |
19 |
√ |
|
null |
|
|
cas_due_date |
datetime |
19 |
√ |
|
null |
|
|
cas_queue_duration |
int |
4 |
√ |
|
0 |
|
|
cas_duration |
int |
4 |
√ |
|
0 |
|
|
cas_delay_duration |
int |
4 |
√ |
|
0 |
|
|
cas_started |
int |
4 |
√ |
|
0 |
|
|
cas_finished |
int |
4 |
√ |
|
0 |
|
|
cas_delayed |
int |
4 |
√ |
|
0 |
|
|
assigned_user_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
Analyzed at Wed Feb 15 12:32 UTC 2017
|