Questionnaire Dependency Table Schema (questionnaire_dependency)


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 quesdepe_que2_fk R

ID of question with dependency.

surveyid BIGINT 19 null 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