Add `traversal_ids` and `archived` columns to the `sbom_occurrences` table
Why are we doing this work
As we are trying to improve the performance of the group-level dependency list page, we are doing some schema denormalization to make it possible to remove join to the projects
table for the group-level queries. In this issue, we are adding the namespaces.traversal_ids
and projects.archived
columns to the sbom_occurrences
table to make it possible to remove that projects
table join.
Implementation plan
-
database Add traversal_ids
andarchived
columns to thesbom_occurrences
table.
Verification steps
- Verify that migration completed successfully
Edited by Brian Williams