꾸욱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