I have a customer table. Each customer can have multiple contacts, as well as multiple phone numbers. Each contact can also have multiple phone numbers.
My design right now is as follows:
customer contact table
cust_id (fk) -> refers to customer table's cust_id
At this point, I thought of using one phone table to store both customer and contact phone numbers, but I can't figure out how to link them ... A customer can have zero, one or many phone numbers. A contact also can have zero, one or many phone numbers.
Then only way I can think of doing it is by having two phone tables:
Is there a better solution that I'm missing?