Mqa Tool Questions

Mqa Tool Questions

FieldTypeDescription
agency_id šŸ”—INTEGERID of the agency that owns the tool
mqa_tool_id šŸ”—INTEGERID of the tool the question belongs to (mqa_tools.id)
mqa_tool_slugSTRINGSlug of the tool (mqa_tools.slug), denormalized so reports can label questions as tool_slug.question_key without a join
form_version_id šŸ”—INTEGERID 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_keySTRINGKey of the form section (domain) containing the questionnaire
section_titleSTRINGTitle of the form section, in English
section_positionINTEGER1-based order of the section within the form version
questionnaire_keySTRINGKey of the questionnaire (standard) containing the question; part of the natural key
questionnaire_titleSTRINGTitle of the questionnaire, in English
questionnaire_positionINTEGER1-based order of the questionnaire within its section
question_pathSTRINGDotted 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_keySTRINGAuthored 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_pathSTRINGDotted path of the enclosing block question, or null for top-level questions
branchSTRINGFor 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_typeSTRINGQuestion type as authored in the form (radio, checkbox, text, block, list_block, ...)
question_titleSTRINGQuestion title, in English
requiredBOOLEANWhether an answer is required
positionINTEGER1-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 tool
  • mqa_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

Did this page help you?