Tips of some PD

How to ImplementNameAndCodeNot automatically equal

How to ImplementCDMCreateEntity,NameAndCodeNot automatically matched

 

SetTools -- gerneral
Options ---> dialog ----> name to code refreshing ing

 

 

How to generate test data?

 

1. UseTest data profilesDefine data generation rules,

2. InColumnsMedium orTableInColumnDefinitionTest DataTree BehaviorTest data profilesDefinition name,

3.Database-> Generate Test DataYou can generate data based on the set generation principles and columns.

 

 

I used'T_' +System name+ '_' +Rules for identifying names, whilePowerdesignerInFKUse: 'Fk _ '+ 7Bit table name1 + '_ relations _' + 7Bit table name2There will be many duplicate names. Where can I modify the naming rules?

 

InPDToSQL ServerFor example, the name of a foreign key is:Fk_table_2_reference_table_1

 

SelectDatabase-> Edit current DBMS

SelectScripts-"Objects-"Reference-"Constname

You can findValueIs:FK _ %. u8: child % _ %. U9: refr % _ %. u8: parent %

It can be seen that the naming method is:'Fk _ '+ 8Table Name+ 9BitReferenceName+ 8Parent table name. You can customize it according to the mode:FK _ %. u7: child % _ relations _ %. u7: parent %Which enablesFKName changedFk_table_2_relations_table_1

 

After mastering this method, you can modify it according to your own ideas. Note that it is best to back up the original script before modification.

 

CDMLiCodeWhy can't I name it again?

EntityA, AttributeID(Code)For the primary identity, why is the attributeBCannot haveIDAttribute?

Right-clickCDMIn the left-side Navigation Pane, select "model options ".(Model Options)",

Set the "identifier"(Unique
Code)"Uncheck this option,

In this way, you can create two primary keys with the same name,

If tables in one package need to be linked to tables in another package,How to do

Copy first, and thenPaste
Shortcut