6 rows
where screengroup = 615
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 615,10009044 |
Hamburg Holstenstraße Bf - all screens 615 |
10009044 - S-Bf Holstenstr., Bstg., Gl. 1, 2. Sto., G1.2 10009044 |
| 615,10009045 |
Hamburg Holstenstraße Bf - all screens 615 |
10009045 - S-Bf Holstenstr., Bstg., Gl. 2, 1. Sto., G2.1 10009045 |
| 615,10009046 |
Hamburg Holstenstraße Bf - all screens 615 |
10009046 - S-Bf Holstenstr., Bstg., Gl.1, 1. Sto., G1.1 10009046 |
| 615,10009047 |
Hamburg Holstenstraße Bf - all screens 615 |
10009047 - S-Bf Holstenstr., SH, geg. Aufg. S-Bahn, li. 10009047 |
| 615,10009048 |
Hamburg Holstenstraße Bf - all screens 615 |
10009048 - S-Bf Holstenstr., Bstg., Gl. 2, 2. Sto., G2.2 10009048 |
| 615,10009049 |
Hamburg Holstenstraße Bf - all screens 615 |
10009049 - S-Bf Holstenstr., SH, geg. Aufg. S-Bahn, re. 10009049 |
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)
);