Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | RELATIONSHIP_END |
| Short Name | RELEND |
| View Name | CI_RELATIONSHIP_ENDS |
| Description | Details of one end of a relationship between two entities |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: ENTITY versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
FROM_ENTITY_REFERENCE NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_RELEND |
| Changes: | Summary of changes to RELATIONSHIP_END in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| FROM_ENTITY_REFERENCE | N | Prompt: Entity | Must be at one and only one ENTITY | |
| OTHER_RELATIONSHIP_END_REF | N |
Not displayed
System maintained Transferable only if null |
Must be the other end of one and only one RELATIONSHIP_END | |
| TO_ENTITY_REFERENCE | N |
Not displayed
System maintained Not transferable |
Must be to one and only one ENTITY | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ACCESS_CONTROL_FLAG | VARCHAR2(1) | Y | Indicates whether the whole relationship should be considered locked if the entity at this end of the relationship is locked
Not displayed Uppercase | YESNO | |
| ARC_NUMBER | NUMBER(6, 0) | Y | A number identifying the arc in which this relationship is included.
Prompt: In Arc Range: 1 to 999999 | ||
| ARC_REFERENCE | NUMBER(38, 0) | Y | Reference to identify an arc that the relationship end is in. It is not a foreign key.
Not displayed System maintained Not updatable by user | ||
| AVERAGE_VOLUME | NUMBER(9, 0) | Y | The average number of entities participating in the relationship.
Prompt: Average | ||
| MAXIMUM_CARDINALITY | NUMBER(10, 0) | Y | Maximum number of entities possible at the other end of the relationship for each entity at this end
Prompt: Maximum Cardinality Range: 1 to 9999999999 | ||
| MAXIMUM_VOLUME | NUMBER(9, 0) | Y | The maximum number of entities participating in the relationship.
Prompt: Maximum | ||
| MINIMUM_CARDINALITY | NUMBER(10, 0) | N | Minimum number of entities possible at the other end of the relationship for each entity at this end. A minimum cardinality of 1 or more therefore indicates this relationship end is mandatory, and 0 indicates it is optional.
Prompt: Minimum Cardinality Range: 0 to 9999999999 | 0 | |
| MINIMUM_VOLUME | NUMBER(9, 0) | Y | The minimum number of entities participating in the relationship.
Prompt: Minimum | ||
| NAME | VARCHAR2(60) | N | The name of this relationship e.g. PART OF, CLASSIFICATION FOR.
Prompt: Relationship Name | ||
| REMARK | VARCHAR2(240) | Y | A comment on this end of the relationship.
Not displayed | ||
| TRANSFER | VARCHAR2(1) | N | Indicates whether or not this end of the relationship can be transferred.
Prompt: Transferable ? Uppercase | YESNO | Y |
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs
Not displayed System maintained Updatable only if null Defined on SAC supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs
Not displayed System maintained Not updatable by user Defined on SAC supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
| RELATIONSHIP_END has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference RELATIONSHIP_END:
Note: