Footprints Data Model

Table
Table Name Configuration Setting
Table Definition A configuration variable that can be identified in programming code and which has an atomic value that affects the behavior of the application. Configuration values are either scalars, or are supported by value lists that also can be programmatically identified. They have localized labels and value choices, and are categorized to support organization and separation in programming namespaces and configuration screens. They support the concept of Built-In Values, Default Values, and Customized Values. Configuration should be supported by an Audit Trail, and should be able to determine if configuration has changed by level, category, and for the individual value in order to support cacheing. A configuration value has a definition to identify its usage, and a enum that identifies if a change will require a restart and what level of restart is required if the value changes. If a restart is required, both the currently running value and the value after restart should be accessible. This means that historical values of the Configuration Settings should be accessible.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Configuration Setting Id The automatically generated primary key of the cfg_setting table. LONG Yes
Configuration Setting Constant The constant name of the Configuration Setting Constant, which can be aligned with an enumeration or other compile time constant value for access in Java. VARCHAR(255) No
Default Setting Label The name of the Configuration Setting. VARCHAR(255) No
Default Setting Description The description of the purpose and usage of the configuration setting. This description serves for documentation, and will be used to help develop UI strings for the Label, ToolTip, Helptext etc. of the UI for the configuration setting. VARCHAR(255) No
Configuration Category Id A Foreign Key to the Configuration Category table. LONG Yes
Configuration Value List Id A Foreign Key to the Configuration Value List table. LONG No
Agent Only Indicates if Agent Only. BOOLEAN No
Unique User Only Indicates if Unique User Only. BOOLEAN No
Value Type Code The data type for a Configuration Setting. The choices are 'S' string, 'D' date, 'T' text, 'L' Long, 'R' real, and 'A' for any type. CHAR(1) Yes
Configuration List Type Name The unique string identifier for an instance of Configuration List 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
Specification Class Name The value of a Configuration Setting, stored as a string. VARCHAR(255) No
Configuration Is Value Mapped Indicates if Configuration Is Value Mapped. BOOLEAN No