4 rows
where screengroup = 22
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 22,10008898 |
Hamburg Elbbrücken U-Bf - all screens 22 |
10008898 - U-Bf Elbbr., Sto.1, V-Ebene 0, Schalterh. B 10008898 |
| 22,10008899 |
Hamburg Elbbrücken U-Bf - all screens 22 |
10008899 - U-Bf Elbbr., Sto.3, V-Ebene 0, Schalterh. C 10008899 |
| 22,10008900 |
Hamburg Elbbrücken U-Bf - all screens 22 |
10008900 - U-Bf Elbbr., Sto.4, V-Ebene 0, Schalterh. D 10008900 |
| 22,10008901 |
Hamburg Elbbrücken U-Bf - all screens 22 |
10008901 - U-Bf Elbbr., Sto.2, V-Ebene 0, Schalterh. A 10008901 |
CREATE TABLE screengroup_screens (
screengroup INTEGER NOT NULL,
screen VARCHAR(8) NOT NULL,
PRIMARY KEY (screengroup, screen),
FOREIGN KEY(screengroup) REFERENCES screengroup (id),
FOREIGN KEY(screen) REFERENCES screen (id)
);