Footprints Data Model

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

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Configuration Allowed Value Id The automatically generated primary key of the cfg_allow_val table. LONG Yes
Configuration Value List Id A Foreign Key to the Configuration Value List table. LONG Yes
Configuration Allowed Value Description A descriptive name of the Configuration Allowed Value. This descriptive name may be localized. VARCHAR(512) No
Value Type Code The data type for a Value Type Code. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. CHAR(1) Yes
String Value The value of a Configuration Allowed Value, stored as a string. VARCHAR(255) No
Text Value The value of a Configuration Allowed Value, stored as a long text object. TEXT No
Date Value The value of a Configuration Allowed Value, stored as a date. DATE No
Real Value The value of a Configuration Allowed Value stored as real. DECIMAL(,) No
Int Value The value of a Configuration Allowed Value stored as boolean. INTEGER No
Long Value The value of a Configuration Allowed Value stored as Long. LONG No
Boolean The value of a Configuration Allowed Value stored as boolean. BOOLEAN Yes