student_notes
- Neill Magill
Owned by Neill Magill
Oct 25, 2022
1 min read
Loading data...
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 |