Database Table: ATTRIBUTE

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.
Indexes:
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
Constraints:
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

Referenced By:
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