02-24-2007, 10:57 PM
I built a Soviet awards database recently. The project started out after I had become kind of interested in how several awards were established on the same date, or within a short period of one another, and thought that it would be neat to see a list of awards by date established. I had code that I had built for work that allowed me to construct a database that could be viewed and edited from the Web. So I built a database with all the orders and medals in it, along with their order of precedence for wear, their dates of establishment, and the (usually approximate) number issued. As such, I can go to my database site and sort the data by any field--I can list awards by date established, by number awarded, or by order for wear (can also sort alphabetically by name but can't think of a use for the feature).
Anyhow, after I had all of that built, it occurred to me to create a Detail View that you could access for any award by clicking on its name. In this area, I put serial numbers, types, and variants for awards that I happen to be the current curator of. My next step is going to be building a photo-upload form that will allow me to add photos of awards that I'm taking care of.
Well, that's what I'm doing; I'm kind of a geek. Others probably have notebooks, photo albums, maybe insurance docs. I'll be interested to see other ideas that come up in this thread.
Anyhow, after I had all of that built, it occurred to me to create a Detail View that you could access for any award by clicking on its name. In this area, I put serial numbers, types, and variants for awards that I happen to be the current curator of. My next step is going to be building a photo-upload form that will allow me to add photos of awards that I'm taking care of.
Well, that's what I'm doing; I'm kind of a geek. Others probably have notebooks, photo albums, maybe insurance docs. I'll be interested to see other ideas that come up in this thread.
