SSAFY
Tables (7)
City (city)
- City ID (city_id) — INT(1) — Primary key — NOT NULL
- City Name (city_name) — VARCHAR(10)
Class (classes)
- Class ID (class_id) — INT(2) — Primary key — NOT NULL
- City ID (city_id) — INT(1) — Foreign key → City.City ID — NOT NULL
- Consultant ID (consultant_id) — VARCHAR(15) — Foreign key → Consultant.Consultant ID — NOT NULL
- Coach ID (coach_id) — VARCHAR(15) — Foreign key → Coach.Coach ID — NOT NULL
- Class Number (class_num) — INT(2)
Coach (coach)
- Coach ID (coach_id) — VARCHAR(15) — Primary key — NOT NULL
- Coach Name (coach_name) — VARCHAR(40)
- Task ID (task_id) — INT(2) — Foreign key → Task.Task ID — NOT NULL
Consultant (consultant)
- Consultant ID (consultant_id) — VARCHAR(15) — Primary key — NOT NULL
- Consultant Name (consultant_name) — VARCHAR(40)
- Task ID (task_id) — INT(2) — Foreign key → Task.Task ID — NOT NULL
Course (course)
- Course ID (course_id) — INT(1) — Primary key — NOT NULL
- Course Name (course_name) — VARCHAR(10)
Students (students)
- Student Id (student_id) — VARCHAR(10) — Primary key — NOT NULL
- Class ID (class_id) — INT(2) — Foreign key → Class.Class ID — NOT NULL
- City ID (city_id) — INT(1) — Foreign key → Class.City ID — NOT NULL
- Consultant ID (consultant_id) — VARCHAR(15) — Foreign key → Class.Consultant ID — NOT NULL
- Coach ID (coach_id) — VARCHAR(15) — Foreign key → Class.Coach ID — NOT NULL
- Course ID (course_id) — INT(1) — Foreign key → Course.Course ID — NOT NULL
- Major (major) — TYPEINT(1)
- Discharge (discharge) — TYPEINT(1)
Task (task)
- Task ID (task_id) — INT(2) — Primary key — NOT NULL
- Task Name (task_name) — VARCHAR(40)
- Description (description) — VARCHAR(1000)
- Complete (complete) — TYPEINT(1)