Can you help? Database design and Search

For simple one to one mapping between Roles and Teams, i have figured it out by reading/watching many tutorials.

image

The above is easy

But what i am trying to achieve is to be able to assign different roles per team… like below
image

Is this something you can help? Or Is there any tutorial that i can look up to for this?

If I understand your question correctly you want each User to have a separate Role in each Team, yes?..

So all you need to do is create a datatype called something like user_team_role that relates to a User, a Team, and a Role.

You could then have a list field on the User datatype called Team Roles, which is a list of user_team_roles (although that might not be necessary, it might be easier and more performant depending on how you want to access those roles).

1 Like

Thanks much Adam. Let me implement this check.

1 Like

may find that a review of generic user/group/permissions would be help with your context as its pretty much the same old entities / relationships as always …

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.