Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ATTRVALDESC
This table holds the language sensitive attribute value description.
Column Name Column Type Description ATTRVAL_ID BIGINT NOT NULL The reference number to an attribute value in the ATTRVAL table. LANGUAGE_ID INTEGER NOT NULL The language for this attribute value description. ATTR_ID BIGINT NOT NULL The reference number to the attribute in the ATTR table. VALUE VARCHAR(254) The string representation of the attribute value VALUSAGE INTEGER 1 - 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). SEQUENCE DOUBLE A number that determines the display order of a list of allowable attribute values for a given attribute. STRINGVALUE VARCHAR(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. INTEGERVALUE INTEGER If 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. FLOATVALUE DOUBLE If 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_ID CHAR(16) The units in which this attribute is measured. IMAGE1 VARCHAR(254) The path of the first image of this attribute value. IMAGE2 VARCHAR(254) The path of the second image of this attribute value. FIELD1 INTEGER Customizable field FIELD2 VARCHAR(254) Customizable field FIELD3 VARCHAR(254) Customizable field OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type SQL100520030300410 ATTRVAL_ID+LANGUAGE_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3562 ATTR_ID LANGUAGE_ID ATTRDESC ATTR_ID Cascade F_3560 ATTRVAL_ID ATTRVAL ATTRVAL_ID Cascade F_3561 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade F_3563 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade _vcc_freeselect_bottom_