Mqa Item Field Value Options
Mqa Item Field Value Options
| Field | Type | Description |
|---|---|---|
mqa_item_field_value_id š | INTEGER | 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 š | INTEGER | ID of the agency that owns the review item |
mqa_review_item_id š | INTEGER | 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 š | INTEGER | ID of the select or multi-select item field (mqa_item_fields.id) |
value | STRING | A 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 rowagency_id- ID of the agency that owns the review itemmqa_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_idmqa_item_field_id- ID of the select or multi-select item field (mqa_item_fields.id)
Updated 27 days ago
Did this page help you?
