workflow_participant


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
workflow_log.owner_id FK5D08B2C43B7237AE R
version BIGINT 19 0
company_id INT 10 √ null
sys_companies.company_id FKB87D7EB316D99B31 R
type_id BIGINT 19 null
workflow_participant_type.id FKB87D7EB3711961A1 R
user_id INT 10 √ null
sys_users.user_id FKB87D7EB328C762A3 R
workflow_id BIGINT 19 null
workflow.id FKB87D7EB3ABF90BA7 R
anybody BIT 1 b'0'
archived BIT 1 √ null
company_email_id BIGINT 19 √ null
company_email.id FKB87D7EB3692FF708 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FKB87D7EB316D99B31 Performance Asc company_id
FKB87D7EB328C762A3 Performance Asc user_id
FKB87D7EB3692FF708 Performance Asc company_email_id
FKB87D7EB3711961A1 Performance Asc type_id
FKB87D7EB3ABF90BA7 Performance Asc workflow_id

Relationships

Close relationships within degrees of separation