cs-arena
Tables (6)
badges
- id — BIGSERIAL
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- icon_url — VARCHAR(500)
- badge_type — badge_type_enum — NOT NULL
- unlock_criteria — JSONB
- created_at — TIMESTAMPTZ
categories
- id — BIGSERIAL
- name — VARCHAR(50) — NOT NULL
- display_name — VARCHAR(100) — NOT NULL
- description — TEXT
- is_active — BOOLEAN
- created_at — TIMESTAMPTZ
leaderboard_snapshots
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- rank — INT — NOT NULL
- tier_points — INT — NOT NULL
- tier — tier_enum — NOT NULL
- total_matches — INT
- win_count — INT
- win_rate — FLOAT
- snapshot_date — DATE — NOT NULL
- created_at — TIMESTAMPTZ
matchmaking_queue
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- tier — tier_enum — NOT NULL
- tier_points — INT — NOT NULL
- search_range — INT
- status — queue_status_enum — NOT NULL
- joined_at — TIMESTAMPTZ
- matched_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ
user_badges
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- badge_id — BIGINT — NOT NULL
- unlocked_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ
users
- id — BIGSERIAL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- oauth_provider — VARCHAR(50)
- oauth_id — VARCHAR(255)
- tier_points — INT — NOT NULL
- tier — tier_enum — NOT NULL
- last_login_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