Mqa Review Item Fields
Mqa Review Item Fields
| Field | Type | Description |
|---|---|---|
mqa_review_id š | INTEGER | Review ID; forms part of the composite key with mqa_review_item_field_id. |
mqa_review_item_field_id š | INTEGER | Config row ID; forms part of the composite key with mqa_review_id. |
agency_id š | INTEGER | The ID of the agency this review belongs to. |
mqa_dataset_id š | INTEGER | The ID of the review's dataset. |
mqa_item_field_id š | INTEGER | The ID of the configured item field. |
position | INTEGER | Display position of the item field; nullable. |
visible_on_dashboard | BOOLEAN | Whether this item field is visible on the dashboard. |
filterable | BOOLEAN | Whether this item field can be used as a filter. |
strata | BOOLEAN | Whether this item field is used as a stratum. |
editable | BOOLEAN | Whether this item field can be edited. |
required | BOOLEAN | Whether this item field is required for the review. |
created_at | TIMESTAMP | When the config row was created. |
updated_at | TIMESTAMP | When the config row was last updated. |
Key Information
Primary Keys
mqa_review_id- Review ID; forms part of the composite key with mqa_review_item_field_id.mqa_review_item_field_id- Config row ID; forms part of the composite key with mqa_review_id.
Foreign Keys
agency_id- The ID of the agency this review belongs to.mqa_dataset_id- The ID of the review's dataset.mqa_item_field_id- The ID of the configured item field.
Updated 20 days ago
Did this page help you?
