DB설계 및 ERD 작성 실습
테이블 (6)
Class (class)
- Class (class) — VARCHAR(5) — 기본 키 — NOT NULL
- Major (major) — VARCHAR(4)
- Track (track) — VARCHAR(2)
- Coach Id (coach_id) — INT(6) — 외래 키 → Coach.Coach Id
- Consultant Id (consultant_id) — INT(6) — 외래 키 → Consultant.Consultant Id — NOT NULL
Coach (coach)
- Coach Id (coach_id) — INT(6) — 기본 키
- Work (work) — VARCHAR(255)
Consultant (consultant)
- Consultant Id (consultant_id) — INT(6) — 기본 키 — NOT NULL
- Work (work) — VARCHAR(255)
Major (major)
- Major (major) — VARCHAR(4) — 기본 키
- Yes (yes) — BOOLEAN
Student (student)
- Student Id (student_id) — INT(6) — 기본 키
- Grade (grade) — INT(2) — NOT NULL
- Exit (exit) — BOOLEAN — NOT NULL
- Name (name) — VARCHAR(20) — NOT NULL
- Age (age) — INT(2) — NOT NULL
- Track (track) — VARCHAR(2)
- Class (class) — VARCHAR(5) — 외래 키 → Class.Class — NOT NULL
- Track (track2) — VARCHAR(2) — 외래 키 → Track.Track
- Major (major) — VARCHAR(4) — 외래 키 → Major.Major
Track (track)
- Track (track) — VARCHAR(2) — 기본 키