This table holds the values assigned to product Attributes and relates them back to CatalogEntries for SKU resolution.
Column Description(s):
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 |
Reserved for IBM internal use. |
CATENTRY_ID |
BIGINT NOT NULL |
The unique identifier of the catalog entry ID 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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000020 |
ATTRIBUTE_ID+CATENTRY_ID+LANGUAGE_ID+NAME |
Unique Index |
I0000021 |
ATTRIBUTE_ID+CATENTRY_ID+STRINGVALUE+LANGUAGE_ID+INTEGERVALUE+FLOATVALUE |
Unique Index |
SQL050212031159260 |
ATTRVALUE_ID+LANGUAGE_ID |
Primary Key |
I0000453 |
CATENTRY_ID |
Non-Unique Index |
I194153 |
ATTRTYPE_ID+CATENTRY_ID+LANGUAGE_ID+SEQUENCE |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1016 |
ATTACHMENT_ID |
ATTACHMENT |
ATTACHMENT_ID |
Cascade |
F_75 |
ATTRIBUTE_ID LANGUAGE_ID |
ATTRIBUTE |
ATTRIBUTE_ID |
Cascade |
F_73 |
ATTRTYPE_ID |
ATTRTYPE |
ATTRTYPE_ID |
Cascade |
F_74 |
CATENTRY_ID |
CATENTRY |
CATENTRY_ID |
Cascade |
F_76 |
LANGUAGE_ID |
LANGUAGE |
LANGUAGE_ID |
Cascade |
F_72 |
OPERATOR_ID |
OPERATOR |
OPERATOR_ID |
Cascade |
F_1017 |
QTYUNIT_ID |
QTYUNIT |
QTYUNIT_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_593 |
ATTRVALUE_ID LANGUAGE_ID |
PKGATTRVAL |
ATTRVALUE_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.