ATTRVALDESC

This table holds the language sensitive attribute value description.

Column Descriptions:

NameTypeDescription
ATTRVAL_IDBIGINT NOT NULLThe reference number to an attribute value in the ATTRVAL table.
LANGUAGE_IDINTEGER NOT NULLThe language for this attribute value description.
ATTR_IDBIGINT NOT NULLThe reference number to the attribute in the ATTR table.
VALUEVARCHAR (254)The truncated version of STRINGVALUE, used for searching purposes only. For example, if STRINGVALUE contains more than 254 characters, VALUE stores the first 254 characters. Otherwise, if STRINGVALUE contains less than 254 characters, VALUE stores the entire value of STRINGVALUE.
VALUSAGEINTEGER1 - Predefined allowed value. (For example, one of the allowed values of Color is Blue) null - Assigned attribute value. (For example Product's Length is 30. Length attribute does not have allowed values).
SEQUENCEDOUBLEA number that determines the display order of a list of allowable attribute values for a given attribute.
STRINGVALUEVARCHAR (2000)If this type of attribute value is STRING, then this column will hold the attribute value. If the type is not STRING, then this column will be NULL.
INTEGERVALUEINTEGERIf this type of attribute value is INTEGER, then this column will hold the attribute value. If the type is not INTEGER, then this column will be NULL.
FLOATVALUEDOUBLEIf this type of attribute value is FLOAT, then this column will hold the attribute value. If the type is not FLOAT, then this column will be NULL.
QTYUNIT_IDCHAR (16)The units in which this attribute is measured.
IMAGE1VARCHAR (254)The path of the first image of this attribute value.
IMAGE2VARCHAR (254)The path of the second image of this attribute value.
FIELD1INTEGERCustomizable field
FIELD2VARCHAR (254)Customizable field
FIELD3VARCHAR (254)Customizable field
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>ATTRVAL_ID+LANGUAGE_IDPrimary Key
I0001468LANGUAGE_IDNon-Unique Index
I0001469ATTR_IDNon-Unique Index
I0001470QTYUNIT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3560ATTRVAL_IDATTRVALATTRVAL_IDCascade
F_3561LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_3562ATTR_ID+LANGUAGE_IDATTRDESCATTR_ID+LANGUAGE_IDCascade
F_3563QTYUNIT_IDQTYUNITQTYUNIT_IDCascade