Lets say that we have the database with tables PEOPLE, COMPANY, PHONE and EMAIL. Both PEOPLE and COMPANY could possibly have an email and phone. Now I choose to have fk_email and fk_phone in both PEOPLE and COMPANY, and this results in this error:
How would you guys set up this relationship?
Thanks for all inputs