Previous Topic: Add an Attribute on the Diagram Window

Next Topic: Specify the Validation Rule and Default Value for an Attribute

Define General Properties for an Attribute

You can use the options in the General tab of the Attribute Editor to view and update the general information about an attribute.

To define general information for an attribute

  1. Right-click the attribute on the diagram that you want to define and click Attribute Properties.

    The Attribute Editor opens.

  2. Click the General tab and work with the following options.

    Note: Click New New icon in property editors to create a new object on the toolbar to create a new attribute.

    Name

    Displays the attribute name. You can change the attribute name in this field.

    Parent Domain

    Displays the parent domain associated with the attribute. You can change the parent domain or open the Domain Editor to create a new one using the drop-down.

    Logical Data Type

    Specifies the logical data type for the attribute. You can change the data type using the drop-down. The drop-down list contains the data types related to the current domain.

    Primary Key

    Specifies whether to include the attribute in the primary key. Select this check box if you want to include the selected attribute in the primary key. Clear this check box if you want the attribute to be a non-key attribute.

    Logical Only

    Specifies whether the attribute should only appear in the logical model. Select this check box if you want the selected attribute to appear in the logical model only. Clear this check box if you want the selected attribute to have a corresponding column in the physical model. If you are working with a logical-only model and select this check box, when you derive a new physical-only model, the selected attributes do not appear in the new model.

    Note: When you select or clear the check box in the Navigation Grid, your selection is automatically reflected in the Logical Only check box in the General tab.

    Domain

    Select a domain from the list to attach it to the selected attribute. When you attach a domain to an attribute, you are specifying the logical data type for the selected attribute. Standard domains include: Default, Blob, Datetime, Number, and String. This list can also include user-defined logical data types that you create in the Domain Editor. When you attach a domain to an attribute, the related column automatically inherits any physical model properties that you assign to the domain as well. For example, you can assign a Currency domain to an attribute, which can then optionally inherit its definition from that domain. The same domain, Currency, is attached to the corresponding column in the physical model, including the inherited domain characteristics such as data type and null option. The Domain option contains a toolbar that includes the following options:

    Attribute Editor General Tab_Domain Option_Sort Button

    Lets you specify to sort the list of domains alphabetically, in reverse alphabetical order, or by domain hierarchy.

    Attribute Editor General Tab_Domain Option_Restore Inheritance from Definition Button

    Restores inheritance from definition. If this attribute is a FK, the domain may be inherited or overridden to a different domain.

    Attribute Editor General Tab_Domain Option_Domain Editor Button

    Opens the Domain Editor in logical edit mode.

    Image

    Specifies the image that you want to use to represent the domain from the list.

    Logical Only

    Specifies whether the selected attribute appears in the logical model only. Select this check box if you want the attribute to appear in the logical model only. Clear this check box if you want the attribute to have a corresponding column in the physical model. If you are working with a logical-only model and select this check box, when you derive a new physical-only model, the selected attributes will not appear in the new model.

    Note: When you select or clear the check box in the General tab, your selection is automatically reflected in the Logical Only check box in the Navigation Grid.

    Name

    Displays the attribute name. You can change the attribute name directly in this field, or click the Expand button to open the Text Editor. You can also click the Inheritance button to either inherit, override, or harden the attribute's name. This button changes to provide you with a visual cue of the current inheritance setting for the attribute name.

    Logical Data Type

    Displays the attribute data type. You can change the data type using the drop-down control. You can also click the Inheritance button to either inherit, override, or harden the attribute's data type. This button changes to provide you with a visual cue of the current inheritance setting for the attribute data type.

    Null Option

    Displays the attribute null option. You can change the null option using the drop-down control. You can also click the Inheritance button to either inherit or override the attribute's null option. This button changes to provide you with a visual cue of the current inheritance setting for the attribute null option.

  3. Click Close.

    General information is defined for the attribute and the Attribute Editor closes.

More information:

Attributes

Rename an Attribute Using the Attribute Editor

The Text Editor