This table holds product Attributes which are used for descriptive or SKU resolution purposes.
Column Name | Column Type | Column Description |
---|---|---|
ATTRIBUTE_ID | BIGINT NOT NULL |
The internal reference number of the Attribute. |
ATTRTYPE_ID | CHARACTER (16) NOT NULL |
The type of the corresponding Attribute value. Foreign key to the ATTRTYPE table. |
CATENTRY_ID | BIGINT NULL |
The reference number of the Product to which this Attribute belongs. |
DESCRIPTION | VARCHAR (254) NULL |
The Attribute description. |
DESCRIPTION2 | VARCHAR (254) NULL |
An additional description field for this Attribute. |
FIELD1 | VARCHAR (254) NULL |
Customizable. |
GROUPNAME | VARCHAR (64) NULL |
Specifies the name of the group of attributes. All related attributes should be created with the same groupname. |
LANGUAGE_ID | INTEGER NOT NULL |
The language that this Attribute pertains to. For a list of language components, see the LANGUAGE table. |
MULTITYPE | CHARACTER (1) NULL |
Reserved for IBM internal use. |
NAME | VARCHAR (254) NULL |
The name given to this Attribute. |
NOTEINFO | VARCHAR (64) NULL |
Auxiliary attribute data such as a footnote. |
OID | VARCHAR (64) NULL |
Reserved for IBM internal use. |
QTYUNIT_ID | CHARACTER (16) NULL |
The units in which this attribute is measured. |
SEQUENCE | DOUBLE NOT NULL, DEFAULT 0 |
A sequence number that determines the display order of Attributes for a given product. |
USAGE | CHARACTER (1) NULL, DEFAULT '1' |
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 use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000019 | CATENTRY_ID, LANGUAGE_ID, NAME | Unique Index |
I0000298 | GROUPNAME, SEQUENCE | Non-Unique Index |
SQL030416034837920 | ATTRIBUTE_ID, LANGUAGE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint 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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint 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 |