12 rows
where screengroup = 806
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 806,10014254 |
Mobility Channel Bistro - all screens 806 |
10014254 - Total Hamburg Aluminiumstrasse 5 10014254 |
| 806,10014255 |
Mobility Channel Bistro - all screens 806 |
10014255 - Total Hamburg Aluminiumstrasse 5 10014255 |
| 806,10014261 |
Mobility Channel Bistro - all screens 806 |
10014261 - Total Hamburg Andreas Meyer Strasse 63 10014261 |
| 806,10014262 |
Mobility Channel Bistro - all screens 806 |
10014262 - Total Hamburg Andreas Meyer Strasse 63 10014262 |
| 806,10014263 |
Mobility Channel Bistro - all screens 806 |
10014263 - Total Hamburg Andreas Meyer Strasse 63 10014263 |
| 806,10014267 |
Mobility Channel Bistro - all screens 806 |
10014267 - Total Hamburg Billstedter Hauptstrasse 21 10014267 |
| 806,10014268 |
Mobility Channel Bistro - all screens 806 |
10014268 - Total Hamburg Billstedter Hauptstrasse 21 10014268 |
| 806,10014272 |
Mobility Channel Bistro - all screens 806 |
10014272 - Total Hamburg Bramfelder Strasse 86a 10014272 |
| 806,10014273 |
Mobility Channel Bistro - all screens 806 |
10014273 - Total Hamburg Bramfelder Strasse 86a 10014273 |
| 806,10014274 |
Mobility Channel Bistro - all screens 806 |
10014274 - Total Hamburg Bramfelder Strasse 86a 10014274 |
| 806,10014278 |
Mobility Channel Bistro - all screens 806 |
10014278 - Total Hamburg Mundsburger Damm 47 10014278 |
| 806,10014282 |
Mobility Channel Bistro - all screens 806 |
10014282 - Total Hamburg Neuhöfer Strasse 28 10014282 |
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)
);