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

public.agent_execution_threads

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
agentId	varchar(36)		false		public.agents
agentName	varchar(255)		false
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
emoji	varchar(8)		true
id	varchar(128)		false	public.agent_execution
parentAgentId	varchar(36)		true			Saved agent id of the parent that delegated this subagent run.
parentThreadId	varchar(128)		true			Parent session thread id that delegated this subagent run.
projectId	varchar(255)		false		public.project
sessionNumber	integer	0	false
taskId	varchar(32)		true			Published task ID that triggered this session; not an FK because published runs can outlive draft task definition rows
taskVersionId	varchar(36)		true		public.agent_history	Published agent_history version that supplied the task snapshot
title	varchar(255)		true
totalCompletionTokens	integer	0	false
totalCost	double precision	0	false
totalDuration	integer	0	false
totalPromptTokens	integer	0	false
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false

Constraints

Name	Type	Definition
FK_0468a9dc35597314e641d4722aa	FOREIGN KEY	FOREIGN KEY ("agentId") REFERENCES agents(id) ON DELETE CASCADE
FK_0e2f8bf92a7a9c88b89670f701c	FOREIGN KEY	FOREIGN KEY ("projectId") REFERENCES project(id) ON DELETE CASCADE
FK_f00b52d74fe11838e1fe086deea	FOREIGN KEY	FOREIGN KEY ("taskVersionId") REFERENCES agent_history("versionId") ON DELETE SET NULL
PK_22373dbf6ba6929d8ac50093309	PRIMARY KEY	PRIMARY KEY (id)
agent_execution_threads_agentId_not_null	n	NOT NULL "agentId"
agent_execution_threads_agentName_not_null	n	NOT NULL "agentName"
agent_execution_threads_createdAt_not_null	n	NOT NULL "createdAt"
agent_execution_threads_id_not_null	n	NOT NULL id
agent_execution_threads_projectId_not_null	n	NOT NULL "projectId"
agent_execution_threads_sessionNumber_not_null	n	NOT NULL "sessionNumber"
agent_execution_threads_totalCompletionTokens_not_null	n	NOT NULL "totalCompletionTokens"
agent_execution_threads_totalCost_not_null	n	NOT NULL "totalCost"
agent_execution_threads_totalDuration_not_null	n	NOT NULL "totalDuration"
agent_execution_threads_totalPromptTokens_not_null	n	NOT NULL "totalPromptTokens"
agent_execution_threads_updatedAt_not_null	n	NOT NULL "updatedAt"

Indexes

Name	Definition
IDX_0468a9dc35597314e641d4722a	CREATE INDEX "IDX_0468a9dc35597314e641d4722a" ON public.agent_execution_threads USING btree ("agentId")
IDX_0e2f8bf92a7a9c88b89670f701	CREATE INDEX "IDX_0e2f8bf92a7a9c88b89670f701" ON public.agent_execution_threads USING btree ("projectId")
IDX_agent_execution_threads_taskVersionId	CREATE INDEX "IDX_agent_execution_threads_taskVersionId" ON public.agent_execution_threads USING btree ("taskVersionId")
PK_22373dbf6ba6929d8ac50093309	CREATE UNIQUE INDEX "PK_22373dbf6ba6929d8ac50093309" ON public.agent_execution_threads USING btree (id)

Relations

erDiagram

"public.agent_execution_threads" }o--|| "public.agents" : "FOREIGN KEY (#quot;agentId#quot;) REFERENCES agents(id) ON DELETE CASCADE"
"public.agent_execution" }o--|| "public.agent_execution_threads" : "FOREIGN KEY (#quot;threadId#quot;) REFERENCES agent_execution_threads(id) ON DELETE CASCADE"
"public.agent_execution_threads" }o--|| "public.project" : "FOREIGN KEY (#quot;projectId#quot;) REFERENCES project(id) ON DELETE CASCADE"
"public.agent_execution_threads" }o--o| "public.agent_history" : "FOREIGN KEY (#quot;taskVersionId#quot;) REFERENCES agent_history(#quot;versionId#quot;) ON DELETE SET NULL"

"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
}
"public.agents" {
  varchar_36_ activeVersionId FK
  boolean availableInMCP
  timestamp_3__with_time_zone createdAt
  varchar_36_ id
  json integrations
  varchar_128_ name
  varchar_255_ projectId FK
  json schema
  json skills
  json tools
  timestamp_3__with_time_zone updatedAt
  varchar_36_ versionId
}
"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.project" {
  timestamp_3__with_time_zone createdAt
  uuid creatorId FK
  json customTelemetryTags
  varchar_512_ description
  json icon
  varchar_36_ id
  varchar_255_ name
  varchar_36_ type
  timestamp_3__with_time_zone updatedAt
}
"public.agent_history" {
  varchar_36_ agentId FK
  varchar_255_ author
  timestamp_3__with_time_zone createdAt
  uuid publishedById FK
  json schema
  json skills
  json tools
  timestamp_3__with_time_zone updatedAt
  varchar_36_ versionId
}

---

Generated by tbls