ATTR

Stores attribute dictionary attributes. These attributes can be used for descriptive or SKU resolution purposes, and can be shared by catalog entries. Non attribute dictionary attributes used for a single catalog entry are stored in the ATTRIBUTE table.

Column Descriptions:

NameTypeDescription
ATTR_IDBIGINT NOT NULLThe unique identifier for this attribute.
IDENTIFIERVARCHAR (254) NOT NULLAn external identifier for the attibute
ATTRTYPE_IDCHAR (16) NOT NULLThe attribute type. For example, INTEGER, STRING, or FLOAT.
ATTRDICT_IDBIGINTThe reference number of the attribute dictionary to which this attribute belongs. Null for a local attribute.
STOREENT_IDINTEGER NOT NULLThe reference number of the store entity to which this attribute belongs.
SEQUENCEDOUBLE NOT NULL DEFAULT 0The display order of attributes in an attribute group or in the root of the attribute dictionary.
DISPLAYABLEINTEGERThis 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.
SEARCHABLEINTEGERThis 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.
COMPARABLEINTEGERThis 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.
FIELD1INTEGERCustomizable field.
FIELD2INTEGERCustomizable field.
FIELD3VARCHAR (254)Customizable field.
ATTRUSAGEINTEGERDefines the usage of the attribute. 1 - Attribute with allowed values. When assign this type of attribute to catalog entry, user need to choose from the predefined allowed values. 2 or null - Attribute with assigned values.This type of attribute does not have predefined allowed value. When assign this type of attribute to catalog entry, user need to input a value. This value belongs to the catalog entry.
STOREDISPLAYSMALLINTReserved for IBM internal use.
FACETABLESMALLINT NOT NULL DEFAULT 0Specifies that the attribute is used as a facet in the storefront for faceted navigation.
MERCHANDISABLEINTEGERSpecifies that the attribute is used in creating merchandising rules. This indicates that the attribute is for internal business use only and does not display to customers unless it is also set to be displayable, searchable, or facetable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ATTR_IDPrimary Key
I0001203IDENTIFIER+ATTRDICT_IDUnique Index
I0001204STOREENT_IDNon-Unique Index
I0001464FACETABLENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3551ATTRTYPE_IDATTRTYPEATTRTYPE_IDCascade
F_3552ATTRDICT_IDATTRDICTATTRDICT_IDCascade
F_3553STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3554ATTR_IDATTRVALATTR_IDCascade
F_3556ATTR_IDATTRDESCATTR_IDCascade
F_3565ATTR_IDATTRDICTGRPATTRRELATTR_IDCascade
F_3567ATTR_IDCATENTRYATTRATTR_IDCascade
F_3670ATTR_IDCFCONDATTR_IDCascade
F_3680ATTR_IDATTRDICTSRCHCONFATTR_IDCascade
F_3732ATTR_IDFACETATTR_IDCascade