pbm
Tables (18)
agents
- id — BIGINT — Primary key — NOT NULL
- agent_id — VARCHAR(255) — NOT NULL
- agent_address — VARCHAR(42)
- name — VARCHAR(255) — NOT NULL
- wallet_access — BOOLEAN — NOT NULL
- spent — NUMERIC(38,6) — NOT NULL
- payer_wallet — VARCHAR(42) — Foreign key → beneficiaries.wallet — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
auth_nonces
- token_hash — VARCHAR(64) — Primary key — NOT NULL
- wallet — VARCHAR(42) — Foreign key → beneficiaries.wallet — NOT NULL
- expires_at — TIMESTAMP WITH TIME ZONE — NOT NULL
auth_sessions
- token_hash — VARCHAR(64) — Primary key — NOT NULL
- wallet — VARCHAR(42) — Foreign key → beneficiaries.wallet — NOT NULL
- expires_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- step_up_complete — BOOLEAN — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
beneficiaries
- id — VARCHAR(255) — Primary key — NOT NULL
- wallet — VARCHAR(42) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- business_name — VARCHAR(255)
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
binding_ceremonies
- token_hash — VARCHAR(64) — Primary key — NOT NULL
- wallet — VARCHAR(42) — Foreign key → beneficiaries.wallet — NOT NULL
- agent_address — VARCHAR(42) — Foreign key → agents.agent_address — NOT NULL
- token_id — NUMERIC(78,0) — Foreign key → pbms.token_id — NOT NULL
- expires_at — TIMESTAMP WITH TIME ZONE — NOT NULL
deployments
- id — VARCHAR(255) — Primary key — NOT NULL
- wallet — VARCHAR(42) — Foreign key → beneficiaries.wallet — NOT NULL
- status — VARCHAR(255) — NOT NULL
- worker_url — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
mandate_selected_vendors
- mandate_id — VARCHAR(255) — Foreign key → mandates.id — NOT NULL
- vendor_key — VARCHAR(50) — Foreign key → vendors.vendor_key — NOT NULL
mandates
- id — VARCHAR(255) — Primary key — NOT NULL
- payer_wallet — VARCHAR(42) — Foreign key → beneficiaries.wallet — NOT NULL
- agent_address — VARCHAR(42) — Foreign key → agents.agent_address
- total_budget — NUMERIC(38,6) — NOT NULL
- max_per_tx — NUMERIC(38,6) — NOT NULL
- daily_limit — NUMERIC(38,6) — NOT NULL
- delegation_value — INTEGER — NOT NULL
- delegation_unit — VARCHAR(20) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- signature_raw — TEXT
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
onchain_mandate_conditions
- token_id — NUMERIC(78,0) — Foreign key → pbms.token_id — NOT NULL
- mandate_id — VARCHAR(255) — Foreign key → mandates.id
- agent_address — VARCHAR(42) — Foreign key → agents.agent_address
- auto_limit — NUMERIC(38,6)
- expires_at — TIMESTAMP WITH TIME ZONE
- updated_at — TIMESTAMP WITH TIME ZONE
onchain_mandate_vendors
- token_id — NUMERIC(78,0) — Foreign key → onchain_mandate_conditions.token_id — NOT NULL
- vendor_key — VARCHAR(50) — Foreign key → vendors.vendor_key — NOT NULL
passkey_credentials
- credential_id — VARCHAR(1024) — Primary key — NOT NULL
- wallet — VARCHAR(42) — Foreign key → beneficiaries.wallet — NOT NULL
- public_key — TEXT — NOT NULL
- sign_count — BIGINT — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
payment_attempts
- id — BIGINT — Primary key — NOT NULL
- tx_hash — VARCHAR(66) — NOT NULL
- token_id — NUMERIC(78,0) — Foreign key → pbms.token_id
- user_wallet_address — VARCHAR(42) — Foreign key → beneficiaries.wallet
- agent_wallet_address — VARCHAR(42) — Foreign key → agents.agent_address
- payee — VARCHAR(42)
- amount — NUMERIC(38,6)
- purpose — VARCHAR(255)
- result — VARCHAR(20) — NOT NULL
- failed_layer — VARCHAR(10)
- error_name — VARCHAR(100)
- fail_reason_code — VARCHAR(100)
- error_detail — TEXT
- service_url — VARCHAR(255)
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- activated_at — TIMESTAMP WITH TIME ZONE
pbm_allowed_vendors
- token_id — NUMERIC(78,0) — Foreign key → pbms.token_id — NOT NULL
- vendor_key — VARCHAR(50) — Foreign key → vendors.vendor_key — NOT NULL
pbms
- token_id — NUMERIC(78,0) — Primary key — NOT NULL
- payer_wallet — VARCHAR(42) — Foreign key → beneficiaries.wallet — NOT NULL
- program_id — VARCHAR(255) — Foreign key → programs.id — NOT NULL
- issuer — VARCHAR(255) — NOT NULL
- slot_id — BIGINT — NOT NULL
- agent_address — VARCHAR(42) — Foreign key → agents.agent_address
- total_budget — NUMERIC(38,6) — NOT NULL
- remaining_value — NUMERIC(38,6) — NOT NULL
- auto_limit — NUMERIC(38,6)
- expires_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
poller_state
- state_key — VARCHAR(100) — Primary key — NOT NULL
- last_processed_block — VARCHAR(50) — NOT NULL
programs
- id — VARCHAR(255) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
vendors
- vendor_key — VARCHAR(50) — Primary key — NOT NULL
- label — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
webhook_events
- event_id — VARCHAR(128) — Primary key — NOT NULL
- event_type — VARCHAR(255) — NOT NULL
- received_at — TIMESTAMP WITH TIME ZONE — NOT NULL