product_categories
5 rows where product_id = "qssg74mbiw"
This data as json, CSV (advanced)
| Link | product_id | category_id |
|---|---|---|
| qssg74mbiw,23 | Lovely Mother qssg74mbiw | Mothers Day 23 |
| qssg74mbiw,39 | Lovely Mother qssg74mbiw | Red 39 |
| qssg74mbiw,51 | Lovely Mother qssg74mbiw | Bouquets 51 |
| qssg74mbiw,74 | Lovely Mother qssg74mbiw | Best Sellers 74 |
| qssg74mbiw,99 | Lovely Mother qssg74mbiw | Pink 99 |
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)
);