I am struggling with knowing how to best set up my database. I have a Data Type “Users” and a Data Type “Teams”. Each Team is composed of many users and a User belongs only to 1 Team.
Is it better to set a “Team” Field to my User or to set a “List of Users” Field to my Team, or do I have to do both? What would you reccommend? Currently I am doing both and it is becoming very chaotic when I reference the elements in the different dashboards or privacy rules.