Discussion: DB Modifications - Where to save static reachability data.
Background
As part of Static reachability feature , based on the results of the modifications to sbom reports , the last stage is to decide where to save the data in our Database in order to be able to presents it in our UI to the customer.
Implementation plan
I think the best place to add a new column ,type text will be in sbom_occurences table, since this table represents packages from a specific customer , and project.
- This column will not be an index .
cc- @or-gal , @minac , @theoretick