Shopware 6.4.20.1 cart
Persisted shopping carts (serialized) for logged-in customers and guest sessions.
| Column | Type | Nullable | Additional |
| token | varchar(50) | NO | Primary Key |
| name | varchar(500) | 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 |
| rule_ids | json | NO | |
| created_at | datetime(3) | NO | Index |
| updated_at | datetime(3) | YES | |
| auto_increment | bigint(20) | NO | Unique, auto_increment |
| compressed | tinyint(1) | NO | Default: 0 |
| payload | longblob | YES | |
| Index Name | Columns | Unique |
| auto_increment | auto_increment | Yes |
| 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 |
| idx.cart.created_at | created_at | No |
| PRIMARY | token | Yes |
Relations (from this table)
6 relations
