pratice
Tables (6)
Coach (coach)
- Coach Num (coach_num) — INT(10) — Primary key — NOT NULL
- Class Num (class_num) — INT(10) — Foreign key → Class.Class Num — NOT NULL
- Name (name) — VARCHAR(10)
- Duty (duty) — VARCHAR(10)
Curriculum (curriculum)
- Curriculum Num (curriculum_num) — INT(10) — Primary key — NOT NULL
- Name (name) — VARCHAR(10) — NOT NULL
Class (class)
- Class Num (class_num) — INT(10) — Primary key — NOT NULL
- Location (location) — VARCHAR(10)
- Class (class) — INT(10)
Consultant (consultant)
- Consultant Num (consultant_num) — INT(10) — Primary key — NOT NULL
- Class Num (class_num) — INT(10) — Foreign key → Class.Class Num — NOT NULL
- Name (name) — VARCHAR(10)
- Duty (duty) — VARCHAR(10)
Student (student)
- Student Num (student_num) — INT(10) — Primary key — NOT NULL
- Curriculum Num (curriculum_num) — INT(10) — Foreign key → Curriculum.Curriculum Num — NOT NULL
- Class Num (class_num) — INT(10) — Foreign key → Class.Class Num — NOT NULL
- Generation (generation) — INT(10)
- Major (major) — VARCHAR(10)
- Expulsion (expulsion) — BOOLEAN
Untitled
- Coach Num (coach_num) — INT(10) — Foreign key → Coach.Coach Num — NOT NULL
- Class Num (class_num) — INT(10) — Foreign key → Coach.Class Num — NOT NULL