workflow


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
workflow_log.workflow_id FK5D08B2C4ABF90BA7 R
workflow_participant.workflow_id FKB87D7EB3ABF90BA7 R
workflow_participant_history.workflow_id FK_qgwcel9i7037h9tbpldl0rbx1 R
version BIGINT 19 0
current_id BIGINT 19 √ null
workflow_log.id FK21BD7BF2C557739 R
iteration INT 10 null
project_id INT 10 null
project.id FK21BD7BFFE2B983 R
type_id BIGINT 19 null
workflow_type.id FK21BD7BF7A8FBA6 R
completed DATETIME 19 √ null
created DATETIME 19 √ null
priority INT 10 √ null
published_file_id BIGINT 19 √ null
project_file.id FK21BD7BF4C7747A7 R
vendor_quote_amount DECIMAL 19,2 √ null
pr_number VARCHAR 7 √ null
po_number VARCHAR 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK21BD7BF2C557739 Performance Asc current_id
FK21BD7BF4C7747A7 Performance Asc published_file_id
FK21BD7BF7A8FBA6 Performance Asc type_id
FK21BD7BFFE2B983 Performance Asc project_id
IX_workflow_project_iteration Must be unique Asc/Asc project_id + iteration

Relationships

Close relationships within degrees of separation