Table storing software version
Data model
Fields
| Field | Type | Description |
|---|---|---|
| id* | INT | Integer Type Primary Key |
| is_inventory* | BIT | flag to indicate if the software is in inventory |
| is_permitted* | INT | Indicates if it is a permitted software |
| parent_id | INT | Indicates if it is a child of any AAM_SOFTWARE_VERSION.id software |
| product_id* | INT | Product Identifier AAM_SOFTWARE_PRODUCT.id |
| version | NVARCHAR (510) | Software version |
Primary Key
| PK_AAM_SOFTWARE_VERSION |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| parent_id | dbo.AAM_SOFTWARE_VERSION | id | FK02_AAM_SOFTWARE_VERSION |
| product_id* | dbo.AAM_SOFTWARE_PRODUCT | id | FK01_AAM_SOFTWARE_VERSION |