13 rows
where screengroup = 818
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 818,10014202 |
Retail TV Food Viewento - all screens 818 |
10014202 - KassenTV Gang 10014202 |
| 818,10014203 |
Retail TV Food Viewento - all screens 818 |
10014203 - Kassen-TV 10014203 |
| 818,10014204 |
Retail TV Food Viewento - all screens 818 |
10014204 - Kassen-TV 10014204 |
| 818,10014205 |
Retail TV Food Viewento - all screens 818 |
10014205 - Kassen-TV 10014205 |
| 818,10014206 |
Retail TV Food Viewento - all screens 818 |
10014206 - 4er Wall 10014206 |
| 818,10014207 |
Retail TV Food Viewento - all screens 818 |
10014207 - 4er Wall 10014207 |
| 818,10014208 |
Retail TV Food Viewento - all screens 818 |
10014208 - 4er Wall 10014208 |
| 818,10014209 |
Retail TV Food Viewento - all screens 818 |
10014209 - 4er Wall 10014209 |
| 818,10014210 |
Retail TV Food Viewento - all screens 818 |
10014210 - Kassen-TV 10014210 |
| 818,10014211 |
Retail TV Food Viewento - all screens 818 |
10014211 - Kassen-TV 10014211 |
| 818,10014212 |
Retail TV Food Viewento - all screens 818 |
10014212 - Kassen-TV 10014212 |
| 818,10014213 |
Retail TV Food Viewento - all screens 818 |
10014213 - Kassen-TV 10014213 |
| 818,10014214 |
Retail TV Food Viewento - all screens 818 |
10014214 - Kassen-TV 10014214 |
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)
);