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.