sample1
Tables (4)
Class (class)
- Class_Id (class_id) — INT(11) — Primary key — NOT NULL
- Consultant_Id (consultant_id) — INT(11) — Foreign key → Consultant.Consultant_Id — NOT NULL
- Coach_Id (coach_id) — INT(11) — Foreign key → Coach.Coach_Id — NOT NULL
- Area (area) — VARCHAR(15)
- Class (class) — VARCHAR(15)
Coach (coach)
- Coach_Id (coach_id) — INT(11) — Primary key — NOT NULL
- Task (task) — VARCHAR(15)
Consultant (consultant)
- Consultant_Id (consultant_id) — INT(11) — Primary key — NOT NULL
- Task (task) — VARCHAR(15)
Students (students)
- Student_Id (student_id) — INT(11) — Primary key — NOT NULL
- Class_Id (class_id) — INT(11) — Foreign key → Class.Class_Id — NOT NULL
- Stage (stage) — INT(2)
- On_Field (on_field) — Boolean
- Curriculum (curriculum) — CHAR(2)
- Discharged (discharged) — Boolean