Add `traversal_ids` and `archived` columns to the `vulnerability_reads` table
Why are we doing this work
As we want to eliminate the need of joining to projects
table while fetching the vulnerability records, we want to denormalize the archived
information and keep it in the vulnerability_reads
table.
In addition to this, we also want to reduce the amount of buffer use and improve the execution time of group-level vulnerability queries even further by implementing the namespace key approach.
Implementation plan
-
database add traversal_ids
andarchived
columns to thevulnerability_reads
table
Verification steps
-
Check the database schema for the vulnerability_reads
table and verify that it has thetraversal_ids
andarchived
columns.
Edited by Gregory Havenga