Here I am trying to implement User relation with company and organization which is one to one
And then company to organization and groups which have many organization many to many
company to user groups having many users many to many
But problem is this I want to apply roles on each and every layers and get it one query which have high performance of read operation and medium performance for write action
can you help me with schema design here I am relational man stuck in this!!