ATTRDICT

Table used to store 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 Descriptions:

NameTypeDescription
ATTRDICT_IDBIGINT NOT NULLThe internal reference number of the attribute dictionary.
STOREENT_IDINTEGERThe reference number of the StoreEntity.
FIELD1INTEGERCustomizable field.
FIELD2INTEGERCustomizable field.
FIELD3VARCHAR (254)Customizable field.
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>ATTRDICT_IDPrimary Key
I0001133STOREENT_IDUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3504STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3506ATTRDICT_IDATTRDICTGRPATTRDICT_IDCascade
F_3552ATTRDICT_IDATTRATTRDICT_IDCascade