13 rows
where screengroup = 600
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 600,10013288 |
EKZ Born Center Hamburg [BOH] - all screens 600 |
10013288 - EKZ Born Center Hamburg [BOH] 10013288 |
| 600,10013289 |
EKZ Born Center Hamburg [BOH] - all screens 600 |
10013289 - EKZ Born Center Hamburg [BOH] 10013289 |
| 600,10013290 |
EKZ Born Center Hamburg [BOH] - all screens 600 |
10013290 - EKZ Born Center Hamburg [BOH] 10013290 |
| 600,10013291 |
EKZ Born Center Hamburg [BOH] - all screens 600 |
10013291 - EKZ Born Center Hamburg [BOH] 10013291 |
| 600,10013292 |
EKZ Born Center Hamburg [BOH] - all screens 600 |
10013292 - EKZ Born Center Hamburg [BOH] 10013292 |
| 600,10013293 |
EKZ Born Center Hamburg [BOH] - all screens 600 |
10013293 - EKZ Born Center Hamburg [BOH] 10013293 |
| 600,10013294 |
EKZ Born Center Hamburg [BOH] - all screens 600 |
10013294 - EKZ Born Center Hamburg [BOH] 10013294 |
| 600,10013295 |
EKZ Born Center Hamburg [BOH] - all screens 600 |
10013295 - EKZ Born Center Hamburg [BOH] 10013295 |
| 600,10013296 |
EKZ Born Center Hamburg [BOH] - all screens 600 |
10013296 - EKZ Born Center Hamburg [BOH] 10013296 |
| 600,10013563 |
EKZ Born Center Hamburg [BOH] - all screens 600 |
10013563 - EKZ Born Center Hamburg [BOH] 10013563 |
| 600,10013564 |
EKZ Born Center Hamburg [BOH] - all screens 600 |
10013564 - EKZ Born Center Hamburg [BOH] 10013564 |
| 600,10013565 |
EKZ Born Center Hamburg [BOH] - all screens 600 |
10013565 - EKZ Born Center Hamburg [BOH] 10013565 |
| 600,10013566 |
EKZ Born Center Hamburg [BOH] - all screens 600 |
10013566 - EKZ Born Center Hamburg [BOH] 10013566 |
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)
);