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