v2

Tables (9)

agent_client

  • id — BIGSERIAL — Primary key — NOT NULL
  • client_id — VARCHAR(128) — NOT NULL
  • client_secret_hash — VARCHAR(255)
  • token_endpoint_auth_method — VARCHAR(32) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • logo_uri — VARCHAR(2048)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

agent_client_redirect_uri

  • id — BIGSERIAL — Primary key — NOT NULL
  • agent_client_id — BIGINT — Foreign key → agent_client.id — NOT NULL
  • redirect_uri — VARCHAR(2048) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

agent_connection

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • agent_client_id — BIGINT — Foreign key → agent_client.id — NOT NULL
  • scopes — TEXT — NOT NULL
  • connected_at — TIMESTAMPTZ — NOT NULL
  • revoked_at — TIMESTAMPTZ

checkout_snapshot

  • id — BIGSERIAL — Primary key — NOT NULL
  • purchase_request_id — BIGINT — Foreign key → purchase_request.id — NOT NULL
  • merchant_id — BIGINT — Foreign key → merchant.id — NOT NULL
  • merchant_checkout_id — VARCHAR(255) — NOT NULL
  • merchant_checkout_status — VARCHAR(32) — NOT NULL
  • raw_payload — JSONB — NOT NULL
  • checkout_hash — VARCHAR(64) — NOT NULL
  • total_amount — NUMERIC(19,4) — NOT NULL
  • last_synced_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

merchant

  • id — BIGSERIAL — Primary key — NOT NULL
  • public_id — UUID — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • domain — VARCHAR(255) — NOT NULL
  • profile — JSONB — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • last_profile_synced_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

pay_authorization_reference

  • id — BIGSERIAL — Primary key — NOT NULL
  • checkout_snapshot_id — BIGINT — Foreign key → checkout_snapshot.id — NOT NULL
  • pay_authorization_id — UUID — NOT NULL
  • checkout_mandate_id — UUID
  • approval_status — VARCHAR(20) — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • approved_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

purchase_request

  • id — BIGSERIAL — Primary key — NOT NULL
  • public_id — UUID — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • agent_connection_id — BIGINT — Foreign key → agent_connection.id — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

user_identity

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • secret_hash — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • public_id — UUID — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL