spotset_timeranges
4 rows where timerange_id = 18
This data as json, copyable, CSV (advanced)
| Link | spotset_id | timerange_id |
|---|---|---|
| 22,18 | Ströer (3) 22 | 09-21 Uhr 18 |
| 23,18 | Ströer (4) 23 | 09-21 Uhr 18 |
| 53,18 | Ströer (10) 53 | 09-21 Uhr 18 |
| 54,18 | Ströer (11) 54 | 09-21 Uhr 18 |
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) );