Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ATTRDESC
This table holds the language sensitive attribute description.
Column Name Column Type Description ATTR_ID BIGINT NOT NULL The reference number to an attribute in the ATTR table. LANGUAGE_ID INTEGER NOT NULL The language for this attribute description. ATTRTYPE_ID CHAR(16) NOT NULL The attribute type. NAME VARCHAR(254) NOT NULL The name of the attribute. DESCRIPTION VARCHAR(254) The attribute description. DESCRIPTION2 VARCHAR(254) An additional description field for this attribute FIELD1 VARCHAR(254) Customizable field GROUPNAME VARCHAR(64) Specifies the name of the group of attributes. All related attributes should be created with the same groupname. QTYUNIT_ID CHAR(16) The units in which this attribute is measured. NOTEINFO VARCHAR(64) Auxiliary attribute data such as a footnote. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type SQL100520030258900 ATTR_ID+LANGUAGE_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3556 ATTR_ID ATTR ATTR_ID Cascade F_3557 ATTRTYPE_ID ATTRTYPE ATTRTYPE_ID Cascade F_3558 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade F_3559 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3562 ATTR_ID LANGUAGE_ID ATTRVALDESC ATTR_ID Cascade _vcc_freeselect_bottom_