학적과 수강신청
테이블 (10)
classroom
- classroom_id — BIGINT
- building_name — VARCHAR(100)
- room_no — VARCHAR(20)
course
- course_id — BIGINT
- course_name — VARCHAR(100)
course_offering
- offering_id — BIGINT
- course_id — BIGINT — 외래 키 → course.course_id
- instructor_id — BIGINT — 외래 키 → instructor.instructor_id
- term_id — BIGINT — 외래 키 → term.term_id
- section_no — INT
enrollment
- student_id — BIGINT — 외래 키 → student.student_id
- offering_id — BIGINT — 외래 키 → course_offering.offering_id
- grade — VARCHAR(5)
- is_retake — VARCHAR(10)
enrollment_time_slot
- student_id — BIGINT — 외래 키 → student.student_id
- offering_id — BIGINT — 외래 키 → course_offering.offering_id
- term_id — BIGINT — 외래 키 → term.term_id
- time_slot_id — BIGINT — 외래 키 → time_slot.time_slot_id
instructor
- instructor_id — BIGINT
- name — VARCHAR(50)
- age — INT
- gender — VARCHAR(10)
offering_schedule
- offering_id — BIGINT — 외래 키 → course_offering.offering_id
- term_id — BIGINT — 외래 키 → term.term_id
- time_slot_id — BIGINT — 외래 키 → time_slot.time_slot_id
- classroom_id — BIGINT — 외래 키 → classroom.classroom_id
- instructor_id — BIGINT — 외래 키 → instructor.instructor_id
student
- student_id — BIGINT
- name — VARCHAR(50)
- address — VARCHAR(255)
term
- term_id — BIGINT
- year — INT
- semester — INT
time_slot
- time_slot_id — BIGINT
- day_of_week — VARCHAR(10)
- period — INT