You can change attribute properties in the Properties view
for entities or attributes in a logical data model.
Procedure
To change attribute properties:
- Select the attribute to be changed in the entity on the
diagram to access the Properties view for the attribute or select
the entity that includes the attribute to be changed and then select
the attribute under the Attributes tab in the Properties view for
the entity.
- Then complete one of the following options:
- In the Properties view for the attribute, you can change the
following properties:
Option |
Description |
General tab |
You can edit the name or label. You can also specify whether
the attribute is Persistent. When you specify
that an attribute is persistent, the attribute is carried over to
the physical data model when you transform from the logical data model
to the physical data model. Non-persistent attributes are not transformed
into columns in the target physical data model.
|
Type tab |
You can edit the data type, length/precision, scale, default
value, and select primary key, required, or surrogate key. |
Documentation tab |
You can provide documentation. |
Annotation tab |
You can add or delete properties and edit their values. |
- In the Properties view for the entity, use the Attributes tab to change the following properties of
the attributes:
- Add or delete attributes
- Move attributes up or down in the list
- Rename attributes
- Select primary or surrogate keys
- Select data types
- Edit length or precision
- Specify scale
- Specify default values