Questionnaire Question Type Table Schema (questionnaire_question_type)


Description

questionnaire_question_type table retrofitted from MySQL

questionnaire_question_type table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
typeid BIGINT 19 0

The code for the type.

type VARCHAR 32
has_choices VARCHAR 1 y
response_table VARCHAR 32 null

Table contained -1 rows

questionnaire_question_type table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesquestype_typ_uix Must be unique Asc typeid