Table that stores the software
Data model
Fields
| Field | Type | Description |
|---|---|---|
| manufacturer_id* | INT | Identifier in the manufacturers’ database |
| name* | NVARCHAR (512) | Software Name |
| platform* | INT | Platform Identifier (Unknown=0, Windows=1, Linux=2, Mac=3) |
| type* | INT | Software type identifier (None=-1, OperatingSystem=0, Application=1, Updates=2) |
Primary Key
| PK_AAM_SOFTWARE_PRODUCT |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| manufacturer_id* | dbo.AAM_MANUFACTURER | id | FK01_AAM_SOFTWARE_PRODUCT |