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?
|