os_workflow_instances

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_task_instance_out_items.WORKFLOW_INSTANCE_ID FK_TASK_INST_OUT_ITEM_WI_IDR
os_workflow_instance_in_items.WORKFLOW_INSTANCE_ID FK_WF_INPUT_ITEM_INSTANCE_IDR
os_workflow_instance_params.WORKFLOW_INSTANCE_ID FK_WF_INSTANCE_PARAMS_IDR
os_workflow_queue_items.WF_INSTANCE_ID FK_WF_QUEUE_INSTANCE_IDR
os_workflow_task_instances.WORKFLOW_INSTANCE_ID FK_WF_TASK_INSTANCE_WF_IDR
NAME VARCHAR 255 null
WORKFLOW_ID BIGINT 19 null
os_workflows.IDENTIFIER FK_WORKFLOW_INSTANCES_WF_IDR
CREATION_TIME TIMESTAMP 19 null
STATUS VARCHAR 32 √ null
COMPLETION_TIME TIMESTAMP 19 √ null
INPUT_TYPE VARCHAR 32 √ null
CREATOR_ID BIGINT 19 √ null
catissue_user.IDENTIFIER FK_WF_INSTANCE_CREATORR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_WF_INSTANCE_CREATOR Performance Asc CREATOR_ID
FK_WORKFLOW_INSTANCES_WF_ID Performance Asc WORKFLOW_ID
OS_WORKFLOW_INSTANCES_NAME_UQ Must be unique Asc NAME

Relationships

Close relationships within degrees of separation