test

Tables (12)

Class (class)

  • Class Id (id) — type — Primary key — NOT NULL
  • 반 (class) — int

Coach (coach)

  • Coach Id (id) — type — Primary key — NOT NULL
  • 담당업무 (task) — char
  • 반 (class) — char
  • 지역 (local) — char

Coach_Class (Untitled5)

  • Coach Id (id) — type — Foreign key → Coach.Coach Id — NOT NULL
  • Class Id (id2) — type — Foreign key → Class.Class Id — NOT NULL

Coach_Local (Untitled6)

  • Coach Id (id) — type — Foreign key → Coach.Coach Id — NOT NULL
  • Local Id (id2) — type — Foreign key → Local.Local Id — NOT NULL

Consultant (consultant)

  • Consultant Id (id) — type — Primary key — NOT NULL
  • 담당업무 (task) — char
  • 반 (class) — char
  • 지역 (local) — char

Consultant_Class (Untitled3)

  • Class Id (id) — type — Foreign key → Class.Class Id — NOT NULL
  • Consultant Id (id2) — type — Foreign key → Consultant.Consultant Id — NOT NULL

Consultant_Local (Untitled4)

  • Local Id (id) — type — Foreign key → Local.Local Id — NOT NULL
  • Consultant Id (id2) — type — Foreign key → Consultant.Consultant Id — NOT NULL

Curriculum (Untitled7)

  • Curriculum id (id) — type — Primary key — NOT NULL
  • 교육과정 (curriculum) — char

Local (local)

  • Local Id (id) — type — Primary key — NOT NULL
  • 지역 (local) — char

Trainee (trainee)

  • Trainee id (id) — type — Primary key — NOT NULL
  • 기수 (year) — int
  • 전공여부 (major) — bool
  • 퇴소여부 (retirement) — bool
  • 반 (class) — char
  • 지역 (local) — char

Trainee_Class (Untitled)

  • Trainee id (id) — type — Foreign key → Trainee.Trainee id — NOT NULL
  • Class Id (id2) — type — Foreign key → Class.Class Id — NOT NULL

Trainee_Local (Untitled2)

  • Trainee id (id) — type — Foreign key → Trainee.Trainee id — NOT NULL
  • Local Id (id2) — type — Foreign key → Local.Local Id — NOT NULL