| id |
BIGINT |
19 |
|
√ |
null |
|
|
|
| questionid |
BIGINT |
19 |
|
|
null |
|
|
Foreign key linking to the question table. |
| responseformat |
VARCHAR |
16 |
|
|
editor |
|
|
The type of input area students should be given for their response. |
| responserequired |
TINYINT |
3 |
|
|
1 |
|
|
Nonzero if an inline text response is optional |
| responsefieldlines |
SMALLINT |
5 |
|
|
15 |
|
|
Approximate height, in lines, of the input box the students should be given for their response. |
| attachments |
SMALLINT |
5 |
|
|
0 |
|
|
Whether, and how many, attachments a student is allowed to include with their response. -1 means unlimited. |
| attachmentsrequired |
SMALLINT |
5 |
|
|
0 |
|
|
The number of attachments that should be required |
| graderinfo |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
Information shown to people with permission to manually grade the question, when they are grading. |
| graderinfoformat |
SMALLINT |
5 |
|
|
0 |
|
|
The text format for graderinfo. |
| responsetemplate |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
The template to pre-populate student's response field during attempt. |
| responsetemplateformat |
SMALLINT |
5 |
|
|
0 |
|
|
The text format for responsetemplate. |
