26 lines
1.5 KiB
Markdown
26 lines
1.5 KiB
Markdown
|
# Task ID: 118
|
||
|
|
|
||
|
|
**Title:** Add Task, TaskVerdict, TaskEvent Prisma models
|
||
|
|
|
||
|
|
**Status:** pending
|
||
|
|
|
||
|
|
**Dependencies:** 117
|
||
|
|
|
||
|
|
**Priority:** high
|
||
|
|
|
||
|
|
**Description:** Add Task, TaskVerdict, TaskEvent models with enums TaskState and TaskRisk to schema.prisma for work item tracking
|
||
|
|
|
||
|
|
**Details:**
|
||
|
|
|
||
|
|
In src/db/prisma/schema.prisma add:
|
||
|
|
1. enum TaskState { todo, in_progress, building, self_testing, qa_review, security_review, sre_review, done, awaiting_review, merged, reopened, cancelled }
|
||
|
|
2. enum TaskRisk { trivial, normal, high }
|
||
|
|
3. model Task with: id, name, title, description (@db.Text), epicTaskId, repoId?, assigneeId?, state, risk, branch?, headCommit?, prUrl?, prNumber?, reviewNote? (@db.Text), ownerId, version, createdAt, updatedAt. Relations: epicTask, repo (CodeRepo?), assignee (Agent?), owner, verdicts[], sessions[], events[]. @@unique([name, epicTaskId]), indexes on epicTaskId, state, assigneeId
|
||
|
|
4. model TaskVerdict with: id, taskId, stage (TaskState), agentId?, commit, passed, summary (@db.Text), findings (Json), createdAt. Relations: task, agent. @@index([taskId]), @@index([taskId, stage])
|
||
|
|
5. model TaskEvent with: id, taskId, fromState?, toState, actorType, actorId?, note? (@db.Text), createdAt. @@index([taskId, createdAt])
|
||
|
|
6. Add reverse relations to Agent model (assignedTasks[], verdicts[])
|
||
|
|
|
||
|
|
**Test Strategy:**
|
||
|
|
|
||
|
|
Schema tests: create Task linked to EpicTask, verify cascade on EpicTask delete, test TaskVerdict immutability pattern, test TaskEvent append-only by creating multiple events for same task.
|