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