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?