github-mirror/n8n
1
0
Fork 0
mirror of https://github.com/n8n-io/n8n.git synced 2026-10-18 23:09:03 +02:00
Code Issues Actions 15 Packages Projects Releases Wiki Activity Graph
backend-agent-message-queue
n8n/docs/generated/postgres-schema/public.agents_messages.md
Robin Braumann 072f4960f0
Some checks are pending
CI: Master (Build, Test, Lint) / Build for Github Cache (push) Waiting to run
Details
CI: Master (Build, Test, Lint) / Unit tests (24.18.1) (push) Waiting to run
Details
CI: Master (Build, Test, Lint) / Unit tests (26.5.1) (push) Waiting to run
Details
CI: Master (Build, Test, Lint) / Lint (push) Waiting to run
Details
CI: Master (Build, Test, Lint) / Performance (push) Waiting to run
Details
CI: Master (Build, Test, Lint) / Verify single-instance deps (npm-install) (push) Waiting to run
Details
CI: Master (Build, Test, Lint) / Notify Slack on failure (push) Blocked by required conditions
Details
feat(core): Share integration threads across participants (#38461) 
Co-authored-by: Cursor <cursoragent@cursor.com>
2026-09-12 05:14:33 +00:00

3.3 KiB
Generated
Raw Permalink Blame History

public.agents_messages

Columns

Name Type Default Nullable Children Parents Comment
content json false
createdAt timestamp(3) with time zone CURRENT_TIMESTAMP(3) false
id varchar(36) false public.agents_memory_entry_candidates
resourceId varchar(255) false
role varchar(36) false
threadId varchar(255) false public.agents_threads
type varchar(36) true
updatedAt timestamp(3) with time zone CURRENT_TIMESTAMP(3) false

Constraints

Name Type Definition
FK_0a8057a61afabd2999608ffd0d9 FOREIGN KEY FOREIGN KEY ("threadId") REFERENCES agents_threads(id) ON DELETE CASCADE
PK_81020dc608dfb0af1ede386d907 PRIMARY KEY PRIMARY KEY (id)
agents_messages_content_not_null n NOT NULL content
agents_messages_createdAt_not_null n NOT NULL "createdAt"
agents_messages_id_not_null n NOT NULL id
agents_messages_resourceId_not_null n NOT NULL "resourceId"
agents_messages_role_not_null n NOT NULL role
agents_messages_threadId_not_null n NOT NULL "threadId"
agents_messages_updatedAt_not_null n NOT NULL "updatedAt"

Indexes

Name Definition
IDX_agents_messages_resourceId_threadId CREATE INDEX "IDX_agents_messages_resourceId_threadId" ON public.agents_messages USING btree ("resourceId", "threadId")
IDX_agents_messages_threadId_createdAt CREATE INDEX "IDX_agents_messages_threadId_createdAt" ON public.agents_messages USING btree ("threadId", "createdAt")
IDX_fc7bf858660bfafd19181e8e35 CREATE INDEX "IDX_fc7bf858660bfafd19181e8e35" ON public.agents_messages USING btree ("threadId", "createdAt")
PK_81020dc608dfb0af1ede386d907 CREATE UNIQUE INDEX "PK_81020dc608dfb0af1ede386d907" ON public.agents_messages USING btree (id)

Relations

erDiagram

"public.agents_memory_entry_candidates" }o--o| "public.agents_messages" : "FOREIGN KEY (#quot;sourceMessageId#quot;) REFERENCES agents_messages(id) ON DELETE SET NULL"
"public.agents_messages" }o--|| "public.agents_threads" : "FOREIGN KEY (#quot;threadId#quot;) REFERENCES agents_threads(id) ON DELETE CASCADE"

"public.agents_messages" {
  json content
  timestamp_3__with_time_zone createdAt
  varchar_36_ id
  varchar_255_ resourceId
  varchar_36_ role
  varchar_255_ threadId FK
  varchar_36_ type
  timestamp_3__with_time_zone updatedAt
}
"public.agents_memory_entry_candidates" {
  varchar_36_ agentId FK
  smallint attemptCount
  text content
  timestamp_3__with_time_zone createdAt
  text evidenceText
  varchar_36_ id
  varchar_32_ kind
  varchar_255_ resourceId FK
  varchar_255_ runId
  varchar_36_ sourceMessageId FK
  varchar_16_ status
  varchar_255_ threadId FK
  varchar_255_ toolCallId
  timestamp_3__with_time_zone updatedAt
}
"public.agents_threads" {
  timestamp_3__with_time_zone createdAt
  varchar_128_ id
  text metadata
  varchar_255_ resourceId
  varchar_255_ title
  timestamp_3__with_time_zone updatedAt
}

Generated by tbls