KHJ
Tables (9)
categories
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
daily_streaks
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL — 일별 기록
- solved_date — DATE — NOT NULL
- correct_count — INT — NOT NULL
- wrong_count — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL — CORRECT, WRONG_ONLY
extension_links
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL — 익스텐션 1개 연동
- link_code_id — BIGINT — Foreign key → link_codes.id — NOT NULL — 코드로 연결됨
- linked_at — DATETIME — NOT NULL
link_codes
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL — 인증 코드 1개 보유
- code — VARCHAR(64) — NOT NULL
- issued_at — DATETIME — NOT NULL
problem_categories
- problem_id — BIGINT — Foreign key → problems.id — NOT NULL
- category_id — BIGINT — Foreign key → categories.id — NOT NULL
problems
- id — BIGINT — Primary key — NOT NULL
- site_name — VARCHAR(30) — NOT NULL — PROGRAMMERS, CODEUP
- external_id — VARCHAR(50) — NOT NULL — site_name과 복합 UK
- title — VARCHAR(255) — NOT NULL
- url — VARCHAR(500) — NOT NULL
- level — VARCHAR(30) — nullable
- constraints — TEXT — nullable
- solver_count — INT — NOT NULL — 정답 처리 사용자 수
- last_solved_at — DATETIME — nullable, 문제 리스트 정렬용
- max_runtime_ms — DECIMAL(10, 3) — nullable, 효율 보너스 기준값
- max_memory_kb — INT — nullable, 효율 보너스 기준값
submissions
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL — 제출
- problem_id — BIGINT — Foreign key → problems.id — NOT NULL — 제출 대상
- code — TEXT — NOT NULL — 제출 코드 원문
- code_hash — VARCHAR(64) — NOT NULL — 중복 판정용, user+problem+solved_at과 복합 UK
- language — VARCHAR(30) — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- runtime_ms — DECIMAL(10, 3) — nullable, 오답시 없음
- memory_kb — INT — nullable, 오답시 없음
- time_complexity — VARCHAR(50) — nullable
- space_complexity — VARCHAR(50) — nullable
- solved_at — DATETIME — NOT NULL
- collected_at — DATETIME — NOT NULL
- collect_status — VARCHAR(20) — NOT NULL — SUCCESS, PARTIAL, FAILED
- deleted_at — DATETIME — nullable, ADMIN-4 소프트 삭제
user_stats
- user_id — BIGINT — Foreign key → users.id — NOT NULL — 통계 보유
- total_submission_count — INT — NOT NULL
- correct_submission_count — INT — NOT NULL
- solved_problem_count — INT — NOT NULL
- accuracy — DECIMAL(5, 4) — NOT NULL
- ranking_score — DECIMAL(12, 4) — NOT NULL — Redis 유실시 복구 기준
- tier — VARCHAR(20) — NOT NULL
- current_streak — INT — NOT NULL
- longest_streak — INT — NOT NULL
- last_correct_date — DATE
users
- id — BIGINT — Primary key — NOT NULL
- github_user_id — BIGINT — NOT NULL — GitHub 숫자 id, 불변
- github_login — VARCHAR(100) — NOT NULL — 표시용 ID, 변경 가능
- avatar_url — VARCHAR(500)
- role — VARCHAR(20) — NOT NULL — USER, ADMIN
- created_at — DATETIME — NOT NULL — 가입일