d

Tables (10)

settlement_merchant_balances

  • merchant_id — UUID — Primary key — NOT NULL
  • account — VARCHAR(50) — Primary key — NOT NULL
  • asset_type — VARCHAR(20) — Primary key — NOT NULL
  • balance — DECIMAL — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

settlement_merchant_ledger

  • entry_id — UUID
  • ref_id — UUID — NOT NULL
  • merchant_id — UUID — NOT NULL
  • asset_type — VARCHAR(20) — NOT NULL
  • account — VARCHAR(50) — NOT NULL
  • type — VARCHAR(2) — NOT NULL
  • tx_type — VARCHAR(40) — NOT NULL
  • amount — DECIMAL — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

settlement_merchant_payments

  • payment_id — UUID
  • merchant_id — UUID — NOT NULL
  • asset_type — VARCHAR(20) — NOT NULL
  • amount — DECIMAL — NOT NULL
  • fee — DECIMAL — NOT NULL
  • net_amount — DECIMAL — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • tx_hash — VARCHAR(256)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

settlement_merchant_snapshots

  • merchant_id — UUID — Primary key — NOT NULL
  • date — DATE — Primary key — NOT NULL
  • asset_type — VARCHAR(20) — Primary key — NOT NULL
  • total_sales — DECIMAL — NOT NULL
  • total_fee — DECIMAL — NOT NULL
  • withdrawable_amount — DECIMAL — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

settlement_merchant_withdrawals

  • withdrawal_id — UUID
  • merchant_id — UUID — NOT NULL
  • asset_type — VARCHAR(20) — NOT NULL
  • amount — DECIMAL — NOT NULL
  • fee — DECIMAL — NOT NULL
  • net_amount — DECIMAL — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • tx_hash — VARCHAR(256)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

settlement_user_balances

  • user_id — UUID — Primary key — NOT NULL
  • account — VARCHAR(50) — Primary key — NOT NULL
  • asset_type — VARCHAR(20) — Primary key — NOT NULL
  • balance — DECIMAL — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

settlement_user_ledger

  • entry_id — UUID
  • ref_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • asset_type — VARCHAR(20) — NOT NULL
  • account — VARCHAR(50) — NOT NULL
  • type — VARCHAR(2) — NOT NULL
  • tx_type — VARCHAR(40) — NOT NULL
  • amount — DECIMAL — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

settlement_user_payments

  • payment_id — UUID
  • user_id — UUID — NOT NULL
  • merchant_id — UUID — NOT NULL
  • asset_type — VARCHAR(20) — NOT NULL
  • amount — DECIMAL — NOT NULL
  • fee — DECIMAL — NOT NULL
  • net_amount — DECIMAL — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • tx_hash — VARCHAR(256)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

settlement_user_refunds

  • refund_id — UUID
  • payment_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • asset_type — VARCHAR(20) — NOT NULL
  • amount — DECIMAL — NOT NULL
  • fee_rate — DECIMAL — NOT NULL
  • refund_amount — DECIMAL — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • tx_hash — VARCHAR(256)
  • requested_at — TIMESTAMP — NOT NULL
  • processed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

settlement_user_snapshots

  • user_id — UUID — Primary key — NOT NULL
  • date — DATE — Primary key — NOT NULL
  • asset_type — VARCHAR(20) — Primary key — NOT NULL
  • total_charged — DECIMAL — NOT NULL
  • total_spent — DECIMAL — NOT NULL
  • total_refunded — DECIMAL — NOT NULL
  • total_fee — DECIMAL — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL