product_market
1 row where product_id = 159
This data as json, CSV (advanced)
| id ▼ | product_id | market_id | url |
|---|---|---|---|
| 21 | Frosta 159 | REWE Markt Bremen/Arbergen Arberger Heerstr. 31 33 | https://www.rewe.de/produkte/frosta-rotes-curry-mit-haehnchen-und-reis-375g/8739785 |
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) );