SSAFY 과제

테이블 (6)

Classes (classes)

  • Class Id (class_id) — INT — 기본 키 — NOT NULL
  • Class (class) — INT

Coach (coach)

  • Coach Id (coach_id) — INT — 기본 키 — NOT NULL
  • Work (work) — VARCHAR(50)
  • Class Id (class_id) — INT — 외래 키 → Classes.Class Id — NOT NULL
  • Region Id (region_id) — INT — 외래 키 → Regions.Region Id — NOT NULL

Consultant (consultant)

  • Consultant Id (consultant_id) — INT — 기본 키 — NOT NULL
  • Work (work) — VARCHAR(50)
  • Class Id (class_id) — INT — 외래 키 → Classes.Class Id — NOT NULL
  • Region Id (region_id) — INT — 외래 키 → Regions.Region Id — NOT NULL

Curriculum (curriculum)

  • Curriculum Id (curriculum _id) — INT — 기본 키 — NOT NULL
  • Part (part) — CHAR(2)

Regions (regions)

  • Region Id (region_id) — INT — 기본 키 — NOT NULL
  • Region (region) — VARCHAR(3)

Students (students)

  • Student Id (student_id) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(10)
  • Term (term) — INT
  • Major (major) — BOOLEAN
  • Left (left) — BOOLEAN
  • Curriculum Id (curriculum _id) — INT — 외래 키 → Curriculum.Curriculum Id — NOT NULL