edu_erd
Tables (5)
Class (class)
- Class Id (class_id) — INT(11) — Primary key — NOT NULL
- Consultant Id (cons_id) — INT(11) — Foreign key → Consultant.Consultant Id — NOT NULL
- Coach Id (coach_id) — INT(11) — Foreign key → Coach.Coach Id — NOT NULL
- Region (region) — VARCHAR(255)
- Number (number) — INT(1)
Coach (coach)
- Coach Id (coach_id) — INT(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Job (job) — VARCHAR(255)
Consultant (consultant)
- Consultant Id (cons_id) — INT(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Job (job) — VARCHAR(255)
Student (student)
- Student Id (stu_id) — INT(11) — Primary key — NOT NULL
- Class Id (class_id) — INT(11) — Foreign key → Class.Class Id — NOT NULL
- Consultant Id (cons_id) — INT(11) — Foreign key → Class.Consultant Id — NOT NULL
- Coach Id (coach_id) — INT(11) — Foreign key → Class.Coach Id — NOT NULL
- Period (period) — INT(10)
- Major (major) — TINYINT
- Retirement (retire) — TINYINT
Track (track)
- Track Name (track_name) — VARCHAR(10) — Primary key — NOT NULL