8 rows
where screengroup = 20
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 20,10009038 |
Hamburg Heimfeld Bf - all screens 20 |
10009038 - S-Bf Heimfeld, Gl. ber, 3. Sto von li. 10009038 |
| 20,10009039 |
Hamburg Heimfeld Bf - all screens 20 |
10009039 - S-Bf Heimfeld, Gl. ber, 4. Sto von li. 10009039 |
| 20,10009040 |
Hamburg Heimfeld Bf - all screens 20 |
10009040 - S-Bf Heimfeld, Gl. ber, 2. Sto von li. 10009040 |
| 20,10009041 |
Hamburg Heimfeld Bf - all screens 20 |
10009041 - S-Bf Heimfeld, Gl. ber, 5. Sto von li. 10009041 |
| 20,10009042 |
Hamburg Heimfeld Bf - all screens 20 |
10009042 - S-Bf Heimfeld, Gl. ber, 6. Sto von li. 10009042 |
| 20,10009043 |
Hamburg Heimfeld Bf - all screens 20 |
10009043 - S-Bf Heimfeld, Gl. ber, 1. Sto von li. 10009043 |
| 20,10010490 |
Hamburg Heimfeld Bf - all screens 20 |
10010490 - S-Bf Heimfeld Gleis 1 -781 10010490 |
| 20,10010548 |
Hamburg Heimfeld Bf - all screens 20 |
10010548 - S-Bf Heimfeld Gleis 2 -782 10010548 |
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)
);