Element Type Definition: ENTITY_OBJECT

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	ENTITY_OBJECT_ATTRIBUTE
Short Name	EAT
View Name	CI_ENTITY_OBJECT_ATTRIBUTES
Description	An attribute, or property, of an entity object

Sub-type of	CLASSIFIER_ATTRIBUTE
Versioning:	Belongs to: ENTITY_OBJECT versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	ENTITY_OBJECT_REFERENCE NAME
Used by:	JDeveloper Enterprise Edition
Underlying table:	SDD_CAT

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
ENTITY_OBJECT_REFERENCE	N	Prompt: Entity Object Transferable only if null	Must be defined in one and only one ENTITY_OBJECT
CLASSIFIER_REFERENCE	Y	Prompt: Classifier Datatype Defined on CAT supertype	May be of datatype of one and only one CLASSIFIER

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
CHANGE_RESTRICTION	VARCHAR2(8)	N	Indicates whether the value may be modified after the object is created and, if so, what restrictions apply Prompt: Change Restriction Uppercase Defined on CAT supertype	CHANGE_RESTRICTION	NONE
CLASSIFIER_ATTRIBUTE_SUBTYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal property indicating whether the attribute is an entity object attribute (EAT) or a general attribute (GAT) Not displayed Uppercase System maintained Not updatable by user Defined on CAT supertype	CLASSIFIER_ATTRIBUTE_SUBTYPE
DATATYPE_FORMAT	VARCHAR2(10)	N	Internal property acting as "logical arc discriminator" between SCALAR_DATATYPE and CLASSIFIER_REFERENCE, indicating which is populated. These are both optional, but one or other MUST be specified Not displayed Uppercase System maintained Not updatable by user Defined on CAT supertype	DATATYPE_FORMAT
DB_COLLECTION_AS_REFS_FLAG	VARCHAR2(1)	N	For an attribute to be transformed to a column whose datatype is a collection, indicates whether that collection is a collection of REFs Prompt: Collection As REFs Uppercase	YESNO	N
DECIMAL_PLACES	NUMBER(4, 0)	Y	For numeric datatypes, specifies the number of decimal places allowed for this attribute Prompt: Decimal Places Defined on CAT supertype
DEFAULT_COLUMN_DATATYPE	VARCHAR2(16)	Y	Default datatype to use for the database column, in the absence of an explicit mapping to the server model Prompt: Column Datatype Uppercase	DEFAULT_COLUMN_DATATYPE
DEFAULT_COLUMN_NAME	VARCHAR2(30)	Y	Default name to use for database column, in the absence of an explicit mapping to the server model Prompt: Column Name Uppercase
DEFAULT_DB_COLLECTION_NAME	VARCHAR2(30)	Y	Default name to use for database collection, in the absence of an explicit mapping to the server model Prompt: Collection Name
DEFAULT_VALUE	VARCHAR2(2000)	Y	Default value for the attribute. If the attribute is an array, the default values are held as a comma separated list Prompt: Default Value Defined on CAT supertype
DISPLAY_FLAG	VARCHAR2(1)	N	Indicates whether the attribute is normally displayed Prompt: Is Displayed Uppercase	YESNO	Y
GENERATE_CLASS_MEMBER_FLAG	VARCHAR2(1)	N	Indicates whether a class member for this attribute is to be generated. This property is defaulted by the API to be the same as on the owning entity object Prompt: Generate Class Member ? Uppercase System maintained: API provides a value only if left null by the user	YESNO
JDBC_TYPE	VARCHAR2(13)	N	The jdbc datatype to be used for this attribute on the middle tier Prompt: JDBC Datatype Uppercase	JDBC_TYPE	VARCHAR
MAXIMUM_LENGTH	NUMBER(5, 0)	Y	Maximum length of data that this attribute can contain Prompt: Maximum Length Defined on CAT supertype
MAXIMUM_MULTIPLICITY	VARCHAR2(10)	N	*Maximum multiplicity of the attribute. A value of 1 indicates a single attribute, whereas a value > 1 or '' indicates an array** Prompt: Maximum Multiplicity Defined on CAT supertype		1
MINIMUM_MULTIPLICITY	NUMBER(10, 0)	N	Minimum multiplicity of the attribute. A value of 0 indicates the attribute is optional, 1 (or more) that it is mandatory Prompt: Minimum Multiplicity Defined on CAT supertype		0
MODIFICATION_FLAG	VARCHAR2(1)	N	Indicates whether attribute maps to a column that is used to identify modification (eg NUMBER_OF_TIMES_MODIFIED). Only one attribute of an entity object can have this flag set Prompt: Indicates Modification ? Uppercase	YESNO	N
NAME	VARCHAR2(100)	N	Name of the attribute Prompt: Name Defined on CAT supertype
PERSISTENT_FLAG	VARCHAR2(1)	N	Indicates whether attribute of persisent entity object to be persistent. Defaulted by API to be same as on owning entity object. If attribute has domain datatype then equivalent property on domain determines whether attribute persistent Prompt: Is Persistent Uppercase System maintained: API provides a value only if left null by the user	YESNO
PROMPT	VARCHAR2(132)	Y	Prompt to be used when displaying this attribute Prompt: Prompt Defined on CAT supertype
PSEUDOCOLUMN_FLAG	VARCHAR2(1)	N	Indicates whether attribute represents a pseudocolumn (eg ROWID), for which no DDL would be generated but which could appear in a select list Prompt: Is Pseudocolumn Uppercase	YESNO	N
RETRIEVABLE_FLAG	VARCHAR2(1)	N	Indicates whether user is allowed to access the values stored in this attribute. If the attribute has a datatype of a domain then the equivalent property on the domain determines whether the attribute is queryable Prompt: Is Retrievable Uppercase Defined on CAT supertype	YESNO	Y
SCALAR_DATATYPE	VARCHAR2(15)	Y	Scalar datatype of the attribute, where datatype not defined as a classifier Prompt: Scalar Datatype Defined on CAT supertype	SCALAR_DATATYPE
SEQUENCE	NUMBER(6, 0)	N	Sequence for use by the transformers, indicating the position of this attribute among other attributes for the same classifier Prompt: Sequence in Classifier System maintained: API provides a value only if left null by the user Defined on CAT supertype
SERIALIZABLE_FLAG	VARCHAR2(1)	N	Indicates, in Java, whether the attribute is part of the persistent state of the object and will be serialized with the object Prompt: Is Serializable Uppercase Defined on CAT supertype	YESNO	N
SORT_ORDER_DIRECTION	VARCHAR2(1)	Y	When attribute is used for ordering (ie SORT_ORDER_SEQUENCE is specified), this property shows whether direction is ascending or descending. Equivalent to COLUMN.SORTING_ORDER at design level Prompt: Sort Direction Uppercase	SORTING_ORDER
SORT_ORDER_SEQUENCE	NUMBER(6, 0)	Y	If populated, indicates attribute used to determine ordering. Equivalent to COLUMN.ORDER_SEQUENCE at design level Prompt: Sort Sequence
STATIC_FLAG	VARCHAR2(1)	N	Indicates whether the attribute is a "class attribute", ie at the class level with only a single value for all instances Prompt: Is Static Uppercase Defined on CAT supertype	YESNO	N
UPDATABLE_FLAG	VARCHAR2(1)	N	Indicates whether the user is allowed to update the values stored in this attribute. If the attribute has a datatype of a domain then the equivalent property on the domain determines whether the attribute is updatable Prompt: Is Updatable Uppercase Defined on CAT supertype	YESNO	Y
VISIBILITY	VARCHAR2(10)	N	Visibility of the attribute Prompt: Visibility Uppercase Defined on CAT supertype	VISIBILITY	PRIVATE
VOLATILE_FLAG	VARCHAR2(1)	N	Indicates, in Java, whether the attribute may be accessed by unsynchronized threads and so certain code optimizations must not be performed on it Prompt: Is Volatile Uppercase Defined on CAT supertype	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 Defined on CAT supertype	Description
NOTES	CDINOT Defined on CAT supertype	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_ATTRIBUTE:

