cloisonne, enamel, jewelry, silver, gold, enameling, metal, fine metal
Database for Button Tracking
Many button collectors would like to be able to track buttons and button trays. The best way to do this is a relational database as opposed to a flat file. A relational database xxx.
My career was in software development and I am working with a database developer to define this system for button collectors. Below is what I have defined so far. If you want more or really dont' think you need something, please email me and let me know. This system is for you!
These are the files for a relational database. If you don't understand what this is, don't worry right now. And just go to the Button File definitions.
NBS Class Numbers – taken standard from the Blue Book, but allow more for collector-defined
Dealer info for those you buy from
Selling info for those you sell to (could be a dealer)
Shank Types - from blue book
ID field - some way to identify the button. Best to use a number, but how to label?
Count - how many of this button you have
Photo fields for front and back - The file for the photo should start with the identifier.
DF (multiple fields)
Material - What main material it's made out of. It's possible that this is covered by the Category section
NBS Class Number - section number of the blue book it falls in. This should allow for multiple fields as many buttons fit into more than one category
OME (multiple fields)
Size: Dimi, Small, Medium, Large, XtraLarge
Studio – yes or no
Shank - yes or no
Age or possibly year created
Border - Y/N
Backmarked – Y/N
Backmark Symbol – what the backmark is
Focal Pictoral - allow mulltiple fields so a bee could also be listed as an insect
Location - use this for which tray or drawer or ??? you have stored it. If it's attached to a Tray record, then that Tray name will show up here
Technique - allow for multiple
Keywords - allow multiple for sorting
Art Style - or this could be included in Keywords
Who you bought it from
What you paid for it
When you bought it
Who you sold it to
What price you sold it for
When you sold it
Notes field - Info about the button(s) that is not part of the description. ex: book it was shown in with page reference