Database Table: ATTRVALUE

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.
Indexes:
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
Constraints:
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

Referenced By:
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