surveyresultdevice
The surveyresultdevice table describes the devices used by a participant to interact with surveys.
Table Schema
| Name | Type | Description |
|---|---|---|
| personid | VARCHAR |
Internal identifier to specify a unique instance of a person. This column is used to partition data tables in the Bulk Data API and should be included on all table joins. Use personid to join to tables in other models within the Bulk Data API. |
| surveyresultkey | VARCHAR |
The key for the related survey result. Key relationship with the surveyresult table. |
| surveyresultdevicekey | VARCHAR |
Primary Key. Internal identifier to specify this instance a survey result and device. |
| name | VARCHAR |
The self-declared name of the device used to give this response. Typically a model name such as iPhone11 or Pixel 3. |
| platform | VARCHAR |
The type of device used, generally corresponding to Android, iOS, or Web. |
| osversion | VARCHAR |
The operating system version of the device used to generate this response. |
