15 rows
where screengroup = 564
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 564,10014103 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014103 - Power Screen 1 10014103 |
| 564,10014104 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014104 - Power Screen 2 10014104 |
| 564,10014105 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014105 - Infoscreen 10014105 |
| 564,10014106 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014106 - Lounge Wall 10014106 |
| 564,10014107 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014107 - Functional Screen 1 10014107 |
| 564,10014108 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014108 - Functional Screen 2 10014108 |
| 564,10014109 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014109 - Express Screen 10014109 |
| 564,10014110 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014110 - Cardio Screen 1 10014110 |
| 564,10014111 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014111 - Cardio Screen 2 10014111 |
| 564,10014112 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014112 - Cardio Screen 3 10014112 |
| 564,10014113 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014113 - Cardio Screen 4 10014113 |
| 564,10014114 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014114 - Cardio Screen 5 10014114 |
| 564,10014115 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014115 - Cardio Screen 6 10014115 |
| 564,10014116 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014116 - Cardio Screen 7 10014116 |
| 564,10014117 |
McFIT Hamburg-Othmarschen - all screens 564 |
10014117 - Cardio Screen 8 10014117 |
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)
);