⚙️ Magento_MysqlMq · engine innodb

queue_message_status

Relation table to keep associations between queues and messages

Neighbourhood (1-hop foreign-key graph — showing 2 of 2)

flowchart LR
  c["queue_message_status"]:::center
  n0["queue_message"]
  click n0 "/schema/table/queue_message"
  n0 -- message_id --> c
  n1["queue"]
  click n1 "/schema/table/queue"
  n1 -- queue_id --> c
  click c "/schema/table/queue_message_status"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (2)

message_id → queue_message queue_id → queue

Columns (6)

Name	Type	Null	Default	Comment
id PK	bigint unsigned	no		Relation ID
queue_id	int unsigned	no		Queue ID
message_id	bigint unsigned	no		Message ID
updated_at	timestamp	no	CURRENT_TIMESTAMP	Updated At
status	smallint unsigned	no		Message status in particular queue
number_of_trials	smallint unsigned	no	0	Number of trials to processed failed message processing

Keys & indexes

Primary key: id

Unique

QUEUE_MESSAGE_STATUS_QUEUE_ID_MESSAGE_ID (queue_id, message_id)

Indexes

QUEUE_MESSAGE_STATUS_STATUS_UPDATED_AT (status, updated_at) btree

References (2)

message_id → queue_message .id (on delete CASCADE)
queue_id → queue .id (on delete CASCADE)