practice
Tables (4)
Class (class)
- Class ID (class_id) — INT — Primary key — NOT NULL
- Location (location) — ENUM('서울', '대전', '구미', '광주', '부울경'
- Class Number (class_number) — INT
Coach (coach)
- Coach ID (coach_id) — INT — Primary key — NOT NULL
- Class ID (class_id) — INT — Foreign key → Class.Class ID — NOT NULL
- Name (name) — VARCHAR(15)
- Task (task) — VARCHAR(100)
Consultant (consultant)
- Consultant ID (consultant_id) — INT — Primary key — NOT NULL
- Class ID (class_id) — INT — Foreign key → Class.Class ID — NOT NULL
- Task (task) — VARCHAR(100)
Student (student)
- Student_ID (student_id) — INT — Primary key — NOT NULL
- Class ID (class_id) — INT — Foreign key → Class.Class ID — NOT NULL
- Name (name) — VARCHAR(15)
- Major (is_major) — TINYINT(1)
- Graduated (is_graduated) — TINYINT(1)
- Generation (generation) — INT
- Course (course) — ENUM('공통', '특화', '자율')