PowerDesigner Mysql primary Key auto increment, initial value, character set

Self-increment

Double-click on the key you want to set as the self-increment (like your id), pop Up a Column Properties dialog box, have a identify selection box in the lower right corner, and check it OK. Check out the preview and you'll be able to see auto_increment.

Starting value

The default self-increment field starts at 1, and if you need to set an initial value, switch to "physical Options" with the following interface:

Character sets and engines

Original address: http://jooben.blog.51cto.com/253727/309467

General modeling may be used: PowerDesigner
But, on the table, I didn't find it:
DEFAULT CHARACTER SET, COLLATE
Two of options. So, think of a way, click: Toolbar-"database-" Edit current DBMS
Then, select: Mysql50::script\objects\table\options
Add at the end of the options:
ENGINE =%s:list = BDB | HEAP | ISAM | InnoDB | MERGE | Mrg_myisam | MYISAM, default = MYISAM
DEFAULT CHARACTER SET =%s:list = UTF8 | GBK, default = UTF8
COLLATE =%s:list = Utf8_bin | Utf8_general_ci | Gbk_bin | Gbk_chinese_ci, default = Utf8_bin
First: Storage engine
Second: Character set
Third: With bin is case-sensitive, CI does not differentiate
Click OK to save, go back to the workspace, double click on a table, in:
Physicial options, you can see the option you just added so that you can do it your way.

PowerDesigner Mysql primary Key auto increment, initial value, character set