41 rows
where network_id = "6.1.1"
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
building
|
network_id
|
| ECN-136580163,6.1.1 |
ECN-136580163 |
ECN 6.1.1 |
| ECN-173697442,6.1.1 |
ECN-173697442 |
ECN 6.1.1 |
| ECN-186517115,6.1.1 |
ECN-186517115 |
ECN 6.1.1 |
| ECN-191472976,6.1.1 |
ECN-191472976 |
ECN 6.1.1 |
| ECN-191479167,6.1.1 |
ECN-191479167 |
ECN 6.1.1 |
| ECN-200385943,6.1.1 |
ECN-200385943 |
ECN 6.1.1 |
| ECN-207730558,6.1.1 |
ECN-207730558 |
ECN 6.1.1 |
| ECN-207732939,6.1.1 |
ECN-207732939 |
ECN 6.1.1 |
| ECN-208357834,6.1.1 |
ECN-208357834 |
ECN 6.1.1 |
| ECN-224393563,6.1.1 |
ECN-224393563 |
ECN 6.1.1 |
| ECN-231706935,6.1.1 |
ECN-231706935 |
ECN 6.1.1 |
| ECN-231795401,6.1.1 |
ECN-231795401 |
ECN 6.1.1 |
| ECN-233232751,6.1.1 |
ECN-233232751 |
ECN 6.1.1 |
| ECN-237777606,6.1.1 |
ECN-237777606 |
ECN 6.1.1 |
| ECN-237826812,6.1.1 |
ECN-237826812 |
ECN 6.1.1 |
| ECN-237828628,6.1.1 |
ECN-237828628 |
ECN 6.1.1 |
| ECN-238019523,6.1.1 |
ECN-238019523 |
ECN 6.1.1 |
| ECN-248873805,6.1.1 |
ECN-248873805 |
ECN 6.1.1 |
| ECN-256705601,6.1.1 |
ECN-256705601 |
ECN 6.1.1 |
| ECN-256712113,6.1.1 |
ECN-256712113 |
ECN 6.1.1 |
| ECN-256713007,6.1.1 |
ECN-256713007 |
ECN 6.1.1 |
| ECN-265601802,6.1.1 |
ECN-265601802 |
ECN 6.1.1 |
| ECN-268811611,6.1.1 |
ECN-268811611 |
ECN 6.1.1 |
| ECN-272196330,6.1.1 |
ECN-272196330 |
ECN 6.1.1 |
| ECN-272227245,6.1.1 |
ECN-272227245 |
ECN 6.1.1 |
| ECN-278498330,6.1.1 |
ECN-278498330 |
ECN 6.1.1 |
| ECN-283940219,6.1.1 |
ECN-283940219 |
ECN 6.1.1 |
| ECN-301300090,6.1.1 |
ECN-301300090 |
ECN 6.1.1 |
| ECN-305108878,6.1.1 |
ECN-305108878 |
ECN 6.1.1 |
| ECN-309883193,6.1.1 |
ECN-309883193 |
ECN 6.1.1 |
| ECN-309884817,6.1.1 |
ECN-309884817 |
ECN 6.1.1 |
| ECN-309910053,6.1.1 |
ECN-309910053 |
ECN 6.1.1 |
| ECN-309945276,6.1.1 |
ECN-309945276 |
ECN 6.1.1 |
| ECN-309963849,6.1.1 |
ECN-309963849 |
ECN 6.1.1 |
| ECN-310102064,6.1.1 |
ECN-310102064 |
ECN 6.1.1 |
| ECN-310174085,6.1.1 |
ECN-310174085 |
ECN 6.1.1 |
| ECN-318568214,6.1.1 |
ECN-318568214 |
ECN 6.1.1 |
| ECN-410872207,6.1.1 |
ECN-410872207 |
ECN 6.1.1 |
| ECN-439277805,6.1.1 |
ECN-439277805 |
ECN 6.1.1 |
| ECN-568285835,6.1.1 |
ECN-568285835 |
ECN 6.1.1 |
| ECN-568298686,6.1.1 |
ECN-568298686 |
ECN 6.1.1 |
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)
);