ssafy_free1

Tables (5)

Class (반)

  • PK (class_id) — int — Primary key — NOT NULL
  • FK (consultant_id) — int — Foreign key → Consultant.PK — NOT NULL
  • FK (coach_id) — int — Foreign key → Coach.PK — NOT NULL
  • Field (region) — varchar
  • Field2 (class_number) — int

Coach (코치)

  • PK (coach_id) — int — Primary key — NOT NULL
  • Field (name) — varchar
  • Field2 (role) — varchar

Consultant (컨설턴트)

  • PK (consultant_id) — int — Primary key — NOT NULL
  • Field (name) — varchar
  • Field2 (role) — varchar

Course (교육 과정)

  • PK (course_id) — int — Primary key — NOT NULL
  • Field (course_type) — varchar

Student (교육생)

  • PK (student_id) — int — Primary key — NOT NULL
  • FK (class_id) — int — Foreign key → Class.PK — NOT NULL
  • Field (name) — varchar
  • Field2 (is_major) — boolean
  • Field3 (is_graduated) — boolean
  • Field4 (batch) — int