Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | INDEX_ENTRY |
| Short Name | INDCOL |
| View Name | CI_INDEX_ENTRIES |
| Description | A column used in an index |
| Sub-type of | OTHER_SE |
| Versioning: | Belongs to: SNAPSHOT_DEFINITION versionable object TABLE_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
RELATION_INDEX_REFERENCE COLUMN_REFERENCE CQA_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_INDCOL |
| Changes: | Summary of changes to INDEX_ENTRY in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| RELATION_INDEX_REFERENCE | N |
Prompt: Index
Transferable only if null |
Must be within one and only one RELATION_INDEX | |
| COLUMN_REFERENCE | Y |
Prompt: Column
Transferable only if null |
May be for one and only one COLUMN | 71 |
| CQA_REFERENCE | Y |
Not displayed
Transferable only if null |
May be for one and only one COLUMN_QUALIFIED_ATTRIBUTE | 71 |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| INDEX_ENTRY_FOR | VARCHAR2(15) | N | Arc 71 discriminator. Discriminator for the "logical arc" involving reference properties COLUMN_REFERENCE and CQA_REFERENCE plus the property INDEX_FUNCTION, since one of the 3 must be populated
Not displayed Uppercase System maintained Not updatable by user | INDEX_ENTRY_FOR | |
| INDEX_ENTRY_TYPE | VARCHAR2(13) | N | Indicates whether this index entry is column based or function based
Prompt: Type Uppercase | INDEX_ENTRY_TYPE | COLUMNBASED |
| INDEX_FUNCTION | VARCHAR2(2000) | Y | The function for a function based index
Prompt: Index Function | ||
| NAME | VARCHAR2(30) | N | The name of the index. Denormalisation.
Not displayed Uppercase System maintained Not updatable by user | ||
| SEQUENCE_NUMBER | NUMBER(6, 0) | N | The sequence of this column in the index.
Prompt: Usage Sequence System maintained: API provides a value only if left null by the user | ||
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Common repository version identifier of owning PAC
Not displayed System maintained Updatable only if null Defined on SE supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Contains the IRID of the PAC for the "versionable object" to which this element belongs
Not displayed System maintained Not updatable by user Defined on SE supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| Other Properties |
|---|
| INDEX_ENTRY 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:
|
Other element types that reference INDEX_ENTRY:
Note: