Powerdesign PDM model design and pdm<=> database SQL file

First, the PDM model design:

1, p is the primary key, M is non-null.

2. Link Association

3, reference foreign key

two . powerdesign configuration MySQL ODBC

1, official website: http://dev.mysql.com/downloads/connector/odbc/download ODBC driver installation;

2, Database---Configure Connections---ADD DataSource (Ctrl + N)--Configure connection Properties--OK.

three . PDM to SQL file:

1. Database-->chang Current DBMS---(Select a DB type)

2, Database -- -Generation Database ---Directory (select SQL Save directory)--Generation Type (scirpt genetation: Generate SQL file only; Direct generation: Build to database table)

Note: Import SQL into the MySQL method:

1) on the cmd command line: mysql- h 127.0.0.1-u root-p < F:/mytest/testdb.sql

2) Log in to MySQL: Execute source F:/mytest/testdb.sql command

Powerdesign PDM model design and pdm<=> database SQL file