Meta_Index

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

Name	Value Domain	Description	Required / 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)

Link	To Entity	Description	Implementation Technique	Required
Entity	Meta_Entity	Foreign Key to Meta_Entity	Restrict	Yes