Chapter 4 Building Physical Diagrams


Reference properties

You can modify an object's properties from its property sheet. To open a reference property sheet, double-click its diagram symbol or its Browser entry in the References folder. The following sections detail the property sheet tabs that contain the properties most commonly entered for references.

The General tab contains the following properties:

Property Description
Name Specifies the name of the item, which should be clear and meaningful, and should convey the item's purpose to non-technical users
Code Specifies the technical name of the object, which is used for generating code or scripts, which may be abbreviated, and should not generally include spaces
Comment Specifies a descriptive label for the reference
Stereotype Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined
Parent table Specifies the parent table of the reference. This table contains the primary key, or alternate key, linked by the reference. You can use the tools to the right of the list to create an object, browse the complete tree of available objects or view the properties of the currently selected object
Parent role Specifies the role of the parent table in the reference. The text is displayed in the diagram, near the parent table
Child table Specifies the child table of the reference. This table contains the foreign key linked by the reference
Child role Specifies the role of the child table in the reference. The text is displayed in the diagram, near the child table
Generate When selected, indicates to generate the reference in the database

 


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