question_statuses

Purpose: Holds the available statuses that can be assigned to a question.

FieldTypePurpose
idint(11)Primary Key – auto increment.
namevarchar(255)The text of the status itself.
exclude_markingtinyint(4)Questions of this status will be excluded from marking. (e.g. Experimental)
retiredtinyint(3)Questions of this status are retired.
is_defaulttinyint(4)This is the default status when creating new questions.
change_lockedtinyint(3)If the question is locked then this status will be unavailable.
validatetinyint(3)Apply checks to questions for missing data/options.
display_warningtinyint(3)Warnings should be displayed if there are problems with questions of this status.
colourchar(7)The colour questions of this status will be displayed in.
display_ordertinyint(3) unsignedThe order to display the status options.