SSAFY
Tables (6)
Areas (areas)
- Area Id (area_id) — INT — Primary key — NOT NULL
- Area Name (area_name) — VARCHAR(255)
Classes (classes)
- Class Id (class_id) — INT — Primary key — NOT NULL
- Class number (class_number) — INT
- Consultant Id (consultant_id) — INT — Foreign key → Consultants.Consultant Id — NOT NULL
- Coach Id (coach_id) — INT — Foreign key → Coaches.Coach Id
- Area Id (area_id) — INT — Foreign key → Areas.Area Id — NOT NULL
- Course Id (course_id) — INT — Foreign key → Courses.Course Id — NOT NULL
Coaches (coaches)
- Coach Id (coach_id) — INT — Primary key — NOT NULL
- Coach Name (coach_name) — VARCHAR(255)
- CoachTask (coach_task) — VARCHAR(255)
- Area Id (area_id) — INT — Foreign key → Areas.Area Id — NOT NULL
Consultants (consultants)
- Consultant Id (consultant_id) — INT — Primary key — NOT NULL
- Consultant Task (consultant_task) — VARCHAR(255)
Courses (courses)
- Course Id (course_id) — INT — Primary key — NOT NULL
- Course Type (course_type) — VARCHAR(255)
- Course Name (course_name) — VARCHAR(255)
Students (students)
- Student Id (student_id) — INT — Primary key — NOT NULL
- Student Year (student_year) — INT
- Student Major (student_major) — BOOL
- Student Active (student_active) — BOOL
- Student Name (student_name) — VARCHAR(255)
- Class Id (class_id) — INT — Foreign key → Classes.Class Id — NOT NULL