building_networks

30 rows where network_id = "1.3"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link building network_id
ISM-10,1.3 ISM-10 Mobility Channel gesamt 1.3
ISM-1108,1.3 ISM-1108 Mobility Channel gesamt 1.3
ISM-1179,1.3 ISM-1179 Mobility Channel gesamt 1.3
ISM-19,1.3 ISM-19 Mobility Channel gesamt 1.3
ISM-21,1.3 ISM-21 Mobility Channel gesamt 1.3
ISM-22,1.3 ISM-22 Mobility Channel gesamt 1.3
ISM-2204,1.3 ISM-2204 Mobility Channel gesamt 1.3
ISM-2311,1.3 ISM-2311 Mobility Channel gesamt 1.3
ISM-2321,1.3 ISM-2321 Mobility Channel gesamt 1.3
ISM-2365,1.3 ISM-2365 Mobility Channel gesamt 1.3
ISM-25,1.3 ISM-25 Mobility Channel gesamt 1.3
ISM-33,1.3 ISM-33 Mobility Channel gesamt 1.3
ISM-338,1.3 ISM-338 Mobility Channel gesamt 1.3
ISM-35,1.3 ISM-35 Mobility Channel gesamt 1.3
ISM-40,1.3 ISM-40 Mobility Channel gesamt 1.3
ISM-41,1.3 ISM-41 Mobility Channel gesamt 1.3
ISM-42,1.3 ISM-42 Mobility Channel gesamt 1.3
ISM-6725,1.3 ISM-6725 Mobility Channel gesamt 1.3
ISM-6726,1.3 ISM-6726 Mobility Channel gesamt 1.3
ISM-6740,1.3 ISM-6740 Mobility Channel gesamt 1.3
ISM-6801,1.3 ISM-6801 Mobility Channel gesamt 1.3
ISM-7961,1.3 ISM-7961 Mobility Channel gesamt 1.3
ISM-7967,1.3 ISM-7967 Mobility Channel gesamt 1.3
ISM-807,1.3 ISM-807 Mobility Channel gesamt 1.3
TOT_ND003855,1.3 TOT_ND003855 Mobility Channel gesamt 1.3
TOT_ND036962,1.3 TOT_ND036962 Mobility Channel gesamt 1.3
TOT_ND037036,1.3 TOT_ND037036 Mobility Channel gesamt 1.3
TOT_ND038778,1.3 TOT_ND038778 Mobility Channel gesamt 1.3
TOT_ND040030,1.3 TOT_ND040030 Mobility Channel gesamt 1.3
TOT_ND040568,1.3 TOT_ND040568 Mobility Channel gesamt 1.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)
);