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
question.id Implied Constraint R

ID of question with dependency.

surveyid BIGINT 19 null
survey.id Implied Constraint 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

questionnaire_dependency table relationships