cart_product_option

Description

Option of product in the cart.

Definition

Column Type Constraint Description
shop TEXT PRIMARY KEY Shop ID. (shop.username)
cart_id INTEGER Cart ID. (cart.id)
index INTEGER Index of product in the cart. (cart_product.index)
option_id INTEGER Option ID. (option.id)
quantity INTEGER NOT NULL Quantity.

Related tables

Query

CREATE TABLE cart_product_option(
shop       TEXT,
cart_id    INTEGER,
index      INTEGER,
option_id  INTEGER,
quantity   INTEGER NOT NULL,
PRIMARY KEY(shop, cart_id, index, option_id)
);