ㅅㄷㄴㅅ
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