Mqa Item Field Values

Mqa Item Field Values

FieldTypeDescription
mqa_item_field_value_id 🔑INTEGERUnique identifier of the item field value
agency_id 🔗INTEGERID of the agency that owns the review item
mqa_review_item_id 🔗INTEGERID of the review item the value belongs to (mqa_review_items.id)
mqa_item_field_id 🔗INTEGERID of the item field the value is for (mqa_item_fields.id)
item_field_slugSTRINGSlug of the item field (mqa_item_fields.slug), denormalized so reports can pivot without a join
item_field_typeSTRINGData type of the item field (mqa_item_fields.field_type); tells BI how to cast value
valueSTRINGNormalized value. Multi-select values are exported as a comma-separated list of the selected options rather than a JSON array
created_atTIMESTAMPWhen the value was created
updated_atTIMESTAMPWhen the value was last updated

Key Information

Primary Keys

  • mqa_item_field_value_id - Unique identifier of the item field value

Foreign Keys

  • agency_id - ID of the agency that owns the review item
  • mqa_review_item_id - ID of the review item the value belongs to (mqa_review_items.id)
  • mqa_item_field_id - ID of the item field the value is for (mqa_item_fields.id)

Did this page help you?