Windows Phone and Surface Device fields: MI_DEVICE_WINDOWS_PHONE table
The set of Windows Phone and Surface-only device fields in the MI_DEVICE_WINDOWS_PHONE table comprises Windows Phone and Surface-specific device details. It has a one-or-zero to one relationship with the MI_DEVICE table. If a device is not a Windows Phone or Surface 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 etl_run_ts + vsp_id + device_id makes the primary key for this table. |
device_uuid | character varying(64) | No | No | |
dm_client_version | double precision | No | No | |
wp_cert_renew_timestamp | timestamp without time zone | No | No | |
wp_ent_dm_id | bigint | No | No | |
wp_exchange_id | character varying(255) | No | No | |
wp_firmware_version | character varying(255) | No | No | |
wp_hardware_version | character varying(255) | No | No | |
wp_local_time | timestamp without time zone | No | No | |
wp_processor_type | bigint | No | No | |
wp_signed_ent_dm_id | bigint | No | No | |
