SSAFY
Tables (8)
Classes
- ClassID — INT — Primary key — NOT NULL
- Region — ENUM('서울', '대전', '구미', '광주', '부울경') — NOT NULL
- ClassNumber — INT — NOT NULL
- ConsultantID — INT — Foreign key → Consultants.ConsultantID — NOT NULL
- CoachID — INT — Foreign key → Coaches.CoachID
Coaches
- CoachID — INT — Primary key — NOT NULL
- Name — VARCHAR(100) — NOT NULL
- Duty — VARCHAR(255) — NOT NULL
Consultants
- ConsultantID — INT — Primary key — NOT NULL
- Name — VARCHAR(100) — NOT NULL
- Duty — VARCHAR(255) — NOT NULL
Courses
- CourseID — INT — Primary key — NOT NULL
- CourseType — ENUM('공통', '특화', '자율') — NOT NULL
Managers
- ManagerID — INT — Primary key — NOT NULL
- Name — VARCHAR(100) — NOT NULL
- Phone — VARCHAR(15) — NOT NULL
- Region — VARCHAR(100)
- Class — VARCHAR(100)
- Team — VARCHAR(100)
ProjectParticipants
- ProjectID — INT — Foreign key → Projects.ProjectID — NOT NULL
- StudentID — INT — Foreign key → Students.StudentID — NOT NULL
Projects
- ProjectID — INT — Primary key — NOT NULL
- CourseID — INT — Foreign key → Courses.CourseID — NOT NULL
- Title — VARCHAR(255) — NOT NULL
Students
- StudentID — INT — Primary key — NOT NULL
- Name — VARCHAR(100) — NOT NULL
- Phone — VARCHAR(15) — NOT NULL
- CampusRegion — VARCHAR(100) — NOT NULL
- ClassID — INT — Foreign key → Classes.ClassID
- Term — INT — NOT NULL
- Major — ENUM('전공자', '비전공자') — NOT NULL
- Dropout — BOOLEAN — NOT NULL
- ManagerID — INT — Foreign key → Managers.ManagerID