I have 2 tables one for People and one for Businesses
The 2 tables are linked so a Person can be linked to multiple Businesses and vice versa.
I am trying to figure out if there is a better way to store the kind of relationship a Person has with a Business. For example a person could be volunteer for a business or an owner etc.
At the moment in the People table I have multiple columns that are all linked to the business table with each column expressing the relationship ship to the business. I am finding the number of columns I need to show the relationships is becoming a burden and would love a way to describe/store the relationship (volunteer, owner etc) in a better way. If a person could be linked to only one other business it seems quite easy but I cant think of another way to handle this with multiple business relationships.
I’d really appreciate any words of wisdom people could offer here to help with this.