In my app, there are 2 user types, Member and Owner. A household can have multiple members and multiple owners. Also, a User may be an Owner in 1 or more households, and a member of 1 or more households.
In SQL I would have a join table for [household - user - user type]. How would it work in bubble?
My thoughts…
Household Data Type would have list-fields (of type user) for Member and Owner?
User table would have a list of Households for which the user is associated in some way, so that I can isolate a list of households in a drop down that a user is part of, or is this unnecessary, and can just be pulled from the household table? OR Should I create an association table, like a join table, with User, Household, User-Type?
Thanks