public.agents_messages

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
author	json		true			Original message author supplied by the chat platform
content	json		false
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
id	varchar(36)		false	public.agent_execution_message_links public.agent_message_queue public.agents_memory_entry_candidates
modelContent	json		true			Enriched model input when it differs from the original content
modelContextAt	timestamp(3) with time zone		true			Runtime ordering timestamp. NULL inputs are excluded from model context
origin	json		true			Source identifiers and transcript visibility. NULL for legacy or SDK-only messages
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_model_context	CREATE INDEX "IDX_agents_messages_model_context" ON public.agents_messages USING btree ("threadId", COALESCE("modelContextAt", "createdAt"), id)
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.agent_execution_message_links" }o--|| "public.agents_messages" : "FOREIGN KEY (#quot;messageId#quot;) REFERENCES agents_messages(id) ON DELETE CASCADE"
"public.agent_message_queue" }o--|| "public.agents_messages" : "FOREIGN KEY (#quot;messageId#quot;) REFERENCES agents_messages(id) ON DELETE CASCADE"
"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 author
  json content
  timestamp_3__with_time_zone createdAt
  varchar_36_ id
  json modelContent
  timestamp_3__with_time_zone modelContextAt
  json origin
  varchar_255_ resourceId
  varchar_36_ role
  varchar_255_ threadId FK
  varchar_36_ type
  timestamp_3__with_time_zone updatedAt
}
"public.agent_execution_message_links" {
  timestamp_3__with_time_zone createdAt
  varchar_6_ direction
  varchar_36_ executionId FK
  varchar_36_ messageId FK
  integer position
}
"public.agent_message_queue" {
  timestamp_3__with_time_zone createdAt
  varchar_36_ executionId FK
  bigint id
  varchar_36_ messageId FK
  json payload
  integer position
  varchar_36_ steeringExecutionId FK
  integer steeringOrder
  varchar_128_ threadId FK
  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