Data modelling

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 … :slight_smile:

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!

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs