DB structure help in Appwrite

Hi, I wanted to use Appwrite for my project, but am not sure how to implement this:

I have 3 user types: manager, sub-manager and employee.

Logic: I wanted the manager to have access to all the functions of the app (E.g. create employees, create sub manager, add tasks send employee report) The sub manager has access to manager's functions with exception of a few (E.g. not able to delete employees, not being able to change company name etc.) The I will create another dashboard for employees to be able to view latest news within the organisation and also send responses via form to the admins - manager and sub manager)

Is it possible to implement something like this in Appwrite, thanks 🙂

This is definitely something Appwrite can do, I'd suggest taking a look at Labels and how they work as I think that would be the best way to do it https://appwrite.io/docs/products/auth/labels

Thanks, will check it out, and what about the DB structure, how would you advise on this pls

(I was thinking of collections for companies, managers, sub-managers, employees, payments, and task lists) but this seems abit complex, would you maybe have another suggestion on this?