Generating Other Models from a CDM

You can generate CDM objects to other model objects.

CDM	OOM	PDM
Entity	Class	Table
Entity attribute	Attribute	Table column
Primary identifier	-	Primary or foreign key depending on independent or dependent relationship
Identifier	-	Alternate key
Association	Relationship or association	-
Binary association with attributes	Association class	-
Inheritance	Generalization	-
Relationship	-	Reference

Persistent Entities (OOM)

All entities are generated as persistent classes with the "Generate table" persistence mode.

When the Generate check box of an entity is not selected, the generated class has the "Migrate columns" persistence mode.

Note:

Two columns in the same table cannot have the same name. If column names conflict due to foreign key migration, PowerDesigner automatically renames the migrated columns. The new name is composed of the first three letters of the original entity name followed by the code of the attribute.

Generating PDM Table Keys from CDM Entity Identifiers
The type of key that is generated in the PDM depends on the cardinality and type of dependency defined for a relationship in the CDM. Primary identifiers generate primary and foreign keys. Other identifiers that are not primary identifiers generate alternate keys:
Generating Tables from Entities with Inheritance Links
Two properties influence the generation of tables from entities with inheritance links.

Parent topic: Generating Other Models from a Data Model