Store device health information
Data model
Fields
| Field | Type | Description |
|---|---|---|
| date_id* | INT | Date dimension identifier. Reference to the ADW_DIM_DATE.id table |
| device_id* | INT | Device identifier. Reference to the AMDM_DEVICE.id table |
| id* | INT | Unique identifier of a device’s health information at a particular point in time |
| last* | BIT | Determines if it’s the last record of a device |
| percentbatterylevel | INT | Battery Level Percentage |
| percentusedexternalstorage | INT | Percentage of external storage used |
| percentusedinternalstorage | INT | Percentage of internal storage used |
| percentusedrammemory | INT | Percentage of RAM used |
| percentusedstorage | INT | Percentage of storage used |
| recorddate* | DATETIME | Log Storage Date |
| signalstrength | INT | Data signal strength |
| simcarrier | VARCHAR (64) | SIM Operator |
| ssid | VARCHAR (128) | WiFi Network Service Packet Identifier |
| time_id* | INT | Time dimension identifier. Reference to the ADW_DIM_TIME.id table |
| totalexternalstorage | BIGINT | Total amount of external storage |
| totalinternalstorage | BIGINT | Total amount of internal storage |
| totalrammemory | BIGINT | Total amount of RAM |
| totalstorage | BIGINT | Total amount of storage |
| usedexternalstorage | BIGINT | Amount of external storage used |
| usedinternalstorage | BIGINT | Amount of internal storage used |
| usedrammemory | BIGINT | Amount of RAM used |
| usedstorage | BIGINT | Amount of storage used |
| wifisignalstrength | INT | WiFi signal strength |
Primary Key
| PK_AMDM_DEVICE_HEALTHINFO |
|---|
| device_id, date_id, time_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| date_id* | Bod. ADW_DIM_DATE | id | FK02_AMDM_DEVICE_HEALTHINFO |
| device_id* | dbo.AMDM_DEVICE | id | FK01_AMDM_DEVICE_HEALTHINFO |
| time_id* | Bod. ADW_DIM_TIME | id | FK03_AMDM_DEVICE_HEALTHINFO |