review

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('review_id_seq'::regclass)
notification.review_id notification_review_id_fkeyR
review_decision.review_id review_decision_review_id_fkeyR
review_response.review_id review_response_review_id_fkeyR
review_status_history.review_id review_status_history_review_id_fkeyR
review_assignment_id int4 10 √ null
review_assignment.id review_review_assignment_id_fkeyR
trigger trigger 2147483647 √ null
application_id int4 10 √ review_application_id(review_assignment_id)
application.id review_application_id_fkeyR
reviewer_id int4 10 √ review_reviewer_id(review_assignment_id)
user.id review_reviewer_id_fkeyR
level_number int4 10 √ review_level(review_assignment_id)
stage_number int4 10 √ review_stage(review_assignment_id)
time_stage_created timestamptz 35,6 √ review_time_stage_created(review_assignment_id)
is_last_level bool 1 √ review_is_last_level(review_assignment_id)

Indexes

Constraint Name Type Sort Column(s)
review_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation