building_networks

23 rows where network_id = "2.1.1"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link building network_id
S-DE-HH-2701-01,2.1.1 S-DE-HH-2701-01 POS Netzwerk 2.1.1
S-DE-HH-2703-01,2.1.1 S-DE-HH-2703-01 POS Netzwerk 2.1.1
S-DE-HH-2705-01,2.1.1 S-DE-HH-2705-01 POS Netzwerk 2.1.1
S-DE-HH-2878-01,2.1.1 S-DE-HH-2878-01 POS Netzwerk 2.1.1
S-DE-HH-2886-01,2.1.1 S-DE-HH-2886-01 POS Netzwerk 2.1.1
S-DE-HH-2887-01,2.1.1 S-DE-HH-2887-01 POS Netzwerk 2.1.1
S-DE-HH-2907-01,2.1.1 S-DE-HH-2907-01 POS Netzwerk 2.1.1
S-DE-HH-2908-01,2.1.1 S-DE-HH-2908-01 POS Netzwerk 2.1.1
S-DE-HH-2985-01,2.1.1 S-DE-HH-2985-01 POS Netzwerk 2.1.1
S-DE-HH-2986-01,2.1.1 S-DE-HH-2986-01 POS Netzwerk 2.1.1
S-DE-HH-2987-01,2.1.1 S-DE-HH-2987-01 POS Netzwerk 2.1.1
S-DE-HH-3029-01,2.1.1 S-DE-HH-3029-01 POS Netzwerk 2.1.1
S-DE-HH-3074-01,2.1.1 S-DE-HH-3074-01 POS Netzwerk 2.1.1
S-DE-HH-3075-01,2.1.1 S-DE-HH-3075-01 POS Netzwerk 2.1.1
S-DE-HH-3247-01,2.1.1 S-DE-HH-3247-01 POS Netzwerk 2.1.1
S-DE-HH-3250-01,2.1.1 S-DE-HH-3250-01 POS Netzwerk 2.1.1
S-DE-HH-3251-01,2.1.1 S-DE-HH-3251-01 POS Netzwerk 2.1.1
S-DE-HH-3323-01,2.1.1 S-DE-HH-3323-01 POS Netzwerk 2.1.1
S-DE-HH-3383-01,2.1.1 S-DE-HH-3383-01 POS Netzwerk 2.1.1
S-DE-HH-3388-01,2.1.1 S-DE-HH-3388-01 POS Netzwerk 2.1.1
S-DE-HH-3511-01,2.1.1 S-DE-HH-3511-01 POS Netzwerk 2.1.1
S-DE-HH-3512-01,2.1.1 S-DE-HH-3512-01 POS Netzwerk 2.1.1
S-DE-HH-4058-01,2.1.1 S-DE-HH-4058-01 POS Netzwerk 2.1.1

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