test2

Tables (5)

Class (반)

  • ClassId (class_id) — int — Primary key — NOT NULL
  • Region (region) — Strin
  • Num (num) — int
  • Field
  • CoachId (coach_id) — int — Foreign key → Coach.CoachId — NOT NULL

Coach (코치)

  • CoachId (coach_id) — int — Primary key — NOT NULL
  • Work (work) — String

Consultant (컨설턴트)

  • ClassId (class_id) — int — Foreign key → Class.ClassId — NOT NULL
  • Work (work) — String

Curriculum (교육과정)

  • CurriculumId (curriculum_id) — int — Primary key — NOT NULL
  • Type (type) — String

Student (교육생)

  • StudentId (student_id) — int — Primary key — NOT NULL
  • StudentGrade (grade) — String
  • IsMajor (is_major) — Boolean
  • isOut (is_out) — Boolean
  • CurriculumId (curriculum_id) — int — Foreign key → Curriculum.CurriculumId — NOT NULL
  • ClassId (class_id) — int — Foreign key → Class.ClassId — NOT NULL