Element Type Definition: JOIN

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	JOIN_COMPONENT
Short Name	AENEAT
View Name	CI_JOIN_COMPONENTS
Description	Identification of an entity object attribute as implementing an
	association. It is specific to BC4J (which models both the
	association and these "foreign key" attributes, and so needs the
	capability to tie them together) and the transformers

Sub-type of	INTERSECTION
Versioning:	Belongs to: ASSOCIATION versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	ASSOCIATION_END_REFERENCE EO_ATTRIBUTE_FROM_REFERENCE
Used by:	JDeveloper Enterprise Edition
Underlying table:	SDD_AENEAT

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
ASSOCIATION_END_REFERENCE	N	Prompt: Association End Transferable only if null	Must be in the context of one and only one ASSOCIATION_END
EO_ATTRIBUTE_FROM_REFERENCE	N	Prompt: Entity Object Attribute (From) Transferable only if null	Must be for joining from one and only one ENTITY_OBJECT_ATTRIBUTE
EO_ATTRIBUTE_TO_REFERENCE	N	Prompt: Entity Object Attribute (To) Transferable only if null	Must be for joining to one and only one ENTITY_OBJECT_ATTRIBUTE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
SEQUENCE	NUMBER(6, 0)	N	Sequence of the join within the association end Prompt: Sequence in Association End System maintained: API provides a value only if left null by the user
PARENT_IVID	NUMBER(38, 0)	Y	Internal use only. Common repository version identifier of owning PAC Not displayed System maintained Updatable only if null Defined on SE supertype
PAC_REFERENCE	NUMBER(38, 0)	Y	Internal use only. Contains the IRID of the PAC for the "versionable object" to which this element belongs Not displayed System maintained Not updatable by user Defined on SE supertype

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC	Description
NOTES	CDINOT	Notes

Other Properties
The following 'standard' properties are also inherited by all element types: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference JOIN_COMPONENT:

Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each ELEMENT_RULE_USAGE must be applicable to one and only one CIELEMENT (in arc)
Each TAGGED_VALUE must be in the context of one and only one CIELEMENT (in arc)
Each UML_DEPENDENCY_CLIENT must be identifying as client one and only one CIELEMENT (in arc)
Each UML_DEPENDENCY_SUPPLIER must be identifying as supplier one and only one CIELEMENT (in arc)

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype