꾸욱

테이블 (12)

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
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

issuance_request

  • id — BIGINT — 기본 키 — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • idempotency_key — VARCHAR(100)
  • expires_at — DATETIME(6) — NOT NULL
  • approved_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • store_id — BIGINT — 외래 키 → store.id — NOT NULL
  • stamp_card_id — BIGINT — 외래 키 → wallet_stamp_card.id — NOT NULL

owner_account (사장님)

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

redeem_event

  • id — BIGINT — 기본 키 — NOT NULL
  • wallet_id — BIGINT — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • result — VARCHAR(20) — NOT NULL
  • occurred_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • redeem_session_id — BIGINT — 외래 키 → redeem_session.id — NOT NULL

redeem_session

  • id — BIGINT — 기본 키 — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • expires_at — DATETIME(6) — NOT NULL
  • completed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • wallet_reward_id — BIGINT — 외래 키 → wallet_reward.id — NOT NULL

reward_rule

  • id — BIGINT — 기본 키 — NOT NULL
  • required_stamps — INT — NOT NULL
  • reward_name — VARCHAR(100) — NOT NULL
  • reward_quantity — INT — NOT NULL
  • expire_days — INT
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • stamp_card_id — BIGINT — 외래 키 → stamp_card.id — NOT NULL

stamp_card

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • status — VARCHAR(20), "DRAFT/ACTIVE/PAUSED/ARCHIVED" — NOT NULL
  • goal_stamp_count — INT — NOT NULL
  • design_json — TEXT
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • store_id — BIGINT — 외래 키 → store.id — NOT NULL

stamp_event

  • id — BIGINT — 기본 키 — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • 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
  • stamp_card_id — BIGINT — 외래 키 → issuance_request.id — NOT NULL
  • store_id — BIGINT — 외래 키 → wallet_stamp_card.id — NOT NULL
  • issuance_request_id — BIGINT — 외래 키 → store.id — NOT NULL

stamp_migration_request

  • id — BIGINT — 기본 키 — NOT NULL
  • wallet_id — BIGINT — NOT NULL
  • store_id — BIGINT — NOT NULL
  • stamp_card_id — BIGINT — NOT NULL
  • image_url — VARCHAR(1024) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • 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)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • owner_account_id — BIGINT — 외래 키 → owner_account.id — NOT NULL

wallet_reward

  • id — BIGINT — 기본 키 — NOT NULL
  • store_id — BIGINT — NOT NULL
  • stamp_card_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • 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_id — BIGINT — 외래 키 → customer_wallet.id — NOT NULL

wallet_stamp_card

  • id — BIGINT — 기본 키 — NOT NULL
  • stamp_count — INT — NOT NULL
  • reward_available — TINYINT(1) — NOT NULL
  • last_stamped_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • wallet_id — BIGINT — 외래 키 → customer_wallet.id — NOT NULL
  • store_id — BIGINT — 외래 키 → store.id — NOT NULL
  • stamp_card_id — BIGINT — 외래 키 → stamp_card.id — NOT NULL