product_categories
9 rows where product_id = "7m7ndgzxh6"
This data as json, CSV (advanced)
| Link | product_id | category_id |
|---|---|---|
| 7m7ndgzxh6,9 | Cream White Roses 7m7ndgzxh6 | Homepage Specials 9 |
| 7m7ndgzxh6,18 | Cream White Roses 7m7ndgzxh6 | White 18 |
| 7m7ndgzxh6,45 | Cream White Roses 7m7ndgzxh6 | Sympathy Bouquet 45 |
| 7m7ndgzxh6,58 | Cream White Roses 7m7ndgzxh6 | Jubileum 58 |
| 7m7ndgzxh6,73 | Cream White Roses 7m7ndgzxh6 | Sympathy 73 |
| 7m7ndgzxh6,74 | Cream White Roses 7m7ndgzxh6 | Best Sellers 74 |
| 7m7ndgzxh6,77 | Cream White Roses 7m7ndgzxh6 | Homepage No 77 |
| 7m7ndgzxh6,93 | Cream White Roses 7m7ndgzxh6 | Hvit 93 |
| 7m7ndgzxh6,97 | Cream White Roses 7m7ndgzxh6 | Anniversary 97 |
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)
);