Database table for programAgents records.
| Field | Type | Required | Description |
|---|
| orgId | string | Yes | Organization ID for multi-tenant isolation |
| programId | Id<"programs"> | Yes | Parent program reference |
| templateId | Id<"agentTemplates"> | No | |
| name | string | Yes | |
| description | string | Yes | |
| role | agentRoleValidator | Yes | |
| model | agentModelValidator | Yes | |
| tools | string[] | Yes | |
| systemPrompt | string | Yes | |
| constraints | string[] | Yes | |
| specializations | string[] | Yes | |
| personalityProfile | personalityProfileValidator | Yes | |
| avatarSeed | string | Yes | |
| skillIds | Id<"skills">[] | Yes | |
| workstreamIds | Id<"workstreams">[] | No | |
| status | agentStatusValidator | Yes | |
| currentVersion | number | Yes | |
| tokenBudget | tokenBudgetValidator | Yes | |
| createdBy | Id<"users"> | Yes | |
| Name | Fields |
|---|
| by_program | programId |
| by_program_status | programId, status |
| by_program_role | programId, role |
| by_org | orgId |