CFCONDVAL

Each row of this table represents the association between a condition and an attribute value.

Column Descriptions:

NameTypeDescription
CFCONDVAL_IDBIGINT NOT NULLGenerated primary key
CFCOND_IDBIGINT NOT NULLCondition ID. The condition group this value belongs to.
ATTRVAL_IDBIGINTAttribute Value ID. This column refers to the ATTRVAL_ID in table ATTRVAL under Attribute Dictionary and should only be used when the TYPE of the corresponding CFCOND record is 0.
LANGUAGE_IDINTEGERThe language of the value. Only used for attribute dictionary condition with assigned value.
STRINGVALUEVARCHAR (254)The String value of the attribute value
INTEGERVALUEINTEGERThe Integer value of the attribute value
FLOATVALUEDOUBLEThe float value of the attribute value
FIELD1BIGINTCustomizable
FIELD2INTEGERCustomizable
FIELD3VARCHAR (254)Customizable
FIELD4DECIMAL (20,5)Customizable
FIELD5DOUBLECustomizable
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CFCONDVAL_IDPrimary Key
I0001382CFCOND_IDNon-Unique Index
I0001383ATTRVAL_IDNon-Unique Index
I0001394LANGUAGE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3672ATTRVAL_IDATTRVALATTRVAL_IDCascade
F_3673CFCOND_IDCFCONDCFCOND_IDCascade
F_3685LANGUAGE_IDLANGUAGELANGUAGE_IDCascade