spot_config

44 rows where weekday = 6

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: length_loop, count_plays, time_range

config_id ▼ length_spot length_loop count_plays weekday time_range published is_standard
36 10 180 10 Fr 6 1 1 1 1
37 10 180 10 Fr 6 2 2 1 1
38 10 180 10 Fr 6 3 3 1 1
39 10 180 10 Fr 6 4 4 1 1
40 10 180 10 Fr 6 5 5 1 1
41 10 180 10 Fr 6 6 6 1 1
42 10 180 10 Fr 6 7 7 1 1
92 10 180 20 Fr 6 1 1 1 1
93 10 180 20 Fr 6 2 2 1 1
94 10 180 20 Fr 6 3 3 1 1
95 10 180 20 Fr 6 4 4 1 1
96 10 180 20 Fr 6 5 5 1 1
97 10 180 20 Fr 6 6 6 1 1
98 10 180 20 Fr 6 7 7 1 1
148 10 180 40 Fr 6 1 1 1 1
149 10 180 40 Fr 6 2 2 1 1
150 10 180 40 Fr 6 3 3 1 1
151 10 180 40 Fr 6 4 4 1 1
152 10 180 40 Fr 6 5 5 1 1
153 10 180 40 Fr 6 6 6 1 1
154 10 180 40 Fr 6 7 7 1 1
204 10 180 60 Fr 6 1 1 1 1
205 10 180 60 Fr 6 2 2 1 1
206 10 180 60 Fr 6 3 3 1 1
207 10 180 60 Fr 6 4 4 1 1
208 10 180 60 Fr 6 5 5 1 1
209 10 180 60 Fr 6 6 6 1 1
210 10 180 60 Fr 6 7 7 1 1
260 10 180 80 Fr 6 1 1 1 1
261 10 180 80 Fr 6 2 2 1 1
262 10 180 80 Fr 6 3 3 1 1
263 10 180 80 Fr 6 4 4 1 1
264 10 180 80 Fr 6 5 5 1 1
265 10 180 80 Fr 6 6 6 1 1
266 10 180 80 Fr 6 7 7 1 1
286 10 60 1 Fr 6 8 8 1 1
294 10 60 18 Fr 6 8 8 1 1
302 10 60 36 Fr 6 8 8 1 1
310 10 60 54 Fr 6 8 8 1 1
318 10 60 72 Fr 6 8 8 1 1
326 10 60 90 Fr 6 8 8 1 1
334 10   20 Fr 6 8 8 1 1
342 10   30 Fr 6 8 8 1 1
350 10   60 Fr 6 8 8 1 1

Advanced export

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

CSV options: 

CREATE TABLE spot_config (
	config_id INTEGER NOT NULL, 
	length_spot INTEGER, 
	length_loop INTEGER, 
	count_plays INTEGER, 
	weekday INTEGER, 
	time_range INTEGER, 
	published BOOLEAN, 
	is_standard BOOLEAN, 
	PRIMARY KEY (config_id), 
	UNIQUE (config_id), 
	FOREIGN KEY(weekday) REFERENCES weekday (id), 
	FOREIGN KEY(time_range) REFERENCES time_range (id)
);