Notifications — user-scoped in-app notifications
| Field | Type | Required | Description |
|---|
| orgId | string | Yes | Organization ID for multi-tenant isolation |
| userId | Id<"users"> | Yes | |
| programId | Id<"programs"> | No | Parent program reference |
| type | ”sandbox_complete” | “sandbox_failed” | “pr_ready” | “review_requested” | “subtask_completed” | “subtask_failed” | “subtask_scope_violation” | “all_subtasks_complete” | “subtask_paused” | “verification_completed” | “verification_failed” | “orchestration_plan_ready” | “orchestration_complete” | “orchestration_failed” | Yes | |
| title | string | Yes | |
| body | string | Yes | |
| link | string | No | |
| entityType | string | No | |
| entityId | string | No | |
| read | boolean | Yes | |
| createdAt | number | Yes | |
| Name | Fields |
|---|
| by_user_read | userId, read |
| by_org | orgId |