Android-only device fields:
MI_DEVICE_ANDROID table
The set of Android-only device fields in the MI_DEVICE_ANDROID table comprises only Android-specific device details. It has a one-or-zero to one relationship with the MI_DEVICE table. If a device is not an Android device, the record will not be here.
Name | Data type | Not Null? | Primary key? | Description |
etl_run_ts |
timestamp without time zone |
Yes |
No |
The time the snapshot is taken on VSP. |
vsp_id |
integer |
No |
No |
|
device_id |
bigint |
No |
No |
VSP device_id. The combination of : |
device_uuid |
character varying(64) |
No |
No |
|
dpm_encryption_status |
varchar |
No |
No |
|
admin_activated |
boolean |
No |
No |
|
board |
character varying(255) |
No |
No |
|
brand |
character varying(255) |
No |
No |
|
c2dmtoken |
character varying(255) |
No |
No |
|
codename |
character varying(255) |
No |
No |
|
device |
character varying(255) |
No |
No |
|
device_roaming_flag |
boolean |
No |
No |
|
incremental |
character varying(255) |
No |
No |
|
mdm_enabled |
boolean |
No |
No |
|
media_card_capacity |
bigint |
No |
No |
|
media_card_free |
bigint |
No |
No |
|
multi_mdm |
boolean |
No |
No |
|
os_build_number |
character varying(255) |
No |
No |
|
platform_flags |
character varying(255) |
No |
No |
|
registration_status |
varchar |
No |
No |
|
security_detail |
bigint |
No |
No |
|
security_patch |
varchar |
No |
No |
|
security_reason |
varchar |
No |
No |
|
usb_debugging |
boolean |
No |
No |
|