building

9 rows where publisher = 5

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ name_publisher publisher
RSG-HH001 McFIT Hamburg-Stellingen El Cartel Media 5
RSG-HH002 McFIT Hamburg-Steilshoop El Cartel Media 5
RSG-HH003 McFIT Hamburg-Hamm El Cartel Media 5
RSG-HH004 McFIT Hamburg-Othmarschen El Cartel Media 5
RSG-HH005 John Reed Hamburg-Harburg El Cartel Media 5
RSG-HH006 John Reed Hamburg-Wandsbek El Cartel Media 5
RSG-HH007 McFIT Hamburg-St. Georg El Cartel Media 5
RSG-HH008 McFIT Hamburg-Stellingen II El Cartel Media 5
RSG-HH010 McFIT Hohenfelde El Cartel Media 5

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