← Shopware 6.4.12.0

Shopware 6.4.12.0 order_transaction_capture_refund

Refund records for captured payments (partial or full refunds).

Columns

9 columns

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

Indexes

3 indexes

Index Name Columns Unique
fk.order_transaction_capture_refund.capture_id capture_id No
fk.order_transaction_capture_refund.state_id state_id No
PRIMARY id Yes

Relations (from this table)

2 relations

Local Field Foreign Table Foreign Field
capture_id order_transaction_capture id
state_id state_machine_state id

Relations (to this table)

1 relations

Local Field Foreign Table Foreign Field
id order_transaction_capture_refund_position refund_id