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)