AnsweredAssumed Answered

Customer database design

Question asked by ChrisG on Feb 23, 2015
Latest reply on Feb 24, 2015 by NickLightbody

To me this has been an age old conundrum. A customer record, is it a company or is it an individual? If it is a company then it has individuals working there. What is the best way to structure this? Currently I have 3 tables; Customer, Company and Contacts. The customer table is the main entity with related company and contact data. Essentially the customer table behaves as a join table between company and contacts. This gives me a single parent ID to link to regardless of wether I'm referring to a contact or a company.

I was just wandering if any of you have a more elegant way of structuring this data?

 

regards

 

Chris G

Outcomes