courses
- Neill Magill
Owned by Neill Magill
Oct 25, 2022
1 min read
Loading data...
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. |