← Shopware 6.2.0.rc1

Shopware 6.2.0.rc1 cart

Persisted shopping carts (serialized) for logged-in customers and guest sessions.

Columns

12 columns

Column Type Nullable Additional
token varchar(50) NO Primary Key
name varchar(500) NO
cart longtext NO
price float NO
line_item_count varchar(42) NO
currency_id binary(16) NO Index Foreign Key → currency.id
shipping_method_id binary(16) NO Index Foreign Key → shipping_method.id
payment_method_id binary(16) NO Index Foreign Key → payment_method.id
country_id binary(16) NO Index Foreign Key → country.id
customer_id binary(16) YES Index Foreign Key → customer.id
sales_channel_id binary(16) NO Index Foreign Key → sales_channel.id
created_at datetime(3) NO

Indexes

7 indexes

Index Name Columns Unique
fk.cart.country_id country_id No
fk.cart.currency_id currency_id No
fk.cart.customer_id customer_id No
fk.cart.payment_method_id payment_method_id No
fk.cart.sales_channel_id sales_channel_id No
fk.cart.shipping_method_id shipping_method_id No
PRIMARY token Yes

Relations (from this table)

6 relations

Local Field Foreign Table Foreign Field
country_id country id
currency_id currency id
customer_id customer id
payment_method_id payment_method id
sales_channel_id sales_channel id
shipping_method_id shipping_method id