Mqa Tool Question Options

Mqa Tool Question Options

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 for labeling without a join
form_version_id šŸ”—INTEGERID 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_keySTRINGKey of the questionnaire containing the question
question_pathSTRINGDotted path of the question within the questionnaire
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
positionINTEGER1-based authored order of the option within the question on this form version, for display sorting only; not part of the key
valueSTRINGStored answer value for the option, unique within its question; this is what mqa_tool_responses.value contains and what reports join on
labelSTRINGDisplay 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 tool
  • mqa_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

Did this page help you?