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