SSAFY
Tables (5)
Class (Entity4)
- Class ID (class_id) — INT(7) — Primary key — NOT NULL
- Location (location) — VARCHAR(10)
- Class Number (class_number) — INT(3)
Coach (Entity3)
- Coach ID (coach_id) — INT(7) — Primary key — NOT NULL
- Class ID (class_id) — INT(7) — Foreign key → Class.Class ID — NOT NULL
- Name (name) — VARCHAR(20)
- Task (task) — VARCHAR(255)
Consultant (Entity2)
- Consultant ID (consultant_id) — INT(7) — Primary key — NOT NULL
- Class ID (class_id) — INT(7) — Foreign key → Class.Class ID — NOT NULL
- Name (name) — VARCHAR(20)
- Task (task) — VARCHAR(255)
Course (Entity5)
- Course ID (course_id) — INT(10) — Primary key — NOT NULL
- Course (course) — VARCHAR(20)
Student (Entity1)
- Student ID (student_id) — INT(7) — Primary key — NOT NULL
- Class ID (class_id) — INT(7) — Foreign key → Class.Class ID — NOT NULL
- Course ID (course_id) — INT(10) — Foreign key → Course.Course ID — NOT NULL
- Name (name) — VARCHAR(20)
- Ordinal Numbers (ordinal_numbers) — INT(2)
- Major (major) — CHAR(1)
- Retire (retire) — CHAR(1)