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