textbox_marking
Purpose: Stores human assigned marks for textbox question type.
Joins: users, papers and questions tables.
Field | Type | Purpose |
---|---|---|
id | int(11) | Primary Key – auto increment. |
paperID | mediumint(8) unsigned | ID of the paper the question is on. |
q_id | int(11) | ID of the question being marked. |
answer_id | int(11) | Links to 'id' field of the relevant log table. |
markerID | int(10) unsigned | User ID of the member of staff marking. |
mark | float | Awarded mark. |
comments | text | Currently not used. |
date | datetime | Datetime when the marking was done. |
phase | tinyint(4) | 1=first marking, 2=secondary marking. |
logtype | tinyint(4) | Number of the log the answer comes from. i.e. 2 would be log2. |
student_userID | int(10) unsigned | User ID of the student |
reminders | varchar(255) | Store the reminders that have been checked in marking. |