Combination Baseball Statistics & Card Database?

Welcome to Net54baseball.com. These forums are devoted to both Pre- and Post- war baseball cards and vintage memorabilia, as well as other sports. There is a separate section for Buying, Selling and Trading - the B/S/T area!! If you write anything concerning a person or company your full name needs to be in your post or obtainable from it. . Contact the moderator at leon@net54baseball.com should you have any questions or concerns. When you click on links to eBay on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network. Enjoy!

01-02-2011, 03:36 PM

mab

Mark B

member

Join Date: Jul 2010

Location: Northern VA

Posts: 24

Not really. Mike has a very cool site, but it isn't quite what I have in mind. Thinking about starting an open source project to do it, though I don't have the best database skills.

I think we would need 3 tables;

1) Brands or Manufacturer, similar to the TeamFranchises table in Lahman. 2) a Set table, similar to Teams in Lahman, and
3) a Cards table, similar to Appearances.

Here's the fields I think would need to be in each table:

Brands:
Brand Name
Brand ID

Sets:
Set Name
Set ID
Card ID

Cards:
PlayerID (from Lahman)
SetID
YearID
Card#

I need to play with this a little to see if I can make it work. I would also want to add fields specifically to tracking cards that the user owns either in the Cards table or in a separate table, but want to see if I can make it work first. What do you think?

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is On Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
LARGE List of Autographed Cards For Sale - 1940s through 2000s (All Sports)	canjond	Baseball Memorabilia B/S/T	0	06-13-2009 06:54 PM
2008-09 Japanese Baseball Card Checklist & Price Guide	Archive	Baseball Memorabilia B/S/T	1	08-13-2008 12:04 PM
Value of Ted Williams Baseball Card?	Archive	Postwar Baseball Cards Forum (Pre-1980)	1	08-04-2008 01:35 PM
About.com: Let's Review Their Baseball Card Timeline	Archive	Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions	10	07-23-2007 01:36 PM
Are baseball card transactions taxable?	Archive	Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions	21	02-28-2007 11:38 AM

All times are GMT -6. The time now is 01:43 PM.