match_stats

0 rows where match_id = 41

✎ View and edit SQL

This data as json

0 records

CREATE TABLE match_stats (
	match_stats_id INTEGER NOT NULL, 
	match_id INTEGER NOT NULL, 
	possession_home FLOAT, 
	possession_away FLOAT, 
	ppda_home FLOAT, 
	ppda_away FLOAT, 
	shots_home INTEGER, 
	shots_away INTEGER, 
	shots_on_target_home INTEGER, 
	shots_on_target_away INTEGER, 
	shots_blocked_home INTEGER, 
	shots_blocked_away INTEGER, 
	big_chances_home INTEGER, 
	big_chances_away INTEGER, 
	big_chances_missed_home INTEGER, 
	big_chances_missed_away INTEGER, 
	xg_home FLOAT, 
	xg_away FLOAT, 
	npxg_home FLOAT, 
	npxg_away FLOAT, 
	total_passes_home INTEGER, 
	total_passes_away INTEGER, 
	pass_accuracy_home FLOAT, 
	pass_accuracy_away FLOAT, 
	key_passes_home INTEGER, 
	key_passes_away INTEGER, 
	corners_home INTEGER, 
	corners_away INTEGER, 
	free_kicks_home INTEGER, 
	free_kicks_away INTEGER, 
	yellow_cards_home INTEGER, 
	yellow_cards_away INTEGER, 
	red_cards_home INTEGER, 
	red_cards_away INTEGER, 
	fouls_home INTEGER, 
	fouls_away INTEGER, 
	offsides_home INTEGER, 
	offsides_away INTEGER, 
	saves_home INTEGER, 
	saves_away INTEGER, 
	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 (match_stats_id), 
	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_match_stats_source_id ON match_stats (source_id);
CREATE INDEX ix_match_stats_created_by_run_id ON match_stats (created_by_run_id);
CREATE INDEX ix_match_stats_updated_by_run_id ON match_stats (updated_by_run_id);
CREATE INDEX ix_match_stats_source_raw_key ON match_stats (source_raw_key);
CREATE UNIQUE INDEX ix_match_stats_match_id ON match_stats (match_id);