유레카 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