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:

NameTypeDescription
PKGATTRVAL_IDBIGINT NOT NULLThe internal reference number of the package attribute value.
ATTRVALUE_IDBIGINT NOT NULLThe reference to an attribute value of a product attribute.
LANGUAGE_IDINTEGER NOT NULLThe language that this attribute value pertains to. For a list of language components, see the LANGUAGE table.
CATENTRY_IDBIGINT NOT NULLThe package that this attribute value describes.
OIDCHAR (32)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PKGATTRVAL_ID+LANGUAGE_IDPrimary Key
I0000188CATENTRY_ID+LANGUAGE_ID+ATTRVALUE_IDUnique Index
I0001272ATTRVALUE_ID+LANGUAGE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_591LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_592CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_593ATTRVALUE_ID+LANGUAGE_IDATTRVALUEATTRVALUE_ID+LANGUAGE_IDCascade