spotset_timeranges
8 rows where timerange_id = 12
This data as json, copyable, CSV (advanced)
| Link | spotset_id | timerange_id |
|---|---|---|
| 20,12 | Ströer (2) 20 | 06-24 Uhr 12 |
| 21,12 | Ströer (3) 21 | 06-24 Uhr 12 |
| 24,12 | Ströer (6) 24 | 06-24 Uhr 12 |
| 25,12 | Ströer (7) 25 | 06-24 Uhr 12 |
| 59,12 | Ströer (9) 59 | 06-24 Uhr 12 |
| 60,12 | Ströer (10) 60 | 06-24 Uhr 12 |
| 63,12 | Ströer (13) 63 | 06-24 Uhr 12 |
| 64,12 | Ströer (14) 64 | 06-24 Uhr 12 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );