Footprints Data Model

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

Column
Name Datatype Comment Is PK Is FK
cfg_setting_val_id bigint The automatically generated primary key of the cfg_setting_val table. Yes No
cfg_setting_owner_type_name varchar(255) The name of the Configuration Setting Owner Type. No Yes
cfg_setting_id bigint A Foreign Key to the Configuration Setting table. No Yes
owner_id bigint A Foreign Key to the Owning instance in either the Definition, Definition Version , Role, or User Profile tables. No Yes
val_type_cd char(1) The data type for a Configuration Setting Value. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. No No
string_val varchar(255) The value of a Configuration Setting Value, stored as a string. No No
text_val varchar(max) The value of a Configuration Setting Value, stored as a long text object. No No
date_val datetime The value of a Configuration Setting Value, stored as a date. No No
real_val numeric(38,20) The value of a Configuration Setting Value stored as a real. No No
int_val int The value of a Configuration Setting Value stored as Int. No No
long_val bigint The value of a Configuration Setting Value stored as Long. No No
boolean_val bit The value of a Configuration Setting Value stored as Boolean. No No
val_map_key varchar(255) The value of a Configuration Setting Value, stored as a string. No No