Multi-SAFFY

Tables (6)

Classes

  • Key (ClassKey) — Primary key — NOT NULL
  • Region — Seoul, Daejeon, Gumi, Buwoolgyeong, Gwangju
  • Subclass — 1~6
  • Key (ConsultantKey) — Foreign key → Consultant.Key — NOT NULL

Coach

  • Key (CoachKey) — Primary key — NOT NULL
  • Key (ClassKey) — Foreign key → Classes.Key — NOT NULL

Consultant

  • Key (ConsultantKey) — Primary key — NOT NULL

Student

  • Key (StudentKey) — Primary key — NOT NULL
  • generation
  • majored
  • left (dismissed)
  • Key (ClassKey) — Foreign key → Classes.Key — NOT NULL
  • Key (CurriculumKey) — Foreign key → Untitled5.Key — NOT NULL

Untitled (Task)

  • Key (TaskKey) — Primary key — NOT NULL
  • Field (Content)
  • Field (Completed)
  • Key (ConsultantKey) — Foreign key → Consultant.Key — NOT NULL
  • Key (CoachKey) — Foreign key → Coach.Key — NOT NULL

Untitled5 (Curriculum)

  • Key (CurriculumKey) — Primary key — NOT NULL
  • Field (Common)
  • Field (Specialized)
  • Field (Self-study)