Vulnerability management data structure issues

Summary

We have some normalization issues with our current database schema related to vulnerability data.

Current state of the schema can be seen here: https://dbdiagram.io/d/5f05f9d10425da461f046b6a

The DDL for those tables can be found here: $1994034

Notes

The dbdiagram.io tool is using a DSL called DBML. So in order to visualize the DDL definition we have, we have to translate it first to DBML by using the CLI tool provided.

Please update the schema snippet & the diagram accordingly if necessary.

Improvements

Risks

Involved components

Optional: Intended side effects

Optional: Missing test coverage