PowerDesigner provides default model checks to verify the validity of packages.
Check |
Description and Correction |
---|---|
Circular references |
[PDM only] A circular reference occurs when a table refers to another table, and so on until a loop is created between tables. A package cannot contain circular references. Manual correction: Resolve the circular reference by correcting the reference, deleting its source, or clearing the Mandatory parent or Check on commit option Automatic correction: None |
Constraint name uniqueness |
[PDM only] A constraint name is a unique identifier for the constraint definition of tables, columns, primary and foreign keys in the database. You define the constraint name in the following tabs: Check tab of the table property sheet Additional Check tab of the column property sheet General tab of the key property sheet A constraint name must be unique in a model. Manual correction: Modify the duplicated constraint name in the corresponding tab Automatic correction: Modifies the duplicated constraint name of a selected object by appending a number to its current name |
Constraint name maximum length |
[PDM only] The constraint name length cannot be longer than the length specified in the DBMS definition: either in the MaxConstLen entry, in the Object category, or in each object category. Manual correction: Modify the constraint name to meet this requirement Automatic correction: Truncates the constraint name to the maximum length specified in the DBMS definition |
Circular dependencies |
[PDM only] Extended dependencies with the stereotype <<DBCreateAfter>> can be used between stored procedures to define a generation order for stored procedures. An extended dependency with the stereotype <<DBCreateAfter>> should not introduce a circular dependency in the model. Manual correction: Remove the <<DBCreateAfter>> extended dependency Automatic correction: None |
Circular dependency |
[CDM/LDM only] A circular dependency occurs when an entity depends on another and so on until a dependency loop is created between entities. A package cannot contain circular dependencies. Manual correction: Clear the Dependent check box for the link or delete an inheritance link. Automatic correction: None. |
Circularity with mandatory links |
[CDM/LDM only] A circular dependency occurs when an entity depends on another and so on until a dependency loop is created between entities through mandatory links. Manual correction: Clear the Mandatory parent check box or delete a dependency on a relationship. Automatic correction: None. |
Shortcut code uniqueness |
Shortcuts codes must be unique in a namespace. Manual correction: Change the code of one of the shortcuts Automatic correction: None |
Shortcut potentially generated as child table of a reference |
[CDM/LDM only] The package should not contain associations or relationships with an external shortcut as child entity. Although this can be tolerated in the CDM, the association or relationship will not be generated in a PDM if the external shortcut is generated as a shortcut. Manual correction: Modify the design of your model in order to create the association or relationship in the package where the child entity is defined. Automatic correction: None. |