point

Tables (7)

point_idempotency

  • id — BIGINT — Primary key — NOT NULL
  • transaction_type — VARCHAR(30) — NOT NULL
  • request_id — VARCHAR(64) — NOT NULL
  • point_operation_id — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

point_lot

  • id — BIGINT — Primary key — NOT NULL
  • point_operation_id — BIGINT — NOT NULL
  • wallet_id — BIGINT — NOT NULL
  • original_amount — BIGINT — NOT NULL
  • remaining_amount — BIGINT — NOT NULL
  • earn_type — VARCHAR(40) — NOT NULL
  • expire_date — DATE — NOT NULL
  • earn_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

point_lot_entry

  • id — BIGINT — Primary key — NOT NULL
  • point_lot_id — BIGINT — NOT NULL
  • point_operation_id — BIGINT — NOT NULL
  • transaction_type — VARCHAR(30) — NOT NULL
  • amount — BIGINT — NOT NULL
  • lot_balance_after — BIGINT — NOT NULL
  • transaction_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

point_operation

  • id — BIGINT — Primary key — NOT NULL
  • wallet_id — BIGINT — NOT NULL
  • transaction_type — VARCHAR(30) — NOT NULL
  • amount — BIGINT — NOT NULL
  • balance_after — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • display_description — VARCHAR(200)
  • internal_memo — VARCHAR(500)
  • order_id — VARCHAR(64)
  • transaction_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

point_policy

  • id — BIGINT — Primary key — NOT NULL
  • policy_key — VARCHAR(40) — NOT NULL
  • policy_value — BIGINT — NOT NULL
  • effective_from — DATETIME(6) — NOT NULL
  • effective_to — DATETIME(6)
  • description — VARCHAR(200)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

point_use_cancel_restoration

  • id — BIGINT — Primary key — NOT NULL
  • use_cancel_operation_id — BIGINT — NOT NULL
  • source_use_lot_entry_id — BIGINT — NOT NULL
  • restore_lot_entry_id — BIGINT — NOT NULL
  • expire_lot_entry_id — BIGINT
  • new_lot_id — BIGINT
  • restoration_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

point_wallet

  • id — BIGINT — Primary key — NOT NULL
  • user_id — VARCHAR(64) — NOT NULL
  • available_balance — BIGINT — NOT NULL
  • next_expire_date — DATE
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL