qtype_multichoice_options

0 rows


Description

Options for multiple choice questions

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
questionid BIGINT 19 0
question.id qtypmultopti_que_fkR
layout SMALLINT 5 0
single SMALLINT 5 0
shuffleanswers SMALLINT 5 1
correctfeedback LONGTEXT 2147483647 null
correctfeedbackformat TINYINT 3 0
partiallycorrectfeedback LONGTEXT 2147483647 null
partiallycorrectfeedbackformat TINYINT 3 0
incorrectfeedback LONGTEXT 2147483647 null
incorrectfeedbackformat TINYINT 3 0
answernumbering VARCHAR 10 abc
shownumcorrect TINYINT 3 0
showstandardinstruction TINYINT 3 1

Indexes

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

Relationships