A table that stores a device’s software information
Data model
Fields
| Field | Type | Description |
|---|---|---|
| company | NVARCHAR (510) | Registered Company |
| device_id* | INT | Associated device ID, reference to AAM_DEVICE.id table |
| id* | INT | Integer Type Primary Key |
| install_path_id | INT | Software installation path identifier, reference to AAM_PATH.id table |
| krun_status | CHAR (1) | Inventory Registration Status |
| modification_date* | DATETIME | Software Modification Date |
| owner | NVARCHAR (510) | Name of registered owner |
| product_code_id | INT | Software product code identifier, reference to AAM_SOFTWARE_CODE.id table |
| software_id* | INT | Identifier of the associated software, reference to the AAM_SOFTWARE_VERSION.id table |
| software_key_id | INT | Identifier of the associated software key, reference to the AAM_SOFTWARE_KEY.id table |
| system_component* | BIT | Indicates whether it is a system component |
| uninstall_string_id | INT | ID of the uninstall command, reference to the AAM_SOFTWARE_UNINSTALL.id table |
Primary Key
| PK_AAM_DEVICE_SOFTWARE |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| device_id* | dbo.AAM_DEVICE | id | FK01_AAM_DEVICE_SOFTWARE |
| install_path_id | dbo.AAM_PATH | id | FK03_AAM_DEVICE_SOFTWARE |
| product_code_id | Bod. AAM_SOFTWARE_CODE | id | FK04_AAM_DEVICE_SOFTWARE |
| software_id* | dbo.AAM_SOFTWARE_VERSION | id | FK02_AAM_DEVICE_SOFTWARE |
| software_key_id | Bod. AAM_SOFTWARE_KEY | id | FK05_AAM_DEVICE_SOFTWARE |
| uninstall_string_id | dbo.AAM_SOFTWARE_UNINSTALL | id | FK06_AAM_DEVICE_SOFTWARE |