subeditor_submission_group


Description

Subeditor assignments to e.g. sections and categories

Columns

Column Type Size Nulls Auto Default Children Parents Comments
subeditor_submission_group_id BIGINT UNSIGNED 20 √ null
context_id BIGINT 19 null
journals.journal_id section_editors_context_idC
assoc_id BIGINT 19 null
assoc_type BIGINT 19 null
user_id BIGINT 19 null
users.user_id subeditor_submission_group_user_idC
user_group_id BIGINT 19 null
user_groups.user_group_id subeditor_submission_group_user_group_id_foreignC

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc subeditor_submission_group_id
section_editors_unique Must be unique Asc/Asc/Asc/Asc/Asc context_id + assoc_id + assoc_type + user_id + user_group_id
subeditor_submission_group_assoc_id Performance Asc/Asc assoc_id + assoc_type
subeditor_submission_group_context_id Performance Asc context_id
subeditor_submission_group_user_group_id Performance Asc user_group_id
subeditor_submission_group_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation