building_networks

4 rows where network_id = "1.2"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link building network_id
AUT-1102,1.2 AUT-1102 Autobahn Touchpoint Gesamt 1.2
AUT-1103,1.2 AUT-1103 Autobahn Touchpoint Gesamt 1.2
AUT-1108,1.2 AUT-1108 Autobahn Touchpoint Gesamt 1.2
AUT-1109,1.2 AUT-1109 Autobahn Touchpoint Gesamt 1.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)
);