Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
review_id | bigserial | 19 | √ | nextval('review_assignments_review_id_seq'::regclass) |
|
|
||||||
submission_id | int8 | 19 | null |
|
|
|||||||
reviewer_id | int8 | 19 | null |
|
|
|||||||
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 |
|
|
|||||||
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 |
|
|
||||||
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 |