Hello Everyone 
,
I’m using Bubble.io to construct a multi-user SaaS application, and I could need some help organising my workflows and database to manage various user roles and data relationships.
My platform of choice is intended to help organisations handle internal tasks. Every organisation will have a number of users, each with a distinct job, like member, manager, and administrator. Admins will have the ability to set up and oversee projects, delegate work to Managers, and keep track of developments. In response, Managers will assign assignments to Members and monitor their fulfilment.
My primary enquiries centre on the following:
Structure of Database:
How can the database be organised to best ensure that the data of one organisation remains isolated from the rest? I want to create a data type called “Company” that has relationships to both users and projects, but I’m not sure how to enforce the separation.
What is the proper way to handle the connections between Users, Roles, and Tasks? Is it better to handle roles using a different data type or the user data type directly? 
Processes for Assigning Assignments:
How can workflows be created most effectively so that tasks can be assigned to particular people according to their roles? Tasks should be assigned to Managers by the Admin, but only Managers should be able to allocate them to Members.
User Authorisations:
How can I limit specific actions (e.g., assign tasks to managers only, delete projects only) without making workflows too complicated?
I would be very grateful for any advice on how to put this up or if someone has built something generative ai similar in the past!
Thank you in advance.
