ATTRVALUE

This table holds the values assigned to product attributes and relates them back to catalog entries for SKU resolution.

Column Descriptions:

NameTypeDescription
ATTRVALUE_IDBIGINT NOT NULLThe unique identifier for this attribute value.
LANGUAGE_IDINTEGER NOT NULLThe Identifier of the language. For a list of language components, see the LANGUAGE table.
ATTRIBUTE_IDBIGINT NOT NULLThe reference number of the attribute to which this attribute value applies.
ATTRTYPE_IDCHAR (16) NOT NULLThe type of the attribute value. Valid types are STRING, INTEGER and FLOAT.
STRINGVALUECHAR (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_IDINTEGERReserved for IBM internal use.
SEQUENCEDOUBLE NOT NULL DEFAULT 0A sequence number that determines the display order of attribute values for a given attribute.
INTEGERVALUEINTEGERIf 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.
FLOATVALUEDOUBLEIf 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_IDBIGINT NOT NULLThe unique identifier of the catalog entry that is assigned this attribute value. The CATENTRY_ID is set to 0 for allowed values of an attribute.
NAMEVARCHAR (254)The name is the string representation of the value for this attribute value.
FIELD1INTEGERCustomizable.
IMAGE1VARCHAR (254)The path of the first image of this attribute value.
IMAGE2VARCHAR (254)The path of the second image of this attribute value.
FIELD2VARCHAR (254)Customizable.
FIELD3VARCHAR (254)Customizable.
OIDVARCHAR (64)Reserved for IBM internal use.
QTYUNIT_IDCHAR (16)The units in which this attribute value is measured.
ATTACHMENT_IDBIGINTThe reference number of an attachment that is associated with the attribute value.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ATTRVALUE_ID+LANGUAGE_IDPrimary Key
I0000020ATTRIBUTE_ID+CATENTRY_ID+LANGUAGE_ID+NAMEUnique Index
I0000021 ATTRIBUTE_ID+CATENTRY_ID+STRINGVALUE+LANGUAGE_ID+INTEGERVALUE+FLOATVALUEUnique Index
I0000453CATENTRY_IDNon-Unique Index
I0001235ATTACHMENT_IDNon-Unique Index
I0001236ATTRIBUTE_ID+LANGUAGE_IDNon-Unique Index
I194153ATTRTYPE_ID+CATENTRY_ID+LANGUAGE_ID+SEQUENCENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1016ATTACHMENT_IDATTACHMENTATTACHMENT_IDCascade
F_1017QTYUNIT_IDQTYUNITQTYUNIT_IDCascade
F_72OPERATOR_IDOPERATOROPERATOR_IDCascade
F_73ATTRTYPE_IDATTRTYPEATTRTYPE_IDCascade
F_74CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_75ATTRIBUTE_ID+LANGUAGE_IDATTRIBUTEATTRIBUTE_ID+LANGUAGE_IDCascade
F_76LANGUAGE_IDLANGUAGELANGUAGE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_593ATTRVALUE_ID+LANGUAGE_IDPKGATTRVALATTRVALUE_ID+LANGUAGE_IDCascade