Using PowerDesigner to create a MySQL database table illustrated version

Use PowerDesigner Build database tables. 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 : Physical Data Model type of in the DBMS Select mysql5.0 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. change the name to User_power user table, set up three fields, ID PRIMARY Key: then 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 , the table design is complete. 4. Establish a connection to the database. On the menu bar, there is a Database Choice of: Select Connect ... After the Popup Settings dialog box: in the Data Source Select a third radio button, Connection Profile: , click Configure . The following window will pop up: Select the upper-left corner of the Add Data Source , the following window pops up: then start setting, basic press to set, first name, pick The second is to save the location of this configuration file, put it in the work space, the third is the 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 are the mysql Some connection configurations, note the last mysql jar package. then click on the lower left corner of the Test Connection , test pass after Point OK close this page. After returning to the connect page, select the configuration file and then connect: 5. Create a database table: on the menu bar, select Database , and then there is a drop-down option called: Generate Database , select the following page to pop up: lets you choose the generated SQL Where the files are placed. 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 last SQL statement can be passed through the last tab Preview to see: Click OK to start the build SQL script, and then pop up the following page: Click Run , the table is created successfully.

Using PowerDesigner to create a MySQL database table illustrated version