Predefined entities are entities that are commonly used in a diagram and can be reused. Some categories have their own predefined entities specified. For a Star schema model, the entity 'dim_date' has been defined. This enables you to easily add date dimensions in a design.
Predefined entities can be configured. New predefined entities can be added, edited and deleted using this settings screen.
REPLACE WITH THIS IMAGE: Images/Settings/Entity Predefined Entity.png
Icons |
Descriptions |
---|---|
REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png |
Click Add to Create predefined entity . Refer to Create or Edit predefined entity for details. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png |
Click to Edit the selected predefined entity. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.png |
Click to Delete the selected predefined entity. |
Creating or Editing a Predefined Entity
- Click REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png to create a predefined entity or select a predefined entity and click REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png to edit it.
REPLACE WITH THIS IMAGE: Images/Settings/Entity Predefined Entity_1.png
- Complete the following:
Fields
Description
Name
The name of the predefined entity.
Comment
A comment on the entity.
Entity types
Select an entity type from the drop-down list.
Attributes
REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png
Click to Add an attribute.
REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.png
Click to Delete the selected attribute.
REPLACE WITH THIS IMAGE: Images/Common_Icons/up.png
Click to move the selected attribute a level up.
REPLACE WITH THIS IMAGE: Images/Common_Icons/down.png
Click to move the selected attribute a level down.
Name
Enter name of the attribute.
Datatype
Enter the attribute's datatype.
Datatype size
Enter the datatype's size parameter.
Datatype scale
Enter the datatype's scale parameter.
Unique
Select the checkbox so the attributes's values must be unique.
Nullable
Select the checkbox so the attribute may contain null values.
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.
Comment
A comment on the attribute.
Attribute Types
Select an attribute type from the drop-down list.