DB설계, ERD 작성 실습
테이블 (6)
Class (class)
- Class Id (class_id) — VARCHAR(5) — 기본 키 — NOT NULL
- Region (region) — VARCHAR(3) — NOT NULL
- Room (room) — INT(2) — NOT NULL
- 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)
- Class Id (class_id) — VARCHAR(5)
Consultant (consultant)
- Consultant Id (consultant_id) — INT(6) — 기본 키 — NOT NULL
- Work (work) — VARCHAR(255)
- Class Id (class_id) — VARCHAR(5)
Major (major)
- Major Name (major_name) — VARCHAR(10) — 기본 키
- Yes Or No (yes_or_no) — BOOLEAN
Student (student)
- Student Id (student_id) — INT(6) — 기본 키 — NOT NULL
- Grade (grade) — INT(3) — NOT NULL
- Exit (exit) — BOOLEAN
- Name (name) — VARCHAR(10)
- Age (age) — INT(3)
- Track Name (track_name) — VARCHAR(10) — 외래 키 → Track.Track Name
- Class Id (class_id) — VARCHAR(5) — 외래 키 → Class.Class Id — NOT NULL
- Major Name (major_name) — VARCHAR(10) — 외래 키 → Major.Major Name
Track (track)
- Track Name (track_name) — VARCHAR(10) — 기본 키