questionnaire_question

0 rows


Description

questionnaire_question table retrofitted from MySQL

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
questionnaire_dependency.questionid quesdepe_que2_fkR
questionnaire_quest_choice.question_id quesqueschoi_que2_fkR
surveyid BIGINT 19 0
survey.id Implied ConstraintR
name VARCHAR 30 √ null
type_id BIGINT 19 0
result_id BIGINT 19 √ null
length BIGINT 19 0
precise BIGINT 19 0
position BIGINT 19 0
content LONGTEXT 2147483647 null
required VARCHAR 1 n
deleted VARCHAR 1 n
extradata LONGTEXT 2147483647 √ null

If a question needs more than the standard fields provided, use this field.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesques_surdel2_ix Performance Asc/Asc surveyid + deleted

Relationships

Close relationships within degrees of separation