Originally Posted by
CJ_London
As davegri says - you need to clarify what your structure is as it doesn't answer these questions:
1. can individuals 'exist' who are not part of a team or a congregation? yes
2. If not, what comes first? they become a member of a congregation and can then be assigned to a team? or just assigned to a team? The individual is created, then associated with a congregation.
3. can individuals be in more than one team? either at the same time or consecutively? As far as I know, and individual is only on one team at a time. There is a team role and begin and end dates.
4. can individuals be in more than one congregation? either at the same time or consecutively? Not as far as I know.
5. can individuals have more than one role in a team? either at the same time or consecutively? At the same time, no. Consecutively, yes. That is based on begin and end dates.
6. Do individuals have a specific role and/or status which is used to assign them to a team? Or are they just individuals who are assigned a role/status when they are assigned to a team? My understanding is that they are assigned a role and status when they are assigned to a team.
7. what do the begin and end dates mean? their time in the congregation? the team? in a role? as an individual? The begin/end dates are for the role in a team. For example from 1/1/2020 - 9/30/2022, someone could be in the role of "network member" then from 10/1/2022 - present (null end date) be in the role of team leader.
I've taken a quick look at the relationships you provided and the structure does not look right - but depends on the answers to the above as to what to change, but almost certainly you don't have enough tables
edit: one other question - can a team be assigned to more than one congregation?