4 rows
where screengroup = 17
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 17,10009194 |
Hamburg Rödingsmarkt U-Bf - all screens 17 |
10009194 - U-Bf Rödingsmarkt Gl 1, re. neb Aufzug, Sto. 2 10009194 |
| 17,10009195 |
Hamburg Rödingsmarkt U-Bf - all screens 17 |
10009195 - U-Bf Rödingsmarkt Gl 2, li. neb Aufzug, Sto. 1 10009195 |
| 17,10009196 |
Hamburg Rödingsmarkt U-Bf - all screens 17 |
10009196 - U-Bf Rödingsmarkt Gl 2, li. neb Aufzug, Sto. 2 10009196 |
| 17,10009197 |
Hamburg Rödingsmarkt U-Bf - all screens 17 |
10009197 - U-Bf Rödingsmarkt Gl 1, re. neb Aufzug, Sto. 1 10009197 |
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)
);