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