01
Tables (5)
Class (class)
- Class ID (class_id) — Primary key — NOT NULL
- Region (region)
- Class Number (class_num)
Coach (coach)
- Coach ID (coach_id) — Primary key — NOT NULL
- Class ID (class_id) — Foreign key → Class.Class ID — NOT NULL
Consultant (consultant)
- Consultant ID (consultant_id) — Primary key — NOT NULL
- Class ID (class_id) — Foreign key → Class.Class ID — NOT NULL
- Field
Course (course)
- Course Name (course_name) — Primary key — NOT NULL
- Class ID (class_id) — Foreign key → Class.Class ID — NOT NULL
Student (student)
- ID (id) — Primary key — NOT NULL
- Year (year)
- Major (major) — Bool
- Discharge (discharge)
- Class ID (class_id) — Foreign key → Class.Class ID — NOT NULL
- Name (name)