workflow_type


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
workflow.type_id FK21BD7BF7A8FBA6 R
workflow_participant_type.workflow_id FK47260146A09B2901 R
workflow_type_history.workflow_type_id FK_ij17xj4s598i7m96phmpke2sq R
version BIGINT 19 0
active BIT 1 b'1'
approved_path VARCHAR 100
form_id INT 10 √ null
project_form.id FK44116FBA82389340 R
name VARCHAR 50 null
timeout INT 10 0
finish_type VARCHAR 20 √ null
priority INT 10 √ null
vendor_quote_type INT 10 null
sys_monitor_types.type Implied Constraint R
vendor_quote_vendor_type_id INT 10 √ null
sys_company_types.type_id FK_bfd55mv84uxtqwuj6x57o9uiv R
quote_info_locked BIT 1 null
review_option INT 10 null
show_id BIT 1 b'0'
owner VARCHAR 100 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK44116FBA82389340 Performance Asc form_id
FK_bfd55mv84uxtqwuj6x57o9uiv Performance Asc vendor_quote_vendor_type_id
name Must be unique Asc name

Relationships

Close relationships within degrees of separation