Element Type Definition: ENTITY

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	ENTITY
Short Name	ENT
View Name	CI_ENTITIES
Description	The definition of a thing of significance to the business about which
	information needs to be known or held

Sub-type of	SHAREABLE_ELEMENT
Versioning:	Structure of ENTITY versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	NAME
Used by:	Oracle Designer
Underlying table:	SDD_ENT
Changes:	Summary of changes to ENTITY in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
SUPERTYPE_REFERENCE	Y	Prompt: Type Of	May be a subtype of one and only one ENTITY

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
ANNUAL_GROWTH_RATE	NUMBER(3, 0)	Y	The expected annual growth rate (percentage) for this entity. Prompt: Annual Growth Rate (%)
DATAWAREHOUSE_TYPE	VARCHAR2(10)	Y	Applicable in data warehouse applications only, classifying the entity as a fact or a dimension Prompt: Data Warehouse Type Uppercase	DATAWAREHOUSE_TYPE
INITIAL_VOLUME	NUMBER(38, 0)	Y	The initial number of occurrences for this entity. Prompt: Initial
INSTANTIABLE_FLAG	VARCHAR2(1)	N	Only exposed in the DDW interface and allows the user to control whether super-types are to be instantiated Not displayed Uppercase	YESNO	Y
MAXIMUM_VOLUME	NUMBER(38, 0)	Y	The maximum number of occurrences for this entity. Prompt: Maximum
NAME	VARCHAR2(40)	N	The full name of this entity. Prompt: Name Uppercase
PLURAL	VARCHAR2(40)	N	The plural form of this entity. Prompt: Plural Uppercase System maintained: API provides a value only if left null by the user
SHORT_NAME	VARCHAR2(10)	N	An abbreviation for this entity. Prompt: Short Name Uppercase System maintained: API provides a value only if left null by the user
VOLUME	NUMBER(38, 0)	Y	The average number of occurrences expected for this entity. Prompt: Average

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

Other Properties
ENTITY 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: 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:

Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each ATTRIBUTE must be of one and only one ENTITY
Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each ENTITY may be a subtype of one and only one ENTITY
Each ENTITY_BUSINESS_UNIT must be for one and only one ENTITY
Each EVENT may be initiated by one and only one ENTITY
Each EXTERNAL may be the representation of one and only one ENTITY
Each FUNCTION_ENTITY_USAGE must be effective on one and only one ENTITY
Each RELATIONSHIP_END must be at one and only one ENTITY
Each RELATIONSHIP_END must be to one and only one ENTITY
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each SYNONYM must be for one and only one ENTITY (in arc)
Each TABLE_ENTITY must be of one and only one ENTITY
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT
Each UNIQUE_IDENTIFIER must be for identification of one and only one ENTITY

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