This table holds the values assigned to product attributes and relates them back to catalog entries for SKU resolution.
Column Descriptions
| Column Name
| Column 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 that is assigned this attribute value.
|
| NAME
| VARCHAR(254)
| The name given to 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
| Reserved for IBM internal use.
|