vulnerablecode icon indicating copy to clipboard operation
vulnerablecode copied to clipboard
verified publisher icon nexB

Make models better for efficient queries

Open TG1999 opened this issue 3 years ago • 1 comments

Currently we store packagerelatedvulnerabilities in one table, either a package fixes a vulnerability or affected by some vulnerability, the combination of package and vulnerability is stored in the same table with a flag for fix, We should segregate this data in 2 tables.

See also:

  • https://github.com/nexB/vulnerablecode/issues/595
  • https://github.com/nexB/vulnerablecode/issues/1549

TG1999 avatar Oct 20 '22 08:10 TG1999

Here are the diagrams we discussed in today's community call:

models

pombredanne avatar Aug 13 '24 16:08 pombredanne