Database Table: PKGATTRVAL

This table holds the values assigned to Package Attributes. Package Attribute Values are inherited from the the Attribute Values of the Products that are contained within Packages.

Column Name Column Type Column Description
ATTRVALUE_ID BIGINT
NOT NULL
The reference to an Attribute Value of a Product Attribute.
CATENTRY_ID BIGINT
NOT NULL
The Package that this Attribute Value describes.
LANGUAGE_ID INTEGER
NOT NULL
The language that this Attribute Value pertains to. For a list of language components, see the LANGUAGE table.
OID CHARACTER (32)
NULL
Reserved for IBM internal use.
PKGATTRVAL_ID BIGINT
NOT NULL
The internal reference number of the Package Attribute Value.
Indexes:
Index Name Indexed Column Names Index Type
I0000188 CATENTRY_ID, LANGUAGE_ID, ATTRVALUE_ID Unique Index
SQL030416035032790 PKGATTRVAL_ID, LANGUAGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_591 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_592 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_593 ATTRVALUE_ID, LANGUAGE_ID ATTRVALUE ATTRVALUE_ID, LANGUAGE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable