TEST

Tables (12)

audit_area_result

  • area_code — VARCHAR(30) — Primary key — NOT NULL
  • result_id — BIGINT — Foreign key → audit_result.result_id — NOT NULL
  • required_credits — INT — NOT NULL
  • acquired_credits — INT — NOT NULL
  • satisfied — BOOLEAN — NOT NULL

audit_course_result

  • requirement_type — ENUM('REQUIRED','DEPT_DESIGNATED','OTHER') — Primary key — NOT NULL
  • result_id — BIGINT — Foreign key → audit_result.result_id — NOT NULL
  • course_code — VARCHAR(20) — Foreign key → course.course_code — NOT NULL
  • required — BOOLEAN — NOT NULL
  • taken — BOOLEAN — NOT NULL
  • note — TEXT

audit_other_requirement

  • req_code — VARCHAR(50) — Primary key — NOT NULL
  • result_id — BIGINT — Foreign key → audit_result.result_id — NOT NULL
  • required_value — VARCHAR(100)
  • satisfied — BOOLEAN — NOT NULL
  • reason — TEXT

audit_result

  • result_id — BIGINT — Primary key — NOT NULL
  • run_id — BIGINT — NOT NULL
  • student_id — VARCHAR(20) — NOT NULL
  • criteria_id — INT — NOT NULL
  • pass_fail — ENUM('PASS','FAIL') — NOT NULL
  • total_credits — INT — NOT NULL
  • gpa — DECIMAL(4,2)
  • applied_criteria_year — INT — NOT NULL
  • exception_applied — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

course

  • course_code — VARCHAR(20) — Primary key — NOT NULL
  • course_name — VARCHAR(100) — NOT NULL
  • credits — INT — NOT NULL

dept_designated_course

  • designated_id — INT — Primary key — NOT NULL
  • dept_code — VARCHAR(10) — NOT NULL
  • admission_year_range — VARCHAR(20) — NOT NULL
  • course_code — VARCHAR(20) — NOT NULL
  • course_name — VARCHAR(100) — NOT NULL
  • credits — INT — NOT NULL
  • designation_type — ENUM('REQUIRED','RECOMMENDED','ELECTIVE') — NOT NULL
  • elective_min_count — INT
  • note — TEXT

english_score_conversion

  • conversion_id — INT — Primary key — NOT NULL
  • toeic_score — INT — NOT NULL
  • toefl_cbt — INT
  • toefl_ibt — INT
  • teps — INT
  • toeic_speaking — INT
  • opic_ielts_gtelp — VARCHAR(20)

equivalent_course

  • map_id — BIGINT — Primary key — NOT NULL
  • from_course_code — VARCHAR(20) — Foreign key → course.course_code — NOT NULL
  • to_course_code — VARCHAR(20) — Foreign key → course.course_code — NOT NULL
  • relation_type — ENUM('EQUIVALENT','REPLACEMENT') — NOT NULL
  • effective_year_term — VARCHAR(10)

exception_setting

  • exception_id — BIGINT — Primary key — NOT NULL
  • student_id — VARCHAR(20) — NOT NULL
  • dept_code — VARCHAR(10)
  • from_admission_year — INT
  • forced_criteria_year — INT — NOT NULL
  • reason — TEXT
  • created_at — DATETIME — NOT NULL

linked_major_criteria

  • linked_major_id — INT — Primary key — NOT NULL
  • major_name — VARCHAR(100) — NOT NULL
  • major_type — ENUM('LINKED','CONVERGENCE') — NOT NULL
  • admission_year_range — VARCHAR(20) — NOT NULL
  • single_credits — INT
  • multi_credits — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL

open_major_status

  • student_id — VARCHAR(20) — Primary key — NOT NULL
  • source_type — ENUM('OPEN_MAJOR','BIOSYSTEM') — NOT NULL
  • major_decided — BOOLEAN — NOT NULL
  • decided_dept_code — VARCHAR(10)
  • exploration_credits — INT — NOT NULL

student_course

  • record_id — BIGINT — Primary key — NOT NULL
  • student_id — VARCHAR(20) — NOT NULL
  • course_code — VARCHAR(20) — Foreign key → course.course_code — NOT NULL
  • year_term — VARCHAR(10) — NOT NULL
  • grade_letter — VARCHAR(5)
  • grade_point — DECIMAL(4,2)
  • credits_earned — INT — NOT NULL
  • is_pass — BOOLEAN — NOT NULL