Footprints Data Model

Table
Table Name Default Configuration Setting Value
Table Definition  

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Default Configuration Setting Value Id The automatically generated primary key of the dflt_cfg_setting_val table. LONG Yes
Configuration Setting Id A Foreign Key to the Configuration Setting table. LONG No
Configuration Setting Owner Type Name The unique string identifier for an instance of Configuration Setting Owner Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. VARCHAR(255) No
Value Type Code The data type for a Value Type Code. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. CHAR(1) No
String Value The value of a Default Configuration Setting Value, stored as a string. VARCHAR(255) No
Text Value The value of a Default Configuration Setting Value, stored as a long text object. TEXT No
Date Value The value of a Default Configuration Setting Value, stored as a date. DATE No
Real Value The value of a Default Configuration Setting Value stored as real. DECIMAL(,) No
Int Value The value of a Default Configuration Setting Value stored as boolean. INTEGER No
Long Value The value of a Default Configuration Setting Value stored as Long. LONG No
Boolean Value The value of a Configuration Setting Value stored as boolean. BOOLEAN Yes
Value Map Key The value of a Default Configuration Setting Value, stored as a string. VARCHAR(255) No