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:

ATTRIBUTE_IDBIGINT NOT NULLThe internal reference number of the attribute.
LANGUAGE_IDINTEGER NOT NULLThe language to which this attribute pertains to For a list of language components, see the LANGUAGE table.
ATTRTYPE_IDCHAR (16) NOT NULLThe type of the corresponding attribute value. Foreign key to the ATTRTYPE table.
NAMEVARCHAR (254)The name given to this attribute.
SEQUENCEDOUBLE NOT NULL DEFAULT 0A sequence number that determines the display order of attributes for a given product.
DESCRIPTIONVARCHAR (254)The attribute description.
CATENTRY_IDBIGINTThe reference number of the product to which this attribute belongs.
DESCRIPTION2VARCHAR (254)An additional description field for this attribute.
FIELD1VARCHAR (254)Customizable.
OIDVARCHAR (64)Reserved for IBM internal use.
USAGECHAR (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_IDCHAR (16)The units in which this attribute is measured.
GROUPNAMEVARCHAR (64)Specifies the name of the group of attributes. All related attributes should be created with the same groupname.
NOTEINFOVARCHAR (64)Auxiliary attribute data such as a footnote.
MULTITYPECHAR (1)Reserved for IBM internal use.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType
I0000298GROUPNAME+SEQUENCENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType