SSAFY- DB 설계, ERD 작성 실습

테이블 (4)

Classes (class)

  • Class Id (class_id) — INT — 기본 키 — NOT NULL
  • Area (area) — Enum
  • Class (class) — Enum
  • Curriculum (curriculum) — Enum

Coaches (coaches)

  • Coach Id (coach_id) — INT — 기본 키 — NOT NULL
  • Class Id (class_id2) — INT — 외래 키 → Classes.Class Id — NOT NULL
  • Class Id (class_id) — INT
  • Work (work) — Work

Consultants (consultants)

  • Consultants Id (consultants_id) — INT — 기본 키 — NOT NULL
  • Class Id (class_id2) — INT — 외래 키 → Classes.Class Id — NOT NULL
  • Class Id (class_id) — INT
  • Work (work) — Work

Student (students)

  • Student Id (student_id) — INT(7) — 기본 키 — NOT NULL
  • Class Id (class_id2) — INT — 외래 키 → Classes.Class Id — NOT NULL
  • Cardinal Number (cardinal_number) — INT
  • Major (major) — boolean
  • Retire (retire) — boolean
  • Class Id (class_id) — INT