Well, I'm not much good at the whole database thing. I just created a single table to track what I need.
Your document control method (how you deal with your files on your hard drive) needs to work with your archiving method. I have a specific way of doing this, but I don't have to share my files--so I have lots of freedom in this regard. Since each iteration of my projects has its own folder (named "070416 Proto", as an example of today's iteration of a project), it's easy for me to properly label and track things in a database table when creating DVD back-ups.
I track things with the following methods--these are headings across the top of my Access table. (If you don't have Access, download a free [[open source] database system as part of Open Office.)
ID: This is the automatic number given to each row in Access
Disc: This is the name of each archive DVD--such as 070416 for today.
#: This is the suffix name of each archive DVD--in case I make multiple DVDs at one time. So I may have 070416-1, 070416-2, and 070416-3.
Client: This tells me who the project was for.
Project: This tells me the project name--such as Utility Knife.
Description: This is an additional field that doesn't always get used. I might add in a descriptive term here, such as the vendor name tooling files were sent to or "animation" or some other thing--to better let me find what I'm looking for within the database.
Rndr: I put an "x" here if the iteration contains any renderings.
Proto: I put an "x" here if the iteration contains any prototype file exports.
Mfg: I put an "x" here if the iteration contains any tooling exported files.
Rev: I put an "x" here if the iteration contains multiples for the folder date--so if I have more than one iteration in a single day--to distinguish which set of files is most recent.
Date: This is perhaps the most important one--it's the name and date of the iteration folder--such as 070416 for today.
I use all these columns as various ways of quickly finding what I need for a client or other needs when the project has been long completed. I must have near 30 DVDs packed with archives of projects over the years, so I had to have some method of quickly accessing the millions of files I've created over the past ten years.
If you know what you're doing with Access, you can also create a query interface to do the same things with your various table columns. I like seeing all the stuff, just in case there was a typo or slight variation in naming a project, so I haven't bothered with a query format.
Jeff Mowry
Reason trumps all. And awe transcends reason.