Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: STLOCATTR
Holds language specific store searchable attributes.
Column Name Column Type Description STLOCATTR_ID INTEGER NOT NULL Store searchable attribute ID. LANGUAGE_ID INTEGER NOT NULL Language ID. Foreign key to LANGUAGE.LANGUAGE_ID STLOC_ID INTEGER NOT NULL Store location Id. Foreign key to STLOC.STLOC_ID. NAME VARCHAR(64) NOT NULL The name of the attribute. E.g. "Pharmacy". DISPLAYNAME VARCHAR(2000) The display name of the attribute. VALUE VARCHAR(128) NOT NULL The value of the attribute. E.g. "true". DISPLAYVALUE VARCHAR(2000) The display value of the attribute. IMAGE VARCHAR(254) The image location of the attribute. DISPLAYABLE SMALLINT NOT NULL DEFAULT 1 A flag to indicate whether the attribute is displayable. 1 when it is displayable; otherwise, 0. SEQUENCE DOUBLE Display order sequence. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001212 STLOC_ID+NAME+LANGUAGE_ID Unique Index SQL100520030432130 STLOCATTR_ID Primary Key I0001213 VALUE Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3571 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade F_3570 STLOC_ID STLOC STLOC_ID Cascade _vcc_freeselect_bottom_