SSAFY
Tables (3)
Coaches (coaches)
- Coach_Id (coach_id) — Auto — Primary key — NOT NULL
- Name (name) — Varchar(30)
- Region (region) — Char(2)
- Class (class) — Varchar(2)
- Job (job) — Varchar(20)
Consultants (consultants)
- Consultant_Id (consultant_id) — Auto — Primary key — NOT NULL
- Name (name) — Varchar(30)
- Region (region) — Char(2)
- Class (class) — Varchar(2)
- Job (job) — Varchar(20)
Students (students)
- Student_Id (student_id) — Auto — Primary key — NOT NULL
- Name (name) — Varchar(30)
- Year (year) — Varchar(2)
- Major (major) — Char(1)
- Region (region) — Char(2)
- Class (class) — Varchar(2)
- Out (out) — Char(1)
- Process (process) — Char(2)
- Consultant_Id (consultant_id) — Auto — Foreign key → Consultants.Consultant_Id — NOT NULL
- Coach_Id (coach_id) — Auto — Foreign key → Coaches.Coach_Id — NOT NULL