stage_assignments

0 rows


Description

Who can access a submission while it is in the editorial workflow. Includes all editorial and author assignments. For reviewers, see review_assignments.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
stage_assignment_id bigserial 19 √ nextval('stage_assignments_stage_assignment_id_seq'::regclass)
submission_id int8 19 null
submissions.submission_id stage_assignments_submission_id_foreignC
user_group_id int8 19 null
user_groups.user_group_id stage_assignments_user_group_idC
user_id int8 19 null
users.user_id stage_assignments_user_idC
date_assigned timestamp 22 null
recommend_only int2 5 '0'::smallint
can_change_metadata int2 5 '0'::smallint

Indexes

Constraint Name Type Sort Column(s)
stage_assignments_pkey Primary key Asc stage_assignment_id
stage_assignment Must be unique Asc/Asc/Asc submission_id + user_group_id + user_id
stage_assignments_submission_id Performance Asc submission_id
stage_assignments_user_group_id Performance Asc user_group_id
stage_assignments_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation