os_workflow_task_instances

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_task_instance_out_items.TASK_INSTANCE_ID FK_TASK_INST_OUT_ITEM_TI_IDR
os_wf_task_instances_state.TASK_INSTANCE_ID FK_TI_STATE_TI_IDR
os_workflow_task_deviations.TASK_INSTANCE_ID FK_DEVIATION_TASK_INSTANCER
WORKFLOW_INSTANCE_ID BIGINT 19 null
os_workflow_instances.IDENTIFIER FK_WF_TASK_INSTANCE_WF_IDR
TASK_ID BIGINT 19 null
os_workflow_tasks.IDENTIFIER FK_WF_TASK_INSTANCE_TASK_IDR
USER_ID BIGINT 19 null
catissue_user.IDENTIFIER FK_WF_TASK_INSTANCE_USER_IDR
STATUS VARCHAR 16 null
COMPLETION_TIME TIMESTAMP 19 √ null
SKIP_REASON TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_WF_TASK_INSTANCE_TASK_ID Performance Asc TASK_ID
FK_WF_TASK_INSTANCE_USER_ID Performance Asc USER_ID
FK_WF_TASK_INSTANCE_WF_ID Performance Asc WORKFLOW_INSTANCE_ID

Relationships

Close relationships within degrees of separation