This table holds product attributes which are used for descriptive or SKU resolution purposes.
Column Descriptions
| 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)
| 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.
|