n8n/docs/generated/sqlite-schema/agent_task_run_lock.md

agent_task_run_lock

Description

Table Definition

CREATE TABLE "agent_task_run_lock" ("agentId" varchar(36) NOT NULL, "taskId" varchar(32) NOT NULL, "holderId" varchar NOT NULL, "heldUntil" datetime(3) NOT NULL, "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')), CONSTRAINT "FK_b57a2862ae869aab24e54cefd48" FOREIGN KEY ("agentId") REFERENCES "agents" ("id") ON DELETE CASCADE, PRIMARY KEY ("agentId", "taskId"))

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
agentId	varchar(36)		false		agents
taskId	varchar(32)		false
holderId	varchar		false
heldUntil	datetime(3)		false
createdAt	datetime(3)	STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')	false
updatedAt	datetime(3)	STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')	false

Constraints

Name	Type	Definition
agentId	PRIMARY KEY	PRIMARY KEY (agentId)
taskId	PRIMARY KEY	PRIMARY KEY (taskId)
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (agentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
sqlite_autoindex_agent_task_run_lock_1	PRIMARY KEY	PRIMARY KEY (agentId, taskId)

Indexes

Name	Definition
sqlite_autoindex_agent_task_run_lock_1	PRIMARY KEY (agentId, taskId)

Relations

erDiagram

"agent_task_run_lock" |o--|| "agents" : "FOREIGN KEY (agentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"agent_task_run_lock" {
  varchar_36_ agentId PK
  varchar_32_ taskId PK
  varchar holderId
  datetime_3_ heldUntil
  datetime_3_ createdAt
  datetime_3_ updatedAt
}
"agents" {
  varchar_36_ id PK
  varchar_128_ name
  varchar_512_ description
  varchar_255_ projectId FK
  TEXT integrations
  TEXT schema
  TEXT tools
  TEXT skills
  varchar_36_ versionId
  datetime_3_ createdAt
  datetime_3_ updatedAt
  varchar_36_ activeVersionId FK
}

---

Generated by tbls