계절학기ERD
sample
테이블 (5)
Class (class)
- Class (class_id) — INT(2) — 기본 키 — NOT NULL
- City (city) — CHAR(2)
- ClassNumber (class_number) — INT(1)
- Coach (coach_id) — INT(6) — 외래 키 → Coach.Coach — NOT NULL
- Consultant (consultant_id) — INT(6) — 외래 키 → Consultant.Consultant — NOT NULL
Coach (coach)
- Coach (coach_id) — INT(6) — 기본 키 — NOT NULL
- Work (work) — VARCHAR(20)
Consultant (consulant)
- Consultant (consultant_id) — INT(6) — 기본 키 — NOT NULL
- Work (work) — VARCHAR(20)
Students (students)
- Student id (student_id) — INT(6) — 기본 키 — NOT NULL
- Oder (order) — INT(1)
- Major (major) — VARCHAR(20)
- Status (status) — VARCHAR(3)
- Class (class_id) — INT(2) — 외래 키 → Class.Class — NOT NULL
Untitled (Education)
- Key (Education) — INT(6) — 기본 키 — NOT NULL
- Field (공통) — VARCHAR(20)
- Field (특화) — VARCHAR(20)
- Field (자율) — VARCHAR(20)