Seoin Software Academy
Tables (5)
Class
- PK — Integer — Primary key — NOT NULL
- Curriculum_id — Integer — Foreign key → Curriculum.PK — NOT NULL
- Consultant_id — Integer — Foreign key → Consultant.PK — NOT NULL
- Coach_id — Integer — Foreign key → Coach.PK — NOT NULL
- Region — Char(Choices)
- ClassNum — Char(Choices)
Coach
- PK — Integer — Primary key — NOT NULL
- Name — Char(50)
- Phone — Text
- JobDescription — Text
Consultant
- PK — Integer — Primary key — NOT NULL
- Name — Char(50)
- Phone — Text
- JobDescription — Text
Curriculum
- PK — Integer — Primary key — NOT NULL
- Description — Text
Student
- PK — Integer — Primary key — NOT NULL
- Class_id — Integer — Foreign key → Class.PK — NOT NULL
- Curriculum_id — Integer — Foreign key → Class.Curriculum_id — NOT NULL
- Consultant_id — Integer — Foreign key → Class.Consultant_id — NOT NULL
- Coach_id — Integer — Foreign key → Class.Coach_id — NOT NULL
- Name — Char(50)
- Phone — Text
- Address — Text
- Birthday — Datetime
- Protector Phone — Text
- Session — Char(Choices)
- IsCSMajor — Boolean
- IsRetirement — Boolean