student
Tables (6)
Batch (기수)
- 기수 (Batch) — Primary key — NOT NULL
Class (반)
- 반ID (ClassID) — INT — Primary key — NOT NULL
- 교육과정ID (CourseID) — INT — Foreign key → Course.교육과정ID — NOT NULL
- 지역 (Region) — varchar(50) — NOT NULL
- 반 (ClassNumber) — INT — NOT NULL
Coach (코치)
- 코치 ID (CoachID) — INT — Primary key — NOT NULL
- 반ID (ClassID) — INT — Foreign key → Class.반ID — NOT NULL
- 교육과정ID (CourseID) — INT — Foreign key → Class.교육과정ID — NOT NULL
- 이름 (Name) — varchar(100)
- 담당업무 (Duty) — varchar(100)
Consultant (컨설턴트)
- 컨설턴트ID (ConsultantID) — INT — Primary key — NOT NULL
- 반ID (ClassID) — INT — Foreign key → Class.반ID — NOT NULL
- 교육과정ID (CourseID) — INT — Foreign key → Class.교육과정ID — NOT NULL
- 이름 (Name) — varchar(100)
- 담당업무 (Duty) — varchar(100)
Course (교육 과정)
- 교육과정ID (CourseID) — INT — Primary key — NOT NULL
- 과정유형 (CourseType) — varchar(50)
Student (교육생)
- 교육생 ID (StudentID) — INT — Primary key — NOT NULL
- 기수 (Batch) — Foreign key → Batch.기수 — NOT NULL
- 반ID (ClassID) — INT — Foreign key → Class.반ID — NOT NULL
- 교육과정ID (CourseID) — INT — Foreign key → Class.교육과정ID — NOT NULL
- 교육생 이름 (Name) — varchar(100)
- 전공 비전공 (Major) — Boolean — NOT NULL
- 퇴소 여부 (Graduated) — Boolean — NOT NULL