Questionnaire Response Table Schema (questionnaire_response)


Description

questionnaire_response table retrofitted from MySQL

questionnaire_response table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
questionnaireid BIGINT 19 0
questionnaire.id quesresp_que2_fk R
submitted BIGINT 19 0
complete VARCHAR 1 n
grade BIGINT 19 0

Grade awarded
userid BIGINT 19 √ null
user.id Implied Constraint R

Table contained -1 rows

questionnaire_response table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesresp_que_ix Performance Asc questionnaireid

questionnaire_response table relationships

Close relationships within degrees of separation