user_groups

1 rows


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 bigserial 19 √ nextval('user_groups_user_group_id_seq'::regclass)
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 int8 19 null
role_id int8 19 null
is_default int2 5 '0'::smallint
show_title int2 5 '1'::smallint
permit_self_registration int2 5 '0'::smallint
permit_metadata_edit int2 5 '0'::smallint

Indexes

Constraint Name Type Sort Column(s)
user_groups_pkey 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