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