product_market
1 row where product_id = 203
This data as json, CSV (advanced)
| id ▼ | product_id | market_id | url |
|---|---|---|---|
| 23 | Dallmayr Prodomo 500g 203 | ALDI Nord – Sortiment/Aktion 4 | https://www.aldi-nord.de/angebote/aktion-do-18-12/prodomo-1013317-0-0.article.html |
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) );