item_option_map

Description

Mapping of product and option.

Because option has not to be related with a category, it would be renamed to "product_option_map."

Also, "item_id" will become "product_id."

Definition

Column Type Constraint Description
shop TEXT PRIMARY KEY Shop ID. (shop.username)
item_id INTEGER Item ID. (item.id)
option_id INTEGER Option ID. (option.id)

Related tables

Query

CREATE TABLE item_option_map(
shop        TEXT,
item_id     INTEGER,
option_id   TEXT,
PRIMARY KEY(shop, item_id, option_id)
);