DB/ERD 실습

테이블 (4)

Class (class)

  • Class Id (class_id) — INT — 기본 키 — NOT NULL
  • Consultant Id (consultant_id) — INT — 외래 키 → Consultant.Consultant Id — NOT NULL
  • Coach Id (coach_id) — INT — 외래 키 → Coach.Coach Id — NOT NULL
  • Region (region) — VARCHAR(255)
  • Class Number (class_number) — INT
  • Course (course) — CHAR(2)

Coach (coach)

  • Coach Id (coach_id) — INT — 기본 키 — NOT NULL
  • Task (task) — VARCHAR(255)

Consultant (consultant)

  • Consultant Id (consultant_id) — INT — 기본 키 — NOT NULL
  • Task (task) — VARCHAR(255)

Student (student)

  • Student Id (student_id) — INT — 기본 키 — NOT NULL
  • Consultant Id (consultant_id) — INT — 외래 키 → Class.Consultant Id — NOT NULL
  • Coach Id (coach_id) — INT — 외래 키 → Class.Coach Id — NOT NULL
  • Key — 외래 키 → Class.Class Id — NOT NULL
  • Major (major) — Bool
  • Retire (retire) — Bool
  • Generation (generation) — CHAR(2)