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 | 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 |