n8n/docs/generated/postgres-schema/public.agent_execution.md

public.agent_execution

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
completionTokens	integer		true
cost	double precision		true
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
duration	integer	0	false
error	text		true
hitlStatus	varchar(16)		true
id	varchar(36)		false
model	varchar(255)		true
promptTokens	integer		true
source	varchar(32)		true
startedAt	timestamp(3) with time zone		true
status	varchar(16)		false
stoppedAt	timestamp(3) with time zone		true
storedAt	varchar(2)	'db'::character varying	false
threadId	varchar(128)		false		public.agent_execution_threads
timeline	json		true
totalTokens	integer		true
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
userMessage	text		true

Constraints

Name	Type	Definition
CHK_agent_execution_hitlStatus	CHECK	CHECK ((("hitlStatus")::text = ANY ((ARRAY['suspended'::character varying, 'resumed'::character varying])::text[])))
CHK_agent_execution_status	CHECK	CHECK (((status)::text = ANY ((ARRAY['success'::character varying, 'error'::character varying])::text[])))
CHK_agent_execution_storedAt	CHECK	CHECK ((("storedAt")::text = ANY ((ARRAY['db'::character varying, 'fs'::character varying, 's3'::character varying, 'az'::character varying])::text[])))
FK_add2432fb6034cc18b6af299dce	FOREIGN KEY	FOREIGN KEY ("threadId") REFERENCES agent_execution_threads(id) ON DELETE CASCADE
PK_ba438acc8532addc12d1ef17049	PRIMARY KEY	PRIMARY KEY (id)
agent_execution_createdAt_not_null	n	NOT NULL "createdAt"
agent_execution_duration_not_null	n	NOT NULL duration
agent_execution_id_not_null	n	NOT NULL id
agent_execution_status_not_null	n	NOT NULL status
agent_execution_storedAt_not_null	n	NOT NULL "storedAt"
agent_execution_threadId_not_null	n	NOT NULL "threadId"
agent_execution_updatedAt_not_null	n	NOT NULL "updatedAt"

Indexes

Name	Definition
IDX_63d3c3a68b9cebf05f967f0b1c	CREATE INDEX "IDX_63d3c3a68b9cebf05f967f0b1c" ON public.agent_execution USING btree ("threadId", "createdAt")
PK_ba438acc8532addc12d1ef17049	CREATE UNIQUE INDEX "PK_ba438acc8532addc12d1ef17049" ON public.agent_execution USING btree (id)

Relations

erDiagram

"public.agent_execution" }o--|| "public.agent_execution_threads" : "FOREIGN KEY (#quot;threadId#quot;) REFERENCES agent_execution_threads(id) ON DELETE CASCADE"

"public.agent_execution" {
  integer completionTokens
  double_precision cost
  timestamp_3__with_time_zone createdAt
  integer duration
  text error
  varchar_16_ hitlStatus
  varchar_36_ id
  varchar_255_ model
  integer promptTokens
  varchar_32_ source
  timestamp_3__with_time_zone startedAt
  varchar_16_ status
  timestamp_3__with_time_zone stoppedAt
  varchar_2_ storedAt
  varchar_128_ threadId FK
  json timeline
  integer totalTokens
  timestamp_3__with_time_zone updatedAt
  text userMessage
}
"public.agent_execution_threads" {
  varchar_36_ agentId FK
  varchar_255_ agentName
  timestamp_3__with_time_zone createdAt
  varchar_8_ emoji
  varchar_128_ id
  varchar_36_ parentAgentId
  varchar_128_ parentThreadId
  varchar_255_ projectId FK
  integer sessionNumber
  varchar_32_ taskId
  varchar_36_ taskVersionId FK
  varchar_255_ title
  integer totalCompletionTokens
  double_precision totalCost
  integer totalDuration
  integer totalPromptTokens
  timestamp_3__with_time_zone updatedAt
}

---

Generated by tbls