hw3
Tables (4)
Class (class)
- ClassId (class_id) — int(2) — Primary key — NOT NULL
- ConsultantId (consultant_id) — INT(8) — Foreign key → Consultant.ConsultantId — NOT NULL
- CoachId (coach_id) — INT(8) — Foreign key → Coach.CoachId — NOT NULL
- StudentId (student_id) — INT(8) — Foreign key → Student.StudentId — NOT NULL
- Region (region) — VARCHAR(255)
- ClassNum (class_num) — INT(1)
- Course (course) — VARCHAR(255)
Coach (coach)
- CoachId (coach_id) — INT(8) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
Consultant (consultant)
- ConsultantId (consultant_id) — INT(8) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
Student (student)
- StudentId (student_id) — INT(8) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Generation (generation) — INT(4)
- Major (major) — Boolean
- Finish (finish) — Boolean