media

3 rows where filiale = 10

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ code title filiale
19 20 Edeka Nordbayern GROß Edeka Nordbayern  10
20 21 Edeka Nordbayern KLEIN Edeka Nordbayern  10
21 22 Edeka Nordbayern MITTEL Edeka Nordbayern  10

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