os_workflows

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_workflow_cps.WORKFLOW_ID FK_WORKFLOW_CPS_WF_IDR
os_workflow_instances.WORKFLOW_ID FK_WORKFLOW_INSTANCES_WF_IDR
os_workflow_labs.WORKFLOW_ID FK_LAB_WORKFLOWR
os_workflow_notif_user_groups.WORKFLOW_ID FK_WORKFLOW_NOTIFS_WF_IDR
os_workflow_queue_items.WORKFLOW_ID FK_WF_QUEUE_WF_IDR
os_workflow_tasks.WORKFLOW_ID FK_TASK_WORKFLOWR
NAME VARCHAR 32 null
TITLE VARCHAR 255 null
SHORT_CODE VARCHAR 32 null
INSTANCE_NAME_FORMAT VARCHAR 128 null
DESCRIPTION TEXT 65535 √ null
ACTIVITY_STATUS VARCHAR 32 Active
CREATED_BY BIGINT 19 √ null
catissue_user.IDENTIFIER FK_WORKFLOW_CREATORR
CREATION_TIME TIMESTAMP 19 √ null
UPDATED_BY BIGINT 19 √ null
catissue_user.IDENTIFIER FK_WORKFLOW_UPDATERR
UPDATE_TIME TIMESTAMP 19 √ null
RULE_JSON TEXT 65535 √ null
INPUT_TYPE VARCHAR 32 √ null
DEF_SCAN_PROP VARCHAR 32 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_WORKFLOW_CREATOR Performance Asc CREATED_BY
FK_WORKFLOW_UPDATER Performance Asc UPDATED_BY
OS_WORFLOW_NAME_UQ Must be unique Asc NAME
OS_WORKFLOWS_SHORT_CODE_UQ Must be unique Asc SHORT_CODE

Relationships

Close relationships within degrees of separation