CFCONDVAL

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

Column Descriptions:

Name	Type	Description
CFCONDVAL_ID	BIGINT NOT NULL	Generated primary key
CFCOND_ID	BIGINT NOT NULL	Condition ID. The condition group this value belongs to.
ATTRVAL_ID	BIGINT	Attribute 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_ID	INTEGER	The language of the value. Only used for attribute dictionary condition with assigned value.
STRINGVALUE	VARCHAR (254)	The String value of the attribute value
INTEGERVALUE	INTEGER	The Integer value of the attribute value
FLOATVALUE	DOUBLE	The float value of the attribute value
FIELD1	BIGINT	Customizable
FIELD2	INTEGER	Customizable
FIELD3	VARCHAR (254)	Customizable
FIELD4	DECIMAL (20,5)	Customizable
FIELD5	DOUBLE	Customizable
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CFCONDVAL_ID	Primary Key
I0001382	CFCOND_ID	Non-Unique Index
I0001383	ATTRVAL_ID	Non-Unique Index
I0001394	LANGUAGE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3672	ATTRVAL_ID	ATTRVAL	ATTRVAL_ID	Cascade
F_3673	CFCOND_ID	CFCOND	CFCOND_ID	Cascade
F_3685	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade