pricing_map

Description

Mapping of item/tag and pricing.

Definition

Column Type Constraint Description
shop TEXT PRIMARY KEY Shop ID. (shop.username)
pricing_id INTEGER pricing の ID.
target INTEGER Type of target.
target_id INTEGER Target ID. (item.id/tag.id)

Related tables

Query

CREATE TABLE pricing_map(
shop       TEXT,
pricing_id INTEGER,
target     INTEGER,
target_id  INTEGER,
PRIMARY KEY (shop, pricing_id, target, target_id)
);