13 rows
where screengroup = 7
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 7,10009132 |
Hamburg Lohmühlenstraße U-Bf - all screens 7 |
10009132 - U-Bf Lohmühlenstr./schalterhalle B/li. 10009132 |
| 7,10009133 |
Hamburg Lohmühlenstraße U-Bf - all screens 7 |
10009133 - U-Bf Lohmühlenstr./schalterhalle B/re. 10009133 |
| 7,10009134 |
Hamburg Lohmühlenstraße U-Bf - all screens 7 |
10009134 - U-Bf Lohmühlenstr./Schalterhalle A/Sto. 1 10009134 |
| 7,10009135 |
Hamburg Lohmühlenstraße U-Bf - all screens 7 |
10009135 - U-Bf Lohmühlenstr./Schalterhalle A/Sto. 3 10009135 |
| 7,10009136 |
Hamburg Lohmühlenstraße U-Bf - all screens 7 |
10009136 - U-Bf Lohmühlenstr./Schalterhalle A/Sto. 2 10009136 |
| 7,10011368 |
Hamburg Lohmühlenstraße U-Bf - all screens 7 |
10011368 - U-Bf Lohmühlenstr./Gl. 2/Sto. 3/4 10011368 |
| 7,10011369 |
Hamburg Lohmühlenstraße U-Bf - all screens 7 |
10011369 - U-Bf Lohmühlenstr./Gl. 1/Sto. 1/4 10011369 |
| 7,10011370 |
Hamburg Lohmühlenstraße U-Bf - all screens 7 |
10011370 - U-Bf Lohmühlenstr./Gl. 1/Sto. 2/4 10011370 |
| 7,10011371 |
Hamburg Lohmühlenstraße U-Bf - all screens 7 |
10011371 - U-Bf Lohmühlenstr./Gl. 2 /Sto. 4/4 10011371 |
| 7,10011372 |
Hamburg Lohmühlenstraße U-Bf - all screens 7 |
10011372 - U-Bf Lohmühlenstr./Gl. 2/Sto. 2/4 10011372 |
| 7,10011373 |
Hamburg Lohmühlenstraße U-Bf - all screens 7 |
10011373 - U-Bf Lohmühlenstr./Gl. 2 /Sto. 3/4 10011373 |
| 7,10011374 |
Hamburg Lohmühlenstraße U-Bf - all screens 7 |
10011374 - U-Bf Lohmühlenstr./Gl.1/Sto. 4/4 10011374 |
| 7,10011375 |
Hamburg Lohmühlenstraße U-Bf - all screens 7 |
10011375 - U-Bf Lohmühlenstr./Gl. 1/Sto. 3/4 10011375 |
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)
);