[Composition Analysis] Backfill sbom_occurrences_vulnerabilities.vulnerability_occurrence_id (BBM)

Part of &21396 (Complete at Scale Vulnerability Management).

Problem

sbom_occurrences_vulnerabilities.vulnerability_occurrence_id has no backfill background migration (VAC consistency check VO-ID-FILL). Existing rows are NULL, which blocks reliable context joins for reachability and future partitioning.

Scope

Add a batched background migration (BBM) to backfill vulnerability_occurrence_id from vulnerabilities.finding_id. Coordinate with the VAC consistency-check work in &20929.

Notes

  • This is a prerequisite for making reachability queries tracked-context aware (companion SBOM query-layer issue).
Edited by 🤖 GitLab Bot 🤖