review_assignments


Description

Data about peer review assignments for all submissions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
review_id BIGINT 19 √ null
review_files.review_id review_files_review_id_foreignC
review_form_responses.review_id review_form_responses_review_id_foreignC
submission_id BIGINT 19 null
submissions.submission_id review_assignments_submission_id_foreignR
reviewer_id BIGINT 19 null
users.user_id review_assignments_reviewer_id_foreignR
competing_interests TEXT 65535 √ NULL
recommendation SMALLINT 5 √ NULL
date_assigned DATETIME 19 √ NULL
date_notified DATETIME 19 √ NULL
date_confirmed DATETIME 19 √ NULL
date_completed DATETIME 19 √ NULL
date_acknowledged DATETIME 19 √ NULL
date_due DATETIME 19 √ NULL
date_response_due DATETIME 19 √ NULL
last_modified DATETIME 19 √ NULL
reminder_was_automatic SMALLINT 5 0
declined SMALLINT 5 0
cancelled SMALLINT 5 0
date_rated DATETIME 19 √ NULL
date_reminded DATETIME 19 √ NULL
quality SMALLINT 5 √ NULL
review_round_id BIGINT 19 null
review_rounds.review_round_id review_assignments_review_round_id_foreignR
stage_id SMALLINT 5 null
review_method SMALLINT 5 1
round SMALLINT 5 1
step SMALLINT 5 1
review_form_id BIGINT 19 √ NULL
review_forms.review_form_id review_assignments_review_form_id_foreignR
considered SMALLINT 5 √ NULL
request_resent SMALLINT 5 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc review_id
review_assignment_reviewer_round Performance Asc/Asc review_round_id + reviewer_id
review_assignments_form_id Performance Asc review_form_id
review_assignments_reviewer_id Performance Asc reviewer_id
review_assignments_reviewer_review Performance Asc/Asc reviewer_id + review_id
review_assignments_submission_id Performance Asc submission_id

Relationships

Close relationships within degrees of separation