꾸욱
테이블 (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