review_rounds


Description

Peer review assignments are organized into multiple rounds on a submission.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
review_round_id BIGINT 19 √ null
edit_decisions.review_round_id edit_decisions_review_round_id_foreignC
review_assignments.review_round_id review_assignments_review_round_id_foreignR
review_round_files.review_round_id review_round_files_review_round_id_foreignC
submission_id BIGINT 19 null
submissions.submission_id review_rounds_submission_id_foreignR
stage_id BIGINT 19 √ NULL
round SMALLINT 5 null
review_revision BIGINT 19 √ NULL
status BIGINT 19 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc review_round_id
review_rounds_submission_id Performance Asc submission_id
review_rounds_submission_id_stage_id_round_pkey Must be unique Asc/Asc/Asc submission_id + stage_id + round

Relationships

Close relationships within degrees of separation