ERD 작성 실습
테이블 (5)
Class (Untitled)
- Class Id (class_id) — int(10) — 기본 키 — NOT NULL
- Consultant Id (consultant_id) — int(10) — 외래 키 → Consultant.Consultant Id — NOT NULL
- Coach Id (coach_id) — int(10) — 외래 키 → Coach.Coach Id — NOT NULL
- Class Number (class_number) — int(11)
- Location (location) — varchar(255)
- Track (track) — varchar(255)
Coach (coach)
- Coach Id (coach_id) — int(10) — 기본 키 — NOT NULL
- Task (task) — varchar(255)
Consultant (consultant)
- Consultant Id (consultant_id) — int(10) — 기본 키 — NOT NULL
- Task (task) — varchar(255)
Trainee (trainee)
- Trainee Id (trainee_id) — int(10) — 기본 키 — NOT NULL
- Cardinal Number (cardinal_number) — int(11)
- Major (major) — int(1)
- Exit (exit) — int(1)
Trainee Class (trainee_class)
- Trainee Class Id (trainee_class_id) — int(10) — 기본 키 — NOT NULL
- Trainee Id (trainee_id) — int(10) — 외래 키 → Trainee.Trainee Id — NOT NULL
- Class Id (class_id2) — int(10) — 외래 키 → Class.Class Id — NOT NULL
- Consultant Id (consultant_id) — int(10) — 외래 키 → Class.Consultant Id — NOT NULL
- Coach Id (coach_id) — int(10) — 외래 키 → Class.Coach Id — NOT NULL