PowerDesigner creates a physical model

Using PowerDesigner Create PDM

1. Open PowerDesigner and press Ctrl + N to create the physical model.

2. Modify the name and create a Table in the toolbar.

3. Fill in the Name Code Comment Stereotype attribute

4. Fill in the Columns primary key and auto-Increment

 

5. Click OK. The effect is as follows:

6. Remember to save the data in time and save the model Ctrl + S. To avoid regret and repetitive work.

7. Next, create a data table for all the data. Each time you create a table, remember to save it.

8. Finally, establish the relationship between the table and the table, foreign keys and constraints.

9. Export the database script. Take the SQL Server2005 database as an example. For details, see.

10. After the export is successful, put the SQL script into the database for execution. The exported data is as follows.

11. Press Ctrl + F12 to generate a report, which is convenient for viewing field descriptions and other information.

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Finally, the SAVE path is selected.

12. Click to open the generated report.

 

Statement: This blog attaches great importance to the protection of intellectual property rights, found that the information published by this blog contains a link content infringing its copyright, please contact me, I will be the first time to do the corresponding processing, contact the mailbox ffgign@qq.com.

Author: Mark Fan Source: http://cube.cnblogs.com
Note: This statement must be retained without the consent of the author, and the original text connection is clearly provided on the article page. Otherwise, the legal liability will be retained. If you have any questions, you can contact the author via ffgign@qq.com, This article uses the Knowledge Sharing signature-non-commercial use-share the same way 2.5 mainland China License Agreement for license