This table holds the values assigned to Package Attributes. Package Attribute Values are inherited from the the Attribute Values of the Products that are contained within Packages.
Column Name | Column Type | Column Description |
---|---|---|
ATTRVALUE_ID | BIGINT NOT NULL |
The reference to an Attribute Value of a Product Attribute. |
CATENTRY_ID | BIGINT NOT NULL |
The Package that this Attribute Value describes. |
LANGUAGE_ID | INTEGER NOT NULL |
The language that this Attribute Value pertains to. For a list of language components, see the LANGUAGE table. |
OID | CHARACTER (32) NULL |
Reserved for IBM internal use. |
PKGATTRVAL_ID | BIGINT NOT NULL |
The internal reference number of the Package Attribute Value. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000188 | CATENTRY_ID, LANGUAGE_ID, ATTRVALUE_ID | Unique Index |
SQL030416035032790 | PKGATTRVAL_ID, LANGUAGE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_591 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |
F_592 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
F_593 | ATTRVALUE_ID, LANGUAGE_ID | ATTRVALUE | ATTRVALUE_ID, LANGUAGE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|