졸업요건

테이블 (18)

alert

  • alert_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • student_id — VARCHAR2(20) — NOT NULL
  • alert_type — VARCHAR2(20) — NOT NULL
  • message — VARCHAR2(200) — NOT NULL
  • created_at — DATE — NOT NULL
  • read_yn — CHAR(1) — NOT NULL

class_timeslot

  • timeslot_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • offering_id — VARCHAR2(20) — NOT NULL
  • day_of_week — VARCHAR2(3) — NOT NULL
  • start_period — NUMBER(2) — NOT NULL
  • end_period — NUMBER(2) — NOT NULL

completed_course

  • completed_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • student_id — VARCHAR2(20) — NOT NULL
  • course_no — VARCHAR2(10) — NOT NULL
  • year — NUMBER(4) — NOT NULL
  • semester — VARCHAR2(6) — NOT NULL
  • grade — VARCHAR2(2) — NOT NULL
  • earned_credit — NUMBER(2) — NOT NULL
  • area_code — VARCHAR2(20) — NOT NULL
  • retake_yn — CHAR(1) — NOT NULL
  • source_type — VARCHAR2(10) — NOT NULL
  • created_at — DATE — NOT NULL

course

  • course_no — VARCHAR2(10) — 기본 키 — NOT NULL
  • course_name — VARCHAR2(100) — NOT NULL
  • credit — NUMBER(1) — NOT NULL
  • default_area — VARCHAR2(20) — NOT NULL
  • english_yn — CHAR(1) — NOT NULL
  • created_at — DATE — NOT NULL

course_offering

  • offering_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • course_no — VARCHAR2(10) — NOT NULL
  • year — NUMBER(4) — NOT NULL
  • semester — VARCHAR2(6) — NOT NULL
  • section_no — VARCHAR2(10) — NOT NULL
  • professor — VARCHAR2(30)
  • room — VARCHAR2(20)
  • capacity — NUMBER(3) — NOT NULL

equivalent_course_map

  • equiv_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • course_no — VARCHAR2(10) — NOT NULL
  • equiv_course_no — VARCHAR2(10) — NOT NULL
  • relation_type — VARCHAR2(12) — NOT NULL
  • priority — NUMBER(2) — NOT NULL

major

  • major_id — VARCHAR2(10) — 기본 키 — NOT NULL
  • major_name — VARCHAR2(50) — NOT NULL
  • dept_name — VARCHAR2(50)
  • created_at — DATE

prerequisite_relation

  • prereq_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • course_no — VARCHAR2(10) — NOT NULL
  • prereq_course_no — VARCHAR2(10) — NOT NULL
  • relation_type — VARCHAR2(10) — NOT NULL
  • allow_concurrent_yn — CHAR(1) — NOT NULL

recommend_run

  • run_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • student_id — VARCHAR2(20) — NOT NULL
  • target_year — NUMBER(4) — NOT NULL
  • target_semester — VARCHAR2(6) — NOT NULL
  • algo_version — VARCHAR2(20) — NOT NULL
  • created_at — DATE — NOT NULL
  • expires_at — DATE

recommended_course

  • reco_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • run_id — VARCHAR2(20) — NOT NULL
  • offering_id — VARCHAR2(20) — NOT NULL
  • rank_no — NUMBER(2) — NOT NULL
  • reason_code — VARCHAR2(20)
  • reason_text — VARCHAR2(200)
  • conflict_yn — CHAR(1) — NOT NULL
  • locked_yn — CHAR(1) — NOT NULL
  • excluded_yn — CHAR(1) — NOT NULL

requirement_area

  • area_code — VARCHAR2(20) — 기본 키 — NOT NULL
  • area_name — VARCHAR2(50) — NOT NULL
  • area_kind — VARCHAR2(10) — NOT NULL

requirement_check

  • check_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • student_id — VARCHAR2(20) — NOT NULL
  • version_id — VARCHAR2(20) — NOT NULL
  • checked_at — DATE — NOT NULL
  • overall_status — VARCHAR2(10) — NOT NULL
  • progress_pct — NUMBER(5,2) — NOT NULL
  • risk_score — NUMBER(5,2) — NOT NULL
  • memo — VARCHAR2(200)

requirement_check_detail

  • detail_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • check_id — VARCHAR2(20) — NOT NULL
  • requirement_id — VARCHAR2(20) — NOT NULL
  • earned_credits — NUMBER(3) — NOT NULL
  • missing_credits — NUMBER(3) — NOT NULL
  • satisfied_yn — CHAR(1) — NOT NULL
  • message — VARCHAR2(200)

student

  • student_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • user_id — VARCHAR2(20) — NOT NULL
  • admission_year — NUMBER(4) — NOT NULL
  • primary_major_id — VARCHAR2(10) — NOT NULL
  • current_grade — NUMBER(1) — NOT NULL
  • total_earned_credit — NUMBER(3) — NOT NULL
  • gpa — NUMBER(3,2) — NOT NULL
  • created_at — DATE — NOT NULL

student_major_history

  • history_id — VARCHAR2(10) — 기본 키 — NOT NULL
  • end_year — NUMBER(4)
  • student_id — VARCHAR2(20)
  • major_id — VARCHAR2(10)
  • major_type — VARCHAR2(10)
  • start_year — NUMBER(4)

transcript_extract

  • extraction_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • transcript_id — VARCHAR2(20) — NOT NULL
  • parser_version — VARCHAR2(20) — NOT NULL
  • extracted_json — CLOB
  • status — VARCHAR2(10) — NOT NULL
  • started_at — DATE — NOT NULL
  • ended_at — DATE
  • error_msg — VARCHAR2(200)

transcript_file

  • transcript_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • student_id — VARCHAR2(20) — NOT NULL
  • file_name — VARCHAR2(200) — NOT NULL
  • stored_path — VARCHAR2(300) — NOT NULL
  • uploaded_at — DATE — NOT NULL
  • status — VARCHAR2(10) — NOT NULL

user_account

  • user_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • pw — VARCHAR2(200) — NOT NULL
  • name — VARCHAR2(30) — NOT NULL
  • email — VARCHAR2(60) — NOT NULL
  • role — VARCHAR2(20) — NOT NULL
  • status — VARCHAR2(10) — NOT NULL
  • failed_login_cnt — NUMBER(2) — NOT NULL
  • last_login_at — DATE
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL
  • privacy_agree_yn — CHAR(1) — NOT NULL
  • privacy_agree_ver — VARCHAR2(20) — NOT NULL