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