Mqa Item Field Values
Mqa Item Field Values
| Field | Type | Description |
|---|---|---|
mqa_item_field_value_id 🔑 | INTEGER | Unique identifier of the item field value |
agency_id 🔗 | INTEGER | ID of the agency that owns the review item |
mqa_review_item_id 🔗 | INTEGER | ID of the review item the value belongs to (mqa_review_items.id) |
mqa_item_field_id 🔗 | INTEGER | ID of the item field the value is for (mqa_item_fields.id) |
item_field_slug | STRING | Slug of the item field (mqa_item_fields.slug), denormalized so reports can pivot without a join |
item_field_type | STRING | Data type of the item field (mqa_item_fields.field_type); tells BI how to cast value |
value | STRING | Normalized value. Multi-select values are exported as a comma-separated list of the selected options rather than a JSON array |
created_at | TIMESTAMP | When the value was created |
updated_at | TIMESTAMP | When 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 itemmqa_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)
Updated 27 days ago
Did this page help you?
