review_files


Description

A list of the submission files made available to each assigned reviewer.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
review_file_id BIGINT UNSIGNED 20 null
review_id BIGINT 19 null
review_assignments.review_id review_files_review_id_foreignC
submission_file_id BIGINT UNSIGNED 20 null
submission_files.submission_file_id review_files_submission_file_id_foreignC

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc review_file_id
review_files_review_id Performance Asc review_id
review_files_submission_file_id Performance Asc submission_file_id
review_files_unique Must be unique Asc/Asc review_id + submission_file_id

Relationships