Good morning everyone!
Hope you all have your coffee in hand when reading this :)
In case it makes a difference, It will be written in PHP 5.2.6 and
using mysql 5.0.51a-community with apache 2.2.9.
I am in the planning stages of a project that will turn into a
customer relation management system. I know there are quiet a few out
there, but I may need to be able to tie it into some accounting
software that we use here so I need to write my own... Besides, I get
paid to do it :)
Now... the meat of the question... When does it make sense to use
multiple tables? I am going to have the name/contact info for the
business, codes for when we contacted them last and how (Phone, e-
mail, postal mail, etc. etc), I also want to track the history of
changes made to each record.
Right now, I am thinking 3 tables, 1 with the name, address, phone,
etc. on it. a second with the contact codes, and a date. And the third
for keeping track of the changes.
I started thinking about it though... and I could have at least 6
tables, Address/contact info. Contact codes. Changes. Customer
History. Sales Rep Info. Access Control...
Right now the organization is small, only 9 full time employees
including production, so it's not a huge deal, but I'm hoping this
will be something that will help grow the company and we will have
sales people all over the world :)
So my question is... When is it best to use more tables? All the info
will be related to each other, so I think I would be looking at either
a many-to-many relationship, or a many-to-one relationship (still
figuring that out).
I am also considering writing it as a module system so that I can just
plug things in as needed, I could also then get it up and running
faster I think..
Was anyone able to determine what I am really asking in this long mess
of words? :)
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
11287 James St
Holland, MI 49424
www.raoset.com
japruim@xxxxxxxxxx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
