ERD 작성 실습

테이블 (5)

Class (Untitled)

  • Class Id (class_id) — int(10) — 기본 키 — NOT NULL
  • Consultant Id (consultant_id) — int(10) — 외래 키 → Consultant.Consultant Id — NOT NULL
  • Coach Id (coach_id) — int(10) — 외래 키 → Coach.Coach Id — NOT NULL
  • Class Number (class_number) — int(11)
  • Location (location) — varchar(255)
  • Track (track) — varchar(255)

Coach (coach)

  • Coach Id (coach_id) — int(10) — 기본 키 — NOT NULL
  • Task (task) — varchar(255)

Consultant (consultant)

  • Consultant Id (consultant_id) — int(10) — 기본 키 — NOT NULL
  • Task (task) — varchar(255)

Trainee (trainee)

  • Trainee Id (trainee_id) — int(10) — 기본 키 — NOT NULL
  • Cardinal Number (cardinal_number) — int(11)
  • Major (major) — int(1)
  • Exit (exit) — int(1)

Trainee Class (trainee_class)

  • Trainee Class Id (trainee_class_id) — int(10) — 기본 키 — NOT NULL
  • Trainee Id (trainee_id) — int(10) — 외래 키 → Trainee.Trainee Id — NOT NULL
  • Class Id (class_id2) — int(10) — 외래 키 → Class.Class Id — NOT NULL
  • Consultant Id (consultant_id) — int(10) — 외래 키 → Class.Consultant Id — NOT NULL
  • Coach Id (coach_id) — int(10) — 외래 키 → Class.Coach Id — NOT NULL