Mqa Review Items
Mqa Review Items
| Field | Type | Description |
|---|---|---|
mqa_review_item_id 🔑 | INTEGER | Unique identifier for this review item (mqa_review_items.id). |
agency_id 🔗 | INTEGER | The ID of the agency this review item belongs to. |
mqa_review_id 🔗 | INTEGER | The ID of the review (mqa_reviews.id) this item belongs to. |
external_id | STRING | Agency-supplied identifier from the upload (e.g. case number). Unique within a review. |
status | STRING | Review item status (pending, awaiting_approval, completed, replacement, eliminated). |
created_at | TIMESTAMP | When this record was created. |
updated_at | TIMESTAMP | When this record was last updated. |
Key Information
Primary Keys
mqa_review_item_id- Unique identifier for this review item (mqa_review_items.id).
Foreign Keys
agency_id- The ID of the agency this review item belongs to.mqa_review_id- The ID of the review (mqa_reviews.id) this item belongs to.
Updated 15 days ago
Did this page help you?