product_market
1 row where product_id = 212
This data as json, CSV (advanced)
| id ▼ | product_id | market_id | url |
|---|---|---|---|
| 25 | Milka Kleintafel 212 | ALDI Nord – Sortiment/Aktion 4 | https://www.aldi-nord.de/angebote/aktion-mo-15-12/tafel-1037439-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) );