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

Overview

The ER model uses to visualize the information stored by the entity, and intuitively presents the relationship between the entity and the entity. In the process of our actual application system development, 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, collaborative tool to create a variety of professional charts. Allows you to create online flowcharts, system deployment diagrams, software architecture diagrams, UML, BPMN, ER models, DFD, organization charts, software flowcharts, charts. Free trial. Using Freedgo Design to create a database ER model currently supports MySQL and basic SQL statements to build tables. Later will be functional expansion to support SQL Server, Oracle, PostgreSQL, Sybase, and other database model modeling, support SQL import to generate ER model, through DDL statements to generate ER model, ER model SQL export, according to the ER model to generate SQL.

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

Provide the following functions: create ER model online by visual tools and use MySQL DDL language to import and generate ER model online. Generate table SQL statements for table entities in ER model, support multi-table generation for fields of selected tables in ER model, add or modify SQL statements quickly and basically use:

If you want to use the MySQL table to model the ER, select MySQL Table as the entity type, and then drag to the editing area.

1. How to import SQL?

First, visit https://www.freedgo.com/draw_index.html, and click adjust Graphics-> insert-> From MySQL

Or +-> From MySQL

Copy the SQL language to the corresponding box and click insert MySQL

Copy the SQL and paste it into the corresponding input box

Finally, the corresponding model diagram is generated.

2. How to modify ER model fields

You can modify the table field information of the ER model

Field name, type, length, primary key, foreign key, remarks, empty or not are supported

Support MySQL table creation syntax CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name (col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT] [UNIQUE [KEY] | [PRIMARY] KEY] [COMMENT 'string'], [CONSTRAINT [symbol]] PRIMARY KEY [index_type] (index_col_name,...), KEY [index_name] [index_type] (index_col_name,...)) INDEX [index_name] [index_type] (index_col_name,...), [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (index_col_name,...), [CONSTRAINT [symbol]] FOREIGN KEY [index_name] (index_col_name,...) [reference_definition],) MySQL field type participates in TINYINT [(length)] [UNSIGNED] [ZEROFILL] | SMALLINT [(length)] [UNSIGNED] [ZEROFILL] | MEDIUMINT [(length)] [UNSIGNED] [ZEROFILL] | INT [(length)] [UNSIGNED] [ZEROFILL] | INTEGER [(length)] [UNSIGNED] [ZEROFILL] | BIGINT [(length)] [UNSIGNED] [ZEROFILL] | REAL [(length) Decimals)] [UNSIGNED] [ZEROFILL] | DOUBLE [(length,decimals)] [UNSIGNED] [ZEROFILL] | FLOAT [(length,decimals)] [UNSIGNED] [ZEROFILL] | DECIMAL (length,decimals) [UNSIGNED] [ZEROFILL] | NUMERIC (length) Decimals) [UNSIGNED] [ZEROFILL] | DATE | TIME | TIMESTAMP | DATETIME | CHAR (length) [BINARY | ASCII | UNICODE] | VARCHAR (length) [BINARY] | TINYBLOB | BLOB | MEDIUMBLOB | TINYTEXT [BINARY] | TEXT [BINARY] | MEDIUMTEXT [BINARY] | LONGTEXT [BINARY] | ENUM (value1,value2,value3,...) | SET (value1,value2,value3,...) | spatial_type3, how to export SQL

Generate SQL

4. How to generate table SQL

Select the table in the model, right-click and select SQL to support the generation of multiple-select tables:

Step 1:

Generate SQL

5. How to generate the field SQL

Select the table field in the model, right-click and select SQL to support the generation of multiple selection fields:

1. Create a new column SQL

2. Modify the table column SQL

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.