Agents Threads

Description

Name	Type	Default	Nullable	Children
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
id	varchar(128)		false	agents_memory_entry_candidates agents_memory_entry_sources agents_messages agents_observation_cursors agents_observation_locks agents_observations
metadata	TEXT		true
resourceId	varchar(255)		false
title	varchar(255)		true
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false

Name	Type	Definition
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_agents_threads_1	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
IDX_54fa1b94f34a409beafae567a4	CREATE INDEX “IDX_54fa1b94f34a409beafae567a4” ON “agents_threads” (“resourceId”)
sqlite_autoindex_agents_threads_1	PRIMARY KEY (id)

erDiagram "agents_memory_entry_candidates" }o--|| "agents_threads" : "FOREIGN KEY (threadId) REFERENCES agents_threads (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE" "agents_memory_entry_sources" }o--|| "agents_threads" : "FOREIGN KEY (threadId) REFERENCES agents_threads (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE" "agents_messages" }o--|| "agents_threads" : "FOREIGN KEY (threadId) REFERENCES agents_threads (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE" "agents_observation_cursors" |o--|| "agents_threads" : "FOREIGN KEY (observationScopeId) REFERENCES agents_threads (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE" "agents_observation_locks" |o--|| "agents_threads" : "FOREIGN KEY (observationScopeId) REFERENCES agents_threads (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE" "agents_observations" }o--|| "agents_threads" : "FOREIGN KEY (observationScopeId) REFERENCES agents_threads (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE" "agents_threads" { datetime_3_ createdAt varchar_128_ id PK TEXT metadata varchar_255_ resourceId varchar_255_ title datetime_3_ updatedAt } "agents_memory_entry_candidates" { varchar_36_ agentId FK smallint attemptCount TEXT content datetime_3_ createdAt TEXT evidenceText varchar_36_ id PK varchar_32_ kind varchar_255_ resourceId FK varchar_255_ runId varchar_36_ sourceMessageId FK varchar_16_ status varchar_255_ threadId FK varchar_255_ toolCallId datetime_3_ updatedAt } "agents_memory_entry_sources" { varchar_36_ agentId FK varchar_36_ candidateId FK datetime_3_ createdAt varchar_64_ evidenceHash TEXT evidenceText varchar_36_ id PK varchar_36_ memoryEntryId FK varchar_36_ observationId FK varchar_255_ threadId FK datetime_3_ updatedAt } "agents_messages" { TEXT author TEXT content datetime_3_ createdAt varchar_36_ id PK TEXT modelContent DATETIME modelContextAt TEXT origin varchar_255_ resourceId varchar_36_ role varchar_255_ threadId FK varchar_36_ type datetime_3_ updatedAt } "agents_observation_cursors" { varchar_36_ agentId PK datetime_3_ createdAt datetime_3_ lastObservedAt varchar_36_ lastObservedMessageId varchar_255_ observationScopeId PK datetime_3_ updatedAt } "agents_observation_locks" { varchar_36_ agentId PK datetime_3_ createdAt datetime_3_ heldUntil varchar_64_ holderId varchar_255_ observationScopeId PK varchar_20_ taskKind PK datetime_3_ updatedAt } "agents_observations" { varchar_36_ agentId FK datetime_3_ createdAt varchar_36_ id PK varchar_16_ marker varchar_255_ observationScopeId FK varchar_36_ parentId FK varchar_16_ status varchar_36_ supersededBy FK TEXT text INTEGER tokenCount datetime_3_ updatedAt }

Description

Agents Threads

Description

Columns

Constraints

Indexes

Relations