Syllaverse
Tables (5)
course
- course_id — INT
- course_code — VARCHAR(10)
- course_name — VARCHAR(50)
- entity_type — ENUM('교양', '전공')
course_offering
- course_offering_id — INT
- year — INT
- semester — ENUM('1학기', '여름학기', '2학기', '겨울학기')
- professor_id — INT — Foreign key → professor.professor_id
- course_id — INT — Foreign key → course.course_id
enrollment
- enrollment_id — INT
- student_id — INT — Foreign key → student.student_id
- course_offering_id — INT — Foreign key → course_offering.course_offering_id
professor
- professor_id — INT
- name — VARCHAR(50)
- email — VARCHAR(50)
- department — VARCHAR(50)
student
- student_id — INT
- name — VARCHAR(50)
- email — VARCHAR(50)
- major — VARCHAR(50)