workflow_participant_type


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
workflow_participant.type_id FKB87D7EB3711961A1 R
version BIGINT 19 0
rank INT 10 0
responsibility VARCHAR 30 null
role_id INT 10 √ null
sys_roles.role_id FK47260146839C9EC3 R
workflow_id BIGINT 19 √ null
workflow_type.id FK47260146A09B2901 R
user_required BIT 1 √ null
default_user_id INT 10 √ null
sys_users.user_id FK_pttcs4ccgxc8l0014t1cp2jay R
user_locked BIT 1 √ null
user_type INT 10 null
sys_monitor_types.type Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK47260146839C9EC3 Performance Asc role_id
FK47260146A09B2901 Performance Asc workflow_id
FK_pttcs4ccgxc8l0014t1cp2jay Performance Asc default_user_id

Relationships

Close relationships within degrees of separation