Mqa Item Fields

Mqa Item Fields

FieldTypeDescription
mqa_item_field_id 🔑INTEGERUnique identifier of the item field
agency_id 🔗INTEGERID of the agency that owns the item field
labelSTRINGHuman-readable column label from the review upload
slugSTRINGStable machine key for the item field, unique per agency
field_typeSTRINGData type of the field (string, date, boolean, select, multi_select); tells BI how to cast mqa_item_field_values.value
created_atTIMESTAMPWhen the item field was created
updated_atTIMESTAMPWhen the item field was last updated

Key Information

Primary Keys

  • mqa_item_field_id - Unique identifier of the item field

Foreign Keys

  • agency_id - ID of the agency that owns the item field

Did this page help you?