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 (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)

Browser not supported