Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: STLOCDS
Contains language specific store detailed descriptions.
Column Name Column Type Description STLOCDS_ID INTEGER NOT NULL Store description ID. STLOC_ID INTEGER NOT NULL Store location Id. Foreign key to STLOC.STLOC_ID LANGUAGE_ID INTEGER NOT NULL Language Id. Foreign key to LANGUAGE.LANGUAGE_ID NAME VARCHAR(128) NOT NULL Name of the store. DESCRIPTION VARCHAR(2000) Store description. IMAGE1 VARCHAR(254) Store image1 location. IMAGE2 VARCHAR(254) Store image2 location. FIELD1 VARCHAR(2000) Store information body 1. FIELD2 VARCHAR(2000) Store information body 2. FIELD3 VARCHAR(2000) Store information body 3. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001214 STLOC_ID+LANGUAGE_ID Unique Index SQL100520030432310 STLOCDS_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3573 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade F_3572 STLOC_ID STLOC STLOC_ID Cascade _vcc_freeselect_bottom_