This table holds catalog entry attributes used for
descriptive or SKU resolution purposes. An attribute stored in this
table is for a single catalog entry and is not shared between
catalog entries. Attribute dictionary attributes are stored in the
ATTR table.
Column Descriptions:
| Name | Type | Description |
| ATTRIBUTE_ID | BIGINT NOT NULL | The internal reference number of the
attribute. |
| LANGUAGE_ID | INTEGER NOT NULL | The language to which this attribute pertains to
For a list of language components, see the LANGUAGE table. |
| ATTRTYPE_ID | CHAR (16) NOT NULL | The type of the corresponding attribute value.
Foreign key to the ATTRTYPE table. |
| NAME | VARCHAR (254) | The name given to this attribute. |
| SEQUENCE | DOUBLE NOT NULL DEFAULT 0 | A sequence number that determines the display
order of attributes for a given product. |
| DESCRIPTION | VARCHAR (254) | The attribute description. |
| CATENTRY_ID | BIGINT | The reference number of the product to which this
attribute belongs. |
| DESCRIPTION2 | VARCHAR (254) | An additional description field for this
attribute. |
| FIELD1 | VARCHAR (254) | Customizable. |
| OID | VARCHAR (64) | Reserved for IBM internal use. |
| USAGE | CHAR (1) DEFAULT '1' | A code that represents the purpose of the
attribute. NULL or "1" indicates SKU-resolution. "2" indicates a
descriptive attribute and should not be used to resolve SKUs. The
values NULL and "0" through "9" are reserved for IBM internal
use. |
| QTYUNIT_ID | CHAR (16) | The units in which this attribute is
measured. |
| GROUPNAME | VARCHAR (64) | Specifies the name of the group of attributes.
All related attributes should be created with the same
groupname. |
| NOTEINFO | VARCHAR (64) | Auxiliary attribute data such as a footnote. |
| MULTITYPE | CHAR (1) | Reserved for IBM internal use. |
| OPTCOUNTER | SMALLINT | 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> | ATTRIBUTE_ID+LANGUAGE_ID | Primary Key |
| I0000019 | CATENTRY_ID+LANGUAGE_ID+NAME | Unique Index |
| I0000298 | GROUPNAME+SEQUENCE | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_1018 | QTYUNIT_ID | QTYUNIT | QTYUNIT_ID | Cascade |
| F_69 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
| F_70 | ATTRTYPE_ID | ATTRTYPE | ATTRTYPE_ID | Cascade |
| F_71 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_590 | ATTRIBUTE_ID+LANGUAGE_ID | PKGATTR | ATTRIBUTE_ID+LANGUAGE_ID | Cascade |
| F_75 | ATTRIBUTE_ID+LANGUAGE_ID | ATTRVALUE | ATTRIBUTE_ID+LANGUAGE_ID | Cascade |