How Would You Structure This?

[eluser]mdavis1982[/eluser]
Thanks for your input, xwero.

I'm not really interested in how to structure the back end as that's fairly straightforward; I'm more concerned with getting the DB schema set up properly and how to make sure that I only enable the sale of the requisite number of products so that they don't go over their stock allowance!

Thanks..

Matt