졸업요건
테이블 (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