Purpose: Holds most of the data used by an individual question. See options table for the rest of the data.
Joins: papers and options tables.

Field	Type	Purpose
q_id	int(4)	Primary Key – auto increment.
q_type	enum('blank', 'calculation', 'dichotomous', 'flash', 'hotspot', 'labelling', 'likert', 'matrix', 'mcq', 'mrq', 'rank', 'textbox', 'info', 'extmatch', 'random', 'sct', 'keyword_based', 'true_false', 'area')	What type the question is (flash is now deprecated)
theme	text	Optional heading for the question
scenario	text	Scenario or background information for the question
leadin	text	The question itself
correct_fback	text	General textual feedback to display if student gets question correct
incorrect_fback	text	General textual feedback to display if student gets question wrong
display_method	text
notes	text	Notes displayed against question (these are visible to students)
ownerID	int(11)	ID of the user who ownes (originally created) the question
q_media	text	Filename of optional media to be attached to the current question (removed in 7.2)
q_media_width	varchar(100)	Width of attached media (removed in 7.2)
q_media_height	varchar(100)	Height of attached media (removed in 7.2)
creation_date	datetime	Datetime when the current question was created
last_edited	datetime	Datetime of the last time the question was edited
bloom	enum('Knowledge', 'Comprehension', 'Application', 'Analysis', 'Synthesis', 'Evaluation')	Holds what level of cognitive engagement as per Bloom's Taxonomy the question pertains to
scenario_plain	text	Same as scenario but with HTML tags removed (used for searching)
leadin_plain	text	Same as leading but with HTML tags removed (used for searching)
checkout_time	datetime	Datetime question was checked out for editing
checkout_authorID	int(10) unsigned	User ID who has question checked out for editing
deleted	datetime	Datetime when question was deleted. If NULL then the question is still active
locked	datetime	Datetime when the question was locked bacause of a summative exam
std	varchar(100)	Standard setting value saved with question for future use.
status	tinyint(3)	Status of the question
q_option_order	enum('display order', 'alphabetic', 'random')	What order to display the options
score_method	enum('Mark per Question','Mark per Option','Allow partial Marks','Bonus Mark')	Depending on question type holds data about how to mark the question
settings	text	5.1: Used to hold JSON encode list of settings for a question. Currently used with the Calculation question.
guid	char(40)	5.1.2: Global unique identifier for a question. Used to help support question identification between Rogo and an external item bank.

Browser not supported