꾹머니
테이블 (29)
app_config
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- effective_at — DATETIME(6) — NOT NULL
- config_key — VARCHAR(100) — NOT NULL
- config_value — JSON — NOT NULL
- changed_by — VARCHAR(50)
- change_reason — VARCHAR(200)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
누적 탭 진행도 (user_tap_progress)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- next_point_target — INT — NOT NULL
- cumulative_valid_tap_count — BIGINT — NOT NULL
- promotion_tap_baseline — BIGINT
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
데일리 미션 보상 (mission_reward)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- mission_code — VARCHAR(60) — NOT NULL
- period_key — VARCHAR(20) — NOT NULL
- reward_point_amount — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- achieved_at — DATETIME(6) — NOT NULL
- expires_at — DATETIME(6)
- claimed_at — DATETIME(6)
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
데일리 미션 정의 (mission_definition)
- id — BIGINT — 기본 키 — NOT NULL
- code — VARCHAR(60) — NOT NULL
- mission_type — VARCHAR(30) — NOT NULL
- period_type — VARCHAR(20) — NOT NULL
- name — VARCHAR(60) — NOT NULL
- description — VARCHAR(200)
- target_value — BIGINT — NOT NULL
- reward_point_amount — BIGINT — NOT NULL
- sort_order — INT — NOT NULL
- active — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
랭킹 부스트 실행 (ranking_boost_run)
- id — BIGINT — 기본 키 — NOT NULL
- run_date — DATE — NOT NULL
- scheduled_at — DATETIME(6) — NOT NULL
- event_type — VARCHAR(60) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- season_id — BIGINT
- selected_user_id — CHAR(36)
- leader_user_id — CHAR(36)
- real_score — BIGINT
- previous_score — BIGINT
- target_score — BIGINT
- boost_before — BIGINT
- boost_after — BIGINT
- score_increment — INT
- leader_rank_before — BIGINT
- leader_rank_after — BIGINT
- policy_snapshot — TEXT
- applied_at — DATETIME(6)
- skip_reason — VARCHAR(100)
- notification_delivery_id — BIGINT
- dispatch_claimed_at — DATETIME(6)
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
랭킹 시즌 (ranking_season)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- closed_at — DATETIME(6)
- ends_at — DATETIME(6)
- starts_at — DATETIME(6) — NOT NULL
- ranking_type — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- code — VARCHAR(80) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
랭킹 점수 (ranking_entry)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- season_id — BIGINT — 외래 키 → 랭킹 시즌.id — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- final_rank — BIGINT
- finalized_at — DATETIME(6)
- score — BIGINT — NOT NULL
- score_updated_at — DATETIME(6) — NOT NULL
- region_code — VARCHAR(40)
- ranking_boost_score — BIGINT — NOT NULL
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
보유 키캡 (user_keycap)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- keycap_id — BIGINT — 외래 키 → 키캡.id — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- equipped — BOOLEAN — NOT NULL
- shard_count — INT — NOT NULL
- completed_at — DATETIME(6)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
부스터 지급 (booster_grant)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- daily_sequence — INT — NOT NULL
- grant_date — DATE — NOT NULL
- multiplier — DECIMAL(5,2) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
- starts_at — DATETIME(6) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
순위 알림 기준 (notification_rank_state)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- baseline_rank — BIGINT — NOT NULL
- baseline_recorded_at — DATETIME(6) — NOT NULL
- season_id — BIGINT — NOT NULL
- user_id — CHAR(36) — NOT NULL
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
알림 발송 (notification_delivery)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- weekly_reset_batch_id — BIGINT — 외래 키 → 주간 초기화 알림 배치.id
- requested_at — DATETIME(6) — NOT NULL
- user_id — CHAR(36) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- notification_type — VARCHAR(60) — NOT NULL
- failure_code — VARCHAR(120)
- template_set_code — VARCHAR(120) — NOT NULL
- content_id — VARCHAR(255)
- context_json — TEXT — NOT NULL
- dedupe_key — VARCHAR(255) — NOT NULL
- failure_reason — TEXT
- provider_response_json — TEXT
- attempt_count — INT — NOT NULL
- next_attempt_at — DATETIME(6)
- last_attempt_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
알림 수신 설정 (notification_preference)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- enabled — BOOLEAN — NOT NULL
- user_id — CHAR(36) — NOT NULL
- agreement_status — VARCHAR(30) — NOT NULL
- notification_type — VARCHAR(60) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
온보딩 보상 (onboarding_reward_attempt)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- bonus_reward_keycap_id — BIGINT — 외래 키 → 키캡.id — NOT NULL
- reward_keycap_id — BIGINT — 외래 키 → 키캡.id — NOT NULL
- claimed_user_id — CHAR(36) — 외래 키 → 회원.id
- accepted_tap_count — INT — NOT NULL
- reward_point_amount — INT — NOT NULL
- claimed_at — DATETIME(6)
- expires_at — DATETIME(6) — NOT NULL
- opened_at — DATETIME(6) — NOT NULL
- tap_session_id — CHAR(36) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- request_hash — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
일별 랭킹 스냅샷 (daily_rank_snapshot)
- id — BIGINT — 기본 키 — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- season_id — BIGINT — 외래 키 → 랭킹 시즌.id — NOT NULL
- snapshot_date — DATE — NOT NULL
- rank_value — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
일별 탭 집계 (user_tap_daily)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- point_earned_amount — INT — NOT NULL
- tap_date — DATE — NOT NULL
- valid_tap_count — INT — NOT NULL
- total_valid_tap_count — INT — NOT NULL
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
주간 랭킹 보상 (weekly_ranking_reward)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- season_id — BIGINT — 외래 키 → 랭킹 시즌.id — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- source_final_rank — BIGINT — NOT NULL
- reward_rank — INT — NOT NULL
- final_score — BIGINT — NOT NULL
- point_amount — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
- claimed_at — DATETIME(6)
- viewed_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
주간 초기화 알림 배치 (weekly_ranking_reset_notification_batch)
- id — BIGINT — 기본 키 — NOT NULL
- season_id — BIGINT — 외래 키 → 랭킹 시즌.id — NOT NULL
- preference_cursor — BIGINT — NOT NULL
- enqueue_completed — BOOLEAN — NOT NULL
- completed — BOOLEAN — NOT NULL
- completed_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
출금 요청 (cashout_request)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- point_amount — BIGINT — NOT NULL
- toss_point_amount — BIGINT — NOT NULL
- idempotency_key — CHAR(36)
- status — VARCHAR(30) — NOT NULL
- toss_promotion_key — VARCHAR(255)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
키캡 (keycap)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- active — BOOLEAN — NOT NULL
- required_shard_count — INT — NOT NULL
- season — INT — NOT NULL
- sort_order — INT — NOT NULL
- grade — VARCHAR(20) — NOT NULL
- code — VARCHAR(60) — NOT NULL
- name — VARCHAR(80) — NOT NULL
- image_url — TEXT
- sound_url — TEXT
- acquisition_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
키캡 상자 개봉 이력 (keycap_box_open)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- keycap_id — BIGINT — 외래 키 → 키캡.id — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- completed — BOOLEAN — NOT NULL
- shard_count — INT — NOT NULL
- opened_at — DATETIME(6) — NOT NULL
- open_method — VARCHAR(30) — NOT NULL
- idempotency_key — VARCHAR(100) — NOT NULL
- ad_reward_id — VARCHAR(255)
- request_hash — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
키캡 상자 지갑 (keycap_box_account)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- ad_open_used_count — INT — NOT NULL
- box_balance — INT — NOT NULL
- free_open_used_count — INT — NOT NULL
- open_cycle_started_at — DATETIME(6) — NOT NULL
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
탭 묶음 (tap_batch)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- accepted_count — INT — NOT NULL
- bot_suspected — BOOLEAN — NOT NULL
- submitted_count — INT — NOT NULL
- sequence — BIGINT — NOT NULL
- tap_session_id — CHAR(36) — NOT NULL
- request_hash — VARCHAR(128) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
탭 세션 (user_tap_session)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- boxes_dropped_in_session — INT — NOT NULL
- next_box_target — INT — NOT NULL
- last_activity_at — DATETIME(6) — NOT NULL
- session_expires_at — DATETIME(6) — NOT NULL
- session_started_at — DATETIME(6) — NOT NULL
- session_valid_tap_count — BIGINT — NOT NULL
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
토스 계정 연결 (auth_identity)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- linked_at — DATETIME(6) — NOT NULL
- provider — VARCHAR(30) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
토스 약관 동의 이력 (toss_login_consent_history)
- id — BIGINT — 기본 키 — NOT NULL
- occurred_at — DATETIME(6) — NOT NULL
- user_id — CHAR(36) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- event_source — VARCHAR(30) — NOT NULL
- term_tag — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
포인트 계좌 (point_account)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- balance — BIGINT — NOT NULL
- lifetime_earned — BIGINT — NOT NULL
- lifetime_spent — BIGINT — NOT NULL
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
포인트 원장 (point_ledger)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- point_account_id — BIGINT — 외래 키 → 포인트 계좌.id — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- amount — BIGINT — NOT NULL
- idempotency_key — CHAR(36)
- entry_type — VARCHAR(30) — NOT NULL
- reason — VARCHAR(50) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
프로모션 지급 (promotion_grant)
- id — BIGINT — 기본 키 — NOT NULL
- public_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — 외래 키 → 회원.id — NOT NULL
- promotion_code — VARCHAR(80) — NOT NULL
- toss_promotion_code — VARCHAR(80)
- amount — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- hold_reason — VARCHAR(40)
- needs_review — BOOLEAN — NOT NULL
- toss_promotion_key — VARCHAR(255)
- toss_error_code — VARCHAR(40)
- failure_reason — VARCHAR(255)
- attempt_count — INT — NOT NULL
- poll_count — INT — NOT NULL
- next_attempt_at — DATETIME(6) — NOT NULL
- trigger_snapshot — INT
- granted_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
회원 (app_user)
- id — CHAR(36) — 기본 키 — NOT NULL
- onboarding_reward_claimed — BOOLEAN — NOT NULL
- last_login_at — DATETIME(6)
- onboarding_completed_at — DATETIME(6)
- withdrawn_at — DATETIME(6)
- status — VARCHAR(20) — NOT NULL
- nickname — TEXT
- nickname_normalized — TEXT
- profile_image_url — TEXT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL