ERD 과제
테이블 (5)
Class (class)
- Class Id (class_id) — INT(11) — 기본 키 — NOT NULL
- Education Id (education_id) — CHAR(10) — 외래 키 → 교육 과정.Education Id — NOT NULL
- Area (area) — Char(10)
- Class Number (class_number) — Char(10)
Coach (coach)
- Coach Id (coach_id) — INT(11) — 기본 키 — NOT NULL
- 업무 — Char(200)
- Class Id (class_id) — INT(11) — 외래 키 → Class.Class Id — NOT NULL
- Education Id (education_id) — CHAR(10) — 외래 키 → Class.Education Id — NOT NULL
Consultent (consultent)
- Consultent Id (consultent_id) — INT(11) — 기본 키 — NOT NULL
- Class Id (class_id) — INT(11) — 외래 키 → Class.Class Id — NOT NULL
- Education Id (education_id) — CHAR(10) — 외래 키 → Class.Education Id — NOT NULL
- 업무 — Char(200)
Students (students)
- Student Id (student_id) — INT(11) — 기본 키 — NOT NULL
- Class Id (class_id) — INT(11) — 외래 키 → Class.Class Id — NOT NULL
- Education Id (education_id) — CHAR(10) — 외래 키 → Class.Education Id — NOT NULL
- 기수 — Char(10)
- 전공 — Char(1)
- 퇴소 — Char(1)
교육 과정
- Education Id (education_id) — CHAR(10) — 기본 키 — NOT NULL
- Education Name (education_name) — CHAR(10)