10 rows
where screengroup = 432
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 432,10014226 |
wellyou Hamburg - all screens 432 |
10014226 - Cardio 1 10014226 |
| 432,10014227 |
wellyou Hamburg - all screens 432 |
10014227 - Cardio2 10014227 |
| 432,10014228 |
wellyou Hamburg - all screens 432 |
10014228 - Cardio 3 10014228 |
| 432,10014229 |
wellyou Hamburg - all screens 432 |
10014229 - Trainingsfläche_Links_Mitte 10014229 |
| 432,10014230 |
wellyou Hamburg - all screens 432 |
10014230 - Cardio Links 10014230 |
| 432,10014231 |
wellyou Hamburg - all screens 432 |
10014231 - Trainingsfläche Links 10014231 |
| 432,10014232 |
wellyou Hamburg - all screens 432 |
10014232 - Trainingsfläche Rechts 10014232 |
| 432,10014233 |
wellyou Hamburg - all screens 432 |
10014233 - Cardio Rechts 10014233 |
| 432,10014234 |
wellyou Hamburg - all screens 432 |
10014234 - Cardio Mitte 10014234 |
| 432,10014235 |
wellyou Hamburg - all screens 432 |
10014235 - Trainingsfläche_Rechts_Mitte 10014235 |
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)
);