꾸욱v1.0.0
테이블 (13)
customer_wallet
- id — BIGINT — 기본 키 — NOT NULL
- phone — VARCHAR(30) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL — ACTIVE | BLOCKED
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
issuance_request
- id — BIGINT — 기본 키 — NOT NULL
- store_id — BIGINT — 외래 키 → store.id — NOT NULL
- wallet_id — BIGINT — 외래 키 → customer_wallet.id — NOT NULL
- wallet_stamp_card_id — BIGINT — 외래 키 → wallet_stamp_card.id — NOT NULL
- status — VARCHAR(20) — NOT NULL — PENDING | APPROVED | REJECTED | EXPIRED | CANCELLED
- idempotency_key — VARCHAR(100)
- expires_at — DATETIME(6) — NOT NULL
- approved_at — DATETIME(6)
- rewards_issued — INT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
oauth_account
- id — BIGINT — 기본 키 — NOT NULL
- provider — VARCHAR(20) — NOT NULL — GOOGLE | KAKAO | NAVER
- provider_id — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- name — VARCHAR(100)
- owner_account_id — BIGINT — 외래 키 → owner_account.id — FK → owner_account (nullable)
- customer_wallet_id — BIGINT — 외래 키 → customer_wallet.id — FK → customer_wallet (nullable)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
owner_account
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255)
- password_hash — VARCHAR(255)
- name — VARCHAR(100)
- nickname — VARCHAR(50)
- phone_number — VARCHAR(255)
- admin — TINYINT(1) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
redeem_event
- id — BIGINT — 기본 키 — NOT NULL
- result — VARCHAR(20) — NOT NULL — SUCCESS | FAILED
- occurred_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- store_id — BIGINT
- wallet_id — BIGINT
- wallet_reward_id — BIGINT
refresh_token
- id — BIGINT — 기본 키 — NOT NULL
- token_hash — VARCHAR(64) — NOT NULL
- token_type — VARCHAR(20) — NOT NULL — OWNER | CUSTOMER
- subject_id — BIGINT — NOT NULL — Polymorphic: owner_account.id or customer_wallet.id
- email — VARCHAR(255)
- is_admin — TINYINT(1)
- expires_at — DATETIME(6) — NOT NULL
- revoked — TINYINT(1) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
stamp_cards
- id — BIGINT — 기본 키 — NOT NULL
- store_id — BIGINT — 외래 키 → store.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- status — VARCHAR(20) — NOT NULL — DRAFT | ACTIVE | ARCHIVED
- goal_stamp_count — INT — NOT NULL
- required_stamps — INT
- reward_name — VARCHAR(255)
- reward_quantity — INT
- expire_days — INT
- design_type — VARCHAR(20) — NOT NULL — COLOR | IMAGE | PUZZLE | CUSTOM
- design_json — MEDIUMTEXT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
stamp_event
- id — BIGINT — 기본 키 — NOT NULL
- type — VARCHAR(30) — NOT NULL — ISSUED | MIGRATED | MANUAL_ADJUST
- delta — INT — NOT NULL
- reason — VARCHAR(255)
- occurred_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- store_id — BIGINT
- stamp_card_id — BIGINT
- wallet_stamp_card_id — BIGINT
- issuance_request_id — BIGINT
- stamp_migration_request_id — BIGINT
stamp_migration_request
- id — BIGINT — 기본 키 — NOT NULL
- customer_wallet_id — BIGINT — 외래 키 → customer_wallet.id — NOT NULL
- store_id — BIGINT — 외래 키 → store.id — NOT NULL
- image_data — MEDIUMTEXT — NOT NULL
- claimed_stamp_count — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL — SUBMITTED | APPROVED | REJECTED | CANCELED
- approved_stamp_count — INT
- reject_reason — VARCHAR(255)
- requested_at — DATETIME(6) — NOT NULL
- processed_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
store
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255)
- phone — VARCHAR(50)
- place_ref — VARCHAR(100)
- icon_image_base64 — LONGTEXT
- description — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL — DRAFT | LIVE | SUSPENDED | DELETED
- owner_account_id — BIGINT — 외래 키 → owner_account.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
store_audit_log
- id — BIGINT — 기본 키 — NOT NULL
- store_id — BIGINT — 외래 키 → store.id — NOT NULL
- action — VARCHAR(30) — NOT NULL — CREATED | APPROVED | SUSPENDED | UNSUSPENDED | DELETED | UPDATED
- previous_status — VARCHAR(20) — DRAFT | LIVE | SUSPENDED | DELETED
- new_status — VARCHAR(20) — DRAFT | LIVE | SUSPENDED | DELETED
- performed_by — BIGINT — Polymorphic: owner_account.id or admin id
- performed_by_type — VARCHAR(20) — NOT NULL — OWNER | ADMIN
- detail — TEXT
- created_at — DATETIME(6) — NOT NULL
wallet_reward
- id — BIGINT — 기본 키 — NOT NULL
- wallet_id — BIGINT — 외래 키 → customer_wallet.id — NOT NULL
- stamp_card_id — BIGINT — 외래 키 → stamp_cards.id — NOT NULL
- store_id — BIGINT — 외래 키 → store.id — NOT NULL
- status — VARCHAR(20) — NOT NULL — AVAILABLE | REDEEMED | EXPIRED
- issued_at — DATETIME(6) — NOT NULL
- expires_at — DATETIME(6)
- redeemed_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
wallet_stamp_card
- id — BIGINT — 기본 키 — NOT NULL
- customer_wallet_id — BIGINT — 외래 키 → customer_wallet.id — NOT NULL
- store_id — BIGINT — 외래 키 → store.id — NOT NULL
- stamp_card_id — BIGINT — 외래 키 → stamp_cards.id — NOT NULL
- stamp_count — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL — ACTIVE | COMPLETED
- last_stamped_at — DATETIME(6)
- completed_at — DATETIME(6)
- version — BIGINT — NOT NULL — Optimistic lock
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL