12 rows
where screengroup = 800
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 800,10014720 |
McDonalds - all screens 800 |
10014720 - Screen zentral im Essensbereich 10014720 |
| 800,10014721 |
McDonalds - all screens 800 |
10014721 - Screen zentral im Essensbereich 10014721 |
| 800,10014722 |
McDonalds - all screens 800 |
10014722 - Screen zentral im Essensbereich 10014722 |
| 800,10014723 |
McDonalds - all screens 800 |
10014723 - Screen zentral im Essensbereich 10014723 |
| 800,10014724 |
McDonalds - all screens 800 |
10014724 - Screen zentral im Essensbereich 10014724 |
| 800,10014725 |
McDonalds - all screens 800 |
10014725 - Screen zentral im Essensbereich 10014725 |
| 800,10014726 |
McDonalds - all screens 800 |
10014726 - Screen zentral im Essensbereich 10014726 |
| 800,10014727 |
McDonalds - all screens 800 |
10014727 - Screen zentral im Essensbereich 10014727 |
| 800,10014728 |
McDonalds - all screens 800 |
10014728 - Screen zentral im Essensbereich 10014728 |
| 800,10014729 |
McDonalds - all screens 800 |
10014729 - Screen zentral im Essensbereich 10014729 |
| 800,10014730 |
McDonalds - all screens 800 |
10014730 - Screen zentral im Essensbereich 10014730 |
| 800,10014731 |
McDonalds - all screens 800 |
10014731 - Screen zentral im Essensbereich 10014731 |
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)
);