Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ATTR
Stores attribute dictionary attributes which can be shared by catalog entries.
Column Name Column Type Description ATTR_ID BIGINT NOT NULL The unique identifier for this attribute. IDENTIFIER VARCHAR(254) NOT NULL An external identifier for the attibute ATTRTYPE_ID CHAR(16) NOT NULL The attribute type. For example, INTEGER, STRING, or FLOAT. ATTRDICT_ID BIGINT The reference number of the attribute dictionary to which this attribute belongs. Null for a local attribute. STOREENT_ID INTEGER NOT NULL The reference number of the store entity to which this attribute belongs. SEQUENCE DOUBLE NOT NULL DEFAULT 0 The display order of attributes in an attribute group or in the root of the attribute dictionary. DISPLAYABLE INTEGER This flag identifies if this attribute is displayable on the store front. This flag can be used to temporarily hide an attribute on the store front. It can also used for attributes that belong to a web crawler (such as Google's web crawling robot), that is not for display to customer. A value of 1 or null indicates that the attribute is displayable, while a value of 0 indicates that the attribute is not displayable. SEARCHABLE INTEGER This flag identifies if this attribute can be searched. Searchable attributes can be indexed to search engine. A value of 1 indicates that the attribute is searchable, while a value of 0 or null indicates that the attribute is not searchable. COMPARABLE INTEGER This flag identifies if this attribute can be used for comparison. A value of 1 indicates that the attribute can be used for comparison, while a value of 0 or null indicates that the attribute cannot be used for comparison. For example, attribute "Auto On/Off" is marked as comparable for all coffee makers. If a shopper selects this attribute on the store front page, only coffee makers that have the "Auto On/Off" feature will be displayed. FIELD1 INTEGER Customizable field. FIELD2 INTEGER Customizable field. FIELD3 VARCHAR(254) Customizable field. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved IBM Internal Use.
Indexes Index Name Indexed Column Names Index Type I0001203 IDENTIFIER+ATTRDICT_ID Unique Index SQL100520030258760 ATTR_ID Primary Key I0001204 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3552 ATTRDICT_ID ATTRDICT ATTRDICT_ID Cascade F_3551 ATTRTYPE_ID ATTRTYPE ATTRTYPE_ID Cascade F_3553 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3556 ATTR_ID ATTRDESC ATTR_ID Cascade F_3565 ATTR_ID ATTRDICTGRPATTRREL ATTR_ID Cascade F_3554 ATTR_ID ATTRVAL ATTR_ID Cascade F_3567 ATTR_ID CATENTRYATTR ATTR_ID Cascade _vcc_freeselect_bottom_