장바구니/주문서

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