Footprints Data Model

Table
Name dyn_table_index_col
Comment The collection of index column specifications for an index.

Column
Name Datatype Comment Is PK Is FK
dyn_col_spec_id bigint A Foreign Key to the Dynamic Column Specification table. Yes Yes
dyn_table_index_id bigint A Foreign Key to the Dynamic Table Index table. Yes Yes
dyn_col_pos int The value of a Dynamic Table Index Column stored as boolean. No No