Workstream Dependencies — cross-workstream dependency tracking
| Field | Type | Required | Description |
|---|
| orgId | string | Yes | Organization ID for multi-tenant isolation |
| programId | Id<"programs"> | Yes | Parent program reference |
| sourceWorkstreamId | Id<"workstreams"> | Yes | |
| targetWorkstreamId | Id<"workstreams"> | Yes | |
| description | string | No | |
| status | ”active” | “resolved” | “blocked” | “suggested” | “approved” | Yes | |
| dependencyType | union | No | |
| suggestedBy | ”manual” | “ai” | No | |
| aiConfidence | number | No | |
| requirementIds | Id<"requirements">[] | No | |
| approvedBy | string | No | |
| approvedAt | number | No | |
| Name | Fields |
|---|
| by_program | programId |
| by_source | sourceWorkstreamId |
| by_target | targetWorkstreamId |
| by_org_status | orgId, status |