Create a MySQL database table diagram using PowerDesigner

Use PowerDesigner to build a database table.

have been very busy, no time to write things. It's going to be a little bit loud this time, hey.

This skill is an essential skill for project managers.

The protagonist of this time:

1. establish a project under the workspace:

Of the physical data model type

Select mysql5.0 at the DBMS

2. Create a table UML diagram:

Select the Table tool on the toolbar to create a table.

Then double-click on him and you can modify it.

Rename word for user_power user table, set up three fields,ID primary key:

Create a table:address_power Address Table

3. Now assume that the user and address one by one in the business logic correspond, then the ID of the address is determined by the user's ID :

Select a reference in the toolbar to establish an association relationship for two tables:

Here you need to change the association settings based on the business logic:

OK, this table design is complete.

4. Establish a connection to the database.

On the menu bar, there is a database selection:

Choose Connect ... After the Popup Settings dialog box:

In Data source, select the Third radio button, Connection profile: Then click Configure. The following window will pop up:

Select Add Data Source in the upper-left corner to bring up the following window:

And then started to set up, basic press to set, the first is the name, random take, the second is to save the location of the configuration file, put the work space on the line; The third is a description, no tube; the fourth is the connection type; The fifth is the database type; sixth seventh is off; eighth Nineth is the username password; the last three Some connection configurations for MySQL, note that the last JDBC driver jar files need to be selected to the MySQL jar package.

Then click on the test Connection in the lower left corner to close the page by clicking OK. After returning to the Connect page, select the configuration file and then connect:

5. Create a database table:

Select database on the menu bar and then have a drop-down option called:Generate Database, select the following page to pop up:

Lets you choose where to place the generated SQL files. Here we use the direct generation option to create a table directly. In the Second tab options you can select options to change the SQL statement, and the final SQL statement can be viewed through the last tab preview:

Click OK to start generating the SQL script, and then pop up the following page:

When you click Run, the table is created successfully.

Create a MySQL database table diagram using PowerDesigner