Newer to Bubble but trying to figure out the correct ways to structure a database for the best speed and security, when there is multiple teams/companies using the application but data should be private to each team.
Example of application: a SaaS product that helps teams with task management.
So there would be the following data types:
So Users in Company A can add tasks, which can be seen by other users in Company A. But no one from Company B (and any other companies that use the application) should not be able to see these tasks at all (even though they are using the same Tasks data type).
What are the recommended ways to structure this for the best speed and security?