building_networks

9 rows where network_id = "2.2"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link building network_id
ATV-91468,2.2 ATV-91468 Media Markt 2.2
ATV-91488,2.2 ATV-91488 Media Markt 2.2
ATV-91567,2.2 ATV-91567 Media Markt 2.2
ATV-91583,2.2 ATV-91583 Media Markt 2.2
ATV-91591,2.2 ATV-91591 Media Markt 2.2
ATV-94440,2.2 ATV-94440 Media Markt 2.2
ATV-94441,2.2 ATV-94441 Media Markt 2.2
ATV-94442,2.2 ATV-94442 Media Markt 2.2
ATV-94443,2.2 ATV-94443 Media Markt 2.2

Advanced export

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

CSV options: 

CREATE TABLE building_networks (
	building VARCHAR(100) NOT NULL, 
	network_id VARCHAR(100) NOT NULL, 
	PRIMARY KEY (building, network_id), 
	FOREIGN KEY(building) REFERENCES building (id), 
	FOREIGN KEY(network_id) REFERENCES network (id)
);