spot_config

44 rows where weekday = 5

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: length_loop, count_plays, time_range, publisher, published

CREATE TABLE spot_config (
	config_id INTEGER NOT NULL, 
	length_spot INTEGER, 
	length_loop INTEGER, 
	count_plays INTEGER, 
	weekday INTEGER, 
	time_range INTEGER, 
	publisher 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), 
	FOREIGN KEY(publisher) REFERENCES publisher (id)
);