4 rows
where screengroup = 616
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 616,10008875 |
Hamburg Berliner Tor Bf - all screens 616 |
10008875 - S-Bf Berliner Tor, Durchgang, li. 10008875 |
| 616,10008876 |
Hamburg Berliner Tor Bf - all screens 616 |
10008876 - S-Bf Berliner Tor, Durchgang, re. 10008876 |
| 616,10008877 |
Hamburg Berliner Tor Bf - all screens 616 |
10008877 - S-Bf Berliner Tor, Durchgang, mi. 10008877 |
| 616,10008878 |
Hamburg Berliner Tor Bf - all screens 616 |
10008878 - S-Bf Berliner Tor,Durchgang,Zugang Gl.1/2,re. 10008878 |
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)
);