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

public.agents_observations

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
agentId	varchar(36)		false		public.agents	Agent that owns this observation row
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
id	varchar(36)		false	public.agents_memory_entry_sources public.agents_observations		Application-generated n8n string ID, not a database UUID
marker	varchar(16)		false
observationScopeId	varchar(255)		false		public.agents_threads	agents_threads.id source stream for this observation log
parentId	varchar(36)		true		public.agents_observations
status	varchar(16)		false
supersededBy	varchar(36)		true		public.agents_observations
text	text		false
tokenCount	integer	0	false
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false

Constraints

Name	Type	Definition
CHK_agents_observations_marker	CHECK	CHECK (((marker)::text = ANY ((ARRAY['critical'::character varying, 'important'::character varying, 'info'::character varying, 'completion'::character varying])::text[])))
CHK_agents_observations_status	CHECK	CHECK (((status)::text = ANY ((ARRAY['active'::character varying, 'superseded'::character varying, 'dropped'::character varying])::text[])))
FK_127ee1078ffa952bb37b511efad	FOREIGN KEY	FOREIGN KEY ("supersededBy") REFERENCES agents_observations(id)
FK_4cfd8a70ebb0a5b0cf047dca3cf	FOREIGN KEY	FOREIGN KEY ("observationScopeId") REFERENCES agents_threads(id) ON DELETE CASCADE
FK_501e2d1701a10e24fb69ab5fc5f	FOREIGN KEY	FOREIGN KEY ("parentId") REFERENCES agents_observations(id)
FK_d206432be97b7ed88d187479b1b	FOREIGN KEY	FOREIGN KEY ("agentId") REFERENCES agents(id) ON DELETE CASCADE
PK_9ad319654d12c2649f7caf27135	PRIMARY KEY	PRIMARY KEY (id)
agents_observations_agentId_not_null	n	NOT NULL "agentId"
agents_observations_createdAt_not_null	n	NOT NULL "createdAt"
agents_observations_id_not_null	n	NOT NULL id
agents_observations_marker_not_null	n	NOT NULL marker
agents_observations_observationScopeId_not_null	n	NOT NULL "observationScopeId"
agents_observations_status_not_null	n	NOT NULL status
agents_observations_text_not_null	n	NOT NULL text
agents_observations_tokenCount_not_null	n	NOT NULL "tokenCount"
agents_observations_updatedAt_not_null	n	NOT NULL "updatedAt"

Indexes

Name	Definition
IDX_07cb1e4a302629c5fa5d74d2bb	CREATE INDEX "IDX_07cb1e4a302629c5fa5d74d2bb" ON public.agents_observations USING btree ("agentId", "observationScopeId", status)
IDX_127ee1078ffa952bb37b511efa	CREATE INDEX "IDX_127ee1078ffa952bb37b511efa" ON public.agents_observations USING btree ("supersededBy")
IDX_4cfd8a70ebb0a5b0cf047dca3c	CREATE INDEX "IDX_4cfd8a70ebb0a5b0cf047dca3c" ON public.agents_observations USING btree ("observationScopeId")
IDX_501e2d1701a10e24fb69ab5fc5	CREATE INDEX "IDX_501e2d1701a10e24fb69ab5fc5" ON public.agents_observations USING btree ("parentId")
PK_9ad319654d12c2649f7caf27135	CREATE UNIQUE INDEX "PK_9ad319654d12c2649f7caf27135" ON public.agents_observations USING btree (id)

Relations

erDiagram

"public.agents_observations" }o--|| "public.agents" : "FOREIGN KEY (#quot;agentId#quot;) REFERENCES agents(id) ON DELETE CASCADE"
"public.agents_memory_entry_sources" }o--|| "public.agents_observations" : "FOREIGN KEY (#quot;observationId#quot;) REFERENCES agents_observations(id) ON DELETE CASCADE"
"public.agents_observations" }o--o| "public.agents_observations" : "FOREIGN KEY (#quot;supersededBy#quot;) REFERENCES agents_observations(id)"
"public.agents_observations" }o--o| "public.agents_observations" : "FOREIGN KEY (#quot;parentId#quot;) REFERENCES agents_observations(id)"
"public.agents_observations" }o--|| "public.agents_threads" : "FOREIGN KEY (#quot;observationScopeId#quot;) REFERENCES agents_threads(id) ON DELETE CASCADE"

"public.agents_observations" {
  varchar_36_ agentId FK
  timestamp_3__with_time_zone createdAt
  varchar_36_ id
  varchar_16_ marker
  varchar_255_ observationScopeId FK
  varchar_36_ parentId FK
  varchar_16_ status
  varchar_36_ supersededBy FK
  text text
  integer tokenCount
  timestamp_3__with_time_zone updatedAt
}
"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
  json schema
  json skills
  json tools
  timestamp_3__with_time_zone updatedAt
  varchar_36_ versionId
}
"public.agents_memory_entry_sources" {
  varchar_36_ agentId FK
  timestamp_3__with_time_zone createdAt
  varchar_64_ evidenceHash
  text evidenceText
  varchar_36_ id
  varchar_36_ memoryEntryId FK
  varchar_36_ observationId FK
  varchar_255_ threadId FK
  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