대학교 학사 관리 시스템의 ERD
테이블 (8)
Assignment
- AssignmentID — INT
- AssignmentName — VARCHAR(50)
- AssignmentDescription — TEXT
- AssignmentDeadline — DATE
- LectureID — INT — 외래 키 → Lecture.LectureID
Lecture
- LectureID — INT
- LectureName — VARCHAR(50)
- LectureDescription — TEXT
- InstructorName — VARCHAR(50)
- LectureDate — DATE
- CourseID — INT
Survey
- SurveyID — INT
- SurveyName — VARCHAR(50)
- SurveyDescription — TEXT
- SurveyDeadline — DATE
- AssignmentID — INT — 외래 키 → Assignment.AssignmentID
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 — 외래 키 → professor.professor_id
- course_id — INT — 외래 키 → course.course_id
enrollment
- enrollment_id — INT
- student_id — INT — 외래 키 → student.student_id
- course_offering_id — INT — 외래 키 → 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)