building

3 rows where publisher = 17

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ name_publisher publisher
I-EDK-2005955 EDEKA Sven Berger E aktivmarkt Berger VIEWENTO GmbH  17
I-EDK-2005962 Airport Plaza L.Tamme e.K. EDEKA Tamme VIEWENTO GmbH  17
I-EDK-2005973 Markus Böcker e.K. EDEKA Böcker VIEWENTO GmbH  17

Advanced export

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

CSV options: 

CREATE TABLE building (
	id VARCHAR(100) NOT NULL, 
	name_publisher VARCHAR(250), 
	publisher INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(publisher) REFERENCES publisher (id)
);
CREATE INDEX ix_building_name_publisher ON building (name_publisher);
CREATE INDEX ix_building_publisher ON building (publisher);