16 rows
where screengroup = 11
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 11,10009198 |
Hamburg Schlump U-Bf - all screens 11 |
10009198 - U-Bf Schlump,Eb-1,U3,Bstg.2,re v. Treppenabg.zu U2 10009198 |
| 11,10009199 |
Hamburg Schlump U-Bf - all screens 11 |
10009199 - U-Bf Schlump,Eb.0,Schalterh. außen Ri. Str., li. 10009199 |
| 11,10009200 |
Hamburg Schlump U-Bf - all screens 11 |
10009200 - U-Bf Schlump,Eb.0,Schalterh. außen Ri. Str., re. 10009200 |
| 11,10010449 |
Hamburg Schlump U-Bf - all screens 11 |
10010449 - U-Bf Schlump,Eb.-2,U2,Gl.5 Ri.Niendorf Nord,3.StO 10010449 |
| 11,10010453 |
Hamburg Schlump U-Bf - all screens 11 |
10010453 - U-Bf Schlump,Eb.-1,U3,Gl.3 Ri.Barmbek,2.StO 10010453 |
| 11,10010454 |
Hamburg Schlump U-Bf - all screens 11 |
10010454 - U-Bf Schlump,Eb.-2,U2,Gl.5 Ri.Niendorf Nord,2.StO 10010454 |
| 11,10010456 |
Hamburg Schlump U-Bf - all screens 11 |
10010456 - U-Bf Schlump,E-1,U3,Gl.1 Ri.Wandsb.Gartenst.,3.StO 10010456 |
| 11,10010462 |
Hamburg Schlump U-Bf - all screens 11 |
10010462 - U-Bf Schlump,E-1,U3,Gl.1 Ri.Wandsb.Gartenst.,2.StO 10010462 |
| 11,10010466 |
Hamburg Schlump U-Bf - all screens 11 |
10010466 - U-Bf Schlump,E-1,U3,Gl.1 Ri.Wandsb.Gartenst.,1.StO 10010466 |
| 11,10010471 |
Hamburg Schlump U-Bf - all screens 11 |
10010471 - U-Bf Schlump,Eb.-1,U3,Gl.3 Ri.Barmbek,1.StO 10010471 |
| 11,10010475 |
Hamburg Schlump U-Bf - all screens 11 |
10010475 - U-Bf Schlump,Eb-2,U2,Gl.4 Ri.Mümmelm.b.,3.StO.v.li 10010475 |
| 11,10010477 |
Hamburg Schlump U-Bf - all screens 11 |
10010477 - U-Bf Schlump,Eb.-2,U2,Gl.5 Ri.Niendorf Nord,1.StO 10010477 |
| 11,10010480 |
Hamburg Schlump U-Bf - all screens 11 |
10010480 - U-Bf Schlump,Eb-2,U2,Gl.4 Ri.Mümmelm.b.,4.StO.v.li 10010480 |
| 11,10010482 |
Hamburg Schlump U-Bf - all screens 11 |
10010482 - U-Bf Schlump,Eb-2,U2,Gl.4 Ri.Mümmelm.b.,2.StO.v.li 10010482 |
| 11,10010483 |
Hamburg Schlump U-Bf - all screens 11 |
10010483 - U-Bf Schlump,Eb-2,U2,Gl.4 Ri.Mümmelm.b.,1.StO.v.li 10010483 |
| 11,10010485 |
Hamburg Schlump U-Bf - all screens 11 |
10010485 - U-Bf Schlump,Eb.-2,U2,Gl.5 Ri.Niendorf Nord,4.StO 10010485 |
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)
);