Mqa Review Item Fields

Mqa Review Item Fields

FieldTypeDescription
mqa_review_id šŸ”‘INTEGERReview ID; forms part of the composite key with mqa_review_item_field_id.
mqa_review_item_field_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_item_field_id šŸ”—INTEGERThe ID of the configured item field.
positionINTEGERDisplay position of the item field; nullable.
visible_on_dashboardBOOLEANWhether this item field is visible on the dashboard.
filterableBOOLEANWhether this item field can be used as a filter.
strataBOOLEANWhether this item field is used as a stratum.
editableBOOLEANWhether this item field can be edited.
requiredBOOLEANWhether this item field is required for the 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_item_field_id.
  • mqa_review_item_field_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_item_field_id - The ID of the configured item field.

Did this page help you?