Meta_Index


[Columns] [Composed Of] [Referenced By] [Refers To]

General Information

[Next]
Name Meta_Index
Entity Type External
Description Index, Primary Keys, and potentially Natural Keys are described using the Meta_Index table.
Submodel Meta
Entity Scope Meta
Primary Key Entity , Index_Nr
Natural Key Entity , Index_Nr
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
Auto
Was this index automatically generated by the meta-system? 1 => TRUE and 0 => FALSE. Automatically populated by the meta-system. No
NUMBER(1)
Bitmap
Is this a Bitmap index? 1 => TRUE and 0 => FALSE. No
NUMBER(1)
Entity Meta_Entity
Foreign Key to Meta_Entity Yes
VARCHAR2(25)
Index_Nr
Used to distinguish indices within entity. Non-Primary indicies begin with one for each entity. Primary keys are identified by zero. Yes
NUMBER(2)
Natural_Key
Is the index for a Natural Key? 1 => TRUE and 0 => FALSE. No
NUMBER(1)
Primary_Key
Is the index for a Primary Key? 1 => TRUE and 0 => FALSE. No
NUMBER(1)
Suppress
Should this index be suppressed? 1 => TRUE and 0 => FALSE. It is intended to inhibit index creation when it is the leading edge of another index. Automatically populated by the meta-system. Not currently exploited. No
NUMBER(1)
Unique_Key
Is the Index unique? 1 => TRUE and 0 => FALSE. No
NUMBER(1)


Refers To

[Previous] [Next] [Top]
LinkTo EntityDescriptionImplementation TechniqueRequired
Entity Meta_Entity Foreign Key to Meta_Entity Restrict Yes


[Seabed Objects] [Entities in Schema Seabed] [Index]

Copyright © 2018 Schlumberger. All rights reserved.