textbox_marking

Purpose: Stores human assigned marks for textbox question type.
Joins: userspapers and questions tables.

FieldTypePurpose
idint(11)Primary Key – auto increment.
paperIDmediumint(8) unsignedID of the paper the question is on.
q_idint(11)ID of the question being marked.
answer_idint(11)Links to 'id' field of the relevant log table.
markerIDint(10) unsignedUser ID of the member of staff marking.
markfloatAwarded mark.
commentstextCurrently not used.
datedatetimeDatetime when the marking was done.
phasetinyint(4)1=first marking, 2=secondary marking.
logtypetinyint(4)Number of the log the answer comes from. i.e. 2 would be log2.
student_userIDint(10) unsignedUser ID of the student
remindersvarchar(255)Store the reminders that have been checked in marking.