Mqa Item Field Value Options

Mqa Item Field Value Options

FieldTypeDescription
mqa_item_field_value_id šŸ”—INTEGERID of the parent item field value row (mqa_item_field_values.id). Together with value this forms the natural key of the row
agency_id šŸ”—INTEGERID of the agency that owns the review item
mqa_review_item_id šŸ”—INTEGERID of the review item the selection belongs to (mqa_review_items.id). Multi-select values produce several rows per review item, so count DISTINCT mqa_review_item_id
mqa_item_field_id šŸ”—INTEGERID of the select or multi-select item field (mqa_item_fields.id)
valueSTRINGA single selected option; joins to mqa_item_field_options.value

Key Information

Foreign Keys

  • mqa_item_field_value_id - ID of the parent item field value row (mqa_item_field_values.id). Together with value this forms the natural key of the row
  • agency_id - ID of the agency that owns the review item
  • mqa_review_item_id - ID of the review item the selection belongs to (mqa_review_items.id). Multi-select values produce several rows per review item, so count DISTINCT mqa_review_item_id
  • mqa_item_field_id - ID of the select or multi-select item field (mqa_item_fields.id)

Did this page help you?