cart_session

Description

Cart session.

Cart session id can be transferred via non-secure connection. So the cart session id must be changed when a customer try to make an order.

Definition

Column Type Constraint Description
shop TEXT PRIMARY KEY Shop ID. (shop.username)
session_id TEXT Cart session id. Random string.
cart_id INTEGER NOT NULL Cart ID. (cart.id)

Related tables

Query

CREATE TABLE cart_session(
shop           TEXT,
session_id     TEXT,
cart_id        INTEGER  NOT NULL,
PRIMARY KEY(shop, session_id)
);