Shulou(Shulou.com)06/01 Report--

This article mainly introduces what is ER model design tool and its use, what it involves, from theoretical knowledge to learn, there are many books, literature for everyone to refer to, from a practical point of view, accumulated years of practical experience can be shared with you.

overview

ER model visualizes the information stored in entities and intuitively presents the relationship between entities. In the actual application system development process, the new ER model can better understand the business model and play a role in summarizing the future development and maintenance work.

[Freedgo Desgin]() is an easy, fast and collaborative tool for creating professional charts. Allows you to create flowcharts, system deployment diagrams, software architecture diagrams, UML, BPMN, ER models,DFD, organization diagrams, software flowcharts, diagrams online. Free trial. Using Freedgo Design to create databases ER model currently supports MySQL and basic SQL statements to create tables. Later, the function will be extended to support SQL Server,Oracle,PostgreSQL, etc. Database model modeling, SQL import to generate ER model, ER model generation through DDL statement,ER model SQL export, and SQL generation according to ER model.

If you use traditional client tools such as ERwin or PowerDesign to design table structures, you may want to experience the lightweight, cloud-based storage and ready-to-use benefits of the online ER model.

It provides the following functions: Support online drawing of tables, views, stored procedures and functions; support multiple styles to choose from; use MySQL DDL language to realize online import and generation of ER model; realize table building SQL statement for table entities in ER model; support multi-table generation; generate fields for selecting tables in ER model; add or modify SQL statement online; export SQL script corresponding to ER model; quickly learn basic use:

If you want to use MySQL table to build ER model, please select Entity Relation/MySQL as entity type, select corresponding table, view, stored procedure, trigger, function and other components, and drag them to editing area.

1. How to import SQL?

There is a relatively simple way to generate an ER model for an established database, which is to export the database table creation script and then import it. The specific operation is as follows:

First visit https://www.freedgo.com/draw_index.html and click on the menu Database-> MySQL -> Import DDL

Copy SQL language into the corresponding box, or drag MySQL DDL file into the corresponding input box, click insert MySQL

Or drag SQL files to the corresponding input box

Finally, the corresponding model diagram is generated

2. Online ER model table operation adds and modifies table structure

To add fields online, click the arrow where you want to add fields.

After adding a field, right-click-> Modify Column to modify the attribute value of the field, supporting field name, type, length, primary key, foreign key, remarks, blank, etc.

3. Online view operation

Add or modify view: drag MySQL view model to edit area, edit view by right-clicking-> View SQL, modify view SQL in pop-up box.

4. Online trigger operation

Operation Same as View Operation

5, online storage procedures or function operations

Operation Same as View Operation

6. Export SQL query SQL of the whole ER model:

Click Database-> MySQL -> Export SQL

Query multi-table or single-table SQl:

As shown in the following figure: Select 3 tables and right-click:

Query column modify SQL or add SQL

Read the above what is ER model design tools and use introduction, hope to give you in the actual application of some help. Due to the limited space of this article, it is inevitable that there will be deficiencies and needs to be supplemented. You can continue to pay attention to the industry information section and regularly update the industry news and knowledge. If you need more professional answers, you can contact our 24-hour pre-sales service on the official website to help you answer questions at any time.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.