odds

44 rows where match_id = 54171

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: recorded_at (date), created_at (date), updated_at (date)

CREATE TABLE odds (
	odds_id INTEGER NOT NULL, 
	match_id INTEGER NOT NULL, 
	bookmaker VARCHAR(64) NOT NULL, 
	market VARCHAR(32) NOT NULL, 
	selection VARCHAR(32) NOT NULL, 
	value FLOAT NOT NULL, 
	value_open FLOAT, 
	implied_probability FLOAT, 
	recorded_at DATETIME NOT NULL, 
	is_closing BOOLEAN NOT NULL, 
	created_at DATETIME NOT NULL, 
	updated_at DATETIME NOT NULL, 
	created_by_run_id INTEGER, 
	updated_by_run_id INTEGER, 
	source_id INTEGER NOT NULL, 
	source_raw_key VARCHAR(512), 
	PRIMARY KEY (odds_id), 
	CONSTRAINT uq_odds_match_bookmaker_market_selection_time UNIQUE (match_id, bookmaker, market, selection, recorded_at), 
	FOREIGN KEY(match_id) REFERENCES "match" (match_id), 
	FOREIGN KEY(created_by_run_id) REFERENCES ingestion_run (run_id), 
	FOREIGN KEY(updated_by_run_id) REFERENCES ingestion_run (run_id), 
	FOREIGN KEY(source_id) REFERENCES data_source (source_id)
);
CREATE INDEX ix_odds_created_by_run_id ON odds (created_by_run_id);
CREATE INDEX ix_odds_recorded_at ON odds (recorded_at);
CREATE INDEX ix_odds_source_id ON odds (source_id);
CREATE INDEX ix_odds_market ON odds (market);
CREATE INDEX ix_odds_updated_by_run_id ON odds (updated_by_run_id);
CREATE INDEX ix_odds_source_raw_key ON odds (source_raw_key);
CREATE INDEX ix_odds_bookmaker ON odds (bookmaker);
CREATE INDEX ix_odds_match_id ON odds (match_id);