Icons | Descriptions |
|---|---|
| Click Add to Create new entity type. Complete the following on the Create a new entity type dialog to create a new entity type:
Note An entity type can only be added if the Restrict types check box is not selected on the Entity> General Settings window. |
| Click to Edit the selected entity type. |
| Click to make a Copy of the selected entity type. |
| Click to Delete the selected entity type. |
| Click to move the selected entity type a level up. |
| Click to move the selected entity type a level down. |
Note |
|---|
If you rename an entity type which is used in a model conversion, the Rename entity type dialog is displayed. Refer to Renaming entity types for details. |
Definition Tab
This tab enables you to define settings required for creating a new entity type.
The following definition fields are available:
Fields | Description |
|---|---|
Name | A name for the entity type |
Group | This field can be used to organize entity types. |
Description | A description of the entity type |
Color | Set the color assigned to an entity, which are used to aid identification in the diagram. Click |
Entity icon | Keep the existing icon or change to another icon. |
Query template | Optionally, assign a template to the entity definition. Note The default template option retains the existing assigned template. |
DW query template | Optionally, assign a template to the entity definition. Note The default template option retains the existing assigned template. |
Behavior | Used to tag if entities of this type should have changes tracked. |
Characteristic | Select if this entity functions as a Terminal or Hub. |
Keywords | A list of keywords to be assigned to entities of this type |
Assign attribute types to pk | A list of attribute types that will be assigned to the primary key attribute(s) in entities of this type |
Prefix and Suffix | A custom prefix and/or suffix to be added to the entity, all attributes in the entity, all foreign keys to and from the entity, and/or all indexes on the entity. |
Automatic Generation Tab
This tab enables you to define attributes and indexes to be automatically created when this entity type is assigned through entity type robots. You can create a new robot by clicking 
or by clicking 
to copy from an existing entity type. Select Attribute or Index from the drop-down list to change whether the currently selected robot creates an attribute or an index.
Attribute Robots
Fields | Description |
|---|---|
Robot name | Attribute robot's name. |
Positioning | Enables you to define whether the attribute should be created above or below all existing attributes in the entity. Select one of the following options:
|
Attribute name | The name of the attribute. Tip The percentage sign % can be used to represent the entity name. |
Comment | A comment on the attribute. |
Data type | Enter the attribute's datatype. |
Data type size | Enter the datatype's size parameter. |
Data type scale | Enter the datatype's scale parameter. |
Character set | The attribute's character set. |
Default value | The default value for the attribute. |
Primary key | Select the checkbox so the attribute is contained in the primary key for the table. |
Auto increment | Select the checkbox so the attributes's value is automatically generated. |
Unique | Select the checkbox so the attributes's values must be unique. |
Nullable | Select the checkbox so the attribute may contain null values. |
Attribute types | Select an attribute type from the drop-down list. |
Index Robots
Fields | Description |
|---|---|
Robot name | Index robot's name. |
Index name | The name of the index. Tip The percentage sign % can be used to represent the entity name. |
Description | A short description of index robot. |
Index types | Select a type of index from the drop-down list. |
Indexed attributes | You can choose any of: primary key attributes, foreign key attributes, selected attributes being created by robots, or all attributes of particular types |
Attribute types | Click
Note
|