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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000188 CATENTRY_ID+LANGUAGE_ID+ATTRVALUE_ID Unique Index
SQL050212031255060 PKGATTRVAL_ID+LANGUAGE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback