os_wf_lib_tasks

11 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_wf_lib_task_notif_groups.TASK_ID FK_LIB_TASK_NOTIF_GROUPS_TASKR
os_wf_lib_task_user_groups.TASK_ID FK_WF_LIB_TASK_UG_TASKR
os_workflow_tasks.TEMPLATE_ID FK_WORKFLOW_TASK_TMPLR
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
OPTIONAL BIT 1 b'0'
ON_SKIP_ACTION VARCHAR 32 √ null
LIBRARY_ID BIGINT 19 null
os_wf_libraries.IDENTIFIER FK_TM_WF_TASK_LIBR
ACTIVITY_STATUS VARCHAR 32 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_TM_WF_TASK_LIB Performance Asc LIBRARY_ID

Relationships

Close relationships within degrees of separation