Store vulnerabilities by product and device
Data model
Fields
| Field | Type | Description |
|---|---|---|
| cve_id* | INT | Vulnerability identifier |
| date* | DATETIME2 | Date of vulnerability registration |
| device_id* | UNIQUEIDENTIFIER | Device Identifier |
| product_id* | INT | Product Identifier |
| signature* | INT | Product Signature |
| version* | VARCHAR (150) | Product Version |
Primary Key
| PK_AES_DEVICE_VULNERABILITY |
|---|
| device_id, signature, cve_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| cve_id* | dbo.AES_CVE | id | FK03_AES_DEVICE_VULNERABILITY |
| device_id* | dbo.AES_DEVICE | id | FK01_AES_DEVICE_VULNERABILITY |
| product_id* | dbo.AES_PRODUCT | id | FK02_AES_DEVICE_VULNERABILITY |
| signature* | dbo.AES_SIGNATURE | id | FK04_AES_DEVICE_VULNERABILITY |