user_groups


Description

All defined user roles in a context, such as Author, Reviewer, Section Editor and Journal Manager.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_group_id BIGINT 19 √ null
authors.user_group_id authors_user_group_id_foreignC
stage_assignments.user_group_id stage_assignments_user_group_idC
subeditor_submission_group.user_group_id subeditor_submission_group_user_group_id_foreignC
user_group_settings.user_group_id user_group_settings_user_group_id_foreignC
user_group_stage.user_group_id user_group_stage_user_group_idC
user_user_groups.user_group_id user_user_groups_user_group_id_foreignC
context_id BIGINT 19 null
role_id BIGINT 19 null
is_default SMALLINT 5 0
show_title SMALLINT 5 1
permit_self_registration SMALLINT 5 0
permit_metadata_edit SMALLINT 5 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc user_group_id
user_groups_context_id Performance Asc context_id
user_groups_role_id Performance Asc role_id
user_groups_user_group_id Performance Asc user_group_id

Relationships

Close relationships within degrees of separation