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

public.instance_ai_checkpoints

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
key	varchar(255)		false	public.instance_ai_pending_confirmations		Opaque checkpoint key from the agent runtime.
runId	varchar(255)		true			Run ID parsed from the checkpoint key when available.
threadId	uuid		false		public.instance_ai_threads	Instance AI thread that owns the checkpoint.
resourceId	varchar(255)		true			Resource ID recorded by the agent runtime.
state	json		true			Serializable agent state snapshot stored as JSON.
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
expiredAt	timestamp(3) with time zone		true			Soft-delete timestamp: null means live; non-null marks the row as a tombstone.

Constraints

Name	Type	Definition
instance_ai_checkpoints_createdAt_not_null	n	NOT NULL "createdAt"
instance_ai_checkpoints_key_not_null	n	NOT NULL key
instance_ai_checkpoints_state_tombstone_check	CHECK	CHECK (((("expiredAt" IS NOT NULL) AND (state IS NULL)) OR ("expiredAt" IS NULL)))
instance_ai_checkpoints_threadId_not_null	n	NOT NULL "threadId"
instance_ai_checkpoints_updatedAt_not_null	n	NOT NULL "updatedAt"
FK_2b23f3f24a70bebb990203b011e	FOREIGN KEY	FOREIGN KEY ("threadId") REFERENCES instance_ai_threads(id) ON DELETE CASCADE
PK_5315a45f0846d1f9d128c18a2ed	PRIMARY KEY	PRIMARY KEY (key)

Indexes

Name	Definition
PK_5315a45f0846d1f9d128c18a2ed	CREATE UNIQUE INDEX "PK_5315a45f0846d1f9d128c18a2ed" ON public.instance_ai_checkpoints USING btree (key)
IDX_768189b506cc26c4fe878b87cb	CREATE INDEX "IDX_768189b506cc26c4fe878b87cb" ON public.instance_ai_checkpoints USING btree ("runId")
IDX_2b23f3f24a70bebb990203b011	CREATE INDEX "IDX_2b23f3f24a70bebb990203b011" ON public.instance_ai_checkpoints USING btree ("threadId")
IDX_be9d0eca0b19fb93d4eb74b327	CREATE INDEX "IDX_be9d0eca0b19fb93d4eb74b327" ON public.instance_ai_checkpoints USING btree ("resourceId")

Relations

erDiagram

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

"public.instance_ai_checkpoints" {
  varchar_255_ key
  varchar_255_ runId
  uuid threadId FK
  varchar_255_ resourceId
  json state
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
  timestamp_3__with_time_zone expiredAt
}
"public.instance_ai_pending_confirmations" {
  varchar_36_ requestId
  uuid threadId FK
  uuid userId FK
  varchar_16_ kind
  varchar_36_ runId
  varchar_64_ toolCallId
  varchar_36_ messageGroupId
  varchar_255_ checkpointKey FK
  varchar_36_ checkpointTaskId
  timestamp_3__with_time_zone expiresAt
  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