Table Type: Metadata
Contains the survey questions for a survey form.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| id | string | Primary Key | The unique identifier of the survey question. |
| form_id | string | The form_id of the survey form this question belongs to. | |
| group_id | string | The group_id of the survey question group this question belongs to. | |
| db_last_updated | datetime | When this record was last updated in UTC. | |
| db_when_created | datetime | When this record was created in UTC. | |
| db_when_deleted | datetime | When this record was deleted in UTC. NULL if not deleted | |
| type | string | Question type one of: multipleChoiceQuestion, freeTextQuestion, npsQuestion or readOnlyTextBlockQuestion | |
| text | string | The text of the question. | |
| help_text | string | Help text for the question. | |
| na_enabled | boolean | Whether the N/A option is enabled for this question. | |
| comments_required | boolean | Whether comments are required for this question. | |
| is_kill | boolean | Whether answering this question incorrectly automatically results in a failure. | |
| is_critical | boolean | Whether this question is marked as critical. |