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 and archived columns to the sbom_occurrences table.

Verification steps

  • Verify that migration completed successfully
Edited by Brian Williams (Ex-GitLab)