review_assignment

17 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('review_assignment_id_seq'::regclass)
review.review_assignment_id review_review_assignment_id_fkeyR
review_assignment_assigner_join.review_assignment_id review_assignment_assigner_join_review_assignment_id_fkeyR
review_question_assignment.review_assignment_id review_question_assignment_review_assignment_id_fkeyR
assigner_id int4 10 √ null
user.id review_assignment_assigner_id_fkeyR
reviewer_id int4 10 √ null
user.id review_assignment_reviewer_id_fkeyR
organisation_id int4 10 √ null
organisation.id review_assignment_organisation_id_fkeyR
stage_id int4 10 √ null
template_stage.id review_assignment_stage_id_fkeyR
stage_number int4 10 √ null
time_stage_created timestamptz 35,6 √ null
status review_assignment_status 2147483647 null
application_id int4 10 √ null
application.id review_assignment_application_id_fkeyR
template_id int4 10 √ review_assignment_template_id(application_id)
template.id review_assignment_template_id_fkeyR
allowed_sections _varchar 2147483647 √ null
trigger trigger 2147483647 √ null
time_updated timestamptz 35,6 √ CURRENT_TIMESTAMP
level_number int4 10 √ null
level_id int4 10 √ null
template_stage_review_level.id review_assignment_level_id_fkeyR
is_last_level bool 1 √ null
is_locked bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
review_assignment_pkey Primary key Asc id
unique_review_assignment_no_org Must be unique Asc/Asc/Asc/Asc reviewer_id + stage_number + application_id + level_number
unique_review_assignment_with_org Must be unique Asc/Asc/Asc/Asc/Asc reviewer_id + organisation_id + stage_number + application_id + level_number

Relationships

Close relationships within degrees of separation