Mqa Tool Question Options
Mqa Tool Question Options
| Field | Type | Description |
|---|---|---|
agency_id š | INTEGER | ID of the agency that owns the tool |
mqa_tool_id š | INTEGER | ID of the tool the question belongs to (mqa_tools.id) |
mqa_tool_slug | STRING | Slug of the tool (mqa_tools.slug), denormalized for labeling without a join |
form_version_id š | INTEGER | ID of the pinned form version (form_versions.id); joins to mqa_tool_questions together with questionnaire_key, question_path and branch. Together with questionnaire_key, question_path, branch and value this forms the natural key of the row |
questionnaire_key | STRING | Key of the questionnaire containing the question |
question_path | STRING | Dotted path of the question within the questionnaire |
branch | STRING | For descendants of a conditional block, which branch the question belongs to (items or items_2); null otherwise. Distinguishes same-key questions in mutually exclusive branches, which share a question_path |
position | INTEGER | 1-based authored order of the option within the question on this form version, for display sorting only; not part of the key |
value | STRING | Stored answer value for the option, unique within its question; this is what mqa_tool_responses.value contains and what reports join on |
label | STRING | Display label for the option, in English; equals value when the option was authored as a plain string |
Key Information
Foreign Keys
agency_id- ID of the agency that owns the toolmqa_tool_id- ID of the tool the question belongs to (mqa_tools.id)form_version_id- ID of the pinned form version (form_versions.id); joins to mqa_tool_questions together with questionnaire_key, question_path and branch. Together with questionnaire_key, question_path, branch and value this forms the natural key of the row
Updated 20 days ago
Did this page help you?
