Footprints Data Model |
Table |
Name | dyn_table_index |
Comment |
A physical database index associated with a dynamically generated table. Different DBMS can have different number and types of these indexes. An index specification will be generated to the database. |
Column |
Name | Datatype | Comment | Is PK | Is FK |
dyn_table_index_id | bigint | The automatically generated primary key of the dyn_table_index table. | Yes | No |
dyn_table_spec_id | bigint | A Foreign Key to the Dynamic Table Specification table. | No | Yes |
index_name | varchar(30) | The name of the Dynamic Table Index. | No | No |
index_type_id | bigint |
The unique identifier for an instance of Index Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. |
No | Yes |