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:
| Name | 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. |
| ATTRUSAGE | INTEGER | Defines 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. |
| STOREDISPLAY | SMALLINT | Reserved for IBM internal use. |
| FACETABLE | SMALLINT NOT NULL DEFAULT 0 | Specifies that the attribute is used as a facet
in the storefront for faceted navigation. |
| MERCHANDISABLE | INTEGER | Specifies 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. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | ATTR_ID | Primary Key |
| I0001203 | IDENTIFIER+ATTRDICT_ID | Unique Index |
| I0001204 | STOREENT_ID | Non-Unique Index |
| I0001464 | FACETABLE | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3551 | ATTRTYPE_ID | ATTRTYPE | ATTRTYPE_ID | Cascade |
| F_3552 | ATTRDICT_ID | ATTRDICT | ATTRDICT_ID | Cascade |
| F_3553 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Referenced By Child Tables: