10 rows
where screengroup = 5
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 5,10011239 |
Hamburg Hallerstraße U-Bf - all screens 5 |
10011239 - U-Bf Hallerstr., Einf. nb. Orientierungsplan - 347 10011239 |
| 5,10011240 |
Hamburg Hallerstraße U-Bf - all screens 5 |
10011240 - U-Bf Hallerstr., Gl.2 Einf. Höhe Sitzbank - 400 10011240 |
| 5,10011242 |
Hamburg Hallerstraße U-Bf - all screens 5 |
10011242 - U-Bf Hallerstr., Gl.2 Höhe Notrufsäule - 405 10011242 |
| 5,10011243 |
Hamburg Hallerstraße U-Bf - all screens 5 |
10011243 - U-Bf Hallerstr., Gl.1 Höhe Notrufsäule - 372 10011243 |
| 5,10011244 |
Hamburg Hallerstraße U-Bf - all screens 5 |
10011244 - U-Bf Hallerstr., Gl.1 Höhe 2. SB zw. WT - 348 10011244 |
| 5,10011251 |
Hamburg Hallerstraße U-Bf - all screens 5 |
10011251 - U-Bf Hallerstr., Gl.2 Ausf. Höhe Sitzbank - 408 10011251 |
| 5,10011252 |
Hamburg Hallerstraße U-Bf - all screens 5 |
10011252 - U-Bf Hallerstr., Gl.1 S-mitte Höhe HS-Schild - 371 10011252 |
| 5,10011253 |
Hamburg Hallerstraße U-Bf - all screens 5 |
10011253 - U-Bf Hallerstr., Gl.2 Höhe HS-Schild - 406 10011253 |
| 5,10011254 |
Hamburg Hallerstraße U-Bf - all screens 5 |
10011254 - U-Bf Hallerstr., Gl.2 Höhe Sitzbank zw. WT - 407 10011254 |
| 5,10011255 |
Hamburg Hallerstraße U-Bf - all screens 5 |
10011255 - U-Bf Hallerstr., Gl.1 Ausf. nb. Infovitr. - 373 10011255 |
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)
);