SSAFY
Tables (5)
Classes (classes)
- Region (region) — VARCHAR(30) — Primary key — NOT NULL
- Class Num (class_num) — INT — Primary key — NOT NULL
Coaches (coaches)
- Coach Id (coach_id) — INT — Primary key — NOT NULL
- Role (role) — VARCHAR(30)
- Region (region) — VARCHAR(30) — Foreign key → Classes.Region — NOT NULL
- Class Num (class_num) — INT — Foreign key → Classes.Class Num — NOT NULL
Consultants (consultants)
- Consultant Id (consultant_id) — INT — Primary key — NOT NULL
- Role (role) — VARCHAR(30)
- Region (region) — VARCHAR(30) — Foreign key → Classes.Region — NOT NULL
- Class Num (class_num) — INT — Foreign key → Classes.Class Num — NOT NULL
Curriculum (curriculum)
- Process (process) — VARCHAR(30) — Primary key — NOT NULL
Students (students)
- Student Id (student_id) — INT — Primary key — NOT NULL
- Generation (generation) — INT
- Is Major (is_major) — VARCHAR(30)
- Is Discharge (is_discharge) — VARCHAR(30)