You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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

  1. 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

  1. 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.
  • No labels