Each ATTRIBUTE_DERIVATION_RULE must be applied to one and only one CLASSIFIER_ATTRIBUTE
Each JOIN_COMPONENT must be for joining from one and only one ENTITY_OBJECT_ATTRIBUTE
Each JOIN_COMPONENT must be for joining to one and only one ENTITY_OBJECT_ATTRIBUTE
Each ROLE_QUALIFICATION must be for qualification by one and only one ENTITY_OBJECT_ATTRIBUTE (in arc)
Each BC4J_EVENT_ATT_MAPPING must be a mapping to one and only one ENTITY_OBJECT_ATTRIBUTE
Each CONTEXT_MAPPING may be a mapping from one and only one CLASSIFIER_ATTRIBUTE (in arc)
Each CONTEXT_MAPPING must be a mapping to one and only one CLASSIFIER_ATTRIBUTE (in arc)
Each CROSS_OBJ_RULE_IMPLEMENT must be applied to one and only one CLASSIFIER_ATTRIBUTE
Each DATA_COMPONENT must be a use of one and only one CLASSIFIER_ATTRIBUTE (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 INTEGRITY_RULE may be applied to one and only one CLASSIFIER_ATTRIBUTE
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 CLASSIFIER_ATTRIBUTE (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 bound to one and only one ENTITY_OBJECT_ATTRIBUTE
Each WORKFLOW_ATTRIBUTE may be based on one and only one CLASSIFIER_ATTRIBUTE

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