daily_1_엔티티추출

테이블 (4)

Class (class)

  • Class Id (class_id) — INT(11) — 기본 키 — NOT NULL
  • Consultant Id (consultant_id) — INT(11) — 외래 키 → Consultant.Consultant Id — NOT NULL
  • Coach Id (coach_id) — INT(11) — 외래 키 → Coach.Coach Id — NOT NULL
  • Domain (domain) — Varchar(10)
  • Class Number (number) — INT(11)

Coach (coach)

  • Coach Id (coach_id) — INT(11) — 기본 키 — NOT NULL
  • Name (name) — Varchar(10)

Consultant (consultant)

  • Consultant Id (consultant_id) — INT(11) — 기본 키 — NOT NULL
  • Name (name) — Varchar(10)

Member (member)

  • Member Id (member_id) — INT(11) — 기본 키 — NOT NULL
  • Class Id (class_id) — INT(11) — 외래 키 → Class.Class Id — NOT NULL
  • Cardinal Number (cardinal_number) — INT(11)
  • Major (major) — BOOLEAN
  • Discharge (discharge) — BOOLEAN