player

38,279 rows sorted by player_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: position, date_of_birth (date), created_at (date), updated_at (date)

Next page

CREATE TABLE player (
	player_id INTEGER NOT NULL, 
	full_name VARCHAR(128) NOT NULL, 
	display_name VARCHAR(128), 
	date_of_birth DATE, 
	nationality VARCHAR(64), 
	position VARCHAR(32), 
	foot VARCHAR(8), 
	height_cm INTEGER, 
	weight_kg INTEGER, 
	current_team_id INTEGER, 
	is_active 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 (player_id), 
	FOREIGN KEY(current_team_id) REFERENCES team (team_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_player_source_raw_key ON player (source_raw_key);
CREATE INDEX ix_player_created_by_run_id ON player (created_by_run_id);
CREATE INDEX ix_player_source_id ON player (source_id);
CREATE INDEX ix_player_full_name ON player (full_name);
CREATE INDEX ix_player_current_team_id ON player (current_team_id);
CREATE INDEX ix_player_updated_by_run_id ON player (updated_by_run_id);