matches

✎ View and edit SQL

This data as json

0 records

CREATE TABLE matches (
        id              INTEGER PRIMARY KEY AUTOINCREMENT,
        season          INTEGER NOT NULL,
        competition     TEXT,
        opponent        TEXT,
        result          TEXT,    -- 'W','L','T','A'
        mad_dogs_runs   INTEGER,
        mad_dogs_wkts   INTEGER,
        mad_dogs_overs  REAL,
        opp_runs        INTEGER,
        opp_wkts        INTEGER,
        opp_overs       REAL,
        notes           TEXT
    );