ㄴ
Tables (4)
course (과목)
- id (기본키) — BIGINT — Primary key — NOT NULL
- student_id (참조키) — BIGINT — Foreign key → student.id — NOT NULL
- name (과목이름) — VARCHAR(100) — NOT NULL
- category (구분) — VARCHAR(40) — NOT NULL
- credit (취득학점) — DECIMAL(4,1) — NOT NULL
- designed_credit (취득설계학점) — INT
- grade (학점) — VARCHAR(5)
- is_english (영어과목구분) — TINYINT(1) — NOT NULL
- academic_year (수강년도) — SMALLINT — NOT NULL
- term (수강학기) — VARCHAR(10) — NOT NULL
- created_at (추가날짜) — DATETIME(6)
curriculum (커리큘럼)
- id (기본키) — BIGINT — Primary key — NOT NULL
- student_id (참조키) — BIGINT — Foreign key → student.id — NOT NULL
- category (구분) — VARCHAR(40) — NOT NULL
- earned_credits (취득학점) — INT — NOT NULL
- status (Pass/Fail) — VARCHAR(10) — NOT NULL
student (학생)
- id (기본키) — BIGINT — Primary key — NOT NULL
- password (비밀번호) — VARCHAR(255)
- email (실제 이메일 값 보관 (AES 암호)) — VARCHAR(255) — NOT NULL
- email_hash (조회/중복검사 (Sha256 암호)) — VARCHAR(255) — NOT NULL
- created_at (생성날짜) — DATETIME(6)
- updated_at (수정날짜) — DATETIME(6)
summary (통합 결과)
- id (기본키) — BIGINT — Primary key — NOT NULL
- student_id (참조키) — BIGINT — Foreign key → student.id
- pf_credits (pf 취득학점) — DOUBLE — NOT NULL
- pf_limit (pf 제한학점) — DOUBLE — NOT NULL
- pf_pass (pf Pass/Fail) — TINYINT(1) — NOT NULL
- total_credits (총 취득학점) — DOUBLE — NOT NULL
- total_pass (총 취득학점 Pass/Fail) — TINYINT(1) — NOT NULL
- gpa (GPA) — DOUBLE — NOT NULL
- eng_major_credits (영어전공취득학점) — INT — NOT NULL
- eng_liberal_credits (영어교양취득학점) — INT — NOT NULL
- english_pass (영어과목 Pass/Fail) — TINYINT(1) — NOT NULL
- grad_english_passed (졸업영어시험 Pass/Fail) — TINYINT(1) — NOT NULL
- dept_extra_passed (비교과 졸업요건 Pass/Fail) — TINYINT(1) — NOT NULL
- final_pass (전체 Pass/Fail) — TINYINT(1) — NOT NULL
- rows_json (JSON 스냅샷) — JSON