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 — 가입일