DB/ERD 실습
테이블 (4)
Class (class)
- Class Id (class_id) — INT — 기본 키 — NOT NULL
- Consultant Id (consultant_id) — INT — 외래 키 → Consultant.Consultant Id — NOT NULL
- Coach Id (coach_id) — INT — 외래 키 → Coach.Coach Id — NOT NULL
- Region (region) — VARCHAR(255)
- Class Number (class_number) — INT
- Course (course) — CHAR(2)
Coach (coach)
- Coach Id (coach_id) — INT — 기본 키 — NOT NULL
- Task (task) — VARCHAR(255)
Consultant (consultant)
- Consultant Id (consultant_id) — INT — 기본 키 — NOT NULL
- Task (task) — VARCHAR(255)
Student (student)
- Student Id (student_id) — INT — 기본 키 — NOT NULL
- Consultant Id (consultant_id) — INT — 외래 키 → Class.Consultant Id — NOT NULL
- Coach Id (coach_id) — INT — 외래 키 → Class.Coach Id — NOT NULL
- Key — 외래 키 → Class.Class Id — NOT NULL
- Major (major) — Bool
- Retire (retire) — Bool
- Generation (generation) — CHAR(2)