Questionnaire Dependency Table Schema (questionnaire_dependency)


Description

Holds the combined dependencies per question to navigate in the test

questionnaire_dependency table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
questionid BIGINT 19 0
questionnaire_question.id quesdepe_que2_fk R

ID of question with dependency.
surveyid BIGINT 19 null
questionnaire_survey.id quesdepe_sur2_fk R

ID of survey question contained in.
dependquestionid BIGINT 19 0

ID of question dependent on.
dependchoiceid BIGINT 19 0

ID of question choice dependent on.
dependlogic TINYINT 3 0
dependandor VARCHAR 4

Mandatory or obligatory dependency

Table contained -1 rows

questionnaire_dependency table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesdepe_que_ix Performance Asc questionid
quesdepe_sur_ix Performance Asc surveyid

questionnaire_dependency table relationships

Close relationships within degrees of separation