Purpose: Stores data about which questions have been excluded post-exam for a summative paper.
Joins: properties, questions and users table.
| Field | Type | Purpose |
|---|---|---|
| id | int(11) | Primary Key – auto increment. |
| q_paper | int(11) | ID of the paper the question is on. |
| q_id | int(11) | ID of the question to be excluded. |
| parts | varchar(255) | 0=include, 1=exclude. Multipart questions like extended matching and ranking will use multiple digits for each part. |
| userID | int(10) unsigned | User ID of the member of staff doing the excluding. |
| date | datetime | Datetime when the question was excluded. |
| reason | text | Currently unused |
See also: Question Excluding