doc_workflow_state


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
key VARCHAR 255 √ NULL
status VARCHAR 255 √ NULL
model_state VARCHAR 191 null
workflow_model_state.identifier fk_doc_workflow_state_model_state R
workflow VARCHAR 191 null
doc_workflow.identifier fk_doc_workflow_state_workflow R
start_date DATETIME 19 √ NULL
end_date DATETIME 19 √ NULL
due_date DATETIME 19 √ NULL
user VARCHAR 255 √ 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()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_doc_workflow_state_model_state Performance Asc model_state
fk_doc_workflow_state_workflow Performance Asc workflow

Relationships

Close relationships within degrees of separation