Purpose: Holds the options of a question.
Joins: questions table.
| 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 |
| o_media_width | varchar(4) | Width of any attached media |
| o_media_height | varchar(4) | Height of any attached media |
| 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) |