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

To introduce an online ER model generation tool, you can generate ER model charts online for a variety of database DDL files, supporting MySQL, SQLServer, Oracle, PostgreSQL and other databases.

The main functions are as follows:

Table creation is supported, and table structure, field type, primary key, default value, index, remarks, etc., can be edited according to the type of database. Views, triggers, sequence, stored procedures, and functions can be viewed and edited to generate SQL synchronously for users to access addresses:

Database ER model diagram.

Function description:

Chart: you can set up the ER model, select a model file to edit, save and other databases: provide the function shape of importing and viewing all SQL to the database DDL: view the corresponding icons of database tables, views, triggers, stored procedures, etc., drag and drop to the editing area format: after clicking, you can arrange, style, adjust the position, color, etc.

Adjust the display scale of the editing area to fit the appropriate size

How to make ER model diagram: 1. Import DDL

First, visit https://www.freedgo.com/erd_index.html, to select the corresponding database, click menu Database-> SQLServer-> Import DDL

Copy the SQL language into the corresponding box, or drag the SQLServer DDL file to the corresponding input box and click insert SQLServer

2. Newly added table

Select the shape and drag the corresponding database table to the edit area

3. Add new columns

Add the table field online. Click the arrow where you need to add the field to add it.

After adding a field, right-click-> modify the field to modify the property value of the field. Field name, type, length, primary key, foreign key, remarks, empty and so on are supported.

4. View table SQL

Select the table and right-click to display the table structure:

5. View the field SQL

Select a column, and then right-click to view the new column SQL and modify column SQL

6. Add view

Select the shape and drag the corresponding database view to the edit area

Similar to views for triggers, stored procedures, and function operations

Problem feedback

In the process of use, you can feedback the effect in time, please click the question feedback button

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.