ㅅㄷㄴㅅ

Tables (13)

entry

  • id — BIGINT — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key → event.id — NOT NULL
  • user_id — BIGINT — Foreign key → virtual_user.id — NOT NULL
  • entry_mode — VARCHAR(20) — NOT NULL
  • prize_id — BIGINT — Foreign key → prize.id
  • ticket_amount — INT — NOT NULL
  • unit_cost — INT — NOT NULL
  • entry_weight — INT — NOT NULL
  • entry_scope_key — BIGINT
  • status — VARCHAR(20) — NOT NULL
  • excluded_reason — VARCHAR(200)
  • ledger_id — BIGINT — Foreign key → ticket_ledger.id
  • refunded_at — DATETIME
  • idempotency_key — VARCHAR(160) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • version — BIGINT — NOT NULL

event

  • id — BIGINT — Primary key — NOT NULL

event_referral_code

  • event_id — BIGINT — Foreign key → event.id — NOT NULL
  • user_id — BIGINT — Foreign key → virtual_user.id — NOT NULL
  • code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

game

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — VARCHAR(300)
  • active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

game_play_result

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → virtual_user.id — NOT NULL
  • game_id — BIGINT — Foreign key → game.id — NOT NULL
  • score — INT — NOT NULL
  • success — BOOLEAN — NOT NULL
  • played_at — DATETIME — NOT NULL

mission

  • id — BIGINT — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key → event.id
  • mission_scope_key — BIGINT
  • code — VARCHAR(50) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — VARCHAR(300)
  • mission_type — VARCHAR(20) — NOT NULL
  • repeat_cycle — VARCHAR(20) — NOT NULL
  • reward_tickets — INT — NOT NULL
  • active — BOOLEAN — NOT NULL
  • starts_at — DATETIME
  • ends_at — DATETIME
  • quiz_question — VARCHAR(300)
  • quiz_choices — JSON
  • quiz_answer_index — INT
  • survey_questions — JSON
  • external_check_code — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

mission_completion

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → virtual_user.id — NOT NULL
  • mission_id — BIGINT — Foreign key → mission.id — NOT NULL
  • business_date — DATE — NOT NULL
  • response — JSON
  • ledger_id — BIGINT — Foreign key → ticket_ledger.id — NOT NULL
  • created_at — DATETIME — NOT NULL

prize

  • id — BIGINT — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key → event.id — NOT NULL

referral_redemption

  • event_id — BIGINT — Foreign key → event.id — NOT NULL
  • invitee_user_id — BIGINT — Foreign key → virtual_user.id — NOT NULL
  • inviter_user_id — BIGINT — Foreign key → virtual_user.id — NOT NULL
  • redeemed_at — DATETIME — NOT NULL

ticket_ledger

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → virtual_user.id — NOT NULL
  • seq — BIGINT — NOT NULL
  • delta — INT — NOT NULL
  • balance_after — INT — NOT NULL
  • reason_code — VARCHAR(30) — NOT NULL
  • ref_type — VARCHAR(30) — NOT NULL
  • ref_id — BIGINT
  • memo — VARCHAR(200)
  • idempotency_key — VARCHAR(160) — NOT NULL
  • created_at — DATETIME — NOT NULL

user_game_stat

  • user_id — BIGINT — Foreign key → virtual_user.id — NOT NULL
  • game_id — BIGINT — Foreign key → game.id — NOT NULL
  • best_score — INT — NOT NULL
  • cumulative_score — BIGINT — NOT NULL
  • play_count — INT — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_ticket_balance

  • user_id — BIGINT — Foreign key → virtual_user.id — NOT NULL
  • balance — INT — NOT NULL
  • last_seq — BIGINT — NOT NULL
  • version — BIGINT — NOT NULL
  • updated_at — DATETIME — NOT NULL

virtual_user

  • id — BIGINT — Primary key — NOT NULL