Table that stores the inventory update date by application
Data model
Fields
| Field | Type | Description |
|---|---|---|
| app_code* | INT | Application Code |
| device_id* | INT | Associated device identifier |
| id* | INT | Unique device inventory identifier |
| last_update* | DATETIME | Date of last inventory update |
| type* | INT | Inventory type for the product |
Primary Key
| PK_ADM_DEVICE_INVENTORY |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| app_code* | Bod. AFW_APPLICATIONS | appl_id | FK01_ADM_DEVICE_INVENTORY |
| device_id* | dbo.AAM_DEVICE | id | FK02_ADM_DEVICE_INVENTORY |