Footprints Data Model

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

Column
Name Datatype Comment Is PK Is FK
dyn_col_spec_id bigint The automatically generated primary key of the dyn_col_spec table. Yes No
dflt_string_val varchar(255)
The value of a database default.  Not used.
No No
dflt_int_val int
The value of a database default.  Not used.
No No
dflt_date_val datetime
The value of a database default.  Not used.
No No
dyn_table_spec_id bigint A Foreign Key to the Dynamic Table Specification table. No Yes
col_name varchar(255) The name of the Dynamic Column Specification. No No
logical_data_type_id int A Foreign Key to the Logical Data Type table. No Yes
dflt_long_val bigint
The value of a database default.  Not used.
No No
reference_id bigint The value of a Dynamic Column Specification stored as Long. No No
is_journal bit Indicates if this column supports the journaling storage feature. No No