On Mon, 28 Sep 2020, Adam Scott wrote:
What if a person is a member of more than one Org? Consider a person_org table.
Adam, Not applicable. An individual is employed by a single organization.
I see mention of a site in the person table. It may also be the case that you need a site table.
Yep. That's what I need to add.
Often, you want a table for the Person and a Contact (or Address) table separately. This allows for having more than one contact for a Person.
Possible, but I've not encountered more than a couple of phone numbers per person (work and mobile). I don't need home addresses or phones.
This way a person can be a member of more than one org, at one or more sites, and have one or more contacts.
Doesn't apply to businesses in my market areas. Thanks for the thoughts, Rich
