review_response

84 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('review_response_id_seq'::regclass)
review_response.original_review_response_id review_response_original_review_response_id_fkeyR
review_response.review_response_link_id review_response_review_response_link_id_fkeyR
comment varchar 2147483647 √ null
decision review_response_decision 2147483647 √ null
review_question_assignment_id int4 10 √ null
review_question_assignment.id review_response_review_question_assignment_id_fkeyR
application_response_id int4 10 √ null
application_response.id review_response_application_response_id_fkeyR
review_response_link_id int4 10 √ null
review_response.id review_response_review_response_link_id_fkeyR
original_review_response_id int4 10 √ null
review_response.id review_response_original_review_response_id_fkeyR
review_id int4 10 √ null
review.id review_response_review_id_fkeyR
stage_number int4 10 √ null
time_created timestamptz 35,6 √ CURRENT_TIMESTAMP
time_updated timestamptz 35,6 √ CURRENT_TIMESTAMP
time_submitted timestamptz 35,6 √ null
is_visible_to_applicant bool 1 √ false
template_element_id int4 10 √ null
template_element.id review_response_template_element_id_fkeyR
recommended_applicant_visibility review_response_recommended_applicant_visibility 2147483647 √ 'ORIGINAL_RESPONSE_NOT_VISIBLE_TO_APPLICANT'::review_response_recommended_applicant_visibility
status review_response_status 2147483647 √ 'DRAFT'::review_response_status

Indexes

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

Relationships

Close relationships within degrees of separation