⚙️ Magento_AsynchronousOperations · engine innodb

magento_operation

Operation entity

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

flowchart LR
  c["magento_operation"]:::center
  n0["magento_bulk"]
  click n0 "/schema/table/magento_bulk"
  n0 -- bulk_uuid --> c
  click c "/schema/table/magento_operation"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (1)

bulk_uuid → magento_bulk

Columns (10)

Name	Type	Null	Default	Comment
id PK	int unsigned	no		Operation ID
operation_key	int unsigned	yes		Operation Key
bulk_uuid	varbinary(39)	yes		Related Bulk UUID
topic_name	varchar(255)	yes		Name of the related message queue topic
serialized_data	blob	yes		Data (serialized) required to perform an operation
result_serialized_data	blob	yes		Result data (serialized) after perform an operation
status	smallint	yes	0	Operation status (OPEN \| COMPLETE \| RETRIABLY_FAILED \| NOT_RETRIABLY_FAILED)
error_code	smallint	yes		Code of the error that appeared during operation execution (used to aggregate related failed operations)
result_message	varchar(255)	yes		Operation result message
started_at	timestamp	yes	NULL	Datetime the operation started processing

Keys & indexes

Primary key: id

Indexes

MAGENTO_OPERATION_BULK_UUID_ERROR_CODE (bulk_uuid, error_code) btree
MAGENTO_OPERATION_STATUS_STARTED_AT (status, started_at) btree
MAGENTO_OPERATION_BULK_UUID_OPERATION_KEY (bulk_uuid, operation_key) btree

References (1)

bulk_uuid → magento_bulk .uuid (on delete CASCADE)