review_round_files


Description

Records the files made available to reviewers for a round of reviews. These can be further customized on a per review basis with review_files.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
review_round_file_id BIGINT UNSIGNED 20 √ null
submission_id BIGINT 19 null
submissions.submission_id review_round_files_submission_id_foreignC
review_round_id BIGINT 19 null
review_rounds.review_round_id review_round_files_review_round_id_foreignC
stage_id SMALLINT 5 null
submission_file_id BIGINT UNSIGNED 20 null
submission_files.submission_file_id review_round_files_submission_file_id_foreignC

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc review_round_file_id
review_round_files_review_round_id Performance Asc review_round_id
review_round_files_submission_file_id Performance Asc submission_file_id
review_round_files_submission_id Performance Asc submission_id
review_round_files_unique Must be unique Asc/Asc/Asc submission_id + review_round_id + submission_file_id

Relationships

Close relationships within degrees of separation