skala
Tables (12)
classrooms (강의실)
- id (강의실ID) — Primary key — NOT NULL
- building (건물명)
- room_no (강의장 호실)
- room_capacity (수용인원)
course_offerings (개설강좌)
- id (개설강좌ID) — Primary key — NOT NULL
- semester (학기)
- section (분반)
- max_students (정원)
- course_id (과목ID) — Foreign key → courses.id — NOT NULL
- professor_id (교수ID) — Foreign key → professors.id — NOT NULL
courses (과목)
- id (과목ID) — Primary key — NOT NULL
- code (과목코드)
- title (과목명)
- credits (학점)
- dept_id (학과ID) — Foreign key → departments.id — NOT NULL
departments (학과)
- id (학과ID) — Primary key — NOT NULL
- code (학과코드)
- name (학과명)
- office (사무실)
- phone (연락처)
enrollments (수강신청)
- offering_id (개설강좌ID) — Foreign key → course_offerings.id — NOT NULL
- student_id (학생ID) — Foreign key → students.id — NOT NULL
- enrolled_at (신청일)
- status (수강상태)
- final_score (확정성적)
eval_types (평가유형)
- code (평가유형코드) — Primary key — NOT NULL
- name (표시명)
- sort_order (정렬순서)
grades (성적)
- offering_id (개설강좌ID) — Foreign key → offering_eval_weights.offering_id — NOT NULL
- offering_id (개설강좌ID (테이블2개 사용)) — Foreign key → enrollments.offering_id — NOT NULL
- student_id (학생ID) — Foreign key → enrollments.student_id — NOT NULL
- eval_type (평가유형코드) — Foreign key → offering_eval_weights.eval_type — NOT NULL
- score (점수)
- graded_at (채점일시)
offering_eval_weights (강의평가배점)
- offering_id (개설강좌ID) — Foreign key → course_offerings.id — NOT NULL
- eval_type (평가유형코드) — Foreign key → eval_types.code — NOT NULL
- weight (반영 비율)
offering_schedules (강의일정)
- id (일정 ID) — Primary key — NOT NULL
- day_of_week (요일)
- offering_id (개설강좌ID) — Foreign key → course_offerings.id — NOT NULL
- classroom_id (강의실ID) — Foreign key → classrooms.id — NOT NULL
- start_period (시작교시) — Foreign key → periods.period_no — NOT NULL
- end_period (종료교시) — Foreign key → periods.period_no — NOT NULL
periods (교시)
- period_no (교시번호) — Primary key — NOT NULL
- start_time (시작시각)
- end_time (종료시각)
professors (교수)
- id (교수ID) — Primary key — NOT NULL
- prof_no (교번)
- name (성명)
- email (이메일)
- hired_at (임용일)
- dept_id (학과ID) — Foreign key → departments.id — NOT NULL
students (학생)
- id (학생ID) — Primary key — NOT NULL
- student_no (학번)
- name (성명)
- grade (학년)
- email (이메일)
- phone (연락처)
- status (학적상태)
- admitted_at (입학일)
- graduated_at (졸업일)
- dept_id (학과ID) — Foreign key → departments.id — NOT NULL