9기_서울5반_주창훈_ERD

테이블 (5)

각반

  • Class Id (class_id) — int — 기본 키 — NOT NULL
  • Consultant Id (consultant_id) — int — 외래 키 → 컨설턴트.Consultant Id — NOT NULL
  • Coach Id (coach_id) — int — 외래 키 → 코치.Coach Id — NOT NULL
  • Region (region) — varchar
  • Class Number (class_number) — int

교육과정

  • Course Id (course_id) — int — 기본 키 — NOT NULL
  • Course Type (course_type) — varchar
  • Field

교육생

  • Student Id (student_id) — int — 기본 키 — NOT NULL
  • Class Id (class_id) — int — 외래 키 → 각반.Class Id — NOT NULL
  • Consultant Id (consultant_id) — int — 외래 키 → 각반.Consultant Id — NOT NULL
  • Coach Id (coach_id) — int — 외래 키 → 각반.Coach Id — NOT NULL
  • Course Id (course_id) — int — 외래 키 → 교육과정.Course Id — NOT NULL
  • Batch (batch) — int
  • Major (major) — tinyint
  • Withdrawal (withdrawal) — tinyint

컨설턴트

  • Consultant Id (consultant_id) — int — 기본 키 — NOT NULL
  • Responsibility (responsibility) — varchar

코치

  • Coach Id (coach_id) — int — 기본 키 — NOT NULL
  • Responsibility (responsibility) — varchar