self-project
Tables (4)
Class (class)
- Student id (student_id2) — VARCHAR(11) — Foreign key → Student.Student_id — NOT NULL
- Coach_id (coach_id) — VARCHAR(11) — Foreign key → Coach.Coach_id — NOT NULL
- Consultant_id (consultant_id) — VARCHAR(11) — Foreign key → Consultant.Consultant_id — NOT NULL
- Area (area) — VARCHAR(11)
- Class (class) — INT(1)
Coach (coach)
- Coach_id (coach_id) — VARCHAR(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(11)
- Task (task) — VARCHAR(11)
Consultant (consultant)
- Consultant_id (consultant_id) — VARCHAR(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(11)
- Task (task) — VARCHAR(11)
- Class (class) — INT(1)
Student (student)
- Student_id (student_id) — VARCHAR(11) — Primary key — NOT NULL
- Pass (pass) — VARCHAR(11)
- Name (name) — VARCHAR(11)
- Th (th) — INT(2)
- Major (major) — VARCHAR(5)
- Out (out) — VARCHAR(3)
- Curriculum (curriculum) — VARCHAR(3)