SWDB
← Versions / 6.5.8.18 /

cart

Fields (15)

Name Type Null Key Default Extra
token varchar(50) NO PRI NULL
price float NO NULL
line_item_count varchar(42) NO NULL
currency_id binary(16) NO MUL NULL
shipping_method_id binary(16) NO MUL NULL
payment_method_id binary(16) NO MUL NULL
country_id binary(16) NO MUL NULL
customer_id binary(16) YES MUL NULL
sales_channel_id binary(16) NO MUL NULL
rule_ids json NO NULL
created_at datetime(3) NO MUL NULL
updated_at datetime(3) YES NULL
auto_increment bigint NO UNI NULL auto_increment
compressed tinyint(1) NO 0
payload longblob YES NULL

Indexes (9)

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 (6)

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