Footprints Data Model

Table
Name cfg_allow_val
Comment A Configuration Allowed Value represents a member of a list of possible values.

Column
Name Datatype Comment Is PK Is FK
cfg_allow_val_id bigint The automatically generated primary key of the cfg_allow_val table. Yes No
cfg_val_list_id bigint A Foreign Key to the Configuration Value List table. No Yes
cfg_allow_val_descr varchar(512)
A descriptive name of the Configuration Allowed Value.  This descriptive name
may be localized.
No No
val_type_cd char(1)
The data type for a Value Type Code.  The choices are 'S' string, 'D' date, 'T'
text, 'I' integer.
No Yes
string_val varchar(255) The value if type String. No No
text_val varchar(max) The value of a Configuration Allowed Value, stored as a long text object. No No
date_val datetime The value of a Configuration Allowed Value, stored as a date. No No
real_val numeric(38,20) The value of a Configuration Allowed Value stored as real. No No
int_val int The value of a Configuration Allowed Value stored as boolean. No No
long_val bigint The value of a Configuration Allowed Value stored as Long. No No
boolean bit The value of a Configuration Allowed Value stored as boolean. No No