| # Entity Type Relationship Details (tgerm3100s000) Use this session to display and maintain the entity relationship details. Related topics Entity Relationship Modeling Data Entity Relationship A reason of relevance for associating entities of one or two entity types. Version A group of model items that share some characteristics, such as the customer, owner, and effective date. Description The description or name of the version. From Entity Type The first entity type in the entity 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. fnnt.desc The description or name of the entity type. To Entity Type The second entity type in the entity 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 line is the second 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 used to identify 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. Expired If this check box is selected, the entity-type relationship has expired as the version it is in is no longer valid. 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-type relationship is between entity types that have tables from the ERP data dictionary linked to them. Associative Table An entity type that is used to link two other entity types that have a many-to-many relationship between them. table.desc The description or name of the associative table. Relationship Category A division within a system of classification. Most model items can be categorized. Description The description or name of the category. Min Cardinality From - To A specification of the number of possible entities per entity type of a pairing. Infinite If this check box is selected, the maximum from-to relationship is infinite. Max Cardinality From - To Min Cardinality To - From A specification of the number of possible entities per entity type of a pairing. Infinite If this check box is selected, the maximum to-from relationship is infinite. Max Cardinality To - From no help available Owner The login of the owner. user.name 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. Text If this check box is selected, text is available that provides you with further information about the entity relationship. Date The date when the latest change was made to the entity-type relationship. Time The time when the latest change was made to the entity-type relationship. User The login of the user who made the latest change to the entity-type relationship. User The name of the user who made the latest change to the entity-type relationship. |