user_group_stage


Description

Which stages of the editorial workflow the user_groups can access.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_group_stage_id BIGINT UNSIGNED 20 √ null
context_id BIGINT 19 null
journals.journal_id user_group_stage_context_idC
user_group_id BIGINT 19 null
user_groups.user_group_id user_group_stage_user_group_idC
stage_id BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc user_group_stage_id
user_group_stage_context_id Performance Asc context_id
user_group_stage_stage_id Performance Asc stage_id
user_group_stage_unique Must be unique Asc/Asc/Asc context_id + user_group_id + stage_id
user_group_stage_user_group_id Performance Asc user_group_id

Relationships

Close relationships within degrees of separation