Purpose: Holds a list of schools by faculty. One of the main places this information is used is 'All Modules' link from the homepage.
Joins: faculty table.
| Field | Type | Purpose |
|---|---|---|
| id | int(11) | Primary Key – auto increment. |
| school | char(255) | Name of the school |
| facultyID | int(11) | ID of the Faculty the school is based in. |
| deleted | datetime | date deleted |