Setting up a Complex Database - Just looking for approval on structure

[eluser]Monotoba[/eluser]
A little late I know however, you may want to take a look at the EAV database scheme. It allows you to dynamically define fields and field values. I think PHP Arch. had an article on EVA a few years ago. Or just google Entity Attribute Value Database scheme. It can result in some complex queries however using an ORM such as DataMapper or DMZ can ease the sheme development.

Hope this helps