This table holds the values assigned to product Attributes and relates them back to CatalogEntries for SKU resolution.
Column Name | Column Type | Column Description |
---|---|---|
ATTACHMENT_ID | BIGINT NULL |
The reference number of an attachment that is associated with the attribute value. |
ATTRIBUTE_ID | BIGINT NOT NULL |
The reference number of the attribute to which this attribute value applies. |
ATTRTYPE_ID | CHARACTER (16) NOT NULL |
The type of the attribute value. Valid types are STRING, INTEGER and FLOAT. |
ATTRVALUE_ID | BIGINT NOT NULL |
The internal reference number of this Attribute Value. |
CATENTRY_ID | BIGINT NOT NULL |
Reserved for IBM internal use. |
FIELD1 | INTEGER NULL |
Customizable. |
FIELD2 | VARCHAR (254) NULL |
Customizable. |
FIELD3 | VARCHAR (254) NULL |
Customizable. |
FLOATVALUE | DOUBLE NULL |
Reserved for IBM internal use. |
IMAGE1 | VARCHAR (254) NULL |
The image path of this Attribute Value. |
IMAGE2 | VARCHAR (254) NULL |
The image path of this Attribute Value. |
INTEGERVALUE | INTEGER NULL |
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. |
LANGUAGE_ID | INTEGER NOT NULL |
The Identifier of the language. For a list of language components, see the LANGUAGE table. |
NAME | VARCHAR (254) NULL |
The name given to this Attribute Value. |
OID | VARCHAR (64) NULL |
Reserved for IBM internal use. |
OPERATOR_ID | INTEGER NULL |
Reserved for IBM internal use. |
QTYUNIT_ID | CHARACTER (16) NULL |
The units in which this attribute value is measured. |
SEQUENCE | DOUBLE NOT NULL, DEFAULT 0 |
A sequence number that determines the display order of Attribute Values for a given Attribute. |
STRINGVALUE | CHARACTER (254) NULL |
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. |
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 |
I194153 | ATTRTYPE_ID, CATENTRY_ID, LANGUAGE_ID, SEQUENCE | Non-Unique Index |
SQL030416034838620 | ATTRVALUE_ID, LANGUAGE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint 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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_593 | ATTRVALUE_ID+LANGUAGE_ID | PKGATTRVAL | ATTRVALUE_ID+LANGUAGE_ID | Cascade |