Batting Statistics

0 rows where player_id = 42

✎ View and edit SQL

This data as json

0 records

CREATE TABLE batting_stats (
        id              INTEGER PRIMARY KEY AUTOINCREMENT,
        player_id       INTEGER NOT NULL REFERENCES players(id),
        season          INTEGER NOT NULL,
        innings         INTEGER,
        not_outs        INTEGER,
        runs            INTEGER,
        average         REAL,
        highest         TEXT,    -- e.g. "81*"
        balls_faced     INTEGER,
        strike_rate     REAL,    -- R/100b
        ducks           INTEGER DEFAULT 0,
        UNIQUE(player_id, season)
    );
CREATE INDEX idx_batting_player  ON batting_stats(player_id);
CREATE INDEX idx_batting_season  ON batting_stats(season);