public.agent_task_snapshot
Columns
| Name |
Type |
Default |
Nullable |
Children |
Parents |
Comment |
| createdAt |
timestamp(3) with time zone |
CURRENT_TIMESTAMP(3) |
false |
|
|
|
| cronExpression |
varchar(128) |
|
false |
|
|
Cron schedule evaluated using the instance timezone |
| enabled |
boolean |
|
false |
|
|
Published enabled state for this task at publish time |
| name |
varchar(128) |
|
false |
|
|
|
| objective |
text |
|
false |
|
|
User-authored instruction sent to the agent when this task runs |
| taskId |
varchar(32) |
|
false |
|
|
Stable task ID referenced from the published agent JSON config |
| timezone |
varchar(64) |
|
true |
|
|
IANA timezone the cron is evaluated in; null falls back to the instance timezone |
| updatedAt |
timestamp(3) with time zone |
CURRENT_TIMESTAMP(3) |
false |
|
|
|
| versionId |
varchar(36) |
|
false |
|
public.agent_history |
Published agent_history version this task snapshot belongs to |
Constraints
| Name |
Type |
Definition |
| FK_1acedce6690392ef1611cca8b88 |
FOREIGN KEY |
FOREIGN KEY ("versionId") REFERENCES agent_history("versionId") ON DELETE CASCADE |
| PK_2142a8bcda2360c3c5e34f82640 |
PRIMARY KEY |
PRIMARY KEY ("versionId", "taskId") |
| agent_task_snapshot_createdAt_not_null |
n |
NOT NULL "createdAt" |
| agent_task_snapshot_cronExpression_not_null |
n |
NOT NULL "cronExpression" |
| agent_task_snapshot_enabled_not_null |
n |
NOT NULL enabled |
| agent_task_snapshot_name_not_null |
n |
NOT NULL name |
| agent_task_snapshot_objective_not_null |
n |
NOT NULL objective |
| agent_task_snapshot_taskId_not_null |
n |
NOT NULL "taskId" |
| agent_task_snapshot_updatedAt_not_null |
n |
NOT NULL "updatedAt" |
| agent_task_snapshot_versionId_not_null |
n |
NOT NULL "versionId" |
Indexes
| Name |
Definition |
| PK_2142a8bcda2360c3c5e34f82640 |
CREATE UNIQUE INDEX "PK_2142a8bcda2360c3c5e34f82640" ON public.agent_task_snapshot USING btree ("versionId", "taskId") |
Relations
erDiagram
"public.agent_task_snapshot" }o--|| "public.agent_history" : "FOREIGN KEY (#quot;versionId#quot;) REFERENCES agent_history(#quot;versionId#quot;) ON DELETE CASCADE"
"public.agent_task_snapshot" {
timestamp_3__with_time_zone createdAt
varchar_128_ cronExpression
boolean enabled
varchar_128_ name
text objective
varchar_32_ taskId
varchar_64_ timezone
timestamp_3__with_time_zone updatedAt
varchar_36_ versionId FK
}
"public.agent_history" {
varchar_36_ agentId FK
varchar_255_ author
timestamp_3__with_time_zone createdAt
uuid publishedById FK
json schema
json skills
json tools
timestamp_3__with_time_zone updatedAt
varchar_36_ versionId
}
Generated by tbls