Purpose: Holds the available statuses that can be assigned to a question.
Version: 5.1
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. |
...