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

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
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_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_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_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