Entity Type Relationships (tgerm1140s000)

Use this session to maintain the entity-type relationship details.

Field Information

Entity Rel. Diagram

entity-relationship diagram

Description

The description or name of the entity-relationship diagram.

Note: The maximum length of the description is 60 characters.
Version

version

Description

The description or name of the version.

Data Entity Relationship

entity-type relationship

From Entity Type

The first entity type in the entity-type relationship.

Example

The entity relationship between an order and an order line is a 1:N relationship. An order is related to one or more order lines. Vice versa, an order line is related to only one order. In this entity relationship the order is the first entity type.

From Entity Type

The description or name of the entity type.

To Entity Type

The second entity type in the entity-type relationship.

Example

The entity-type relationship between an order and an order line is a 1:N relationship. An order has one or more order lines. Vice versa, an order line is related to only one order. In this entity-type relationship the order line is the second entity type.

To Entity Type

The description or name of the entity type.

Description From - To

The description that identifies the from-to relationship. The description must be a verb in the third person singular.

Example

An order is detailed by one or more order lines. For this relationship the From-To description is: is detailed by.

  • if the relationship is a horizontal line with the name located above, then the diagram should be read from left to right. If the name is located underneath, then the diagram should be read from right to left.
  • if the relationship is a vertical line with the name located on the left, then the diagram should be read from top to bottom. If the name is on the right, then the diagram is read from the bottom up.
Description To - From

The description that identifies the to-from relationship. The description must be a verb in the third person singular.

Example

An order line details an order. For this relationship, the To-From description is: details.

  • if the relationship is a horizontal line with the name located above, then the diagram should be read from left to right. If the name is located underneath, the diagram should be read from right to left.
  • if the relationship is a vertical line with the name located on the left, then the diagram should be read from top to bottom. If the name is on the right, then the diagram is read from the bottom up.
Relationship is Subtype

If this check box is selected, the entity-type relationship is a subtype relationship.

Physical Database Relation exists

If this check box is selected, the entity relationship is equal to an ERP data dictionary relationship.

Associative Table

associative entity type

Associative Table

The description or name of the associative entity type.

Relationship Category

category

Description

The description or name of the category.

Min Cardinality From - To

Infinite

If this check box is selected, the maximum from-to relationship is infinite.

Max Cardinality From - To

Min Cardinality To - From

Infinite

If this check box is selected, the maximum to-from relationship is infinite.

Max Cardinality To - From

Owner

The login of the owner.

Owner

The name of the owner.

Generation Date

BY default, the date when the entity relationship was generated. However, any authorized user can change the date into another date.

Expired

If this check box is selected, the entity relationship has expired because the version it is in is no longer valid.

User Last Change

The login of the user who made the latest change to the entity-type relationship.

User Last Change

The name of the user who made the latest change to the entity-type relationship.

Last Change

The date when the latest change was made to the entity-type relationship.

Text

If this check box is selected, text is available that provides you with more information about the entity-type relationship.