workflow_model


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
doc_workflow.model fk_doc_workflow_model R
lot_lot.workflow_model fk_lot_workflow_model R
proj_project.workflow_model fk_project_workflow_model R
workflow_model_state.model fk_workflow_model_state_model R
name VARCHAR 191 √ NULL
library VARCHAR 191 null
lib_library.identifier fk_workflow_model_library R
description TEXT 65535 √ NULL
version BIGINT 19 null
created_by VARCHAR 255 'system'
last_modified_by VARCHAR 255 'system'
created_date TIMESTAMP 19 current_timestamp()
last_modified_date TIMESTAMP 19 current_timestamp()
active BIT 1 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_workflow_model_library Performance Asc library
uniq_workflow_model_name Must be unique Asc name

Relationships

Close relationships within degrees of separation