product_categories
15 rows where product_id = "ee2py0lb3a"
This data as json, CSV (advanced)
| Link | product_id | category_id |
|---|---|---|
| ee2py0lb3a,6 | Rosy Beauty ee2py0lb3a | Blomster i en boks 6 |
| ee2py0lb3a,9 | Rosy Beauty ee2py0lb3a | Homepage Specials 9 |
| ee2py0lb3a,11 | Rosy Beauty ee2py0lb3a | Romance 11 |
| ee2py0lb3a,13 | Rosy Beauty ee2py0lb3a | Seasonal Product 13 |
| ee2py0lb3a,23 | Rosy Beauty ee2py0lb3a | Mothers Day 23 |
| ee2py0lb3a,24 | Rosy Beauty ee2py0lb3a | Morsdag 24 |
| ee2py0lb3a,37 | Rosy Beauty ee2py0lb3a | Valentines 37 |
| ee2py0lb3a,40 | Rosy Beauty ee2py0lb3a | Romanse 40 |
| ee2py0lb3a,42 | Rosy Beauty ee2py0lb3a | Orange 42 |
| ee2py0lb3a,67 | Rosy Beauty ee2py0lb3a | Valentines Day 67 |
| ee2py0lb3a,77 | Rosy Beauty ee2py0lb3a | Homepage No 77 |
| ee2py0lb3a,79 | Rosy Beauty ee2py0lb3a | Oransj 79 |
| ee2py0lb3a,94 | Rosy Beauty ee2py0lb3a | Rosa 94 |
| ee2py0lb3a,99 | Rosy Beauty ee2py0lb3a | Pink 99 |
| ee2py0lb3a,100 | Rosy Beauty ee2py0lb3a | Flowers in a box 100 |
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)
);