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

Refactor cve and product_info Tables #2521

Closed Matthew-Grayson closed 5 months ago

Matthew-Grayson commented 5 months ago

🐛 Summary

These are new tables that don't follow Crossfeed naming conventions. This makes development around the API confusing. The column names use snake_case whereas the rest of the tables use camelCase. Additionally, the uuid for the cve table is called "cve_uid" whereas every other table uses the name "id". Here are two tables that follow the naming convention:

Screenshot 2024-02-07 at 14 18 31 Screenshot 2024-02-07 at 14 19 09

Here are the new tables:

Screenshot 2024-02-07 at 14 19 26 Screenshot 2024-02-07 at 14 20 24