ERD 그리기
테이블 (6)
Class (class)
- Region (region) — VARCHAR(100) — 기본 키 — NOT NULL
- Number (number) — INT — 기본 키 — NOT NULL
- CoachName (coach_name) — VARCHAR(50) — 외래 키 → Coach.CoachName — NOT NULL
- ConsultantName (consultant_name) — VARCHAR(50) — 외래 키 → Consultant.ConsultantName — NOT NULL
Coach
- CoachName (coach_name) — VARCHAR(50) — 기본 키 — NOT NULL
- JobName (job_name) — VARCHAR(100) — 외래 키 → Job.JobName — NOT NULL
Consultant (consultant)
- ConsultantName (consultant_name) — VARCHAR(50) — 기본 키 — NOT NULL
- JobName (job_name) — VARCHAR(100) — 외래 키 → Job.JobName — NOT NULL
Curriculum (curriculum)
- Course (course) — VARCHAR(10) — 기본 키 — NOT NULL
Job (job)
- JobName (job_name) — VARCHAR(100) — 기본 키 — NOT NULL
Student (student)
- Cardinal (cardinal) — INT — 기본 키 — NOT NULL
- Major (major) — VARCHAR(100)
- Class (class) — VARCHAR(50)
- Retirement (retirement) — VARCHAR(10)
- Region (region) — VARCHAR(100) — 외래 키 → Class.Region — NOT NULL
- Number (number) — INT — 외래 키 → Class.Number — NOT NULL