erd
Tables (5)
Class
- Key — int — Primary key — NOT NULL
- Field (location) — String
- Field2 (class_id) — int
- Key (course_type) — String — Foreign key → Consultant.Key — NOT NULL
- Key (consultant_id) — int — Foreign key → Coach.Key — NOT NULL
- Key (coach_id) — int — Foreign key → Course.Key — NOT NULL
Coach
- Key — int — Primary key — NOT NULL
- Field (coach_id) — int
- Key (class_id) — int — Foreign key → Class.Key — NOT NULL
Consultant
- Key — int — Primary key — NOT NULL
- Field (consultant_id) — int
Course
- Key — int — Primary key — NOT NULL
- Field (course_type) — String
Student
- Key — int — Primary key — NOT NULL
- Field (name) — String
- Field2 (cohort) — int
- Field3 (is_major) — Boolean
- Field4 (is_discharge) — Boolean
- Key (class_id) — int — Foreign key → Class.Key — NOT NULL