building_networks
2 rows where building = "STS-100305526"
This data as json, copyable, CSV (advanced)
| Link | building | network_id |
|---|---|---|
| STS-100305526,1.5 | STS-100305526 | Public Video Station Deutschland 1.5 |
| STS-100305526,1.6 | STS-100305526 | X-City Station 1.6 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );