ssafy
Tables (6)
classes
- class_id (Key) — INT — Primary key — NOT NULL
- region — ENUM('Seoul', 'Daejeon', 'Gumi', 'Gwangju', 'Busan', 'Ulsan') — NOT NULL
- class_number — INT — NOT NULL
- consultant_id (Key2) — INT — Foreign key → consultants.consultant_id — NOT NULL
- coach_id (Key3) — INT — Foreign key → coaches.coach_id — NOT NULL
coaches
- coach_id (Key) — INT — Primary key — NOT NULL
- name — VARCHAR(100)
consultants
- consultant_id (Key) — INT — Primary key — NOT NULL
- name — VARCHAR(100)
courses
- course_id — INT — Primary key — NOT NULL
- course_name — VARCHAR(100)
- type — ENUM('common', 'special', 'self') — NOT NULL
enrollments
- enrollment_id — INT — Primary key — NOT NULL
- course_id — INT — Foreign key → courses.course_id — NOT NULL
- student_id (Key) — INT — Foreign key → students.student_id — NOT NULL
students
- student_id (Key) — INT — Primary key — NOT NULL
- name — VARCHAR(100)
- status — ENUM('active', 'inactive', 'graduated') — NOT NULL
- major — ENUM('major', 'non_major') — NOT NULL
- cardinal number — INT