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 | |
---|---|---|---|
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. |