spotset_timeranges
8 rows where timerange_id = 12
This data as json, copyable, CSV (advanced)
| Link | spotset_id | timerange_id |
|---|---|---|
| 21,12 | Ströer (1) 21 | 06-24 Uhr 12 |
| 22,12 | Ströer (2) 22 | 06-24 Uhr 12 |
| 25,12 | Ströer (5) 25 | 06-24 Uhr 12 |
| 26,12 | Ströer (6) 26 | 06-24 Uhr 12 |
| 52,12 | Ströer (8) 52 | 06-24 Uhr 12 |
| 53,12 | Ströer (9) 53 | 06-24 Uhr 12 |
| 56,12 | Ströer (12) 56 | 06-24 Uhr 12 |
| 57,12 | Ströer (13) 57 | 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) );