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.

FieldTypePurpose
idint(11)Primary Key – auto increment.
schoolchar(255)Name of the school
facultyIDint(11)ID of the Faculty the school is based in.
deleteddatetimedate deleted