screengroup
1 row where building = "ECN-272196330"
This data as json, copyable, CSV (advanced)
| id ▼ | title | building | network |
|---|---|---|---|
| 462 | Bürodeck Bahrenfeld, Notkestr. 9, 22607 Hamburg - all screens | ECN-272196330 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE screengroup ( id INTEGER NOT NULL, title VARCHAR(250), building VARCHAR, network INTEGER, PRIMARY KEY (id), UNIQUE (id), FOREIGN KEY(building) REFERENCES building (id), FOREIGN KEY(network) REFERENCES network (id) ); CREATE INDEX ix_screengroup_building ON screengroup (building); CREATE INDEX ix_screengroup_network ON screengroup (network);