Element Type Definition: CLUSTER

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	CLUSTER_INDEX
Short Name	CIN
View Name	CI_CLUSTER_INDEXES
Description	Definition of a cluster index, used to access information in a
	specific cluster

Sub-type of	INDEX
Versioning:	Belongs to: CLUSTER versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	CLUSTER_REFERENCE NAME
Used by:	Oracle Designer
Underlying table:	SDD_IND
Changes:	Summary of changes to CLUSTER_INDEX in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
CLUSTER_REFERENCE	N	Prompt: Cluster Transferable only if null	Must be to optimise access to one and only one CLUSTER

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
COMPLETE_FLAG	VARCHAR2(1)	N	Indicates whether the definition of the index is complete and ready to be used by the generators Prompt: Complete ? Uppercase Defined on IND supertype	YESNO	Y
COMPUTE_STATISTICS_FLAG	VARCHAR2(1)	N	Indicates whether statistics are to be collected on creation of index Prompt: Compute Statistics ? Uppercase Defined on IND supertype	YESNO	N
INDEX_TYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal property indicating whether the INDEX is a CLUSTER_INDEX (CIN) or a RELATION_INDEX (RIN) Not displayed Uppercase System maintained Not updatable by user Defined on IND supertype	INDEX_TYPE
NAME	VARCHAR2(30)	N	The name of this index. Prompt: Name Uppercase Defined on IND supertype
REMARK	VARCHAR2(2000)	Y	A brief comment on why the index is created and how it is used. Prompt: Comment Defined on IND supertype
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 IND supertype	Description
NOTES	CDINOT Defined on IND supertype	Notes

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

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 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 USER_OBJECT_INDEX_STORAGE must be for the index implementing one and only one INDEX (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