학적과 수강신청

테이블 (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