screengroup
1 row where building = "BK-22119"
This data as json, copyable, CSV (advanced)
| id ▼ | title | building | network |
|---|---|---|---|
| 335 | Burger King, Hamburg, Friedrich-Ebert-Damm 166 - all screens | BK-22119 |
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);