paper_notes

Purpose: Records notes pertaining to a whole paper. Most common uses would be to make a note about a question that had incorrect information or a fire alarm.
Note: See student_notes table for notes pertaining to individual students.
Joins: properties table.

Field	Type	Purpose

Field	Type	Purpose
note_id	int(11)	Primary Key – auto increment.
note	text	The message of the note.
note_date	datetime	Datetime when the note was made.
paper_id	mediumint(8) unsigned	The ID of the paper that the note pertains to.
note_authorID	mediumint(10) unsigned	The ID of the user (staff) making the note.
note_workstation	varchar(100)	The IP address of the workstation on which the note was made. This is used when an exam in spit over multiple labs. Invigilators in each lab can all make their own notes on the same paper from each location without affecting each other.