Search the web
Sign In
New User? Sign Up
hockey-databank
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Proposed (minor) change to Master table   Message List  
Reply | Forward Message #90 of 133 |
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





Fri Jan 18, 2008 3:18 pm

dsreyn
Offline Offline
Send Email Send Email

Forward
Message #90 of 133 |
Expand Messages Author Sort by Date

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...
dsreyn
Offline Send Email
Jan 18, 2008
3:18 pm

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 ... Tim Raines, Hall...
tangotiger
Offline Send Email
Jan 19, 2008
12:22 am

I agree with Tom, it's better to keep every single field separate and representing one thing only. I like the idea of separate years for the NHL and WHA...
SIRE1499
Offline Send Email
Jan 20, 2008
5:56 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help