building_networks

6 rows where network_id = "7.3"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link building network_id
100445707,7.3 100445707 Public Video Cinema 7.3
100445708,7.3 100445708 Public Video Cinema 7.3
100445709,7.3 100445709 Public Video Cinema 7.3
ATV-109970,7.3 ATV-109970 Public Video Cinema 7.3
ATV-109971,7.3 ATV-109971 Public Video Cinema 7.3
ATV-109972,7.3 ATV-109972 Public Video Cinema 7.3

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