Hi @JellyBean, thanks for posting in the Lucid Community! You can then drag the database tables from the shape menu onto the canvas. If you have properly set up the primary and foreign keys, when you drag related tables onto the canvas, Lucidchart draws relationship lines automatically.

I would recommend reviewing our ERD article from the Lucid Help Center as an additional resource, but please let me know any questions about the intended functionality of ERDs in Lucidchart!

Hi ​@Amelia W, this is not working for me. 

The relationship lines are not automatically drawn, even if I have properly set-up primary and foreign in the Constraint_type column of my CSV. Can you explain further what should be done ?

Mathilde

Hi ​@mathildeguilbard, thanks for adding to this thread! When Lucidchart is not drawing lines between the entities of your imported ERD, it is likely that your data file does not indicate the relationships using primary and foreign keys as our importer would expect. To check this, please open your data file and make sure that the cells at the end of each row are populated with information about the relationships between entities.

I’ve attached an example csv file in the format our ERD importer expects, would you mind comparing your file to this example? Please let me know if the issue persists! 

Thanks it seems to be working! 

As I use a BigQuery dbms it is not that easy to take on and the documentation does not very clearly explain which columns of the CSV are crucial (but i figured it out finally :)))

Hi ​@mathildeguilbard, I’m glad to hear that! We appreciate your feedback for our documentation as well.

Going forward, if your DBMS is not formally supported in Lucid, or if you run into any import errors, you can write a custom query and run it in your database. Then, the example file can be used to help you generate an output file in the format our ERD importer expects.

For any other users that might have questions about ERD’s,  I recommend reviewing our Create an Entity Relationship Diagram in Lucidchart article from the Lucid Help Center for more information about the set up and intended functionality.

I have a strange pb today, I cannot clik the “import your data” button. I have no eror message it is just not display the options ‘from salesforce” or “from SQL database” anymore… It worked this morning but not anymore, I am confused

​@mathildeguilbard  thanks for your comment! I am able to reproduce this on my end and have reported this to our development team. 

I recognize that this issue may hinder your workflow, and I want to be transparent so that you are able to move forward in the best way possible. Our development team has to rigorously prioritize what to work on based on the extent and criticality of the issue. Because of this, it is not likely that this issue will be resolved quickly. I apologize for any disruption this may cause, and I would like to do all I can to help you continue your work.

In the meantime, I recommend adding the ERD shape library to your document and clicking the Import button here instead.

I hope this helps. Please don't hesitate to let me know if you have any additional questions or concerns.