꾹머니

테이블 (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