Loading ...
Sorry, an error occurred while loading the content.

92Re: [hockey-databank] Proposed (minor) change to Master table

Expand Messages
  • Tangotiger
    Jan 18, 2008
    • 0 Attachment
      On a data design issue, every single field should
      represent one and only one thing. Merging data into
      one field is not a good idea.

      Tom


      --- dsreyn <dreynolds@...> wrote:

      > The Master table currently contains four fields
      > (firstNHL, lastNHL,
      > firstWHA, lastWHA) that give the years a player was
      > active in the NHL
      > and WHA. I'm considering replacing these with one
      > pair of fields to
      > indicate the span of years for which a player has
      > data in the Scoring
      > and Goalies tables. In addition to combining the
      > NHL and WHA years,
      > this would also include the three older leagues
      > (NHA, PCHA, WCHL).
      >
      > I don't see this as a major change, but I thought
      > I'd mention this
      > before going ahead. If this will cause a serious
      > inconvenience for
      > anyone, I could be persuaded to leave it alone.
      >
      > Doug
      >
      >
      >
      >
      >
      > Yahoo! Groups Links
      >
      > (Yahoo! ID required)
      >
      > mailto:hockey-databank-fullfeatured@yahoogroups.com
      >
      >
      >


      ---------------------------------------------
      Tim Raines, Hall of Fame 2008
      http://www.raines30.com/










      ---------------------------------------------


      ____________________________________________________________________________________
      Be a better friend, newshound, and
      know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
    • Show all 3 messages in this topic