Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: STLOC
Represents store location information.
Column Name Column Type Description STLOC_ID INTEGER NOT NULL Store location ID. IDENTIFIER VARCHAR(128) NOT NULL Store location external identifier. (unique index) PHONE CHAR(32) Store location phone number. FAX CHAR(32) Store location fax number. ADDRESS1 VARCHAR(128) Store location address line 1. ADDRESS2 VARCHAR(64) Store location address line 2. ADDRESS3 VARCHAR(64) Store location address line 3 CITY VARCHAR(128) The city that the store locates. STATE VARCHAR(128) The state or province of the store location. COUNTRY VARCHAR(128) The country or region of the store location. ZIPCODE CHAR(40) The zip or postal code of the store location. ACTIVE SMALLINT NOT NULL DEFAULT 1 1 if the store is active. Otherwise, 0. LATITUDE DECIMAL (20,5) NOT NULL Latitude of the store in degrees north or south of the equator. LONGITUDE DECIMAL (20,5) NOT NULL Longitude of the store in degrees east or west of the Greenwich meridian. GEONODE_ID INTEGER The ID of the geo node that the store locates. Foreign key to GEONODE.GEONODE_ID. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001209 IDENTIFIER Unique Index SQL100520030431980 STLOC_ID Primary Key I0001210 LATITUDE+LONGITUDE Non-Unique Index I0001211 GEONODE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3569 GEONODE_ID GEONODE GEONODE_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3583 STLOC_ID INVAVL STLOC_ID Cascade F_3588 STLOC_ID INVCNFREL STLOC_ID Cascade F_3578 STLOC_ID STLFFMREL STLOC_ID Cascade F_3570 STLOC_ID STLOCATTR STLOC_ID Cascade F_3572 STLOC_ID STLOCDS STLOC_ID Cascade _vcc_freeselect_bottom_