Footprints Data Model

Table
Table Name Dynamic Column Specification
Table Definition The list of column specifications for the Dynamic Table Specification. A column will be added or modified to align with the column specification.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Dynamic Column Specification Id The automatically generated primary key of the dyn_col_spec table. LONG Yes
Column Name The name of the Dynamic Column Specification. VARCHAR(255) No
Default String Value The value of a database default. Not used. VARCHAR(255) No
Default Int Value The value of a database default. Not used. INTEGER No
Default Long Value The value of a database default. Not used. LONG No
Default Date Value The value of a database default. Not used. DATE No
Dynamic Table Specification Id A Foreign Key to the Dynamic Table Specification table. LONG No
Logical Data Type Id A Foreign Key to the Logical Data Type table. INTEGER No
Reference Id The value of a Dynamic Column Specification stored as Long. LONG No
Is Journal Indicates if this column supports the journaling storage feature. BOOLEAN Yes