Chapter 5 Customizing the PDM Environment


Reference display preferences

To set display preferences for dimensions, select Tools→Display Preferences, and select the Reference sub-category in the left-hand Category pane.

Preference Description
Name Displays the name or code of the reference*
Constraint name Displays the referential integrity constraint name
Join Displays the statement of linked columns between the two tables
Referential integrity Displays the update and delete referential integrity constraints as follows:

  • upd() - Update
  • del() - Delete
  • cpa - Change Parent Allowed


A letter between the parentheses indicates the type of constraint, as follows:

  • ( ) - None
  • (R) - Restrict
  • (C) - Cascade
  • (N) - Set null
  • (D) - Set default


The referential integrity label shown below indicates the following:

  • Cascade on update
  • Set null on delete
  • Cardinality is
    0..n
    (any number of children is acceptable).

Stereotype Displays the stereotypes of references
Role names Displays the role names for parent and child tables of references
Cardinality Displays the minimum and maximum number of instances in a child table that can appear for each corresponding instance in the parent table.

The default cardinality labels for PowerDesigner indicate the minimum and maximum number of children as follows:

[minimum..maximum]

For example, the cardinality label
[0..n]
indicates that any number of children is acceptable.
Implementation Displays the implementation mode of referential integrity, declarative or by triggers

*Displayed text depends on whether the Name or Code radio button is selected.

Reference display mode

For information about changing the notation of references, see Setting Model Settings.

Note   Moving text on a reference symbol
When a reference symbol displays text, the text position is based on the position of handles. You can add a handle on the reference symbol by pressing ctrl while you click the symbol.

 


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