Mqa Tool Questions
Mqa Tool Questions
| 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 so reports can label questions as tool_slug.question_key without a join |
form_version_id š | INTEGER | ID of the pinned form version the question definition was read from (form_versions.id). Together with questionnaire_key and question_path this forms the natural key of the row |
section_key | STRING | Key of the form section (domain) containing the questionnaire |
section_title | STRING | Title of the form section, in English |
section_position | INTEGER | 1-based order of the section within the form version |
questionnaire_key | STRING | Key of the questionnaire (standard) containing the question; part of the natural key |
questionnaire_title | STRING | Title of the questionnaire, in English |
questionnaire_position | INTEGER | 1-based order of the questionnaire within its section |
question_path | STRING | Dotted path of the question within the questionnaire (e.g. concerns.notes); conditional branch segments are omitted; part of the natural key (with branch) and the key answer rows join on |
question_key | STRING | Authored key of the question (last segment of question_path, e.g. P11); a display handle only, unique within its parent block but not necessarily within the form |
parent_path | STRING | Dotted path of the enclosing block question, or null for top-level questions |
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 |
question_type | STRING | Question type as authored in the form (radio, checkbox, text, block, list_block, ...) |
question_title | STRING | Question title, in English |
required | BOOLEAN | Whether an answer is required |
position | INTEGER | 1-based order of the question within its questionnaire, in authored (depth-first) order |
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 the question definition was read from (form_versions.id). Together with questionnaire_key and question_path this forms the natural key of the row
Updated 20 days ago
Did this page help you?
