review_assignments

0 rows


Description

Data about peer review assignments for all submissions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
review_id bigserial 19 √ nextval('review_assignments_review_id_seq'::regclass)
review_files.review_id review_files_review_id_foreignC
review_form_responses.review_id review_form_responses_review_id_foreignC
submission_id int8 19 null
submissions.submission_id review_assignments_submission_id_foreignR
reviewer_id int8 19 null
users.user_id review_assignments_reviewer_id_foreignR
competing_interests text 2147483647 √ null
recommendation int2 5 √ null
date_assigned timestamp 22 √ null
date_notified timestamp 22 √ null
date_confirmed timestamp 22 √ null
date_completed timestamp 22 √ null
date_acknowledged timestamp 22 √ null
date_due timestamp 22 √ null
date_response_due timestamp 22 √ null
last_modified timestamp 22 √ null
reminder_was_automatic int2 5 '0'::smallint
declined int2 5 '0'::smallint
cancelled int2 5 '0'::smallint
reviewer_file_id int8 19 √ null
date_rated timestamp 22 √ null
date_reminded timestamp 22 √ null
quality int2 5 √ null
review_round_id int8 19 null
review_rounds.review_round_id review_assignments_review_round_id_foreignR
stage_id int2 5 null
review_method int2 5 '1'::smallint
round int2 5 '1'::smallint
step int2 5 '1'::smallint
review_form_id int8 19 √ null
review_forms.review_form_id review_assignments_review_form_id_foreignR
considered int2 5 √ null
request_resent int2 5 '0'::smallint

Indexes

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