Store an app’s consumption information on a device
Data model
Fields
| Field | Type | Description |
|---|---|---|
| app_id* | INT | Application ID. Reference to the AMDM_APPSINFORMATION.id table |
| celldata | BIGINT | Data consumed by the app on the device |
| device_id* | INT | Device identifier. Reference to the AMDM_DEVICE.id table |
| dimdate_id* | INT | Date dimension record ID. Reference to the ADW_DIM_DATE.id table |
| lastupdate | DATETIME | Date of last update |
| totalworkingtime | INT | Total working day time |
| user_id* | INT | User identifier. Reference to the AFW_USERS.user_id table |
| usetime | INT | Time spent using the app on the device |
Primary Key
| PK_AMDMAPPLICATIONMETRICS |
|---|
| user_id, device_id, app_id, dimdate_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| app_id* | dbo.AMDM_APPSINFORMATION | id | FK03_AMDMAPPLICATIONMETRICS |
| device_id* | dbo.AMDM_DEVICE | id | FK02_AMDMAPPLICATIONMETRICS |
| dimdate_id* | Bod. ADW_DIM_DATE | id | FK04_AMDMAPPLICATIONMETRICS |
| user_id* | dbo.AFW_USERS | user_id | FK01_AMDMAPPLICATIONMETRICS |