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