장바구니/주문서
테이블 (9)
reward
- id — BIGINT — 기본 키 — NOT NULL
- barcode_number — VARCHAR(255) — NOT NULL
- issued_at — DATETIME(6) — NOT NULL
- expiration_date — DATE — NOT NULL
- face_value — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- state — VARCHAR(64) — NOT NULL
- used_at — DATETIME(6)
- expired_at — DATETIME(6)
- disposed_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
reward_shop_contribution
- id — BIGINT — 기본 키 — NOT NULL
- reward_id — BIGINT — 외래 키 → reward.id — NOT NULL
- stamp_count — BIGINT — NOT NULL
- deposit — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
shop_payment_account_history
- id — BIGINT — 기본 키 — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
stamp
- id — BIGINT — 기본 키 — NOT NULL
- deposit — BIGINT — NOT NULL
- expiration_date — DATE — NOT NULL
- state — VARCHAR(64) — NOT NULL
- head_office_deposit_support — BIGINT
- stamp_exchange_id — BIGINT — 외래 키 → stamp_exchange.id
- exchanged_at — DATETIME(6)
- expired_at — DATETIME(6)
- disposed_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
stamp_entry
- id — BIGINT — 기본 키 — NOT NULL
- type — VARCHAR(64) — NOT NULL
- stamp_issue_id — BIGINT — 외래 키 → stamp_issue.id — NOT NULL
- stamp_count — BIGINT — NOT NULL
- unit_deposit — BIGINT — NOT NULL
- paid_deposit — BIGINT — NOT NULL
- debt_deposit — BIGINT — NOT NULL
- at — DATETIME(6) — NOT NULL
- at_date — DATE — NOT NULL
- is_delayed — BOOLEAN
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
stamp_exchange
- id — BIGINT — 기본 키 — NOT NULL
- reward_id — BIGINT — 외래 키 → reward.id — NOT NULL
- exchanged_at — DATETIME(6) — NOT NULL
- canceled_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
stamp_exchange_stamp_ids
- stamp_exchange_id — BIGINT — 외래 키 → stamp_exchange.id — NOT NULL
- stamp_ids — BIGINT — 외래 키 → stamp.id — NOT NULL
stamp_issue
- id — BIGINT — 기본 키 — NOT NULL
- external_key — BIGINT
- stamp_count — BIGINT — NOT NULL
- type — VARCHAR(64) — NOT NULL
- unit_deposit — BIGINT — NOT NULL
- paid_deposit — BIGINT — NOT NULL
- deposit_debt — BIGINT — NOT NULL
- issued_at — DATETIME(6) — NOT NULL
- canceled_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
stamp_issue_issued_stamp_ids
- stamp_issue_id — BIGINT — 외래 키 → stamp_issue.id — NOT NULL
- issued_stamp_ids — BIGINT — 외래 키 → stamp.id — NOT NULL