review_form_responses


Description

Each review form response records a reviewer’s answer to a review form element associated with a peer review.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
review_form_response_id BIGINT UNSIGNED 20 √ null
review_form_element_id BIGINT 19 null
review_form_elements.review_form_element_id review_form_responses_review_form_element_id_foreignC
review_id BIGINT 19 null
review_assignments.review_id review_form_responses_review_id_foreignC
response_type VARCHAR 6 √ NULL
response_value TEXT 65535 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc review_form_response_id
review_form_responses_review_form_element_id Performance Asc review_form_element_id
review_form_responses_review_id Performance Asc review_id
review_form_responses_unique Performance Asc/Asc review_form_element_id + review_id

Relationships

Close relationships within degrees of separation