| Name | Meta_Index_Column |
|---|---|
| Entity Type | External |
| Description | The columns of an Index are described via the Meta_Index_Column table. |
| Submodel | Meta |
| Entity Scope | Meta |
| Primary Key | Entity , Index_Nr , Attribute |
| Natural Key | Entity , Index_Nr , Attribute |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Attribute |
|
Column that is indexed. | Yes |
VARCHAR2(30) | |
| Attribute_Nr |
|
NEEDS CHANGED TO Rank IN CONJUNCTION WITH BOTH GENs Attribute order within index. This is a different value than Attribute_Nr in other meta tables. At some point the name should be changed to Rank. Automatically populated by the meta-system. | Yes |
NUMBER(2) | |
| Descending |
|
Is this column of the Index Descending? 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. | Yes |
NUMBER(2) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Entity | Meta_Entity | Foreign Key to Meta_Entity | Restrict | Yes |