Let’s start with the product management. I’ll try to keep it simple for the time being. My weapon of choice, when designing the database schema is the almost great WWW SQL Designer.
Right now the schema looks like this:
And the XML file is located here.