테스트

테이블 (16)

analytics_overview

  • id — UUID
  • user_id — UUID — NOT NULL
  • solved — INT
  • incorrect — INT
  • retried — INT
  • accuracy — FLOAT
  • streak_days — INT

auth_tokens

  • access_token — TEXT
  • user_id — UUID — NOT NULL

badges

  • id — UUID
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100)
  • description — TEXT
  • icon_url — TEXT

friends

  • id — UUID
  • user_id — UUID — NOT NULL
  • friend_id — UUID — NOT NULL
  • status — VARCHAR(20)
  • created_at — TIMESTAMP

hints

  • id — UUID
  • problem_id — UUID — NOT NULL
  • stage — VARCHAR(20)
  • content — TEXT
  • order_num — INT
  • created_by — VARCHAR(20)
  • created_at — TIMESTAMP

language_usage

  • user_id — UUID — NOT NULL
  • language — VARCHAR(50)
  • ratio — FLOAT

level_distribution

  • user_id — UUID — NOT NULL
  • level — INT
  • solved — INT

problem_algorithm_tags

  • problem_id — UUID — NOT NULL
  • algorithm_name — VARCHAR(100) — NOT NULL

problem_recommendations

  • id — UUID
  • problem_id — UUID — NOT NULL
  • reason — TEXT
  • rank_score — FLOAT

problem_solved

  • id — UUID
  • problem_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • verdict — VARCHAR(10)
  • date — DATE

problem_types

  • problem_id — UUID — NOT NULL
  • type_name — VARCHAR(100) — NOT NULL

problems

  • id — UUID
  • slug — VARCHAR(100) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • difficulty — INT
  • accuracy — FLOAT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

runs

  • run_id — UUID
  • problem_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • language — VARCHAR(50)
  • status — VARCHAR(20)
  • stdout_url — TEXT
  • stderr_url — TEXT
  • created_at — TIMESTAMP

submissions

  • id — UUID
  • problem_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • language — VARCHAR(50)
  • status — VARCHAR(20)
  • verdict — VARCHAR(5)
  • runtime_ms — INT
  • memory_kb — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_badges

  • user_id — UUID — 기본 키 — NOT NULL
  • badge_id — UUID — 기본 키 — NOT NULL

users

  • id — UUID
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • level — INT
  • xp — INT
  • display_name — VARCHAR(100)
  • avatar_url — TEXT
  • timezone — VARCHAR(50)
  • bio — TEXT