MageSmith

🛒 Magento_Sales · engine innodb

sales_order_payment

Sales Flat Order Payment

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

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

Click a node to jump to that table.

Related tables (3)

parent_id → sales_ordersales_payment_transaction → payment_idvault_payment_token_order_payment_link → order_payment_id

Columns (54)

NameTypeNullDefaultComment
entity_id PKint unsignednoEntity ID
parent_id int unsignednoParent ID
base_shipping_captured decimal yesBase Shipping Captured
shipping_captured decimal yesShipping Captured
amount_refunded decimal yesAmount Refunded
base_amount_paid decimal yesBase Amount Paid
amount_canceled decimal yesAmount Canceled
base_amount_authorized decimal yesBase Amount Authorized
base_amount_paid_online decimal yesBase Amount Paid Online
base_amount_refunded_online decimal yesBase Amount Refunded Online
base_shipping_amount decimal yesBase Shipping Amount
shipping_amount decimal yesShipping Amount
amount_paid decimal yesAmount Paid
amount_authorized decimal yesAmount Authorized
base_amount_ordered decimal yesBase Amount Ordered
base_shipping_refunded decimal yesBase Shipping Refunded
shipping_refunded decimal yesShipping Refunded
base_amount_refunded decimal yesBase Amount Refunded
amount_ordered decimal yesAmount Ordered
base_amount_canceled decimal yesBase Amount Canceled
quote_payment_id int yesQuote Payment ID
additional_data text yesAdditional Data
cc_exp_month varchar(12) yesCc Exp Month
cc_ss_start_year varchar(12) yesCc Ss Start Year
echeck_bank_name varchar(128) yesEcheck Bank Name
method varchar(128) yesMethod
cc_debug_request_body varchar(32) yesCc Debug Request Body
cc_secure_verify varchar(32) yesCc Secure Verify
protection_eligibility varchar(32) yesProtection Eligibility
cc_approval varchar(32) yesCc Approval
cc_last_4 varchar(100) yesCc Last 4
cc_status_description varchar(32) yesCc Status Description
echeck_type varchar(32) yesEcheck Type
cc_debug_response_serialized varchar(32) yesCc Debug Response Serialized
cc_ss_start_month varchar(128) yesCc Ss Start Month
echeck_account_type varchar(255) yesEcheck Account Type
last_trans_id varchar(255) yesLast Trans ID
cc_cid_status varchar(32) yesCc Cid Status
cc_owner varchar(128) yesCc Owner
cc_type varchar(32) yesCc Type
po_number varchar(32) yesPo Number
cc_exp_year varchar(4) yesCc Exp Year
cc_status varchar(4) yesCc Status
echeck_routing_number varchar(32) yesEcheck Routing Number
account_status varchar(32) yesAccount Status
anet_trans_method varchar(32) yesAnet Trans Method
cc_debug_response_body varchar(32) yesCc Debug Response Body
cc_ss_issue varchar(32) yesCc Ss Issue
echeck_account_name varchar(32) yesEcheck Account Name
cc_avs_status varchar(32) yesCc Avs Status
cc_number_enc varchar(128) yes
cc_trans_id varchar(32) yesCc Trans ID
address_status varchar(32) yesAddress Status
additional_information text yesAdditional Information

Keys & indexes

Primary key: entity_id

Indexes

  • SALES_ORDER_PAYMENT_PARENT_ID (parent_id) btree

References (1)

  • parent_id → sales_order .entity_id (on delete CASCADE)

Referenced by (2)