product_market

2 rows where product_id = 3

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ product_id market_id url
3 kerrygold-original-irische-butter-250g/ 3 REWE Markt Bremen 1 https://www.rewe.de/produkte/kerrygold-original-irische-butter-250g/4529316
6 kerrygold-original-irische-butter-250g/ 3 REWE Markt Bonn 2 https://www.rewe.de/produkte/kerrygold-original-irische-butter-250g/4529316

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);