Element Type Definition: ASSOCIATION

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	ASSOCIATION_END
Short Name	AEN
View Name	CI_ASSOCIATION_ENDS
Description	One "end" of an association between two or more entity objects,
	generic classes or interface classifiers

Sub-type of	SECONDARY_ACCESS_ELEMENT
Versioning:	Belongs to: ASSOCIATION versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	ASSOCIATION_REFERENCE SEQUENCE NAME
Used by:	JDeveloper Enterprise Edition
Underlying table:	SDD_AEN

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
ENTITY_OBJECT_REFERENCE	N	Prompt: Entity Object	Must be a role in one and only one ENTITY_OBJECT	108
GENERIC_CLASS_REFERENCE	N	Prompt: Generic Class	Must be a role in one and only one GENERIC_CLASS	108
INTERFACE_CLASSIFIER_REFERENCE	N	Prompt: Interface	Must be a role in one and only one INTERFACE_CLASSIFIER	108
ASSOCIATION_REFERENCE	N	Prompt: Association Transferable only if null	Must be within one and only one ASSOCIATION
CLASSIFIER_REFERENCE	Y	Prompt: Collection Type	May be a collection defined by one and only one CLASSIFIER
UNIQUENESS_RULE_REFERENCE	Y	Prompt: Uniqueness Rule	May be joined using one and only one UNIQUENESS_RULE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
AGGREGATION	VARCHAR2(6)	N	When placed on a target end, specifies whether the target end is an aggregation with respect to the source end and, if so, whether the aggregation is strong or weak Prompt: Aggregation Uppercase	AGGREGATION	NONE
ASSOCIATION_ROLE_IN	VARCHAR2(3)	N	Arc 108 discriminator. Internal property indicating the type of classifier than this association end is a role in Not displayed Uppercase System maintained Not updatable by user	ASSOCIATION_ROLE_IN
CHANGE_RESTRICTION	VARCHAR2(8)	N	When placed on a target end, specifies whether an instance of the association may be modified from the source end and, if so, what restrictions apply Prompt: Change Restriction Uppercase	CHANGE_RESTRICTION	NONE
COR_DEPTH_LEVEL	NUMBER(12, 0)	Y	Complex object retrieval depth level Not displayed
DB_COLLECTION_AS_REFS_FLAG	VARCHAR2(1)	N	Indicates whether the collection is to be a collection of REFs Not displayed Uppercase	YESNO	N
DEFAULT_COLUMN_NAME	VARCHAR2(30)	Y	Default name to use for database column, in the absence of an explicit mapping to the server model, if this association end is to be transformed to a column Prompt: Column Name
DEFAULT_DB_COLLECTION_NAME	VARCHAR2(30)	Y	Default name to use for the database collection, in the absence of an explicit mapping to the server model, if this association end is to be transformed to a collection Not displayed
DEFAULT_DB_COLLECTION_TYPE	VARCHAR2(12)	Y	Type of collection that DEFAULT_COLLECTION_NAME (if specified) represents Not displayed Uppercase	ORACLE_COLLECTION_TYPE
GENERATE_CLASS_MEMBER_FLAG	VARCHAR2(1)	N	Indicates whether a class member for this association end is to be generated, if it belongs to a classifier for which a class is to be generated. Dfaulted by the API to be the same as on the owning classifer Prompt: Generate Class Member ? Uppercase System maintained: API provides a value only if left null by the user	YESNO
MAXIMUM_MULTIPLICITY	VARCHAR2(10)	N	Maximum number of objects (ie instances) possible at this end of the association for each object at the other end, a value of ''implies no upper limit. (Value of 1 indicates a "one" end, '' or a value > 1 indicates a "many" end) Prompt: Maximum Multiplicity		*
MINIMUM_MULTIPLICITY	NUMBER(10, 0)	N	Minimum number of objects (ie instances) possible at this end of the association for each object at the other end. A value of 0 indicates this end of the association is optional, a value of 1 or more indicates it is mandatory Prompt: Minimum Multiplicity		0
NAME	VARCHAR2(100)	Y	The role name of the association end Prompt: Role Name
NAVIGATION_TARGET_FLAG	VARCHAR2(1)	N	When placed on a target end, specifies whether traversal from a source instance to its associated target instances is possible Prompt: Is Navigation Target Uppercase	YESNO	Y
ORDERED_FLAG	VARCHAR2(1)	N	When placed on a target end, specifies whether the set of links from the source instance to the target instance is ordered Prompt: Is Ordered Uppercase	YESNO	N
PERSISTENT_FLAG	VARCHAR2(1)	N	When association end is a role in an ENTITY_OBJECT that is to be made persistent, indicates whether this association end is to be made persistent. Defaulted by the API to be the same as on the ENTITY_OBJECT in which it is a role Prompt: Is Persistent Uppercase System maintained: API provides a value only if left null by the user	YESNO
SCOPE	VARCHAR2(8)	N	Scope of this association end Prompt: Scope Uppercase	MEMBER_SCOPE	INSTANCE
SEQUENCE	NUMBER(6, 0)	N	Sequence for use by the transformers, indicating the position of this association end amongst other association ends for the same classifier Prompt: Sequence in Classifier System maintained: API provides a value only if left null by the user
SERIALIZABLE_FLAG	VARCHAR2(1)	N	Indicates, in Java, whether the association end is part of the persistent state of the object and will be serialized with the object Prompt: Is Serializable Uppercase	YESNO	N
SORT_ORDER_DIRECTION	VARCHAR2(1)	Y	When association end is used for ordering (ie SORT_ORDER_SEQUENCE is set), this property shows whether direction is ascending or descending. Equivalent to COLUMN.SORTING_ORDER at design level. (C++ specific) Prompt: Sort Direction Uppercase	SORTING_ORDER
SORT_ORDER_SEQUENCE	NUMBER(6, 0)	Y	If populated, indicates association end used to determine ordering. Equivalent to COLUMN.ORDER_SEQUENCE at design level. (C++ specific) Prompt: Sort Sequence
STORE_REF_WITH_ROWID_FLAG	VARCHAR2(1)	N	Indicates whether the ROWID is to be stored with the REF Not displayed Uppercase	YESNO	Y
VISIBILITY	VARCHAR2(10)	N	Visibility of this association end Prompt: Visibility Uppercase	VISIBILITY	PACKAGE
VOLATILE_FLAG	VARCHAR2(1)	N	Indicates, in Java, whether the association end may be accessed by unsynchronized threads and so certain code optimizations must not be performed on it Prompt: Is Volatile Uppercase	YESNO	N
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
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 ASSOCIATION_END:

Each JOIN_COMPONENT must be in the context of one and only one ASSOCIATION_END
Each ASSOCIATION_END_USAGE must be a usage of one and only one ASSOCIATION_END
Each ASSOC_DERIVATION_COMPONENT must be a part of one and only one ASSOCIATION_END
Each ASSOC_DERIVATION_COMPONENT must be a use of one and only one ASSOCIATION_END
Each ROLE_QUALIFICATION must be for qualification of one and only one ASSOCIATION_END
Each ROLE_SPECIFICATION must be of one and only one ASSOCIATION_END
Each CONTEXT_MAPPING may be a mapping from one and only one ASSOCIATION_END (in arc)
Each DATA_COMPONENT must be a use of one and only one ASSOCIATION_END (in arc)
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 MAPPING_ELEMENT must be sourced from one and only one CIELEMENT (in arc)
Each MAPPING_ELEMENT must be targeted to one and only one CIELEMENT (in arc)
Each MEMBER_COMPONENT must be a use of one and only one ASSOCIATION_END (in arc)
Each SUBSCRIPTION_DETAIL may be scoped by one and only one ASSOCIATION_END
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