ssafy
Tables (6)
Class
- Class_id (class_id) — INT(11) — Primary key — NOT NULL
- Consultant_id (consultant_id) — INT(11) — Foreign key → Consultant.Consultant_id — NOT NULL
- Coach_id (coach_id) — INT(11) — Foreign key → Coach.Coach_id — NOT NULL
- Course_id (course_id) — INT(11) — Foreign key → Course.Course_id — NOT NULL
- region
- class_num
Coach
- Coach_id (coach_id) — INT(11) — Primary key — NOT NULL
- name — VARCHAR(20)
- task — VARCHAR(20)
Consultant
- Consultant_id (consultant_id) — INT(11) — Primary key — NOT NULL
- name — VARCHAR(20)
- task — VARCHAR(20)
Course
- Course_id (course_id) — INT(11) — Primary key — NOT NULL
- name — VARCHAR(20)
Student
- Student_id (student_id) — INT(11) — Primary key — NOT NULL
- name — VARCHAR(20)
- generation — INT(11)
- major — BOOLEAN
- exit — BOOLEAN
Student_Class
- PK — INT(11) — Primary key — NOT NULL
- Class_id (class_id) — INT(11) — Foreign key → Class.Class_id — NOT NULL
- Consultant_id (consultant_id) — INT(11) — Foreign key → Class.Consultant_id — NOT NULL
- Coach_id (coach_id) — INT(11) — Foreign key → Class.Coach_id — NOT NULL
- Student_id (student_id) — INT(11) — Foreign key → Student.Student_id — NOT NULL
- Course_id (course_id) — INT(11) — Foreign key → Class.Course_id — NOT NULL