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

FieldTypePurpose
note_idint(11)Primary Key – auto increment.
userIDint(10) unsignedID of the student who the note pertains to
notetextThe text of the note
note_datedatetimeDatetime when the note was created
paper_idmediumint(8) unsignedThe paper ID that the note pertains to
note_authorIDint(10) unsignedThe ID of the member of staff who created the note