Database Table: PKGATTR

This table holds Package Attributes. Package Attributes are inherited from the the Attributes of the Products that are contained within Packages.

Column Name Column Type Column Description
ATTRIBUTE_ID BIGINT
NOT NULL
The reference to an Attribute of a Product that is contained within the Package.
CATENTRY_ID BIGINT
NULL
The reference number of the Package.
LANGUAGE_ID INTEGER
NOT NULL
The language that this Attribute pertains to. For a list of language components, see the LANGUAGE table.
OID CHARACTER (32)
NULL
Reserved for IBM internal use.
PKGATTR_ID BIGINT
NOT NULL
The internal reference number of the Package Attribute.
Indexes:
Index Name Indexed Column Names Index Type
I0000187 CATENTRY_ID, LANGUAGE_ID, ATTRIBUTE_ID Unique Index
SQL030416035032420 PKGATTR_ID, LANGUAGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable