WebSphere Commerce database table: PKGATTRVAL

This table holds the values assigned to package attributes. Package attribute values are inherited from the attribute values of the products that are contained within packages.

Column Descriptions
Column Name Column Type Description
PKGATTRVAL_ID BIGINT NOT NULL The internal reference number of the package attribute value.
ATTRVALUE_ID BIGINT NOT NULL The reference to an attribute value of a product attribute.
LANGUAGE_ID INTEGER NOT NULL The language that this attribute value pertains to. For a list of language components, see the LANGUAGE table.
CATENTRY_ID BIGINT NOT NULL The package that this attribute value describes.
OID CHAR(32) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000188 CATENTRY_ID+LANGUAGE_ID+ATTRVALUE_ID Unique Index
SQL060903235229790 PKGATTRVAL_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_593 ATTRVALUE_ID LANGUAGE_ID ATTRVALUE ATTRVALUE_ID Cascade
F_592 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_591 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference