Page History
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:
| ||||||
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. |
...
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 to select a color. | |||||
Entity icon | Keep the existing icon or change to another icon. | |||||
Query template | Optionally, assign a template to the entity definition.
| |||||
DW query template | Optionally, assign a template to the entity definition.
| |||||
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. |
...
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.
Anchor | ||||
---|---|---|---|---|
|
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.
| |||||
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. |
Anchor | ||||
---|---|---|---|---|
|
Fields | Description | |||||
---|---|---|---|---|---|---|
Robot name | Index robot's name. | |||||
Index name | The name of the index.
| |||||
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 to add index attribute. You can select one of the following options from the Select index attribute dialog:
|
...