---
title: Android-only device fields: MI_DEVICE_ANDROID table
slug: rdb/essentials-guide/android-only-device-fields-mideviceandroid-table
createdAt: 2026-11-05T09:24:41.831Z
---

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.

Table: MI\_Device\_Android device fields

| 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**.<br />The combination of :<br />**etl\_run\_ts** + **vsp\_id** + **device\_id**<br />makes the primary key for this table. |
| 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           |                                                                                                                                               |

