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