Chapter 12 Generating Other Models from a PDM

Generating CDM objects

When you generate a Conceptual Data Model (CDM) from a PDM, PowerDesigner translates physical objects to conceptual objects as follows:

Object in a PDM Generated object in a CDM
Table Entity
Table column Entity attribute
Primary key Primary identifier
Alternate key Identifier
Reference Relationship

Oracle 8 and Interbase sequence translation

When a CDM is generated from a PDM, the data type of a table column attached to a sequence is translated to a serial data type in the new model.

The resulting CDM serial data type for an entity property has the format NO%n , where %n is a number indicating the length of the data type.

For more information on sequences, see sections on Oracle and Interbase in chapter DBMS-specific Features.

 

Copyright (C) 2007. Sybase Inc. All rights reserved.