screengroup
1 row where building = 338828
This data as json, copyable, CSV (advanced)
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);