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!
