유레카 erd

테이블 (7)

daily_stats

  • stats_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • date — DATE — NOT NULL
  • today_score — INTEGER
  • today_solved_count — INTEGER
  • today_rank — INTEGER

monthly_stats

  • stats_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • year_month — VARCHAR(7) — NOT NULL
  • monthly_score — INTEGER
  • monthly_rank — INTEGER
  • previous_rank — INTEGER

problem

  • problem_id — BIGSERIAL
  • baekjoon_number — INTEGER — NOT NULL
  • title — VARCHAR(255)
  • level — INTEGER
  • link — VARCHAR(500)

solve_log

  • log_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • problem_id — BIGINT — NOT NULL
  • solved_at — TIMESTAMP

study_group

  • 그룹 ID (group_id) — BIGINT — 기본 키 — NOT NULL — PK
  • 그룹명 (group_name) — VARCHAR(100) — NOT NULL — UK ( 벡엔드 대면반/비대면반, 프론트엔드 대면반/비대면반

users

  • 그룹 ID (group_id2) — BIGINT — 외래 키 → study_group.그룹 ID — NOT NULL — PK
  • user_id — BIGSERIAL
  • slack_id — VARCHAR(100) — NOT NULL
  • baekjoon_id — VARCHAR(100) — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • group_id — BIGINT — NOT NULL
  • current_tier — INTEGER
  • total_solved_count — INTEGER
  • is_alert_agreed — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

weekly_stats

  • stats_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • year_week — VARCHAR(10) — NOT NULL
  • weekly_score — INTEGER
  • weekly_rank — INTEGER