계절학기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)