ERD 작성 실습
테이블 (7)
Class (class)
- Class ID (class_id) — INT(11) — 기본 키 — NOT NULL
- Zip Code ID (zip_code_id) — INT(11) — 외래 키 → Zip Code.Zip Code ID — NOT NULL
- Year ID (year_id) — INT(11) — 외래 키 → Zip Code.Year ID — NOT NULL
- Class (class) — INT(10)
Coach (coach)
- Coach ID (coach_id) — INT(11) — 기본 키 — NOT NULL
- Last Name (last_name) — VARCHAR(255)
- First Name (first_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
- Email (email) — VARCHAR(100)
- Gender (gender) — CHAR(1)
- Birthday (birthday) — CHAR(8)
- Class ID (class_id) — INT(11) — 외래 키 → Class.Class ID — NOT NULL
- Zip Code ID (zip_code_id) — INT(11) — 외래 키 → Class.Zip Code ID — NOT NULL
- Year ID (year_id) — INT(11) — 외래 키 → Class.Year ID — NOT NULL
Consultant (consultant)
- Consultant ID (consultant_id) — INT(11) — 기본 키 — NOT NULL
- Last Name (last_name) — VARCHAR(255)
- First Name (first_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
- Email (email) — VARCHAR(100)
- Gender (gender) — CHAR(1)
- Birthday (birthday) — CHAR(8)
- Class ID (class_id) — INT(11) — 외래 키 → Class.Class ID — NOT NULL
- Zip Code ID (zip_code_id) — INT(11) — 외래 키 → Class.Zip Code ID — NOT NULL
- Year ID (year_id) — INT(11) — 외래 키 → Class.Year ID — NOT NULL
Curriculum (curriculum)
- Curriculum ID (curriculum_id) — INT(11) — 기본 키 — NOT NULL
- Class ID (class_id) — INT(11) — 외래 키 → Class.Class ID — NOT NULL
- Zip Code ID (zip_code_id) — INT(11) — 외래 키 → Class.Zip Code ID — NOT NULL
- Year ID (year_id) — INT(11) — 외래 키 → Class.Year ID — NOT NULL
- Field
Student (student)
- Student ID (student_id) — INT(11) — 기본 키 — NOT NULL
- Curriculum ID (curriculum_id) — INT(11) — 외래 키 → Curriculum.Curriculum ID — NOT NULL
- Class ID (class_id) — INT(11) — 외래 키 → Curriculum.Class ID — NOT NULL
- Zip Code ID (zip_code_id) — INT(11) — 외래 키 → Curriculum.Zip Code ID — NOT NULL
- Year ID (year_id) — INT(11) — 외래 키 → Curriculum.Year ID — NOT NULL
- Last Name (last_name) — VARCHAR(255)
- First Name (first_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
- Email (email) — VARCHAR(100)
- Gender (gender) — CHAR(1)
- Birthday (birthday) — CHAR(8)
- Major (major) — CHAR(1)
- Discharge (discharge) — CHAR(1)
Year (year)
- Year ID (year_id) — INT(11) — 기본 키 — NOT NULL
- Generation (generation) — INT(10)
Zip Code (zip_code)
- Zip Code ID (zip_code_id) — INT(11) — 기본 키 — NOT NULL
- Year ID (year_id) — INT(11) — 외래 키 → Year.Year ID — NOT NULL
- City (city) — VARCHAR(255)
- State (state) — VARCHAR(255)