20 rows
where network_id = "2.5.1"
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
building
|
network_id
|
| INO-881371,2.5.1 |
INO-881371 |
Inovisco Retail 2.5.1 |
| INO-881382,2.5.1 |
INO-881382 |
Inovisco Retail 2.5.1 |
| INO-881387,2.5.1 |
INO-881387 |
Inovisco Retail 2.5.1 |
| INO-881764,2.5.1 |
INO-881764 |
Inovisco Retail 2.5.1 |
| INO-881908,2.5.1 |
INO-881908 |
Inovisco Retail 2.5.1 |
| INO-881915,2.5.1 |
INO-881915 |
Inovisco Retail 2.5.1 |
| INO-881916,2.5.1 |
INO-881916 |
Inovisco Retail 2.5.1 |
| INO-882092,2.5.1 |
INO-882092 |
Inovisco Retail 2.5.1 |
| INO-882516,2.5.1 |
INO-882516 |
Inovisco Retail 2.5.1 |
| INO-882517,2.5.1 |
INO-882517 |
Inovisco Retail 2.5.1 |
| INO-885017,2.5.1 |
INO-885017 |
Inovisco Retail 2.5.1 |
| INO-885018,2.5.1 |
INO-885018 |
Inovisco Retail 2.5.1 |
| INO-885023,2.5.1 |
INO-885023 |
Inovisco Retail 2.5.1 |
| INO-885024,2.5.1 |
INO-885024 |
Inovisco Retail 2.5.1 |
| INO-885285,2.5.1 |
INO-885285 |
Inovisco Retail 2.5.1 |
| INO-890489,2.5.1 |
INO-890489 |
Inovisco Retail 2.5.1 |
| INO-890498,2.5.1 |
INO-890498 |
Inovisco Retail 2.5.1 |
| INO-892192,2.5.1 |
INO-892192 |
Inovisco Retail 2.5.1 |
| INO-893080,2.5.1 |
INO-893080 |
Inovisco Retail 2.5.1 |
| INO-893303,2.5.1 |
INO-893303 |
Inovisco Retail 2.5.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)
);