product_categories
5 rows where product_id = "5aak3hv5o2"
This data as json, CSV (advanced)
| Link | product_id | category_id |
|---|---|---|
| 5aak3hv5o2,19 | Floral Juvel 5aak3hv5o2 | Buketter 19 |
| 5aak3hv5o2,24 | Floral Juvel 5aak3hv5o2 | Morsdag 24 |
| 5aak3hv5o2,37 | Floral Juvel 5aak3hv5o2 | Valentines 37 |
| 5aak3hv5o2,40 | Floral Juvel 5aak3hv5o2 | Romanse 40 |
| 5aak3hv5o2,92 | Floral Juvel 5aak3hv5o2 | Flerfarget 92 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE product_categories (
product_id TEXT NOT NULL,
category_id INTEGER NOT NULL,
PRIMARY KEY (product_id, category_id),
FOREIGN KEY (product_id) REFERENCES products(id),
FOREIGN KEY (category_id) REFERENCES categories(id)
);