edit_decisions


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 BIGINT 19 √ null
submission_id BIGINT 19 null
submissions.submission_id edit_decisions_submission_idC
review_round_id BIGINT 19 √ NULL
review_rounds.review_round_id edit_decisions_review_round_id_foreignC
stage_id BIGINT 19 √ NULL
round SMALLINT 5 √ NULL
editor_id BIGINT 19 null
users.user_id edit_decisions_editor_idC
decision SMALLINT 5 null
date_decided DATETIME 19 null

Indexes

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