screen_calc

0 rows where screen = 10007263

✎ View and edit SQL

This data as json, copyable

0 records

CREATE TABLE screen_calc (
	id VARCHAR(150) NOT NULL, 
	name VARCHAR(250), 
	screen INTEGER, 
	weekhour INTEGER, 
	count_plays_per_hour INTEGER, 
	length_spot_sec INTEGER, 
	raw_sample FLOAT, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(screen) REFERENCES screen (id), 
	FOREIGN KEY(weekhour) REFERENCES weekhour (id)
);
CREATE INDEX ix_screen_calc_weekhour ON screen_calc (weekhour);
CREATE INDEX ix_screen_calc_raw_sample ON screen_calc (raw_sample);
CREATE INDEX ix_screen_calc_screen ON screen_calc (screen);