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

public.instance_ai_iteration_logs

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	varchar(36)		false
threadId	uuid		false		public.instance_ai_threads
taskKey	varchar		false
entry	text		false
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false

Constraints

Name	Type	Definition
instance_ai_iteration_logs_createdAt_not_null	n	NOT NULL "createdAt"
instance_ai_iteration_logs_entry_not_null	n	NOT NULL entry
instance_ai_iteration_logs_id_not_null	n	NOT NULL id
instance_ai_iteration_logs_taskKey_not_null	n	NOT NULL "taskKey"
instance_ai_iteration_logs_threadId_not_null	n	NOT NULL "threadId"
instance_ai_iteration_logs_updatedAt_not_null	n	NOT NULL "updatedAt"
FK_8bfcc6c51fd3d69b1eae8aebd49	FOREIGN KEY	FOREIGN KEY ("threadId") REFERENCES instance_ai_threads(id) ON DELETE CASCADE
PK_21c2b214b44bc6c34a6d3551c90	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
PK_21c2b214b44bc6c34a6d3551c90	CREATE UNIQUE INDEX "PK_21c2b214b44bc6c34a6d3551c90" ON public.instance_ai_iteration_logs USING btree (id)
IDX_02751202c9a2ad75f2d8e14f5e	CREATE INDEX "IDX_02751202c9a2ad75f2d8e14f5e" ON public.instance_ai_iteration_logs USING btree ("threadId", "taskKey", "createdAt")

Relations

erDiagram

"public.instance_ai_iteration_logs" }o--|| "public.instance_ai_threads" : "FOREIGN KEY (#quot;threadId#quot;) REFERENCES instance_ai_threads(id) ON DELETE CASCADE"

"public.instance_ai_iteration_logs" {
  varchar_36_ id
  uuid threadId FK
  varchar taskKey
  text entry
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
}
"public.instance_ai_threads" {
  uuid id
  varchar_255_ resourceId
  text title
  json metadata
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
  varchar_36_ projectId FK
}

---

Generated by tbls