Mqa Elimination Events

Mqa Elimination Events

FieldTypeDescription
mqa_elimination_event_id šŸ”‘INTEGERUnique identifier of the elimination event
agency_id šŸ”—INTEGERID of the agency that owns the review item
mqa_review_item_id šŸ”—INTEGERID of the eliminated review item (mqa_review_items.id)
eliminated_by_id šŸ”—INTEGERID of the agency worker who eliminated the item (users.id; agency workers are STI users)
commentsSTRINGFree-text comments entered when eliminating the item
replacement_case_idSTRINGFree-text ID of the case that replaces the eliminated item
created_atTIMESTAMPWhen the item was eliminated
updated_atTIMESTAMPWhen the event was last updated

Key Information

Primary Keys

  • mqa_elimination_event_id - Unique identifier of the elimination event

Foreign Keys

  • agency_id - ID of the agency that owns the review item
  • mqa_review_item_id - ID of the eliminated review item (mqa_review_items.id)
  • eliminated_by_id - ID of the agency worker who eliminated the item (users.id; agency workers are STI users)

Did this page help you?