Requirements — gap analysis findings
| Field | Type | Required | Description |
|---|
| orgId | string | Yes | Organization ID for multi-tenant isolation |
| programId | Id<"programs"> | Yes | Parent program reference |
| workstreamId | Id<"workstreams"> | No | Parent workstream reference |
| refId | string | Yes | |
| title | string | Yes | |
| description | string | No | |
| batch | string | No | |
| priority | ”must_have” | “should_have” | “nice_to_have” | “deferred” | Yes | |
| fitGap | ”native” | “config” | “custom_dev” | “third_party” | “not_feasible” | Yes | |
| effortEstimate | union | No | |
| deliveryPhase | union | No | |
| status | ”draft” | “approved” | “in_progress” | “complete” | “deferred” | Yes | |
| dependencies | Id<"requirements">[] | No | |
| implementationStatus | union | No | |
| implementationConfidence | number | No | |
| lastAnalyzedAt | number | No | |
| lastAnalysisRunId | Id<"codebaseAnalysisRuns"> | No | |
| Name | Fields |
|---|
| by_program | programId |
| by_workstream | workstreamId |
| by_org | orgId |
| by_batch | programId, batch |