Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ATTRDICT
Stores the attribute dictionaries configured for the site. Each attribute dictionary is owned by a store, but can be used by children stores through store relationships. There can be only one attribute dictionary owned by any given store.
Column Name Column Type Description ATTRDICT_ID BIGINT NOT NULL The internal reference number of the attribute dictionary. STOREENT_ID INTEGER The reference number of the StoreEntity. NULL if this attribute dictionary applies to all stores in the site. FIELD1 INTEGER Customizable field. FIELD2 INTEGER Customizable field. FIELD3 VARCHAR(254) Customizable field. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001133 STOREENT_ID Unique Index SQL100520030259050 ATTRDICT_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3504 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3552 ATTRDICT_ID ATTR ATTRDICT_ID Cascade F_3506 ATTRDICT_ID ATTRDICTGRP ATTRDICT_ID Cascade _vcc_freeselect_bottom_