Footprints Data Model

Table
Table Name Dynamic Table Index
Table Definition 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.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Dynamic Table Index Id The automatically generated primary key of the dyn_table_index table. LONG Yes
Index Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. VARCHAR(30) Yes
Dynamic Table Specification Id A Foreign Key to the Dynamic Table Specification table. LONG Yes
Index Type Id 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. LONG Yes