9 Dec 2002, "Re: LEAGUES table - create", ... Yes. I suppose that that usage is portable. ... I wonder the capacity of Access and MySQL should govern this, or...
1068
tangotiger <tmasc@...
tangotiger
Dec 9, 2002 3:34 pm
... Paul: With yahoo groups formatting, it's tough to read some of the stuff. Can you upload in the files section (or e-mail me and I'll post it), a csv...
1067
Sean Lahman
anson2995
Dec 8, 2002 1:46 am
I'll go out on a limb and say Wednesday (12/11). I spent Saturday updating the readme file, and have a few last minute things to check before it's ready. ...
Anxiously awaiting 2002 update to the Lahman DB. What's the latest ETA?...
1064
Sean Forman
sforman71
Dec 7, 2002 5:34 pm
I believe this was still on the table as something left to do. I have taken care of these, so they can be crossed off the list. I also have the awards voting...
... Beside the possibility of other fields (where the structure to add minor leagues is the main point discussed): One revision of LgName (which is matter of...
1061
tmasc@...
tangotiger
Dec 6, 2002 12:55 am
Total number of teams can be calculated. It might be more difficult to count "new" teams, especially if you have expansion and teams moving. ...
1060
kjokbaseball
Dec 6, 2002 12:16 am
I agree with Paul. Eventually we may need a league record for each league year, something like: League Table ID Date Status No_teams Comments FL 1913...
1059
Paul Wendt
pgw02472
Dec 5, 2002 11:17 pm
... One alternative is popular name and unpopular name, er, lgName: National Association lgFormalName: National Association of Professional Base Ball Players ...
1058
tmasc@...
tangotiger
Dec 5, 2002 5:48 pm
... That looks pretty good to me. Are there any other fields that we need to consider? Currently, we have lgID lgName StartDt EndDt (can be null) Comments...
1057
baseball-databank@yah...
Dec 5, 2002 5:07 pm
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the baseball-databank group. File :...
1056
kjokbaseball
Dec 5, 2002 5:06 pm
... that ... there ... Feel ... Paul ... I am uploading one. Let me know if that's what you had in mind... THANKS, KJOk...
1055
tangotiger
Dec 5, 2002 2:34 pm
I just noticed that there is no leagues table, meaning of course that we are left to ponder such things as "UA" and "PL", as well as there being no integrity...
1054
tangotiger
Dec 5, 2002 4:05 am
Anyone want to (already did?) want to verify against this list? http://www.baseballamerica.com/today/features/agechart.html Don't know how many of those guys...
1053
tmasc@...
tangotiger
Dec 5, 2002 1:27 am
... The other way Paul. Franchise aka Ballclub is the "root". Milwaukee Brewers went through many "team" incarnations, but they are always the same ...
1052
Paul Wendt
pgw02472
Dec 5, 2002 1:06 am
Moments ago, 4 Dec 2002, Paul Wendt (that's I) contributed "Re: DESIGN - normalization - teams/franchises" ... This is part two. It is an index to the...
1051
Paul Wendt
pgw02472
Dec 4, 2002 11:35 pm
[part one. A list of bb-db references will follow.] 2002-03-29, #116, "Re: Database errors, part 4 (last one)", ... One version is the attachment to #116....
1050
tangotiger
Dec 4, 2002 9:21 pm
Here is a list of outstanding items that we've brought up in the last month. I don't know the resolution status on some of them. I have provided the message...
1049
tangotiger
Dec 4, 2002 9:06 pm
Paul said: ...but he expressed a different view regarding ERA a message ago *** Actually, my views are pretty clear, and we make everything 3NF. I concede that...
1048
Paul Wendt
pgw02472
Dec 4, 2002 8:55 pm
Normalization, again. ... Interest in a particular league is exceptionally common, more common than interest in any particular calculated stat such as ERA. ...
1047
Sean Lahman
anson2995
Dec 4, 2002 12:03 am
Trying one more time. If anybody has completed updates of these tables, please submit them now, or forever hold your peace. :-) --SL ... From: Sean Lahman...
... PH4 should be the Philadelphia franchise in the AA from 1882 to 1890. The other one is a little tricky. I think the 1890 players league team and the 1891...
1044
tangotiger
Dec 3, 2002 4:00 pm
I think we said that the "team id" would be unique across leagues, meaning that you don't need the teamID and lgID to uniquely identify a team, just the team...
1043
tangotiger
Dec 3, 2002 3:45 pm
The manager table is missing the "manager id" from the key. This is what is on the website PRIMARY KEY (yearID,teamID,inseason),...
1042
tangotiger
Dec 3, 2002 3:36 pm
I created a team/franchise cross-reference table. This means that the "franchid"; should disappear from all tables, except this one, and the "TeamFranchises"...
1041
baseball-databank@yah...
Dec 3, 2002 3:25 pm
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the baseball-databank group. File :...
1040
Mike Crain
ucraimx
Dec 2, 2002 3:22 pm
... That would be a great idea and would work nicely! __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful....
