Reference > Database > WebSphere Commerce database tables > S


WebSphere Commerce database table: STADDRESS

Each row of this table represents a store address. StoreEntities, FulfillmentCenters, and Vendors can have store addresses. Sore addresses can be staged using the staging server.

Column Name Column Type Description
STADDRESS_ID INTEGER NOT NULL Generated unique key.
ADDRESS1 VARCHAR(50) The first line of the store address.
MEMBER_ID BIGINT NOT NULL The owner of this address.
ADDRESS2 VARCHAR(50) The second line of the store address.
ADDRESS3 VARCHAR(50) The third line of the store address.
CITY VARCHAR(128) The city within this address.
COUNTRY VARCHAR(128) The country or region within this address.
EMAIL1 VARCHAR(254) The primary e-mail address.
EMAIL2 VARCHAR(254) The secondary e-mail address.
FAX1 VARCHAR(32) The primary fax number.
FAX2 VARCHAR(32) The secondary fax number.
FIELD1 VARCHAR(64) Customizable.
FIELD2 VARCHAR(64) Customizable.
FIELD3 VARCHAR(64) Customizable.
PHONE1 VARCHAR(32) The primary phone number.
PHONE2 VARCHAR(32) The secondary phone number.
STATE VARCHAR(128) The state within this address.
ZIPCODE VARCHAR(40) The ZIP code within this address.
FIRSTNAME VARCHAR(128) First name for the contact person.
LASTNAME VARCHAR(128) Last name for the contact person.
MIDDLENAME VARCHAR(128) Middle name for the contact person.
PERSONTITLE VARCHAR(50) Title of the contact person (for example, Mr or Mrs).
BUSINESSTITLE VARCHAR(128) Occupation of the contact person (for example, Site Administrator or Customer Service Representative).
NICKNAME VARCHAR(254) NOT NULL Nickname or identifier for the address. Verify the nickname is unique for each store.
SHIPPINGGEOCODE VARCHAR(254) Reserved for IBM internal use.
TAXGEOCODE VARCHAR(254) Reserved for IBM internal use.
URL VARCHAR(254) The URL of the store.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000231 MEMBER_ID+NICKNAME Unique Index
SQL100520030429850 STADDRESS_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_757 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_314 STADDRESS_ID FFMCENTDS STADDRESS_ID Cascade
F_791 STADDRESS_ID_CONT STOREENTDS STADDRESS_ID Cascade
F_792 STADDRESS_ID_LOC STOREENTDS STADDRESS_ID Cascade
F_902 STADDRESS_ID VENDORDESC STADDRESS_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search