ㄴ

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