15 rows
where timerange_id = 2
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
spotset_id
|
timerange_id
|
| 1,2 |
Brand Community Network (BCN) 1 |
00-06 Uhr 2 |
| 2,2 |
Brand Community Network (BCN) (1) 2 |
00-06 Uhr 2 |
| 3,2 |
Brand Community Network (BCN) (2) 3 |
00-06 Uhr 2 |
| 4,2 |
Brand Community Network (BCN) (3) 4 |
00-06 Uhr 2 |
| 6,2 |
Brandstifter AG 6 |
00-06 Uhr 2 |
| 12,2 |
Goldbach Germany 12 |
00-06 Uhr 2 |
| 17,2 |
Piranha Media GmbH 17 |
00-06 Uhr 2 |
| 34,2 |
Brand Community Network (BCN) (5) 34 |
00-06 Uhr 2 |
| 35,2 |
Brand Community Network (BCN) (6) 35 |
00-06 Uhr 2 |
| 36,2 |
Brand Community Network (BCN) (7) 36 |
00-06 Uhr 2 |
| 37,2 |
Brand Community Network (BCN) (8) 37 |
00-06 Uhr 2 |
| 38,2 |
Brandstifter AG (1) 38 |
00-06 Uhr 2 |
| 44,2 |
Goldbach Germany (4) 44 |
00-06 Uhr 2 |
| 45,2 |
Goldbach Germany (5) 45 |
00-06 Uhr 2 |
| 48,2 |
Piranha Media GmbH (1) 48 |
00-06 Uhr 2 |
CREATE TABLE spotset_timeranges (
spotset_id INTEGER NOT NULL,
timerange_id INTEGER NOT NULL,
PRIMARY KEY (spotset_id, timerange_id),
FOREIGN KEY(spotset_id) REFERENCES spotset (id),
FOREIGN KEY(timerange_id) REFERENCES time_range (id)
);