Store an app’s consumption information on a device
Data model
Fields
| Field | Type | Description |
|---|---|---|
| app_id* | INT | App ID |
| celldata | BIGINT | Data consumed by the app on the device |
| device_id* | INT | Device Identifier |
| dimdate_id* | INT | Date dimension record ID |
| lastupdate | DATETIME | Date of last update |
| totalworkingtime | INT | Total working day time |
| user_id* | INT | User ID |
| 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* | dbo.ADW_DIM_DATE | id | FK04_AMDMAPPLICATIONMETRICS |
| user_id* | dbo.AFW_USERS | user_id | FK01_AMDMAPPLICATIONMETRICS |