spotset_timeranges
8 rows where spotset_id = 5
This data as json, copyable, CSV (advanced)
| Link | spotset_id | timerange_id |
|---|---|---|
| 5,2 | CITTADINO GmbH (3) 5 | 00-06 Uhr 2 |
| 5,11 | CITTADINO GmbH (3) 5 | 06-09 Uhr 11 |
| 5,17 | CITTADINO GmbH (3) 5 | 09-12 Uhr 17 |
| 5,24 | CITTADINO GmbH (3) 5 | 12-15 Uhr 24 |
| 5,29 | CITTADINO GmbH (3) 5 | 15-18 Uhr 29 |
| 5,35 | CITTADINO GmbH (3) 5 | 18-21 Uhr 35 |
| 5,40 | CITTADINO GmbH (3) 5 | 21-24 Uhr 40 |
| 5,44 | CITTADINO GmbH (3) 5 | ganztägig 44 |
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) );