product_data_map

Description

Mapping between product and downloadable data.

Definition

Column Type Constraint Description
shop TEXT PRIMARY KEY Shop ID. (shop.username)
product_id INTEGER Product ID. (product.id)
data_id INTEGER Data ID. (downloadable_data.id)

Related tables

Query

CREATE TABLE product_data_map(
shop        TEXT,
product_id  INTEGER,
data_id     INTEGER,
PRIMARY KEY (shop, product_id, data_id)
);