Multiple Organizations

[abouolia]

Ability to include multiple organizations under one user and switch between them.

The multiple organization feature is really simple one, especially if break it down to smaller tasks would be much easier to build.

Backend

• [ ] Let us start with database schema design first, because DB handles all the data, in the current design there’re two main tables. TENANTS and USERS, in the USERS table there’s a TENANT_ID column as one-to-many relation between TENANTS and USERS table. We have to re-design it to be manu-to-many, which means the user has relation with multiple tenants in the same time the tenant could have relation with multiple user. I think that could be done by building another table includes both relations. and of course that would have reflection on relations on the ORM models.
• [ ] When client sends any request to the server should have two main headers the x-access-token is authentication token and organization-id is the organization id (unique id for each tenant stored under TENANTS table), when switching organization from the frontend the org id that being sent to the server should change but access token should be the same because belongs to the user.
• [ ] Under TenancyMiddleware we have to validate if the org id is exist and also belongs to the user, if not, thrown error have to sent to the user.
• [ ] Build another endpoint e.g. `/api/organizations` retrieves the organizations list that belong to the current user with avoiding retrieving the organization is still not setup. because we need that in the frontend.
• [ ] Under the USERS table, we will add `DEFAULT_TENANT_ID``` the main purpose of that will represent the default organization when the user sign-in if the value was null, we'll show the organizations menu to select one of the them and mark the selected organization as last and default one.
• [ ] We will need new endpoint POST: /api/organizations has the same body payload of setup endpoint, creates a new organization, set it up and link it to the current user. (once you finish the first tasks I will involve in this since I know well how the system works)

Frontend

• [ ] Dropdown on header to list all active organizations to switch between them.
• [ ] Add new "Add a new organization" item to dropdown on the application header and build a new form on the popup/dialog to fill up the new org data and set it up.

[linear[bot]]

BIG-161 Multiple Organizations

[smart715]

Hello, I have read the job description carefully on upwork. I understand that the feature requires database schema redesign, token authentication, organization switching, and additional endpoints. I am confident in my ability to handle these tasks effectively. I am confident in my ability to deliver high-quality work and meet the project goals and deadlines. I am available to start working on the project immediately and can dedicate my full attention to its successful completion.

I look forward to discussing the project further and collaborating with you to implement the multiple organization feature in your application. Thanks.

Gmaill : smartmanage715@gmail.com Skype : https://join.skype.com/invite/vNeE45Svtd9P

[Parth0487]

Hello there,

I have thoroughly reviewed the job description on Upwork and fully understand the requirements, including database schema redesign, token authentication, organization switching, and the creation of additional API endpoints. I am confident in my ability to manage these tasks efficiently and deliver high-quality results.

I am eager to begin work on this project immediately and am fully committed to dedicating the necessary time and effort to ensure its successful completion. I look forward to the opportunity to discuss this further and collaborate on integrating the multiple organization features into your application.

Thank you for considering my proposal.

Best regards, Parth

Gmail: sonubhavsar0487@gmail.com Skype: https://join.skype.com/invite/XodklfZvBb80

[ASADFi]

Hi,

After reviewing the Upwork job description, I identified key areas where my expertise can significantly enhance your project.
I specialize in optimizing database schemas and crafting robust API architectures. This experience allows me to tackle the project's core requirements:

Database Schema Redesign: I'll ensure your database structure efficiently supports organization switching and future growth. Secure Token Authentication: I'll implement a secure token-based system for seamless user access across organizations. Organization Switching Functionality: Effortless organization management will be built into the API, streamlining user experience. Tailored API Endpoints: I'll develop additional API endpoints aligned with your specific needs.

Beyond Efficiency: A Collaborative Approach

I'm not just about getting things done quickly. I prioritize clear communication and collaboration. I'll actively engage with you to understand your vision and ensure the final product aligns perfectly with your goals.

Ready to Discuss and Deliver

I'm eager to discuss the project further and delve into the details of integrating multi-organization features seamlessly within your application.

Thank you for your time and consideration.

Gmail: meerasad636@gmail.com Skype: https://join.skype.com/invite/yskNEqJVPYwu

[srathore007]

Hi , As a 5+ yrs of Development experience engineer in Fullstack domain and analyizing the requirement , I can assure you that this can be done in a day after a quick discussion. I have my clarity on what is required out of me and It would be great if we can get on a zoom call to dicuss further. Let me know your availabilty. I assure you that the solution would be robust and with production standards. We can dicuss the costing as well in the call and it will be minimum . Looking forward to hearing back from you. Email : srathore00793@gmail.com Regards, Sushant

[poudelprakash]

@abouolia multiple organization would be related to passport.js as well right?

Referencing your comment on OIDC #385 feature

Hey Prakash, I have looked at your PR, recently we've decided to migrate the authentication module to passport.js because we want to integrate other more additional strategies like Gmail, and do OIDC through passport, but since you worked on this you can keep use the feature on your cloned repo and merge to new updates the coming from main repo.

[abouolia]

@poudelprakash No, multi orgs has nothing to do with auth service.