OverView
The ER model uses visualization of information stored by entities and intuitively presents the relationship between entities. The new ER model can better understand the business model in our actual application system development process, and plays a role in summarizing and summarizing the future development and maintenance work.
Freedgo DesginIt is an easy, fast and collaborative tool for creating various professional charts. Let you create flow chart, system deployment chart, software architecture chart, UML, BPMN, ER model, DFD, organization chart, software flow chart and chart online. Free trial. Using Freedgo Design to create a database ER model currently supports MySQL and basic SQL statements to create tables. Later, the function will be expanded to support modeling of database models such as’ SQL Server’,’ PostgreSQL’,’ PostgreSQL’, etc. SQL import is supported to generate ER model, ER model is generated through DDL statements, ER model SQL is exported, and SQL is generated according to ER model.
If you use traditional client tools such as ERwin or PowerDesign to design the table structure, you may as well experience the benefits of lightweight, cloud storage and ready use brought by online ER model.
function:
- Supports online drawing of tables, views, stored procedures and functions, and supports a variety of styles to choose from.
- Using MySQL DDL Language to Realize Online Import Generator Model
- For table entities in the ER model, table-building SQL statements are generated, supporting multi-table generation.
- Add or modify SQL statements for fields generated by fields in the selection table in the ER model
- Export SQL script corresponding to ER model online
Examples
Get started quickly
Basic :
If you want to use MySQL tables to build ER models, please select the entity type as Entity Relationship /MySQL
, select the corresponding table, view, stored procedure, trigger, function and other components and drag them to the editing area.
1、How to Import DDL SQL?
There is a relatively simple way for an established database to generate an ER model, which is to export the database’s table-building script and then import it. The specific operations are as follows:
First access https://www.freedgo.com/erd-index.html and click on the menu database
->MySQL
-> import DDL
Copy SQL language to the corresponding box, or drag MySQL DDL file to the corresponding input box,click insert MySQL
Or drag the SQL file to the corresponding input box
Finally, the corresponding model diagram is generated
2、On-line ER model table operation
Add and Modify Table Structure
To add a table field online, click the arrow at the position where the field needs to be added.,
After adding a field, right-click-> modify column
to modify the attribute value of the field. field name, type, length, primary key, foreign key, comment, null, etc. are supported.
3、 view operation
Add or modify a view: drag the MySQL view model to the editing area, and edit the view by right-clicking-> view SQL’ to modify the view SQL in the pop-up box.
4、Online trigger operation
Operation Same View Operation
5、stored procedures or function operations
Operation Same View Operation
6、export SQL
export All SQL:
click database
-> MySQL
-> export SQL
Query multi-table or single-table SQL:
The following figure: Select 3 right-click tables: