yongmin_pots
Tables (26)
cert_result
- cert_result_id — BIGINT — Primary key — NOT NULL
- student_profile_id — BIGINT — Foreign key → student_profile.student_profile_id — NOT NULL
- student_major_id — BIGINT — Foreign key → student_major.student_major_id
- cert_type — VARCHAR(30) — NOT NULL — THESIS, ENGLISH, SW, TOPIK, GRADUATION_CERT, ETC
- result — VARCHAR(20) — NOT NULL — PASS, FAIL, EXEMPT, NONE
- source — VARCHAR(20) — NOT NULL — PDF, MANUAL
course
- course_id — BIGINT — Primary key — NOT NULL
- school_id — BIGINT — Foreign key → school.school_id — NOT NULL
- course_code — VARCHAR(30) — NOT NULL
- name — VARCHAR(150) — NOT NULL
- credit — DECIMAL(4, 1) — NOT NULL
- default_division_id — BIGINT — Foreign key → division.division_id
- ge_area_id — BIGINT — Foreign key → ge_area.ge_area_id
- recommended_year — INT
- opened_semester — VARCHAR(20) — FIRST, SECOND, BOTH
- is_english — BOOLEAN — NOT NULL
- is_sw — BOOLEAN — NOT NULL
course_prerequisite
- prerequisite_id — BIGINT — Primary key — NOT NULL
- course_id — BIGINT — Foreign key → course.course_id — NOT NULL
- required_course_id — BIGINT — Foreign key → course.course_id — NOT NULL
course_substitute
- course_substitute_id — BIGINT — Primary key — NOT NULL
- old_course_id — BIGINT — Foreign key → course.course_id — NOT NULL
- new_course_id — BIGINT — Foreign key → course.course_id — NOT NULL
- valid_until_year — INT
department
- department_id — BIGINT — Primary key — NOT NULL
- school_id — BIGINT — Foreign key → school.school_id — NOT NULL
- code — VARCHAR(20) — NOT NULL
- name — VARCHAR(100) — NOT NULL
division
- division_id — BIGINT — Primary key — NOT NULL
- school_id — BIGINT — Foreign key → school.school_id — NOT NULL
- code — VARCHAR(20) — NOT NULL
- category — VARCHAR(30) — NOT NULL — MAJOR_BASIC, MAJOR_REQUIRED, MAJOR_ELECTIVE, GE_REQUIRED, GE_DISTRIBUTION, GE_FREE, GENERAL_ELECTIVE
ge_area
- ge_area_id — BIGINT — Primary key — NOT NULL
- school_id — BIGINT — Foreign key → school.school_id — NOT NULL
- code — VARCHAR(20) — NOT NULL
- name — VARCHAR(50) — NOT NULL
member
- member_id — BIGINT — Primary key — NOT NULL
- oauth_provider — VARCHAR(20) — NOT NULL — KAKAO
- oauth_id — VARCHAR(100) — NOT NULL
- email — VARCHAR(255)
- role — VARCHAR(20) — NOT NULL — USER, ADMIN
planner_sim_version
- planner_sim_version_id — BIGINT — Primary key — NOT NULL
- planner_simulation_id — BIGINT — Foreign key → planner_simulation.planner_simulation_id — NOT NULL
- planner_term_version_id — BIGINT — Foreign key → planner_term_version.planner_term_version_id — NOT NULL
- created_at — DATETIME — NOT NULL
planner_simulation
- planner_simulation_id — BIGINT — Primary key — NOT NULL
- student_profile_id — BIGINT — Foreign key → student_profile.student_profile_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
planner_term
- planner_term_id — BIGINT — Primary key — NOT NULL
- planner_simulation_id — BIGINT — Foreign key → planner_simulation.planner_simulation_id — NOT NULL
- year_level — INT — NOT NULL
- semester — INT — NOT NULL
- term_order — INT — NOT NULL
planner_term_version
- planner_term_version_id — BIGINT — Primary key — NOT NULL
- planner_term_id — BIGINT — Foreign key → planner_term.planner_term_id — NOT NULL
- version_no — INT — NOT NULL
- name — VARCHAR(100)
- is_selected — BOOLEAN — NOT NULL
planner_version_item
- planner_version_item_id — BIGINT — Primary key — NOT NULL
- planner_term_version_id — BIGINT — Foreign key → planner_term_version.planner_term_version_id — NOT NULL
- student_course_id — BIGINT — Foreign key → student_course.student_course_id
- course_id — BIGINT — Foreign key → course.course_id
- raw_course_name — VARCHAR(150)
- planned_division_id — BIGINT — Foreign key → division.division_id — NOT NULL
- credit — DECIMAL(4, 1) — NOT NULL
- status — VARCHAR(20) — NOT NULL — COMPLETED, IN_PROGRESS, PLANNED
- position_order — INT — NOT NULL
requirement_area
- requirement_area_id — BIGINT — Primary key — NOT NULL
- requirement_set_id — BIGINT — Foreign key → requirement_set.requirement_set_id — NOT NULL
- ge_area_id — BIGINT — Foreign key → ge_area.ge_area_id — NOT NULL
- required_area_count — INT — NOT NULL
- required_credit — INT — NOT NULL
requirement_cert
- requirement_cert_id — BIGINT — Primary key — NOT NULL
- requirement_set_id — BIGINT — Foreign key → requirement_set.requirement_set_id — NOT NULL
- cert_type — VARCHAR(30) — NOT NULL — THESIS, ENGLISH, SW, TOPIK, GRADUATION_CERT, ETC
- threshold — VARCHAR(50)
- required — BOOLEAN — NOT NULL
requirement_course
- requirement_course_id — BIGINT — Primary key — NOT NULL
- requirement_set_id — BIGINT — Foreign key → requirement_set.requirement_set_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- min_count — INT
- division_id — BIGINT — Foreign key → division.division_id
requirement_course_item
- requirement_course_item_id — BIGINT — Primary key — NOT NULL
- requirement_course_id — BIGINT — Foreign key → requirement_course.requirement_course_id — NOT NULL
- course_id — BIGINT — Foreign key → course.course_id — NOT NULL
requirement_credit
- requirement_credit_id — BIGINT — Primary key — NOT NULL
- requirement_set_id — BIGINT — Foreign key → requirement_set.requirement_set_id — NOT NULL
- division_id — BIGINT — Foreign key → division.division_id — NOT NULL
- required_credit — INT — NOT NULL
requirement_set
- requirement_set_id — BIGINT — Primary key — NOT NULL
- school_id — BIGINT — Foreign key → school.school_id — NOT NULL
- department_id — BIGINT — Foreign key → department.department_id — NOT NULL
- base_year — INT — NOT NULL
- major_type — VARCHAR(20) — NOT NULL — MAIN, DOUBLE
- total_credit — INT — NOT NULL
- min_gpa — DECIMAL(3, 2) — NOT NULL
- min_terms — INT
school
- school_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- code — VARCHAR(20) — NOT NULL
student_course
- student_course_id — BIGINT — Primary key — NOT NULL
- student_profile_id — BIGINT — Foreign key → student_profile.student_profile_id — NOT NULL
- course_id — BIGINT — Foreign key → course.course_id
- raw_course_name — VARCHAR(150) — NOT NULL
- raw_course_code — VARCHAR(30)
- applied_division_id — BIGINT — Foreign key → division.division_id — NOT NULL
- credit — DECIMAL(4, 1) — NOT NULL
- taken_year — INT
- taken_semester — VARCHAR(20)
- grade — VARCHAR(10)
- status — VARCHAR(20) — NOT NULL — COMPLETED, IN_PROGRESS
- source — VARCHAR(20) — NOT NULL — PDF, MANUAL, PLANNER
- is_retake — BOOLEAN — NOT NULL
student_major
- student_major_id — BIGINT — Primary key — NOT NULL
- student_profile_id — BIGINT — Foreign key → student_profile.student_profile_id — NOT NULL
- department_id — BIGINT — Foreign key → department.department_id — NOT NULL
- major_type — VARCHAR(20) — NOT NULL — MAIN, DOUBLE
- requirement_set_id — BIGINT — Foreign key → requirement_set.requirement_set_id — NOT NULL
- track_id — BIGINT — Foreign key → track.track_id
student_profile
- student_profile_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- school_id — BIGINT — Foreign key → school.school_id — NOT NULL
- student_no — VARCHAR(20) — NOT NULL
- department_id — BIGINT — Foreign key → department.department_id — NOT NULL
- admission_year — INT — NOT NULL
track
- track_id — BIGINT — Primary key — NOT NULL
- requirement_set_id — BIGINT — Foreign key → requirement_set.requirement_set_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- total_required_credit — INT — NOT NULL
track_course
- track_course_id — BIGINT — Primary key — NOT NULL
- track_requirement_id — BIGINT — Foreign key → track_requirement.track_requirement_id — NOT NULL
- course_id — BIGINT — Foreign key → course.course_id — NOT NULL
track_requirement
- track_requirement_id — BIGINT — Primary key — NOT NULL
- track_id — BIGINT — Foreign key → track.track_id — NOT NULL
- division_id — BIGINT — Foreign key → division.division_id — NOT NULL
- required_credit — INT — NOT NULL
- required_course_count — INT