| id |
BIGINT |
19 |
|
√ |
null |
|
|
|
| question |
BIGINT |
19 |
|
|
0 |
|
|
|
| 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. |
