spotset_timeranges

25 rows where spotset_id = 30

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link spotset_id timerange_id
30,1 X-City Marketing 30 00-01 Uhr 1
30,3 X-City Marketing 30 01-02 Uhr 3
30,4 X-City Marketing 30 02-03 Uhr 4
30,5 X-City Marketing 30 03-04 Uhr 5
30,6 X-City Marketing 30 04-05 Uhr 6
30,8 X-City Marketing 30 05-06 Uhr 8
30,9 X-City Marketing 30 06-07 Uhr 9
30,13 X-City Marketing 30 07-08 Uhr 13
30,14 X-City Marketing 30 08-09 Uhr 14
30,16 X-City Marketing 30 09-10 Uhr 16
30,19 X-City Marketing 30 10-11 Uhr 19
30,21 X-City Marketing 30 11-12 Uhr 21
30,22 X-City Marketing 30 12-13 Uhr 22
30,25 X-City Marketing 30 13-14 Uhr 25
30,26 X-City Marketing 30 14-15 Uhr 26
30,28 X-City Marketing 30 15-16 Uhr 28
30,30 X-City Marketing 30 16-17 Uhr 30
30,32 X-City Marketing 30 17-18 Uhr 32
30,33 X-City Marketing 30 18-19 Uhr 33
30,36 X-City Marketing 30 19-20 Uhr 36
30,37 X-City Marketing 30 20-21 Uhr 37
30,39 X-City Marketing 30 21-22 Uhr 39
30,41 X-City Marketing 30 22-23 Uhr 41
30,43 X-City Marketing 30 23-24 Uhr 43
30,44 X-City Marketing 30 ganztägig 44

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);