score_realteam

Description:

 

Fields:

  • realteamid - id field of the "score_realteam" table
  • name - location or ownership name of a real team, such as "New England", "New York", or "Florida"
  • nickname - the mascot or team marketing name, such as "Patriots", "Knicks", or "Marlins"
  • abbrev - abbreviation of real team name
  • realsport - the real sport that a team plays in, such as "American Football Professional" or "Baseball Minors"
  • league - the league that a team plays in, such as the "NFL", "MLB", or "NCAA"
  • class - the level of play within a league that a real team plays in, such as "FCS or FBS in the NCAA" or "league pyramids in English football"
  • conference - a particular conference within a league that a real team plays in, such as "National League in the MLB" or "Eastern Conference in the NBA"
  • division - a particular division within a conference that a real team plays in, such as "NFC South in the NFL" or "Central Division in MLB"
  • city - the municipal location of the real team address
  • state - the state of the real team address
  • zipcode - the postal code of the real team address
  • url - the official website of the real team (this field can be moved to a separate table to accomodate several websites)

Notes:

  • xxx