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