n8n/docs/generated/postgres-schema/public.agent_budget_spend.md
Anne Aguirre a2fd4189f1
feat(core): Persist agent budget spend in the database (#40138)
Co-authored-by: cubic-dev-ai[bot] <191113872+cubic-dev-ai[bot]@users.noreply.github.com>
2026-10-05 15:11:29 +00:00

1.5 KiB
Generated

public.agent_budget_spend

Columns

Name Type Default Nullable Children Parents Comment
createdAt timestamp(3) with time zone CURRENT_TIMESTAMP(3) false
key varchar(128) false Session key is the root thread id. Month key is {agentId}:{YYYY-MM}.
totalUsd double precision 0 false Running USD estimate for this ledger key. A check rejects a negative total.
updatedAt timestamp(3) with time zone CURRENT_TIMESTAMP(3) false

Constraints

Name Type Definition
CHK_agent_budget_spend_total_usd_non_negative CHECK CHECK (("totalUsd" >= (0)::double precision))
PK_ca88e3ef81cc367fc55807e582c PRIMARY KEY PRIMARY KEY (key)
agent_budget_spend_createdAt_not_null n NOT NULL "createdAt"
agent_budget_spend_key_not_null n NOT NULL key
agent_budget_spend_totalUsd_not_null n NOT NULL "totalUsd"
agent_budget_spend_updatedAt_not_null n NOT NULL "updatedAt"

Indexes

Name Definition
PK_ca88e3ef81cc367fc55807e582c CREATE UNIQUE INDEX "PK_ca88e3ef81cc367fc55807e582c" ON public.agent_budget_spend USING btree (key)

Relations

erDiagram


"public.agent_budget_spend" {
  timestamp_3__with_time_zone createdAt
  varchar_128_ key
  double_precision totalUsd
  timestamp_3__with_time_zone updatedAt
}

Generated by tbls