🛒 Magento_Sales · engine innodb

sales_payment_transaction

Sales Payment Transaction

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

flowchart LR
  c["sales_payment_transaction"]:::center
  n0["sales_order"]
  click n0 "/schema/table/sales_order"
  n0 -- order_id --> c
  n1["sales_order_payment"]
  click n1 "/schema/table/sales_order_payment"
  n1 -- payment_id --> c
  click c "/schema/table/sales_payment_transaction"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (4)

order_id → sales_order parent_id → sales_payment_transaction payment_id → sales_order_payment sales_payment_transaction → parent_id

Columns (10)

Name	Type	Null	Default	Comment
transaction_id PK	int unsigned	no		Transaction ID
parent_id	int unsigned	yes		Parent ID
order_id	int unsigned	no	0	Order ID
payment_id	int unsigned	no	0	Payment ID
txn_id	varchar(100)	yes		Txn ID
parent_txn_id	varchar(100)	yes		Parent Txn ID
txn_type	varchar(15)	yes		Txn Type
is_closed	smallint unsigned	no	1	Is Closed
additional_information	blob	yes		Additional Information
created_at	timestamp	no	CURRENT_TIMESTAMP	Created At

Keys & indexes

Primary key: transaction_id

Unique

SALES_PAYMENT_TRANSACTION_ORDER_ID_PAYMENT_ID_TXN_ID (order_id, payment_id, txn_id)

Indexes

SALES_PAYMENT_TRANSACTION_PARENT_ID (parent_id) btree
SALES_PAYMENT_TRANSACTION_PAYMENT_ID (payment_id) btree

References (3)

order_id → sales_order .entity_id (on delete CASCADE)
parent_id → sales_payment_transaction .transaction_id (on delete CASCADE)
payment_id → sales_order_payment .entity_id (on delete CASCADE)

Referenced by (1)

sales_payment_transaction .parent_id → .transaction_id (on delete CASCADE)