# 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