cisagov / crossfeed

External monitoring for organization assets
https://docs.crossfeed.cyber.dhs.gov
Creative Commons Zero v1.0 Universal
359 stars 54 forks source link

Create Relation Between vulnerability and cve Tables #2522

Open Matthew-Grayson opened 5 months ago

Matthew-Grayson commented 5 months ago

💡 Summary

Vulnerability has a cve field with the name of a CVE (e.g. CVE-2017-14158). Let's change to a uuid to make our db more efficient.

When coding API responses using TypeORM, joins aren't possible unless tables are related using a uuid. This means additional joins are needed in the frontend which complicates API usage.