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