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