spot_config

2 rows where time_range = 9

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

config_id ▼ length_spot length_loop count_plays weekday time_range published is_standard
544 10   50 Woche 1 9 9 1 1
545 10   25 Woche 1 9 9 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)
);