8 rows
where screengroup = 8
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 8,10009141 |
Hamburg Mönckebergstraße U-Bf - all screens 8 |
10009141 - U-Bf Mönckebergstr., Gl. 2, 3 Sto. 10009141 |
| 8,10009142 |
Hamburg Mönckebergstraße U-Bf - all screens 8 |
10009142 - U-Bf Mönckebergstr., Gl. 1, 1 Sto. 10009142 |
| 8,10009143 |
Hamburg Mönckebergstraße U-Bf - all screens 8 |
10009143 - U-Bf Mönckebergstr., Gl. 1, 3 Sto. 10009143 |
| 8,10009144 |
Hamburg Mönckebergstraße U-Bf - all screens 8 |
10009144 - U-Bf Mönckebergstr., Gl. 2, 4 Sto. 10009144 |
| 8,10009145 |
Hamburg Mönckebergstraße U-Bf - all screens 8 |
10009145 - U-Bf Mönckebergstr., Gl. 1, 4 Sto. 10009145 |
| 8,10009146 |
Hamburg Mönckebergstraße U-Bf - all screens 8 |
10009146 - U-Bf Mönckebergstr., Gl. 2, 2 Sto. 10009146 |
| 8,10009147 |
Hamburg Mönckebergstraße U-Bf - all screens 8 |
10009147 - U-Bf Mönckebergstr., Gl. 1, 2 Sto. 10009147 |
| 8,10009148 |
Hamburg Mönckebergstraße U-Bf - all screens 8 |
10009148 - U-Bf Mönckebergstr., Gl. 2, 1 Sto. 10009148 |
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)
);