public.agent_thread_grants¶

Columns¶

Name	Type	Default	Nullable	Parents	Comment
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
grantKey	varchar(512)		false		JSON tuple: [tool, toolName] or [integration_action, connectionId, action]
threadId	varchar(128)		false	public.agent_execution_threads
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false

Constraints¶

Name	Type	Definition
FK_10aad4b5b51d34aae8da90fd5cb	FOREIGN KEY	FOREIGN KEY ("threadId") REFERENCES agent_execution_threads(id) ON DELETE CASCADE
PK_18777b98ed446901dd7453424ce	PRIMARY KEY	PRIMARY KEY ("threadId", "grantKey")
agent_thread_grants_createdAt_not_null	n	NOT NULL "createdAt"
agent_thread_grants_grantKey_not_null	n	NOT NULL "grantKey"
agent_thread_grants_threadId_not_null	n	NOT NULL "threadId"
agent_thread_grants_updatedAt_not_null	n	NOT NULL "updatedAt"

Indexes¶

Name	Definition
PK_18777b98ed446901dd7453424ce	CREATE UNIQUE INDEX "PK_18777b98ed446901dd7453424ce" ON public.agent_thread_grants USING btree ("threadId", "grantKey")

Relations¶

erDiagram

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

"public.agent_thread_grants" {
  timestamp_3__with_time_zone createdAt
  varchar_512_ grantKey
  varchar_128_ threadId FK
  timestamp_3__with_time_zone updatedAt
}
"public.agent_execution_threads" {
  varchar_16_ accessScope
  varchar_36_ agentId FK
  varchar_255_ agentName
  timestamp_3__with_time_zone createdAt
  varchar_8_ emoji
  varchar_128_ id
  uuid ownerId FK
  varchar_36_ parentAgentId
  varchar_128_ parentThreadId
  varchar_255_ projectId FK
  integer sessionNumber
  varchar_32_ taskId
  json taskStop
  varchar_36_ taskVersionId FK
  varchar_255_ title
  integer totalCompletionTokens
  double_precision totalCost
  integer totalDuration
  integer totalPromptTokens
  timestamp_3__with_time_zone updatedAt
}

Generated by tbls