How to generate an Entity Relationship Diagram (ERD) using the SQL email attachment?
Disclaimer: Mitratech does not take responsibility for any defects or improvements that may occur while using third-party tools such as dbdiagram.io to visualize diagrams through our scripts.
This document contains instructions on generating an Entity Relationship Diagram (ERD) using the SQL script received through email.
Follow these steps to create an Entity Relationship Diagram (ERD) using SQL scripts:
Instruction | Screenshot for your reference |
|
|
2. Open the downloaded text file, which contains the SQL script necessary for generating the Entity Relationship Diagram (ERD). 3. Launch a web browser and enter "dbdiagram.io" in the search bar. Once on the welcome screen of dbdiagram.io, click "Create your diagram." |
|
4. A screen for generating the Entity Relationship Diagram (ERD) will appear. Copy the SQL script from the downloaded text file and paste it into the left panel of the dbdiagram.io interface. |
|
5. After pasting the SQL script, the required Entity Relationship Diagram (ERD) will be displayed on the screen. |