Agent Background Job · SQLite Schema · n8n-io/n8n · Skills Docs

Agent Background Job · SQLite Schema · n8n-io/n8n · Skills Docs

CREATE TABLE "agent_background_job" ("id" varchar(36) PRIMARY KEY NOT NULL, "kind" varchar(16) NOT NULL, "status" varchar(16) NOT NULL, "parentAgentId" varchar(36) NOT NULL, "parentThreadId" varchar(128) NOT NULL, "title" varchar(255) NOT NULL, "subAgentId" varchar(36), "childThreadId" varchar(128), "childExecutionId" varchar(36), "workflowId" varchar(36), "timeoutAt" datetime(3), "result" text, "error" text, "settledAt" datetime(3), "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')), "notifiedAt" datetime(3), "parentResourceId" varchar(255) NOT NULL, "parentPrincipalHash" varchar(64) NOT NULL, "pauseRequestId" varchar, "sourceExecutionId" varchar(36), "planId" varchar, "planTaskId" varchar, "files" text, "skippedFiles" text, CONSTRAINT "CHK_agent_background_job_kind" CHECK (((((("kind" IN ('subagent', 'workflow'))))))), CONSTRAINT "CHK_agent_background_job_status" CHECK ((("status" IN ('running', 'suspended', 'paused', 'completed', 'failed', 'cancelled')))), CONSTRAINT "FK_ce131bff629d89015893e350e9c" FOREIGN KEY ("planId") REFERENCES "agent_plan" ("id") ON DELETE SET NULL ON UPDATE NO ACTION, CONSTRAINT "FK_4db3b7ebea4ed4f69649982018c" FOREIGN KEY ("sourceExecutionId") REFERENCES "agent_execution" ("id") ON DELETE SET NULL ON UPDATE NO ACTION, CONSTRAINT "FK_d46c6f00730c2ef8bcb6ee24b67" FOREIGN KEY ("parentAgentId") REFERENCES "agents" ("id") ON DELETE CASCADE ON UPDATE NO ACTION)

Name	Type	Default	Nullable	Children	Parents	Comment
childExecutionId	varchar(36)		true
childThreadId	varchar(128)		true
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
error	TEXT		true
files	TEXT		true
id	varchar(36)		false
kind	varchar(16)		false
notifiedAt	datetime(3)		true
parentAgentId	varchar(36)		false		agents
parentPrincipalHash	varchar(64)		false
parentResourceId	varchar(255)		false
parentThreadId	varchar(128)		false
pauseRequestId	varchar		true
planId	varchar		true		agent_plan
planTaskId	varchar		true
result	TEXT		true
settledAt	datetime(3)		true
skippedFiles	TEXT		true
sourceExecutionId	varchar(36)		true		agent_execution
status	varchar(16)		false
subAgentId	varchar(36)		true
timeoutAt	datetime(3)		true
title	varchar(255)		false
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
workflowId	varchar(36)		true

Name	Type	Definition
-	CHECK	CHECK ((((((“kind” IN (‘subagent’, ‘workflow’)))))))
-	CHECK	CHECK (((“status” IN (‘running’, ‘suspended’, ‘paused’, ‘completed’, ‘failed’, ‘cancelled’))))
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (parentAgentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
- (Foreign key ID: 1)	FOREIGN KEY	FOREIGN KEY (sourceExecutionId) REFERENCES agent_execution (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE
- (Foreign key ID: 2)	FOREIGN KEY	FOREIGN KEY (planId) REFERENCES agent_plan (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_agent_background_job_1	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
IDX_93d62baabe9858816b5adafb44	CREATE INDEX “IDX_93d62baabe9858816b5adafb44” ON “agent_background_job” (“parentThreadId”, “status”)
IDX_agent_background_job_childExecutionId	CREATE UNIQUE INDEX “IDX_agent_background_job_childExecutionId” ON “agent_background_job” (“childExecutionId”) WHERE “childExecutionId” IS NOT NULL
IDX_agent_background_job_parentThreadId	CREATE INDEX “IDX_agent_background_job_parentThreadId” ON “agent_background_job” (“parentThreadId”) WHERE “status” <> ‘running’ AND “notifiedAt” IS NULL
IDX_agent_background_job_planId_planTaskId	CREATE INDEX “IDX_agent_background_job_planId_planTaskId” ON “agent_background_job” (“planId”, “planTaskId”)
IDX_agent_background_job_sourceExecutionId	CREATE INDEX “IDX_agent_background_job_sourceExecutionId” ON “agent_background_job” (“sourceExecutionId”)
IDX_agent_background_job_timeoutAt	CREATE INDEX “IDX_agent_background_job_timeoutAt” ON “agent_background_job” (“timeoutAt”) WHERE “status” IN (‘running’, ‘suspended’)
IDX_d46c6f00730c2ef8bcb6ee24b6	CREATE INDEX “IDX_d46c6f00730c2ef8bcb6ee24b6” ON “agent_background_job” (“parentAgentId”)
IDX_e43e630272995a93dfeb94ab3e	CREATE INDEX “IDX_e43e630272995a93dfeb94ab3e” ON “agent_background_job” (“settledAt”)
sqlite_autoindex_agent_background_job_1	PRIMARY KEY (id)

erDiagram

"agent_background_job" }o--|| "agents" : "FOREIGN KEY (parentAgentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_background_job" }o--o| "agent_plan" : "FOREIGN KEY (planId) REFERENCES agent_plan (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"agent_background_job" }o--o| "agent_execution" : "FOREIGN KEY (sourceExecutionId) REFERENCES agent_execution (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"

"agent_background_job" {
  varchar_36_ childExecutionId
  varchar_128_ childThreadId
  datetime_3_ createdAt
  TEXT error
  TEXT files
  varchar_36_ id PK
  varchar_16_ kind
  datetime_3_ notifiedAt
  varchar_36_ parentAgentId FK
  varchar_64_ parentPrincipalHash
  varchar_255_ parentResourceId
  varchar_128_ parentThreadId
  varchar pauseRequestId
  varchar planId FK
  varchar planTaskId
  TEXT result
  datetime_3_ settledAt
  TEXT skippedFiles
  varchar_36_ sourceExecutionId FK
  varchar_16_ status
  varchar_36_ subAgentId
  datetime_3_ timeoutAt
  varchar_255_ title
  datetime_3_ updatedAt
  varchar_36_ workflowId
}
"agents" {
  varchar_36_ activeVersionId FK
  boolean availableInMCP
  datetime_3_ createdAt
  varchar_36_ id PK
  TEXT integrations
  varchar_128_ name
  varchar_255_ projectId FK
  INTEGER publicationRevision
  INTEGER revision
  TEXT schema
  varchar_16_ scope
  datetime_3_ setupCompletedAt
  TEXT skills
  TEXT tools
  datetime_3_ updatedAt
  varchar_36_ versionId
}
"agent_plan" {
  datetime_3_ closedAt
  datetime_3_ createdAt
  TEXT data
  INTEGER formatVersion
  varchar id PK
  INTEGER revision
  varchar_128_ threadId FK
  datetime_3_ updatedAt
}
"agent_execution" {
  BOOLEAN acceptsSteering
  TEXT attachments
  TEXT author
  INTEGER cacheReadTokens
  INTEGER cacheWriteTokens
  INTEGER completionTokens
  REAL cost
  datetime_3_ createdAt
  INTEGER duration
  TEXT error
  TEXT failureSummary
  VARCHAR_32_ finishReason
  VARCHAR_64_ guardrailCode
  varchar_16_ hitlStatus
  varchar_36_ id PK
  varchar_255_ model
  varchar_36_ parentExecutionId FK
  INTEGER promptTokens
  varchar_32_ source
  datetime_3_ startedAt
  varchar_16_ status
  datetime_3_ stoppedAt
  varchar_2_ storedAt
  varchar_128_ threadId FK
  TEXT timeline
  INTEGER totalTokens
  datetime_3_ updatedAt
  TEXT userMessage
}