DB 설계 및 ERD 실습
테이블 (6)
Class (class)
- Class ID (class_id) — INT(11) — 기본 키 — NOT NULL
- Class Number (class_number) — INT(50)
- Consultant ID (consultant_id) — INT(11) — 외래 키 → Consultant.Consultant ID — NOT NULL
- Coach ID (coach_id) — INT(11) — 외래 키 → Coach.Coach ID — NOT NULL
- Region ID (region_id) — INT(11) — 외래 키 → Region.Region ID — NOT NULL
- Course ID (course_id) — INT(11) — 외래 키 → Course.Course ID — NOT NULL
Coach (coach)
- Coach ID (coach_id) — INT(11) — 기본 키 — NOT NULL
- Task (task) — VARCHAR(255)
Consultant (consultant)
- Consultant ID (consultant_id) — INT(11) — 기본 키 — NOT NULL
- Task (task) — VARCHAR(255)
Course (course)
- Course ID (course_id) — INT(11) — 기본 키 — NOT NULL
- Course Name (course_name) — VARCHAR(255)
Region (region)
- Region ID (region_id) — INT(11) — 기본 키 — NOT NULL
- Region Name (region_name) — VARCHAR(50)
Student (student)
- Student ID (student_id) — INT(11) — 기본 키 — NOT NULL
- Generation (generation) — VARCHAR(50)
- Major (major) — BOOLEAN
- Withdrawal (withdrawal) — BOOLEAN
- Class ID (class_id) — INT(11) — 외래 키 → Class.Class ID — NOT NULL