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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000187 | CATENTRY_ID, LANGUAGE_ID, ATTRIBUTE_ID | Unique Index |
SQL030416035032420 | PKGATTR_ID, LANGUAGE_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|