edit_decisions

0 rows


Description

Editorial decisions recorded on a submission, such as decisions to accept or decline the submission, as well as decisions to send for review, send to copyediting, request revisions, and more.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
edit_decision_id bigserial 19 √ nextval('edit_decisions_edit_decision_id_seq'::regclass)
submission_id int8 19 null
submissions.submission_id edit_decisions_submission_idC
review_round_id int8 19 √ null
review_rounds.review_round_id edit_decisions_review_round_id_foreignC
stage_id int8 19 √ null
round int2 5 √ null
editor_id int8 19 null
users.user_id edit_decisions_editor_idC
decision int2 5 null
date_decided timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
edit_decisions_pkey Primary key Asc edit_decision_id
edit_decisions_editor_id Performance Asc editor_id
edit_decisions_review_round_id Performance Asc review_round_id
edit_decisions_submission_id Performance Asc submission_id

Relationships

Close relationships within degrees of separation