PKGATTR

This table holds package attributes. Package attributes are inherited from the attributes of the products that are contained within packages.

Column Descriptions:

NameTypeDescription
PKGATTR_IDBIGINT NOT NULLThe internal reference number of the package attribute.
ATTRIBUTE_IDBIGINT NOT NULLThe reference to an attribute of a product that is contained within the package.
LANGUAGE_IDINTEGER NOT NULLThe language that this attribute pertains to. For a list of language components, see the LANGUAGE table.
CATENTRY_IDBIGINTThe reference number of the package.
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>PKGATTR_ID+LANGUAGE_IDPrimary Key
I0000187CATENTRY_ID+LANGUAGE_ID+ATTRIBUTE_IDUnique Index
I0001271ATTRIBUTE_ID+LANGUAGE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_588CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_589LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_590ATTRIBUTE_ID+LANGUAGE_IDATTRIBUTEATTRIBUTE_ID+LANGUAGE_IDCascade