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:
Name 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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
Indexes:
Name Column Names Type <SYSTEM-GENERATED> PKGATTRVAL_ID+LANGUAGE_ID Primary Key I0000188 CATENTRY_ID+LANGUAGE_ID+ATTRVALUE_ID Unique Index I0001272 ATTRVALUE_ID+LANGUAGE_ID Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns 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
Related reference
Package data model