student_notes

Purpose: Used for creating notes for specific students/papers to records such things as computer crashes or feeling ill, etc.
Joins: users table.
Main Scripts: /reports/class_totals.php and /users/user_details.php

Field	Type	Purpose
note_id	int(11)	Primary Key – auto increment.
userID	int(10) unsigned	ID of the student who the note pertains to
note	text	The text of the note
note_date	datetime	Datetime when the note was created
paper_id	mediumint(8) unsigned	The paper ID that the note pertains to
note_authorID	int(10) unsigned	The ID of the member of staff who created the note