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