SS

Tables (16)

balanced_ge_area

  • id — VARCHAR(36) — Primary key — NOT NULL
  • requirement_set_id — VARCHAR(36) — Foreign key → graduation_requirement_set.id — NOT NULL
  • area_name — VARCHAR(50) — NOT NULL
  • min_courses — INT — NOT NULL

course

  • id — VARCHAR(36) — Primary key — NOT NULL
  • course_code — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • credit — INT — NOT NULL
  • category — VARCHAR(50) — NOT NULL

course_section

  • id — VARCHAR(36) — Primary key — NOT NULL
  • course_id — VARCHAR(36) — Foreign key → course.id — NOT NULL
  • section_no — VARCHAR(10) — NOT NULL
  • professor — VARCHAR(50) — NOT NULL
  • capacity — INT — NOT NULL

graduation_check_result

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → user.id — NOT NULL
  • requirement_set_id — VARCHAR(36) — Foreign key → graduation_requirement_set.id — NOT NULL
  • total_credit — INT — NOT NULL
  • verdict — VARCHAR(20) — NOT NULL

graduation_requirement_set

  • id — VARCHAR(36) — Primary key — NOT NULL
  • department — VARCHAR(100) — NOT NULL
  • year_range — VARCHAR(20) — NOT NULL
  • total_credit — INT — NOT NULL

practice_attempt

  • id — VARCHAR(36) — Primary key — NOT NULL
  • session_id — VARCHAR(36) — Foreign key → practice_session.id — NOT NULL
  • section_id — VARCHAR(36) — Foreign key → course_section.id — NOT NULL
  • result — VARCHAR(20) — NOT NULL

practice_seat_pool

  • id — VARCHAR(36) — Primary key — NOT NULL
  • session_id — VARCHAR(36) — Foreign key → practice_session.id — NOT NULL
  • section_id — VARCHAR(36) — Foreign key → course_section.id — NOT NULL
  • remaining_seats — INT — NOT NULL

practice_session

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → user.id — NOT NULL
  • semester — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL

required_course_group

  • id — VARCHAR(36) — Primary key — NOT NULL
  • requirement_set_id — VARCHAR(36) — Foreign key → graduation_requirement_set.id — NOT NULL
  • group_name — VARCHAR(50) — NOT NULL

required_course_group_item

  • id — VARCHAR(36) — Primary key — NOT NULL
  • group_id — VARCHAR(36) — Foreign key → required_course_group.id — NOT NULL
  • course_code — VARCHAR(20) — NOT NULL

time_slot

  • id — VARCHAR(36) — Primary key — NOT NULL
  • section_id — VARCHAR(36) — Foreign key → course_section.id — NOT NULL
  • day — VARCHAR(10) — NOT NULL
  • period — INT — NOT NULL
  • room — VARCHAR(50) — NOT NULL

timetable_entry

  • id — VARCHAR(36) — Primary key — NOT NULL
  • timetable_id — VARCHAR(36) — Foreign key → user_timetable.id — NOT NULL
  • section_id — VARCHAR(36) — Foreign key → course_section.id — NOT NULL

user

  • id — VARCHAR(36) — Primary key — NOT NULL
  • student_no — VARCHAR(20) — NOT NULL
  • department — VARCHAR(100) — NOT NULL
  • enroll_year — INT — NOT NULL

user_completion

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → user.id — NOT NULL
  • course_code — VARCHAR(20) — NOT NULL
  • semester — VARCHAR(20) — NOT NULL
  • grade — VARCHAR(5) — NOT NULL
  • status — VARCHAR(20) — NOT NULL

user_timetable

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → user.id — NOT NULL
  • semester — VARCHAR(20) — NOT NULL
  • name — VARCHAR(50) — NOT NULL

wishlist_item

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → user.id — NOT NULL
  • section_id — VARCHAR(36) — Foreign key → course_section.id — NOT NULL