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