← Shopware 6.4.16.1

Shopware 6.4.16.1 order_transaction_capture

Payment captures for a transaction (represents the actual charge of authorized payments).

Columns

9 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
order_transaction_id binary(16) NO Index Foreign Key → order_transaction.id
order_transaction_version_id binary(16) NO Foreign Key → order_transaction.version_id
state_id binary(16) NO Index Foreign Key → state_machine_state.id
external_reference varchar(255) YES
amount longtext NO
custom_fields longtext YES
created_at datetime(3) NO
updated_at datetime(3) YES

Indexes

3 indexes

Index Name Columns Unique
fk.order_transaction_capture.order_transaction_id order_transaction_id,order_transaction_version_id No
fk.order_transaction_capture.state_id state_id No
PRIMARY id Yes

Relations (from this table)

3 relations

Local Field Foreign Table Foreign Field
order_transaction_id order_transaction id
order_transaction_version_id order_transaction version_id
state_id state_machine_state id

Relations (to this table)

1 relations

Local Field Foreign Table Foreign Field
id order_transaction_capture_refund capture_id