erd 실습~

테이블 (5)

교육과정 (curriculum)

  • curriculum_key — bigInt — 기본 키 — NOT NULL
  • curriculum

교육생 (Student)

  • Student_key (Key) — bigInt — 기본 키 — NOT NULL
  • cardinal _number
  • major — boolean
  • exit — boolean
  • class_key — bigInt — 외래 키 → 반.class_key — NOT NULL
  • cunsultunt_key — bigInt — 외래 키 → 반.cunsultunt_key — NOT NULL

반 (class)

  • class_key — bigInt — 기본 키 — NOT NULL
  • cunsultunt_key — bigInt — 외래 키 → 컨설턴트.cunsultunt_key — NOT NULL
  • region
  • class_num

컨설턴트 (cunsultunt)

  • cunsultunt_key — bigInt — 기본 키 — NOT NULL
  • responsibilities

코치 (coach)

  • coach_key — bigInt — 기본 키 — NOT NULL
  • responsibilities
  • class_key — bigInt — 외래 키 → 반.class_key — NOT NULL
  • cunsultunt_key — bigInt — 외래 키 → 반.cunsultunt_key — NOT NULL