Baseball Database Table Definitions

CREATE TABLE Batting (
  playerID varchar(9) NOT NULL default '',
  yearID smallint(4) unsigned NOT NULL default '0',
  stintID int(2) NOT NULL default '0',
  teamID char(3) NOT NULL default '',
  teamName varchar(50) NOT NULL default '',
  playerName varchar(100) NOT NULL default '',
  lgID char(2) NOT NULL default '',
  G smallint(3) unsigned default NULL,
  AB smallint(3) NOT NULL default '0',
  R smallint(3) unsigned default NULL,
  H smallint(3) unsigned default NULL,
  BA decimal(5,3) unsigned NOT NULL default '0.000',
  2B smallint(3) unsigned default NULL,
  3B smallint(3) unsigned default NULL,
  HR smallint(3) unsigned NOT NULL default '0',
  RBI smallint(3) unsigned default NULL,
  SB smallint(3) unsigned default NULL,
  CS smallint(3) unsigned default NULL,
  BB smallint(3) unsigned default NULL,
  SO smallint(3) unsigned default NULL,
  IBB smallint(3) unsigned default NULL,
  HBP smallint(3) unsigned default NULL,
  SH smallint(3) unsigned default NULL,
  SF smallint(3) unsigned default NULL,
  GIDP smallint(3) unsigned default NULL,
  PRIMARY KEY  (playerID,yearID,stintID),
  KEY playerID (playerID),
  KEY team (teamID,yearID,lgID)
) TYPE=MyISAM;

Pitching Table

CREATE TABLE Pitching (
  playerID varchar(9) NOT NULL default '',
  yearID smallint(4) unsigned NOT NULL default '0',
  stintID int(2) NOT NULL default '0',
  teamID char(3) NOT NULL default '',
  teamName varchar(50) NOT NULL default '',
  playerName varchar(100) NOT NULL default '',
  lgID char(2) NOT NULL default '',
  W smallint(2) unsigned default NULL,
  L smallint(2) unsigned default NULL,
  G smallint(3) unsigned default NULL,
  GS smallint(3) unsigned default NULL,
  CG smallint(3) unsigned default NULL,
  SHO smallint(3) unsigned default NULL,
  SV smallint(3) unsigned default NULL,
  IPouts int(5) unsigned default NULL,
  H smallint(3) unsigned default NULL,
  ER smallint(3) unsigned default NULL,
  HR smallint(3) unsigned default NULL,
  BB smallint(3) unsigned default NULL,
  SO smallint(3) unsigned default NULL,
  BAOpp decimal(5,3) unsigned default NULL,
  ERA decimal(5,2) unsigned default NULL,
  PRIMARY KEY  (playerID,yearID,stintID),
  KEY playerID (playerID),
  KEY team (teamID,yearID,lgID)
) TYPE=MyISAM;

CREATE TABLE Fielding (
  playerID varchar(9) NOT NULL default '',
  yearID smallint(4) unsigned NOT NULL default '0',
  stintID int(2) NOT NULL default '0',
  teamID char(3) NOT NULL default '',
  teamName varchar(50) NOT NULL default '',
  playerName varchar(100) NOT NULL default '',
  lgID char(2) NOT NULL default '',
  POS char(2) NOT NULL default '',
  G smallint(3) unsigned default NULL,
  GS int(3) default NULL,
  InnOuts int(5) default NULL,
  PO smallint(3) unsigned default NULL,
  A smallint(3) unsigned default NULL,
  E smallint(2) unsigned default NULL,
  DP smallint(3) unsigned default NULL,
  ZR double(5,3) default NULL,
  PRIMARY KEY  (playerID,yearID,stintID,POS),
  KEY playerID (playerID),
  KEY team (teamID,yearID,lgID)
) TYPE=MyISAM;