courses

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

Field	Type	Purpose
id	int(11)	Primary Key – auto increment.
name	varchar(255)	The code of the course (e.g. A124))
description	varchar(255)	The title of the course (e.g. Immunology and Allergy MSc)
deleted	datetime	When the course was deleted - NULL means the course is still active.
schoolid	int(11)	The ID of the school the course belongs to.

ExamSys