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 |