Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Purpose: Stores data about which questions have been excluded post-exam for a summative paper.
Joins: propertiesquestions and users table.

FieldTypePurpose
idint(11)Primary Key – auto increment.
q_paperint(11)ID of the paper the question is on.
q_idint(11)ID of the question to be excluded.
partsvarchar(255)0=include, 1=exclude. Multipart questions like extended matching and ranking will use multiple digits for each part.
userIDint(10) unsignedUser ID of the member of staff doing the excluding.
datedatetimeDatetime when the question was excluded.
reasontextCurrently unused

...