- Thread starter
- #1
linuxabuser
Well-known member
- Jan 16, 2011
- 2,364
- 50
Right now, I have one Excel sheet for every set I collect. They're not easy to search, unless I'm in front of a computer. And even then, searching takes time. I'm putting together one database, for all of the sets I collect. This will have entries for cards I have, and cards I do not, since I'll need them eventually.
I would like FCB's input on what data should be recorded about each card. I'm trying to avoid a generic "notes" field, because that would be unstructured and muddy the search results. Below are the properties I have so far. What else would you add?
PlayerName
AcqCost (Acquisition cost)
AcqFrom (Acquired from - eBay, COMC, etc.)
Brand (Topps, Upper Deck)
CardNum (Numeric or letters, doesn't matter)
EstPrice (Estimated price I could sell it for)
InInventory (true/false)
InTransit (true/false - I don't count it as being in my inventory until I take possession)
Qty
Set
Subset
Year
Authenticator
Grade
Redemption (true or false)
QtyMade (what's it short printed or numbered to)
ItemID (this will be my own creation to uniquely identify each card)
I would like FCB's input on what data should be recorded about each card. I'm trying to avoid a generic "notes" field, because that would be unstructured and muddy the search results. Below are the properties I have so far. What else would you add?
PlayerName
AcqCost (Acquisition cost)
AcqFrom (Acquired from - eBay, COMC, etc.)
Brand (Topps, Upper Deck)
CardNum (Numeric or letters, doesn't matter)
EstPrice (Estimated price I could sell it for)
InInventory (true/false)
InTransit (true/false - I don't count it as being in my inventory until I take possession)
Qty
Set
Subset
Year
Authenticator
Grade
Redemption (true or false)
QtyMade (what's it short printed or numbered to)
ItemID (this will be my own creation to uniquely identify each card)
Last edited: