WebSphere Commerce database table: ATTRIBUTE

Reference > Database > WebSphere Commerce database tables > A

WebSphere Commerce database table: ATTRIBUTE

This table holds product attributes which are used for descriptive or SKU resolution purposes.

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.

Indexes
Index Name Indexed Column Names Index Type
I0000019 CATENTRY_ID+LANGUAGE_ID+NAME Unique Index
SQL100520030259820 ATTRIBUTE_ID+LANGUAGE_ID Primary Key
I0000298 GROUPNAME+SEQUENCE Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names 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 Names Constraint Type
F_75 ATTRIBUTE_ID LANGUAGE_ID ATTRVALUE ATTRIBUTE_ID Cascade
F_590 ATTRIBUTE_ID LANGUAGE_ID PKGATTR ATTRIBUTE_ID Cascade

Related reference

Attribute data model

Package data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

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 Name	Indexed Column Names	Index Type
I0000019	CATENTRY_ID+LANGUAGE_ID+NAME	Unique Index
SQL100520030259820	ATTRIBUTE_ID+LANGUAGE_ID	Primary Key
I0000298	GROUPNAME+SEQUENCE	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	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

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_75	ATTRIBUTE_ID LANGUAGE_ID	ATTRVALUE	ATTRIBUTE_ID	Cascade
F_590	ATTRIBUTE_ID LANGUAGE_ID	PKGATTR	ATTRIBUTE_ID	Cascade