home / PUP_Spotconfigs_2022_01

spotset_timeranges

25 rows where spotset_id = 70

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link spotset_id timerange_id
70,1 echion Corporate Communication AG (1) 70 00-01 Uhr 1
70,3 echion Corporate Communication AG (1) 70 01-02 Uhr 3
70,4 echion Corporate Communication AG (1) 70 02-03 Uhr 4
70,5 echion Corporate Communication AG (1) 70 03-04 Uhr 5
70,6 echion Corporate Communication AG (1) 70 04-05 Uhr 6
70,8 echion Corporate Communication AG (1) 70 05-06 Uhr 8
70,9 echion Corporate Communication AG (1) 70 06-07 Uhr 9
70,13 echion Corporate Communication AG (1) 70 07-08 Uhr 13
70,14 echion Corporate Communication AG (1) 70 08-09 Uhr 14
70,16 echion Corporate Communication AG (1) 70 09-10 Uhr 16
70,19 echion Corporate Communication AG (1) 70 10-11 Uhr 19
70,21 echion Corporate Communication AG (1) 70 11-12 Uhr 21
70,22 echion Corporate Communication AG (1) 70 12-13 Uhr 22
70,25 echion Corporate Communication AG (1) 70 13-14 Uhr 25
70,26 echion Corporate Communication AG (1) 70 14-15 Uhr 26
70,28 echion Corporate Communication AG (1) 70 15-16 Uhr 28
70,30 echion Corporate Communication AG (1) 70 16-17 Uhr 30
70,32 echion Corporate Communication AG (1) 70 17-18 Uhr 32
70,33 echion Corporate Communication AG (1) 70 18-19 Uhr 33
70,36 echion Corporate Communication AG (1) 70 19-20 Uhr 36
70,37 echion Corporate Communication AG (1) 70 20-21 Uhr 37
70,39 echion Corporate Communication AG (1) 70 21-22 Uhr 39
70,41 echion Corporate Communication AG (1) 70 22-23 Uhr 41
70,43 echion Corporate Communication AG (1) 70 23-24 Uhr 43
70,44 echion Corporate Communication AG (1) 70 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)
);
Powered by Datasette · Queries took 7.211ms