10 rows
where screengroup = 562
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 562,10014084 |
McFIT Hamburg-Steilshoop - all screens 562 |
10014084 - Cardio Screen 1 (links) 10014084 |
| 562,10014085 |
McFIT Hamburg-Steilshoop - all screens 562 |
10014085 - Cardio Screen 2 (mitte) 10014085 |
| 562,10014086 |
McFIT Hamburg-Steilshoop - all screens 562 |
10014086 - Cardio Screen 3 (mitte) 10014086 |
| 562,10014087 |
McFIT Hamburg-Steilshoop - all screens 562 |
10014087 - Cardio Screen 4 (rechts) 10014087 |
| 562,10014088 |
McFIT Hamburg-Steilshoop - all screens 562 |
10014088 - Infoscreen 10014088 |
| 562,10014089 |
McFIT Hamburg-Steilshoop - all screens 562 |
10014089 - Geräte Screen 1 (Links) 10014089 |
| 562,10014090 |
McFIT Hamburg-Steilshoop - all screens 562 |
10014090 - Geräte Screen 2 (mitte) 10014090 |
| 562,10014091 |
McFIT Hamburg-Steilshoop - all screens 562 |
10014091 - Geräte Screen 3 (rechts) 10014091 |
| 562,10014092 |
McFIT Hamburg-Steilshoop - all screens 562 |
10014092 - Power Screen 10014092 |
| 562,10014093 |
McFIT Hamburg-Steilshoop - all screens 562 |
10014093 - Training 10014093 |
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)
);