Mqa Review Tools

Mqa Review Tools

FieldTypeDescription
mqa_review_id 🔑INTEGERReview ID; forms part of the composite key with mqa_review_tool_id.
mqa_review_tool_id 🔑INTEGERConfig row ID; forms part of the composite key with mqa_review_id.
agency_id 🔗INTEGERThe ID of the agency this review belongs to.
mqa_dataset_id 🔗INTEGERThe ID of the review's dataset.
mqa_tool_id 🔗INTEGERThe ID of the configured tool.
form_version_id 🔗INTEGERThe ID of the pinned form version.
requiredBOOLEANWhether using the tool is required for this review.
created_atTIMESTAMPWhen the config row was created.
updated_atTIMESTAMPWhen the config row was last updated.

Key Information

Primary Keys

  • mqa_review_id - Review ID; forms part of the composite key with mqa_review_tool_id.
  • mqa_review_tool_id - Config row ID; forms part of the composite key with mqa_review_id.

Foreign Keys

  • agency_id - The ID of the agency this review belongs to.
  • mqa_dataset_id - The ID of the review's dataset.
  • mqa_tool_id - The ID of the configured tool.
  • form_version_id - The ID of the pinned form version.

Did this page help you?