ATTRVALUE
This table holds the values assigned to product attributes and relates them back to catalog entries for SKU resolution.
Column Descriptions:
Name Type Description ATTRVALUE_ID BIGINT NOT NULL The unique identifier for this attribute value. LANGUAGE_ID INTEGER NOT NULL The Identifier of the language. For a list of language components, see the LANGUAGE table. ATTRIBUTE_ID BIGINT NOT NULL The reference number of the attribute to which this attribute value applies. ATTRTYPE_ID CHAR (16) NOT NULL The type of the attribute value. Valid types are STRING, INTEGER and FLOAT. STRINGVALUE CHAR (254) 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. OPERATOR_ID INTEGER Reserved for IBM internal use. SEQUENCE DOUBLE NOT NULL DEFAULT 0 A sequence number that determines the display order of attribute values for a given attribute. 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. CATENTRY_ID BIGINT NOT NULL The unique identifier of the catalog entry assigned this attribute value. The CATENTRY_ID is set to 0 for allowed values of an attribute. NAME VARCHAR (254) The name is the string representation of the value for this attribute value. FIELD1 INTEGER Customizable. 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. FIELD2 VARCHAR (254) Customizable. FIELD3 VARCHAR (254) Customizable. OID VARCHAR (64) Reserved for IBM internal use. QTYUNIT_ID CHAR (16) The units in which this attribute value is measured. ATTACHMENT_ID BIGINT The reference number of an attachment that is associated with the attribute value. 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> ATTRVALUE_ID+LANGUAGE_ID Primary Key I0000020 ATTRIBUTE_ID+CATENTRY_ID+LANGUAGE_ID+NAME Unique Index I0000021 ATTRIBUTE_ID+CATENTRY_ID+STRINGVALUE+LANGUAGE_ID+INTEGERVALUE+FLOATVALUE Unique Index I0000453 CATENTRY_ID Non-Unique Index I0001235 ATTACHMENT_ID Non-Unique Index I0001236 ATTRIBUTE_ID+LANGUAGE_ID Non-Unique Index I194153 ATTRTYPE_ID+CATENTRY_ID+LANGUAGE_ID+SEQUENCE Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_1016 ATTACHMENT_ID ATTACHMENT ATTACHMENT_ID Cascade F_1017 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade F_72 OPERATOR_ID OPERATOR OPERATOR_ID Cascade F_73 ATTRTYPE_ID ATTRTYPE ATTRTYPE_ID Cascade F_74 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_75 ATTRIBUTE_ID+LANGUAGE_ID ATTRIBUTE ATTRIBUTE_ID+LANGUAGE_ID Cascade F_76 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Referenced By Child Tables:
Constraint Columns Child Table Child Columns Type F_593 ATTRVALUE_ID+LANGUAGE_ID PKGATTRVAL ATTRVALUE_ID+LANGUAGE_ID Cascade
Related reference
Attribute data model
Package data model