I’m creating a base for managing contacts and people and am torn between creating a table for companies and another table for People or whether to put Companies and People on the same table.
Here are what I see as the advantages of putting Companies and People on the same table.
- The Companies and People share many of the same fields (name, address, phone, email) and so there are efficiencies to having both on the same table.
- You can also do links to the same table so you can show a linked “Works for” field if you want to track what people are associated with the Companies in the table.
- Lastly, if you have another table that needs to reference contact info from either People or Company, referencing a single table seems much cleaner than have a separate reference field for each table and then another that tries to parse each field column to figure out which value to take.
When I look at other CRMs, I often see People and Companies as different tables. Can someone articulate a good answer as to why folks do 2 tables rather than one and a view as to what is better?