player_season_stats

1,328 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, season_name, goals, assists, created_at (date), updated_at (date)

Next page

CREATE TABLE player_season_stats (
            player_id INTEGER NOT NULL,
            team_id INTEGER NOT NULL,
            season_name TEXT NOT NULL,
            apps INTEGER,
            goals INTEGER,
            assists INTEGER,
            minutes INTEGER,
            shots INTEGER,
            cards INTEGER,
            xg REAL,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            PRIMARY KEY (player_id, team_id, season_name)
        );
CREATE INDEX idx_player_season_stats_player 
        ON player_season_stats (player_id)
    ;
CREATE INDEX idx_player_season_stats_team 
        ON player_season_stats (team_id)
    ;
CREATE INDEX idx_player_season_stats_season 
        ON player_season_stats (season_name)
    ;