Mqa Tools

Mqa Tools

FieldTypeDescription
mqa_tool_id šŸ”‘INTEGERUnique identifier of the tool
agency_id šŸ”—INTEGERID of the agency that owns the tool
slugSTRINGStable machine key for the tool, unique per agency
nameSTRINGName of the backing form
form_id šŸ”—INTEGERID of the backing form (forms.id); the form version is pinned per review, see mqa_tool_submissions.form_version_id
tool_typeSTRINGTool type: questionnaire, alert, or participant_interview. Alert tools feed the Alerts reports
created_atTIMESTAMPWhen the tool was created
updated_atTIMESTAMPWhen the tool was last updated

Key Information

Primary Keys

  • mqa_tool_id - Unique identifier of the tool

Foreign Keys

  • agency_id - ID of the agency that owns the tool
  • form_id - ID of the backing form (forms.id); the form version is pinned per review, see mqa_tool_submissions.form_version_id

Did this page help you?