STLOCATTR

Holds language specific store searchable attributes.

Column Descriptions:

NameTypeDescription
STLOCATTR_IDINTEGER NOT NULLStore searchable attribute ID.
LANGUAGE_IDINTEGER NOT NULLLanguage ID. Foreign key to LANGUAGE.LANGUAGE_ID
STLOC_IDINTEGER NOT NULLStore location Id. Foreign key to STLOC.STLOC_ID.
NAMEVARCHAR (64) NOT NULLThe name of the attribute, such as "Pharmacy".
DISPLAYNAMEVARCHAR (2000)The display name of the attribute.
VALUEVARCHAR (128) NOT NULLThe value of the attribute, such as "true".
DISPLAYVALUEVARCHAR (2000)The display value of the attribute.
IMAGEVARCHAR (254)The image location of the attribute.
DISPLAYABLESMALLINT NOT NULL DEFAULT 1A flag to indicate whether the attribute is displayable. 1 when it is displayable; otherwise, 0.
SEQUENCEDOUBLEDisplay order sequence.
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>STLOCATTR_IDPrimary Key
I0001212STLOC_ID+NAME+LANGUAGE_IDUnique Index
I0001213VALUENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3570STLOC_IDSTLOCSTLOC_IDCascade
F_3571LANGUAGE_IDLANGUAGELANGUAGE_IDCascade