ATTRVALDESC
Language sensitive attribute value description.
Column Descriptions:
Name 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 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. 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 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> ATTRVAL_ID+LANGUAGE_ID Primary Key I0001468 LANGUAGE_ID Non-Unique Index I0001469 ATTR_ID Non-Unique Index I0001470 QTYUNIT_ID Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_3560 ATTRVAL_ID ATTRVAL ATTRVAL_ID Cascade F_3561 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade F_3562 ATTR_ID+LANGUAGE_ID ATTRDESC ATTR_ID+LANGUAGE_ID Cascade F_3563 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade