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 |
| q_media_width | varchar(100) | Width of attached media |
| q_media_height | varchar(100) | Height of attached media |
| 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. |