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 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php