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)