product_market
1 row where product_id = 51
This data as json, CSV (advanced)
| id ▼ | product_id | market_id | url |
|---|---|---|---|
| 7 | kerrygold-original-irische-butter-250g 51 | REWE Markt Bremen 1 | https://www.rewe.de/produkte/kerrygold-original-irische-butter-250g/4529316 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE product_market ( id INTEGER PRIMARY KEY, product_id INTEGER NOT NULL REFERENCES product(id), market_id INTEGER NOT NULL REFERENCES market(id), url TEXT NOT NULL, UNIQUE(product_id, market_id) );