Hello Everyone 
,
At the moment, I’m engaged in a project that entails creating multi-tenant databases for SaaS applications. My objective is to use dbdiagram to construct an effective and scalable database structure. Since I’m still learning about multi-tenant designs, I’ve run into a few obstacles. I would be very grateful for any advice or suggestions from the community.
Here is a quick synopsis of my project:
Tenants and Users: Tenants each stand in for companies, and companies have groups of users. It is imperative that I guarantee the secure partitioning of data to prevent access to it by users belonging to different companies.
Shared & Isolated Data: Some data should be shared by all tenants, such as system-wide templates and settings. Nonetheless, for items like accounts for users, orders, and reports, every tenant will have a separate, isolated collection of data.
Scalability: As the variety of users and renters increases, the program must be able to grow effectively. Performance bottlenecks worry me, thus I want to make sure the database design allows for horizontal scaling when needed.
These are the particular queries I have:
Schema Designing: What are the most effective methods for creating a multi-tenant database’s schema? 
Should I think about utilising different databases or schema for each tenant, or can I use one database that has a shared schema across all tenants?
Data Partitioning: What is the best way to divide up the data so that performance and security are guaranteed? Are there specific database features or indexing algorithms that I should take advantage of?
Managing Shared Data: How should I manage data that is accessible to all tenants? Is there a better way to store this data, or should it be in its own table?
Tools and Techniques: What particular plugins, tools, or features of dbdiagram can make managing and designing multi-tenant databases easier?
Case Studies: I’d love to learn about your strategy and any lessons you learnt if you have any previous knowledge of multi-tenant database in a comparable setting.
I also followed this 
https://stackoverflow.com/questions/25164606/database-er-diagram-of-a-multi-tenant-system-uipath
Thank you 
in advance.