os_workflow_tasks

20 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_wf_task_eff_user_groups.TASK_ID FK_TASK_EFF_UGS_TASKR
os_workflow_task_inputs.SINK_TASK_ID FK_INPUT_TASK_SINKR
os_workflow_task_inputs.SOURCE_TASK_ID FK_INPUT_TASK_SRCR
os_workflow_task_instances.TASK_ID FK_WF_TASK_INSTANCE_TASK_IDR
os_workflow_task_notif_groups.TASK_ID FK_TASK_NOTIF_GROUPS_TASKR
os_workflow_task_user_groups.TASK_ID FK_TASK_UG_TASKR
NAME VARCHAR 32 null
TITLE VARCHAR 64 √ null
TASK_TYPE VARCHAR 32 √ null
SHORT_DESC VARCHAR 128 √ null
LONG_DESC TEXT 65535 √ null
SOP_DOCUMENT_LINK VARCHAR 255 √ null
JSON_CONFIG BIT 1 b'0'
CONFIG TEXT 65535 √ null
STARTER_TASK BIT 1 b'0'
WORKFLOW_ID BIGINT 19 null
os_workflows.IDENTIFIER FK_TASK_WORKFLOWR
ACTIVITY_STATUS VARCHAR 32 null
OPTIONAL BIT 1 √ null
ON_SKIP_ACTION VARCHAR 32 √ null
TEMPLATE_ID BIGINT 19 √ null
os_wf_lib_tasks.IDENTIFIER FK_WORKFLOW_TASK_TMPLR
OUT_ITEMS_WF_RULES TEXT 65535 √ null
OUT_ITEMS_CART_RULES TEXT 65535 √ null
OUT_ITEMS_RULES TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_WORKFLOW_TASK_TMPL Performance Asc TEMPLATE_ID
OS_WF_TASK_NAME_UQ Must be unique Asc/Asc WORKFLOW_ID + NAME

Relationships

Close relationships within degrees of separation