media

3 rows where filiale = 13

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ code title filiale
27 28 Edeka Südwest GROß Edeka Südwest  13
28 29 Edeka Südwest KLEIN Edeka Südwest  13
29 30 Edeka Südwest MITTEL Edeka Südwest  13

Advanced export

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

CSV options: 

CREATE TABLE media (
	id INTEGER NOT NULL, 
	code INTEGER, 
	title VARCHAR(250), 
	filiale INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(filiale) REFERENCES filiale (id)
);
CREATE INDEX ix_media_code ON media (code);
CREATE INDEX ix_media_filiale ON media (filiale);