question_statuses
Purpose: Holds the available statuses that can be assigned to a question.
| Field | Type | Purpose |
|---|---|---|
| id | int(11) | Primary Key – auto increment. |
| name | varchar(255) | The text of the status itself. |
| exclude_marking | tinyint(4) | Questions of this status will be excluded from marking. (e.g. Experimental) |
| retired | tinyint(3) | Questions of this status are retired. |
| is_default | tinyint(4) | This is the default status when creating new questions. |
| change_locked | tinyint(3) | If the question is locked then this status will be unavailable. |
| validate | tinyint(3) | Apply checks to questions for missing data/options. |
| display_warning | tinyint(3) | Warnings should be displayed if there are problems with questions of this status. |
| colour | char(7) | The colour questions of this status will be displayed in. |
| display_order | tinyint(3) unsigned | The order to display the status options. |
, multiple selections available,