꾸욱 v0.1.0

테이블 (10)

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
  • updated_at — DATETIME(6) — NOT NULL
  • store_id — BIGINT — 외래 키 → store.id — NOT NULL
  • wallet_stamp_card_id — BIGINT — 외래 키 → wallet_stamp_card.id — NOT NULL
  • wallet_id — BIGINT — 외래 키 → customer_wallet.id — NOT NULL

owner_account

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

redeem_event

  • 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
  • wallet_id — BIGINT — NOT NULL
  • store_id — BIGINT — NOT NULL
  • wallet_reward_id (id2) — BIGINT — 외래 키 → wallet_reward.id — NOT NULL

stamp_card

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • goal_stamp_count — INT — NOT NULL
  • required_stamps
  • reward_name
  • reward_quantity
  • expire_days
  • 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
  • wallet_stamp_card_id — BIGINT
  • stamp_card_id — BIGINT — NOT NULL
  • store_id — BIGINT — NOT NULL

stamp_migration_request

  • 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
  • customer_wallet_id — BIGINT — 외래 키 → customer_wallet.id — NOT NULL
  • store_id — BIGINT — 외래 키 → store.id — 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
  • 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
  • stamp_card_id — BIGINT — NOT NULL
  • store_id — BIGINT — NOT NULL

wallet_stamp_card

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