Chapter 3 Building Physical Diagrams
A key has the following properties:
| Property | Description |
|---|---|
| Name | The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users |
| Code | The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces |
| Comment | Descriptive comment for the key |
| Stereotype | Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined |
| Table | Name of the table where the key is defined |
| Constraint name | Name of the key constraint. PowerDesigner automatically creates a constraint name for a key, it is used during database creation and modification. You can modify the default name, you can also cancel these changes and go back to the default name |
| Primary key | Indicates if the key is the primary key of the current table. There must be only one primary key in a table, if you select the Primary Key check box in a key property sheet, it replaces an already existing primary key |
| Cluster | Indicates whether the key constraint is a clustered constraint (for those DBMS that support clustered indexes) |
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |