Using Navicat to reverse build MySQL data Model--efficient memory data logical relationship

Clevercode recently familiar with the company's old business, this need to know the system table and the relationship between the table, when the number of tables is relatively large, you will find it difficult to remember the association between tables, as well as the relationship between the data. Especially time is long, more easy to forget. Here Clevercode recommends a way, very effective to comb the data of the model and the relationship--navicat.

1 navicat Download

http://download.csdn.net/detail/clevercode/9566110

2 Building a data model model new model


3 adding table elements to a model 3.1 drag the Add table to select a table in a database and drag it directly into the model panel. The default is only the name of the table, there is no library name, for easy lookup, it is recommended to right-click Rename plus the library name. As in Chapter 3.3.

3.2 New Add Table Select Table Icon function, click panel

3.3 Edit Table element 1 Select the table element in the model panel and right-click. Or, in the list bar on the left, select Table 1 and right-click Edit.

4 Notes and tags
1 NEW: Select the note icon, and then click Model Panel 2 to turn the note into a label: Select the note in the Panel, right-click the "Style" tab. 3 Modify the font color: can be manipulated in the lower left side panel.

5 Relationship 1 NEW: Select the relationship icon to drag one field from one table to the field in another table.

6 Export to Png,pdf,svg format file "PNG"



7 Save Model Click the Save button

8 View Model Save path Select Test1 model, right click, object information can see the file format for NDM format


9 open and share to a friend open: Find the location of the file, you can double-click to open the share with Navicat: The TEST1.NDM can be copied to a friend, friends directly open with NAVICAT can see the data model

Using Navicat to reverse build MySQL data Model--efficient memory data logical relationship