Hi all, Building my hosting administration application, I wonder If somebody can give me some feedback about the following. When a customer wants a hosting package, I want to create a new project (what's in a name?). To which I copy contact info, (sub)products like mailbox, hostname webspace. etc. And I want to log my hours into a project as well. I came up with the following prelimenary tables (models if you will) Project has_many: Project_Contacts has_many: Project_Products has_many: Project_Time_items Project_Contacts (records wil be copied from the normal Contacts table) Project_Products (a shopping cart like setup to gather all sub products and copy them in from Products) Project_Time_items (A table with records on what time was spent on what) Note: Records are copied to the Project_Contact table so data is still valid when contacts do no longer work for a company and they are deleted from Contacts. Do's this make any sence or is somebody out there scratching his head trying not laugh .. :-) Thanx! Gerard. -- "Who cares if it doesn't do anything? It was made with our new Triple-Iso-Bifurcated-Krypton-Gate-MOS process ..." My $Grtz =~ Gerard; ~ :wq!
on 2006-01-03 16:23