options

Purpose: Holds the options of a question.
Joins: questions table.

FieldTypePurpose
o_idint(4)ID of the question the option belongs to. Join on q_id in questions table.
option_texttextThe text of the option.
o_mediavarchar(255)The filename of any attached media at the option level (removed in 7.2)
o_media_widthvarchar(4)Width of any attached media (removed in 7.2)
o_media_heightvarchar(4)Height of any attached media (removed in 7.2)
feedback_righttextTextual feedback to display if student gets option correct
feedback_wrongtextTextual feedback to display if student gets option wrong
correcttextSignifies which option is correct
id_numint(11)Primary Key – auto increment. Use this field to order the options by (if not random or alphabetical)
marks_correctfloatThe number of marks for the current option
marks_incorrectfloatNumber of marks awarded if incorrect
marks_partialfloatNumber of marks if partially correct (question types like Ranking and Area use this)