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

agent_conversation_lease

Description

Table Definition

CREATE TABLE "agent_conversation_lease" ("threadId" varchar(128) PRIMARY KEY NOT NULL, "agentId" varchar(36) NOT NULL, "ownerToken" varchar NOT NULL, "expiresAt" datetime(3) NOT NULL, CONSTRAINT "FK_828d2a046ac7a8565ac2d273d1c" FOREIGN KEY ("agentId") REFERENCES "agents" ("id") ON DELETE CASCADE)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
agentId	varchar(36)		false		agents
expiresAt	datetime(3)		false
ownerToken	varchar		false
threadId	varchar(128)		false

Constraints

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

Indexes

Name	Definition
IDX_828d2a046ac7a8565ac2d273d1	CREATE INDEX "IDX_828d2a046ac7a8565ac2d273d1" ON "agent_conversation_lease" ("agentId")
sqlite_autoindex_agent_conversation_lease_1	PRIMARY KEY (threadId)

Relations

erDiagram

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

"agent_conversation_lease" {
  varchar_36_ agentId FK
  datetime_3_ expiresAt
  varchar ownerToken
  varchar_128_ threadId PK
}
"agents" {
  varchar_36_ activeVersionId FK
  boolean availableInMCP
  datetime_3_ createdAt
  varchar_36_ id PK
  TEXT integrations
  varchar_128_ name
  varchar_255_ projectId FK
  INTEGER revision
  TEXT schema
  datetime_3_ setupCompletedAt
  TEXT skills
  TEXT tools
  datetime_3_ updatedAt
  varchar_36_ versionId
}

---

Generated by tbls