SSAFY
Tables (7)
ClassCoach
- ClassCoachID — INT — Primary key
- ClassID — INT — NOT NULL
- CoachID — INT
- ConsultantID — INT — Foreign key → Consultant.ConsultantID
ClassConsultant
- ClassConsultantID — INT — Primary key
- ClassID — INT — NOT NULL
- ConsultantID — INT — NOT NULL
Classes
- ClassID — INT — Primary key
- Region — ENUM('서울', '대전', '구미', '광주', '부울경') — NOT NULL
- ClassNumber — INT — NOT NULL
Coach
- CoachID — INT — Primary key
- Name — VARCHAR(100) — NOT NULL
- Duty — VARCHAR(255) — NOT NULL
- TraineeID — INT — Foreign key → Trainee.TraineeID
Consultant
- ConsultantID — INT — Primary key
- Name — VARCHAR(100) — NOT NULL
- Duty — VARCHAR(255) — NOT NULL
Course
- CourseID — INT — Primary key
- ClassCoachID — INT — Foreign key → ClassCoach.ClassCoachID
- CourseType — ENUM('공통', '특화', '자율') — NOT NULL
Trainee
- TraineeID — INT — Primary key
- Name — VARCHAR(100) — NOT NULL
- Batch — INT — NOT NULL
- MajorStatus — ENUM('전공자', '비전공자') — NOT NULL
- ExitStatus — ENUM('재학', '퇴소') — NOT NULL
- ClassID (ClassID2) — INT — Foreign key → Classes.ClassID