Footprints Data Model

Table
Table Name Configuration Setting Value
Table Definition Configuration Setting Value is an association between the Configuration Setting entity and a container entity (i.e. User Profile, Role, and Definition). This association contains a distinct value for each of the intersection points between the two entities.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Configuration Setting Value Id The automatically generated primary key of the cfg_setting_val table. LONG Yes
Configuration Setting Id A Foreign Key to the Configuration Setting table. LONG Yes
Owner Id A Foreign Key to the Owning instance in either the Definition, Definition Version , Role, or User Profile tables. LONG Yes
Value Type Code The data type for a Configuration Setting Value. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. CHAR(1) Yes
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) Yes
String Value The value of a Configuration Setting Value, stored as a string. VARCHAR(255) No
Text Value The value of a Configuration Setting Value, stored as a long text object. TEXT No
Date Value The value of a Configuration Setting Value, stored as a date. DATE No
Real Value The value of a Configuration Setting Value stored as a real. DECIMAL(,) No
Int Value The value of a Configuration Setting Value stored as Int. INTEGER No
Long Value The value of a Configuration Setting Value stored as Long. LONG No
Boolean Value The value of a Configuration Setting Value stored as Boolean. BOOLEAN No
Application Role Id A Foreign Key to the Application Role table. LONG No
Value Map Key The value of a Configuration Setting Value, stored as a string. VARCHAR(255) No