Agent Execution Threads · SQLite Schema · n8n-io/n8n · Skills Docs

Agent Execution Threads · SQLite Schema · n8n-io/n8n · Skills Docs

CREATE TABLE "agent_execution_threads" ("id" varchar(128) PRIMARY KEY NOT NULL, "agentId" varchar(36) NOT NULL, "agentName" varchar(255) NOT NULL, "projectId" varchar(255) NOT NULL, "sessionNumber" integer NOT NULL DEFAULT (0), "totalPromptTokens" integer NOT NULL DEFAULT (0), "totalCompletionTokens" integer NOT NULL DEFAULT (0), "totalCost" real NOT NULL DEFAULT (0), "totalDuration" integer NOT NULL DEFAULT (0), "title" varchar(255), "emoji" varchar(8), "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "taskId" varchar(32), "taskVersionId" varchar(36), "parentThreadId" varchar(128), "parentAgentId" varchar(36), "ownerId" varchar, "accessScope" varchar(16) NOT NULL DEFAULT ('user'), "taskStop" TEXT, CONSTRAINT "CHK_agent_execution_threads_accessScope" CHECK ("accessScope" IN ('user', 'project')), CONSTRAINT "FK_f00b52d74fe11838e1fe086deea" FOREIGN KEY ("taskVersionId") REFERENCES "agent_history" ("versionId") ON DELETE SET NULL ON UPDATE NO ACTION, CONSTRAINT "FK_0468a9dc35597314e641d4722aa" FOREIGN KEY ("agentId") REFERENCES "agents" ("id") ON DELETE CASCADE ON UPDATE NO ACTION, CONSTRAINT "FK_0e2f8bf92a7a9c88b89670f701c" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE CASCADE ON UPDATE NO ACTION, CONSTRAINT "FK_agent_execution_threads_owner" FOREIGN KEY ("ownerId") REFERENCES "user" ("id") ON DELETE SET NULL)

Name	Type	Default	Nullable	Children	Parents	Comment
accessScope	varchar(16)	‘user’	false
agentId	varchar(36)		false		agents
agentName	varchar(255)		false
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
emoji	varchar(8)		true
id	varchar(128)		false	agent_execution agent_message_queue agent_plan agent_thread_grants
ownerId	varchar		true		user
parentAgentId	varchar(36)		true
parentThreadId	varchar(128)		true
projectId	varchar(255)		false		project
sessionNumber	INTEGER	0	false
taskId	varchar(32)		true
taskStop	TEXT		true
taskVersionId	varchar(36)		true		agent_history
title	varchar(255)		true
totalCompletionTokens	INTEGER	0	false
totalCost	REAL	0	false
totalDuration	INTEGER	0	false
totalPromptTokens	INTEGER	0	false
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false

Name	Type	Definition
-	CHECK	CHECK (“accessScope” IN (‘user’, ‘project’))
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (ownerId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE
- (Foreign key ID: 1)	FOREIGN KEY	FOREIGN KEY (projectId) REFERENCES project (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
- (Foreign key ID: 2)	FOREIGN KEY	FOREIGN KEY (agentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
- (Foreign key ID: 3)	FOREIGN KEY	FOREIGN KEY (taskVersionId) REFERENCES agent_history (versionId) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_agent_execution_threads_1	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
IDX_0468a9dc35597314e641d4722a	CREATE INDEX “IDX_0468a9dc35597314e641d4722a” ON “agent_execution_threads” (“agentId”)
IDX_0e2f8bf92a7a9c88b89670f701	CREATE INDEX “IDX_0e2f8bf92a7a9c88b89670f701” ON “agent_execution_threads” (“projectId”)
IDX_agent_execution_threads_ownerId	CREATE INDEX “IDX_agent_execution_threads_ownerId” ON “agent_execution_threads” (“ownerId”)
IDX_agent_execution_threads_taskVersionId	CREATE INDEX “IDX_agent_execution_threads_taskVersionId” ON “agent_execution_threads” (“taskVersionId”)
sqlite_autoindex_agent_execution_threads_1	PRIMARY KEY (id)

erDiagram

"agent_execution_threads" }o--|| "agents" : "FOREIGN KEY (agentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_execution" }o--|| "agent_execution_threads" : "FOREIGN KEY (threadId) REFERENCES agent_execution_threads (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_message_queue" }o--|| "agent_execution_threads" : "FOREIGN KEY (threadId) REFERENCES agent_execution_threads (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_plan" }o--|| "agent_execution_threads" : "FOREIGN KEY (threadId) REFERENCES agent_execution_threads (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_thread_grants" |o--|| "agent_execution_threads" : "FOREIGN KEY (threadId) REFERENCES agent_execution_threads (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_execution_threads" }o--o| "user" : "FOREIGN KEY (ownerId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"agent_execution_threads" }o--|| "project" : "FOREIGN KEY (projectId) REFERENCES project (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_execution_threads" }o--o| "agent_history" : "FOREIGN KEY (taskVersionId) REFERENCES agent_history (versionId) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"

"agent_execution_threads" {
  varchar_16_ accessScope
  varchar_36_ agentId FK
  varchar_255_ agentName
  datetime_3_ createdAt