Mapping between order product and download ticket.
| Column | Type | Constraint | Description |
|---|---|---|---|
| shop | TEXT | PRIMARY KEY | Shop ID. (shop.username) |
| order_id | INTEGER | Order ID. (order.id) | |
| index | INTEGER | Index of ordered products. (order_product.index) | |
| ticket_id | INTEGER | Ticket ID. (download_ticket.id) |
CREATE TABLE order_product_download_ticket_map(
shop TEXT,
order_id INTEGER,
index INTEGER,
ticket_id INTEGER,
PRIMARY KEY (shop, order_id, index, ticket_id)
);