Element Type Definition: ENTITY_OBJECT

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	ENTITY_OBJECT_USAGE
Short Name	EOU
View Name	CI_ENTITY_OBJECT_USAGES
Description	The usage of an entity object within a view object

Sub-type of	SECONDARY_ACCESS_ELEMENT
Versioning:	Belongs to: VIEW_OBJECT versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	VIEW_OBJECT_REFERENCE NAME
Used by:	JDeveloper Enterprise Edition
Underlying table:	SDD_EOU

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
ENTITY_OBJECT_REFERENCE	N	Prompt: Entity Object Transferable only if null	Must be a usage of one and only one ENTITY_OBJECT
VIEW_OBJECT_REFERENCE	N	Prompt: View Object Transferable only if null	Must be a usage in one and only one VIEW_OBJECT

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
NAME	VARCHAR2(100)	N	Name of this entity object usage Prompt: Name
PRIMARY_FLAG	VARCHAR2(1)	N	Indicates whether this represents the starting entity object, for traversal of associations to build up the SQL statement for the view object Prompt: Is Primary Uppercase System maintained: API provides a value only if left null by the user	YESNO
REQUERY_FLAG	VARCHAR2(1)	N	Indicates whether the attributes in this entity object will be requeried when the element identified by the primary entity object usage is updated. (Corresponds to BC4J's REFERENCE_FLAG) Prompt: Is Requeried Uppercase	YESNO	N
SEQUENCE_NUMBER	NUMBER(6, 0)	N	Sequence of this entity object usage within others for the same view object Prompt: Sequence in View Object System maintained: API provides a value only if left null by the user
SQL_ALIAS	VARCHAR2(30)	N	Alias to be used in SQL queries Prompt: SQL Alias Uppercase
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 ENTITY_OBJECT_USAGE:

Each ASSOCIATION_END_USAGE must be a usage in one and only one ENTITY_OBJECT_USAGE
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)
Each VIEW_OBJECT_ATTRIBUTE may be defined from one and only one ENTITY_OBJECT_USAGE

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