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