public.agent_plan

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
closedAt	timestamp(3) with time zone		true			NULL while the plan is active
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
data	json		false			Opaque plan document
formatVersion	integer		false			Version of the plan JSON format
id	uuid		false	public.agent_background_job public.agent_plan_history		Plan ID generated by the caller
revision	integer	1	false			Current document revision
threadId	varchar(128)		false		public.agent_execution_threads	Session that owns the plan
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false

Constraints

Name	Type	Definition
CHK_agent_plan_format_version	CHECK	CHECK (("formatVersion" > 0))
CHK_agent_plan_revision	CHECK	CHECK ((revision > 0))
FK_a72ec0a4fc0c1d6aa1d7a177e32	FOREIGN KEY	FOREIGN KEY ("threadId") REFERENCES agent_execution_threads(id) ON DELETE CASCADE
PK_c2b705709b763e796e29b1f6282	PRIMARY KEY	PRIMARY KEY (id)
agent_plan_createdAt_not_null	n	NOT NULL "createdAt"
agent_plan_data_not_null	n	NOT NULL data
agent_plan_formatVersion_not_null	n	NOT NULL "formatVersion"
agent_plan_id_not_null	n	NOT NULL id
agent_plan_revision_not_null	n	NOT NULL revision
agent_plan_threadId_not_null	n	NOT NULL "threadId"
agent_plan_updatedAt_not_null	n	NOT NULL "updatedAt"

Indexes

Name	Definition
IDX_a72ec0a4fc0c1d6aa1d7a177e3	CREATE INDEX "IDX_a72ec0a4fc0c1d6aa1d7a177e3" ON public.agent_plan USING btree ("threadId")
IDX_agent_plan_threadId	CREATE UNIQUE INDEX "IDX_agent_plan_threadId" ON public.agent_plan USING btree ("threadId") WHERE ("closedAt" IS NULL)
PK_c2b705709b763e796e29b1f6282	CREATE UNIQUE INDEX "PK_c2b705709b763e796e29b1f6282" ON public.agent_plan USING btree (id)

Relations

erDiagram

"public.agent_background_job" }o--o| "public.agent_plan" : "FOREIGN KEY (#quot;planId#quot;) REFERENCES agent_plan(id) ON DELETE SET NULL"
"public.agent_plan_history" }o--|| "public.agent_plan" : "FOREIGN KEY (#quot;planId#quot;) REFERENCES agent_plan(id) ON DELETE CASCADE"
"public.agent_plan" }o--|| "public.agent_execution_threads" : "FOREIGN KEY (#quot;threadId#quot;) REFERENCES agent_execution_threads(id) ON DELETE CASCADE"

"public.agent_plan" {
  timestamp_3__with_time_zone closedAt
  timestamp_3__with_time_zone createdAt
  json data
  integer formatVersion
  uuid id
  integer revision
  varchar_128_ threadId FK
  timestamp_3__with_time_zone updatedAt
}
"public.agent_background_job" {
  varchar_36_ childExecutionId
  varchar_128_ childThreadId
  timestamp_3__with_time_zone createdAt
  text error
  varchar_36_ id
  varchar_16_ kind
  timestamp_3__with_time_zone notifiedAt
  varchar_36_ parentAgentId FK
  varchar_64_ parentPrincipalHash
  varchar_255_ parentResourceId
  varchar_128_ parentThreadId
  uuid pauseRequestId
  uuid planId FK
  uuid planTaskId
  text result
  timestamp_3__with_time_zone settledAt
  varchar_36_ sourceExecutionId FK
  varchar_16_ status
  varchar_36_ subAgentId
  timestamp_3__with_time_zone timeoutAt
  varchar_255_ title
  timestamp_3__with_time_zone updatedAt
  varchar_36_ workflowId
}
"public.agent_plan_history" {
  timestamp_3__with_time_zone closedAt
  timestamp_3__with_time_zone createdAt
  json data
  integer formatVersion
  uuid planId FK
  integer revision
}
"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