Mapping between pair of product and option and donloadable data.
| Column | Type | Constraint | Description |
|---|---|---|---|
| shop | TEXT | PRIMARY KEY | Shop ID. (shop.username) |
| product_id | INTEGER | Product ID. (product.id) | |
| option_id | INTEGER | Option ID. (option.id | |
| data_id | INTEGER | Data ID. (downloadable_data.id) |
CREATE TABLE product_option_data_map(
shop TEXT,
product_id INTEGER,
option_id INTEGER,
data_id INTEGER,
PRIMARY KEY (shop, product_id, option_id, data_id)
);