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

public.agent_conversation_lease

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
agentId	varchar(36)		false		public.agents
expiresAt	timestamp(3) with time zone		false			Lease expiry on the database clock.
ownerToken	uuid		false			Fresh identity for one execution owner.
threadId	varchar(128)		false			Conversation routing ID.

Constraints

Name	Type	Definition
FK_828d2a046ac7a8565ac2d273d1c	FOREIGN KEY	FOREIGN KEY ("agentId") REFERENCES agents(id) ON DELETE CASCADE
PK_1f4fe0ff37a0ebe5023c2f294f7	PRIMARY KEY	PRIMARY KEY ("threadId")
agent_conversation_lease_agentId_not_null	n	NOT NULL "agentId"
agent_conversation_lease_expiresAt_not_null	n	NOT NULL "expiresAt"
agent_conversation_lease_ownerToken_not_null	n	NOT NULL "ownerToken"
agent_conversation_lease_threadId_not_null	n	NOT NULL "threadId"

Indexes

Name	Definition
IDX_828d2a046ac7a8565ac2d273d1	CREATE INDEX "IDX_828d2a046ac7a8565ac2d273d1" ON public.agent_conversation_lease USING btree ("agentId")
PK_1f4fe0ff37a0ebe5023c2f294f7	CREATE UNIQUE INDEX "PK_1f4fe0ff37a0ebe5023c2f294f7" ON public.agent_conversation_lease USING btree ("threadId")

Relations

erDiagram

"public.agent_conversation_lease" }o--|| "public.agents" : "FOREIGN KEY (#quot;agentId#quot;) REFERENCES agents(id) ON DELETE CASCADE"

"public.agent_conversation_lease" {
  varchar_36_ agentId FK
  timestamp_3__with_time_zone expiresAt
  uuid ownerToken
  varchar_128_ threadId
}
"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
  integer revision
  json schema
  timestamp_3__with_time_zone setupCompletedAt
  json skills
  json tools
  timestamp_3__with_time_zone updatedAt
  varchar_36_ versionId
}

---

Generated by tbls