building_networks

25 rows where network_id = "7.1.3"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link building network_id
ATV-187222,7.1.3 ATV-187222 King Channel 7.1.3
ATV-189880,7.1.3 ATV-189880 King Channel 7.1.3
ATV-90969,7.1.3 ATV-90969 King Channel 7.1.3
ATV-90990,7.1.3 ATV-90990 King Channel 7.1.3
ATV-90993,7.1.3 ATV-90993 King Channel 7.1.3
ATV-90994,7.1.3 ATV-90994 King Channel 7.1.3
ATV-90996,7.1.3 ATV-90996 King Channel 7.1.3
ATV-90997,7.1.3 ATV-90997 King Channel 7.1.3
ATV-90998,7.1.3 ATV-90998 King Channel 7.1.3
ATV-91001,7.1.3 ATV-91001 King Channel 7.1.3
ATV-91002,7.1.3 ATV-91002 King Channel 7.1.3
ATV-91004,7.1.3 ATV-91004 King Channel 7.1.3
BK-11711,7.1.3 BK-11711 King Channel 7.1.3
BK-11946,7.1.3 BK-11946 King Channel 7.1.3
BK-12532,7.1.3 BK-12532 King Channel 7.1.3
BK-13383,7.1.3 BK-13383 King Channel 7.1.3
BK-14155,7.1.3 BK-14155 King Channel 7.1.3
BK-15226,7.1.3 BK-15226 King Channel 7.1.3
BK-15297,7.1.3 BK-15297 King Channel 7.1.3
BK-16206,7.1.3 BK-16206 King Channel 7.1.3
BK-16593,7.1.3 BK-16593 King Channel 7.1.3
BK-21942,7.1.3 BK-21942 King Channel 7.1.3
BK-22119,7.1.3 BK-22119 King Channel 7.1.3
BK-6161,7.1.3 BK-6161 King Channel 7.1.3
BK-7158,7.1.3 BK-7158 King Channel 7.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)
);