Can you out perform ChatGTP? (1 Viewer)

[The_Doc_Man]

each of the members activities can have multiple partners

From your description including but not limited to that statement, I think you need to look up what are called JUNCTION TABLES.

It would assume that a member's partner is ALSO a member. Your junction table will include not less than one slot for the member's ID, one slot for the partner's ID, one slot for an activity code, and MAYBE (if this applies) a slot to make the partnership unique IF the member has more than one partner for a given activity. If you have multi-partner teams (i.e. >2 members) this still works if you have team ID (for example).

 

[GaP42]

I have a different view on the relationships: as stated by Redstick it is not a genealogy database, however associations between members need to be supported to allow recognition of partnerships - meaning generally teams. Family associations between members (may) also need to be recognised. Without going into the detail, the following supports these requirements.

I know that there is no stated requirement for attendance at an event / GroupActivity. Just threw it up as there is nothing to say because you are a member of the team and the team played that a particular member participated on that occassion. A similar arrangement is used to track attendance at scheduled meetings.