Footprints Data Model

Table
Name cfg_setting
Comment 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.

Column
Name Datatype Comment Is PK Is FK
cfg_setting_id bigint The automatically generated primary key of the cfg_setting table. Yes No
cfg_setting_const varchar(255) The name of the Configuration Setting. No No
dflt_setting_label varchar(255) The name of the Configuration Setting. No No
dflt_setting_descr varchar(255) 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. No No
cfg_ctgy_id bigint A Foreign Key to the Configuration Category table. No Yes
val_type_cd char(1) 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. No No
agent_only bit identifies a setting as agent use only. This prevents customer role, customer user profile usage of the property. No No
unique_user_only bit identifies a setting as unique user only so it does not get used in Roles or Agent Preference Templates. There are certain settings in that should not be shared across individuals, and there are also the direct properties of the former USERS table which will now be configuration settings so that they can be used in templates and user profiles such as the Customer Auto Add Profile. No No
cfg_val_list_id bigint A Foreign Key to the Configuration Value List table. No Yes
spec_class_name varchar(255) The value of a Configuration Setting, stored as a string. No No
cfg_list_type_name varchar(255) The name of the Configuration List Type. No Yes
cfg_is_val_mapped bit Indicates if Configuration Is Value Mapped. No No