...
Field | Type | Purpose |
---|---|---|
o_id | int(4) | ID of the question the option belongs to. Join on q_id in questions table. |
option_text | text | The text of the option. |
o_media | varchar(255) | The filename of any attached media at the option level (removed in 7.2) |
o_media_width | varchar(4) | Width of any attached media (removed in 7.2) |
o_media_height | varchar(4) | Height of any attached media (removed in 7.2) |
feedback_right | text | Textual feedback to display if student gets option correct |
feedback_wrong | text | Textual feedback to display if student gets option wrong |
correct | text | Signifies which option is correct |
id_num | int(11) | Primary Key – auto increment. Use this field to order the options by (if not random or alphabetical) |
marks_correct | float | The number of marks for the current option |
marks_incorrect | float | Number of marks awarded if incorrect |
marks_partial | float | Number of marks if partially correct (question types like Ranking and Area use this) |
...