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