This table holds product Attributes which are used for descriptive or SKU resolution purposes.
Column Description(s):
Column Name | Column 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 |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000019 |
CATENTRY_ID+LANGUAGE_ID+NAME |
Unique Index |
SQL050212031158990 |
ATTRIBUTE_ID+LANGUAGE_ID |
Primary Key |
I0000298 |
GROUPNAME+SEQUENCE |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_70 |
ATTRTYPE_ID |
ATTRTYPE |
ATTRTYPE_ID |
Cascade |
F_69 |
CATENTRY_ID |
CATENTRY |
CATENTRY_ID |
Cascade |
F_71 |
LANGUAGE_ID |
LANGUAGE |
LANGUAGE_ID |
Cascade |
F_1018 |
QTYUNIT_ID |
QTYUNIT |
QTYUNIT_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_75 |
ATTRIBUTE_ID LANGUAGE_ID |
ATTRVALUE |
ATTRIBUTE_ID |
Cascade |
F_590 |
ATTRIBUTE_ID LANGUAGE_ID |
PKGATTR |
ATTRIBUTE_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.