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!