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 HCL 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 |