DB설계
테이블 (5)
Class (class)
- Class ID (class_id) — INT — 기본 키 — NOT NULL
- Location (location) — ENUM('서울', '대전', '구미', '광주', '부울경')
- Class Number (class_number) — INT
Coach (coach)
- Coach ID (coach_id) — INT — 기본 키 — NOT NULL
- Class ID (class_id) — INT — 외래 키 → Class.Class ID — NOT NULL
- Name (name) — VARCHAR(50)
- Duties (duties) — VARCHAR(100)
Consultant (consultant)
- Consultant ID (consultant_id) — INT — 기본 키 — NOT NULL
- Class ID (class_id) — INT — 외래 키 → Class.Class ID — NOT NULL
- Name (name) — VARCHAR(50)
- Duties (duties) — VARCHAR(100)
Course (course)
- Course ID (course_id) — INT — 기본 키 — NOT NULL
- Type (type) — ENUM('공통', '특화','자율')
- Field
Student (student)
- Student ID (student_id) — INT — 기본 키 — NOT NULL
- Class ID (class_id2) — INT — 외래 키 → Class.Class ID — NOT NULL
- Course ID (course_id) — INT — 외래 키 → Course.Course ID — NOT NULL
- Name (name) — VARCHAR(50)
- Major (is_major) — BOOLEAN
- Graduated (is_graduated) — BOOLEAN
- Term (term) — INT