score_realteam
Wed, 02/20/2008 - 21:54 — wrburgess
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: