PKGATTR

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

Column Descriptions:

Name	Type	Description
PKGATTR_ID	BIGINT NOT NULL	The internal reference number of the package attribute.
ATTRIBUTE_ID	BIGINT NOT NULL	The reference to an attribute of a product that is contained within the package.
LANGUAGE_ID	INTEGER NOT NULL	The language that this attribute pertains to. For a list of language components, see the LANGUAGE table.
CATENTRY_ID	BIGINT	The reference number of the package.
OID	CHAR (32)	Reserved for IBM 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>	PKGATTR_ID+LANGUAGE_ID	Primary Key
I0000187	CATENTRY_ID+LANGUAGE_ID+ATTRIBUTE_ID	Unique Index
I0001271	ATTRIBUTE_ID+LANGUAGE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_588	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade
F_589	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_590	ATTRIBUTE_ID+LANGUAGE_ID	ATTRIBUTE	ATTRIBUTE_ID+LANGUAGE_ID	Cascade

Related reference
Package data model