Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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)

...