Use wrwin to design databases

Generate document

Select the logical view and Click Tools> retorp template builder> retorp builder... The following page is displayed.

There are some default export templates in the normal status available templates. It seems that I have reinstalled them once, resulting in the loss of the templates. If there is a template, select the output format directly for the output type, run directly to get the template.

Click new to create a new template.

The picture under the first node g graphical selects to generate an image of the erimage. This is still very useful. Not everyone in the development will install Erwin on their computers, I often generate an image and place it on SVN. When the database changes, an update is generated to SVN. Meanwhile, the document is updated. Although the document is updated, the image is more intuitive, in addition, it is convenient for the team to put closely related tables together. You can right-click in the logical view to display the field type and the Data Type of the image.

The following two nodes are physically and logically related. To generate a data dictionary, select the column node in physical, double-click the column node, and select settion to set the name and format of the header.

Select the data columns required for the table in the property tree. Here I select the following, and click Finish.

What we want in the end is this.

Here, you can also click the column setting column name, reverse key-Attribute-Modify the header. Here, you must change the word to a Chinese font. Otherwise, Chinese characters may be garbled,

Click Generate document after completion. Of course, the generated document is not very compliant with the specifications we want, but at least a lot of words can be entered.

 

Set the comment of the physical view to be the same as that of the logical view.

Switch the model to physical mode,

Select model ---> domain dictionary. In the tab, switch to comment.

Enter: % attname

 

Did you find all the models have been commented out.

 

Export to database

Since I am remotely connected to the Oracle database, I have not found a method on Erwin to remotely connect to Oracle. It seems that I need to be local, I just run the SQL script on PLSQL.

Switch to physical, Click Tools-forward engineer-> schema genratian, and select the report content to export.

To export comments at the same time, select the other options node and select comments.

Basic http://wenku.baidu.com/view/bc11524ef7ec4afe04a1dfdd.html of some content