program_workflow_participant_type


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
program_workflow_participant.type_id FK_h36kpkb5t3k9aynqeq339k8uo R
version BIGINT 19 null
default_user_id INT 10 √ null
sys_users.user_id FK_bqurf790aytjy49u073vptees R
rank INT 10 null
responsibility VARCHAR 255 null
role_id INT 10 √ null
sys_roles.role_id FK_1ipwjaq4gjgcjkuj9p49g73pr R
user_locked BIT 1 √ null
user_required BIT 1 √ null
user_type INT 10 null
sys_monitor_types.type Implied Constraint R
workflow_id BIGINT 19 √ null
program_workflow_type.id FK_nl6qhup25v7e862d8te7oodo R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_1ipwjaq4gjgcjkuj9p49g73pr Performance Asc role_id
FK_bqurf790aytjy49u073vptees Performance Asc default_user_id
FK_nl6qhup25v7e862d8te7oodo Performance Asc workflow_id

Relationships

Close relationships within degrees of separation