[PowerDesigner]
Very good database design Tools, used before, let’s summarize today.
PowerDesigner is a powerful software capable of database design. It is a database modeling tool commonly used by developers. It can design the database from two levels of conceptual data model and physical data model. In the modeling process, people can manage only the solution model, and can make full use of database technology to optimize the database design.
[Use]
1 .Create a workspace
2. Build a table
Add field
Design table fields and lengths, etc.
< br>
A database table is released.
3. Create a table Relationship between
As shown in the figure below: The distributor information table has two foreign keys, one from itself and one from another table. After the foreign key relationship is drawn, two foreign key fields will be automatically added to the table, and you can modify it according to your needs.
4. After all the tables are designed, as shown below:
5. Export sql statement script
First select the type of database script to be exported
At this time, powerdesigner will automatically check all tables for errors. The following figure is a warning, which proves that there is no error and can be exported.
Start exporting span>
Completed, the sql script already exists on the corresponding path at this time
