product_market
1 row where market_id = 24
This data as json, CSV (advanced)
| id ▼ | product_id | market_id | url |
|---|---|---|---|
| 17 | Coca-Cola 0,85l 140 | REWE Köln – Lieferservice 24 | 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) );