I have a large database that is used for many different things--customers billing product details--and would like to create a chart that has a separate table for each sub-schema with field-to-field links between the tabs.
EX: my customer schema has 10 tables on tab 1. Table 3 has the FK for Product ID. I want to link that to the Product ID in the Product table on tab 3 (Products).
For a smaller database I would just use one chart but this database has 100+ tables that represent the 4 areas (customer product locations and invoicing). I need to show how the data flow works for each area and between the areas so that it can be used by everyone who needs to integrate with the system.
ERD for Database with Multiple Schemas
+8Hi Nova
Thank you for posting in the community! We do not currently support this functionality however you can create a similar visual by using layers and pages. You can then use actions and hotspots to link to the different pages or layers of your document.
We're always looking for ways to improve Lucidchart and your feedback is the best way for us to do that. If you would like to share this use case with our product team you can do so using our feature request form.
Thanks for your request and I apologize for any inconvenience this causes you.
Create an account in the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in to the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in with Lucid
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
