Managing different user in application

Hi Bubblers
I am new to bubble and have been learning constantly.
Although, my skill set is improving and I am more and more spending time on learning bubble.
I am building a property management system.
Where I will have different users
Tenants, (rent property from landlord)
Landlords, (landlord rent their property to tenant)
Guests (rent certain type of properties, which will be short term rentals like air bnb)
Agents (manage property on behalf of landlords)

Property (different types of properties such as short term Airbnb type and long let )
Maintenance team with different sets of users like cleaners, painters etc.

Lots of connected sets of users
Problem is when I am managing users
I created a field in user (tenant as list if users)
I also created a field in tenant (user as a list of users)
But problem now is when I want to show the list of tenants in RG, i want to show the tenants email address in RG, but I cannot see option of tenants email
Please someone help me structuring the db right was


there is the ability to create permissions in the database