day1227
Tables (4)
Class (class)
- Class_Num (class_num) — INT(2) — Primary key — NOT NULL
- Coach_ID (coach_ID) — INT(10) — Foreign key → Coach.Coach_ID — NOT NULL
- Area (area) — VARCHAR(10)
- Curriculum (curriculum) — VARCHAR(10)
Coach (coach)
- Coach_ID (coach_ID) — INT(10) — Primary key — NOT NULL
- Task (task) — VARCHAR(30)
Consultant (consultant)
- Consultant_ID (consultant_ID) — INT(10) — Primary key — NOT NULL
- Class_Num (class_num) — INT(2) — Foreign key → Class.Class_Num — NOT NULL
- Coach_ID (coach_ID) — INT(10) — Foreign key → Class.Coach_ID — NOT NULL
- Task (task) — VARCHAR(30)
Student (student)
- Student_ID (student_ID) — INT(10) — Primary key — NOT NULL
- Class_Num (class_num) — INT(2) — Foreign key → Class.Class_Num — NOT NULL
- Coach_ID (coach_ID) — INT(10) — Foreign key → Class.Coach_ID — NOT NULL
- Cardinal (cardinal) — INT(2)
- Discharge (discharge) — BOOLEAN