7 rows
where screengroup = 1
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 1,10009125 |
Hamburg Landungsbrücken U-Bf - all screens 1 |
10009125 - U-Bf Landungsbrücken, SH Ri. S-Bahn rechts, 2.Sto. 10009125 |
| 1,10009126 |
Hamburg Landungsbrücken U-Bf - all screens 1 |
10009126 - U-Bf Landungsbrücken, SH Ri.S-Bahn re, 1.Sto 10009126 |
| 1,10009127 |
Hamburg Landungsbrücken U-Bf - all screens 1 |
10009127 - U-Bf Landungsbrücken, SH Ri.S-Bahn li, 1.Sto 10009127 |
| 1,10009128 |
Hamburg Landungsbrücken U-Bf - all screens 1 |
10009128 - U-Bf Landungsbrücken, SH Ri.S-Bahn li, 2.Sto 10009128 |
| 1,10009129 |
Hamburg Landungsbrücken U-Bf - all screens 1 |
10009129 - U-Bf Landungsbrücken, SH Ri.S-Bahn li, 3.Sto. 10009129 |
| 1,10009130 |
Hamburg Landungsbrücken U-Bf - all screens 1 |
10009130 - U-Bf Landungsbrücken, SH Ri.S-Bahn re, 3.Sto. 10009130 |
| 1,10009131 |
Hamburg Landungsbrücken U-Bf - all screens 1 |
10009131 - U-Bf Landungsbrücken Bstg. Gl. 2 Richtung Schlump 10009131 |
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)
);