courses

Purpose: Holds course information (BA, MSC, etc)
Joins: schools table.

FieldTypePurpose
idint(11)Primary Key – auto increment.
namevarchar(255)The code of the course (e.g. A124))
descriptionvarchar(255)The title of the course (e.g. Immunology and Allergy MSc)
deleteddatetimeWhen the course was deleted - NULL means the course is still active.
schoolidint(11)The ID of the school the course belongs to.