25 rows
where screengroup = 770
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 770,10014215 |
airtango DOOH Fitnessstudios - all screens 770 |
10014215 - Eingang 10014215 |
| 770,10014216 |
airtango DOOH Fitnessstudios - all screens 770 |
10014216 - Cardio 10014216 |
| 770,10014217 |
airtango DOOH Fitnessstudios - all screens 770 |
10014217 - Geräte_Eingang 10014217 |
| 770,10014218 |
airtango DOOH Fitnessstudios - all screens 770 |
10014218 - Geräte_Cycling 10014218 |
| 770,10014219 |
airtango DOOH Fitnessstudios - all screens 770 |
10014219 - Cardio vorne 10014219 |
| 770,10014220 |
airtango DOOH Fitnessstudios - all screens 770 |
10014220 - Gerätebereich 10014220 |
| 770,10014221 |
airtango DOOH Fitnessstudios - all screens 770 |
10014221 - Crosstrainer 10014221 |
| 770,10014222 |
airtango DOOH Fitnessstudios - all screens 770 |
10014222 - Kraftzirkel 10014222 |
| 770,10014223 |
airtango DOOH Fitnessstudios - all screens 770 |
10014223 - Gerätepark 10014223 |
| 770,10014224 |
airtango DOOH Fitnessstudios - all screens 770 |
10014224 - Empfang 10014224 |
| 770,10014225 |
airtango DOOH Fitnessstudios - all screens 770 |
10014225 - Vorkursraum 10014225 |
| 770,10014226 |
airtango DOOH Fitnessstudios - all screens 770 |
10014226 - Cardio 1 10014226 |
| 770,10014227 |
airtango DOOH Fitnessstudios - all screens 770 |
10014227 - Cardio2 10014227 |
| 770,10014228 |
airtango DOOH Fitnessstudios - all screens 770 |
10014228 - Cardio 3 10014228 |
| 770,10014229 |
airtango DOOH Fitnessstudios - all screens 770 |
10014229 - Trainingsfläche_Links_Mitte 10014229 |
| 770,10014230 |
airtango DOOH Fitnessstudios - all screens 770 |
10014230 - Cardio Links 10014230 |
| 770,10014231 |
airtango DOOH Fitnessstudios - all screens 770 |
10014231 - Trainingsfläche Links 10014231 |
| 770,10014232 |
airtango DOOH Fitnessstudios - all screens 770 |
10014232 - Trainingsfläche Rechts 10014232 |
| 770,10014233 |
airtango DOOH Fitnessstudios - all screens 770 |
10014233 - Cardio Rechts 10014233 |
| 770,10014234 |
airtango DOOH Fitnessstudios - all screens 770 |
10014234 - Cardio Mitte 10014234 |
| 770,10014235 |
airtango DOOH Fitnessstudios - all screens 770 |
10014235 - Trainingsfläche_Rechts_Mitte 10014235 |
| 770,10014236 |
airtango DOOH Fitnessstudios - all screens 770 |
10014236 - LED_Wall 10014236 |
| 770,10014237 |
airtango DOOH Fitnessstudios - all screens 770 |
10014237 - Cardio_Rechts 10014237 |
| 770,10014238 |
airtango DOOH Fitnessstudios - all screens 770 |
10014238 - Cardio_Links 10014238 |
| 770,10014239 |
airtango DOOH Fitnessstudios - all screens 770 |
10014239 - Cardio Rechts 10014239 |
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)
);