question_calculated_options

0 rows


Description

Options for questions of type calculated

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
question BIGINT 19 0
question.id quescalcopti_que2_fkR
synchronize TINYINT 3 0
single SMALLINT 5 0

If 0 it multiple response (checkboxes). Otherwise it is radio buttons.

shuffleanswers SMALLINT 5 0

Whether the choices can be randomly shuffled.

correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

correctfeedbackformat TINYINT 3 0
partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

partiallycorrectfeedbackformat TINYINT 3 0
incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

incorrectfeedbackformat TINYINT 3 0
answernumbering VARCHAR 10 abc

Indicates how and whether the choices should be numbered.

shownumcorrect TINYINT 3 0

If true, then when the user gets a multiple-response question partially correct, tell them how many choices they got correct alongside the feedback.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quescalcopti_que_ix Performance Asc question

Relationships