cart

Description

Cart information.

It is better to delete the cart by elapsed time from last accessing time.

Definition

Column Type Constraint Description
shop TEXT PRIMARY KEY Shop ID. (shop.username)
id INTEGER Identifier. (1-origin)
modified TIMESTAMP NOT NULL Last accessing time. (FIXME: This name would be not appropriate.)

Related tables

Query

CREATE TABLE cart(
shop       TEXT,
id         INTEGER,
modified   TIMESTAMP NOT NULL,
PRIMARY KEY(shop, id));