Database Table: STADDRESS

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

Column Name Column Type Column Description
ADDRESS1 VARCHAR (50)
NULL
The first line of the store address.
ADDRESS2 VARCHAR (50)
NULL
The second line of the store address.
ADDRESS3 VARCHAR (50)
NULL
The third line of the store address.
BUSINESSTITLE VARCHAR (128)
NULL
The user's business title. For example, Site Administrator, Customer Service Representative.
CITY VARCHAR (128)
NULL
The city within this address.
COUNTRY VARCHAR (128)
NULL
The country or region within this address.
EMAIL1 VARCHAR (254)
NULL
The primary e-mail address.
EMAIL2 VARCHAR (254)
NULL
The secondary e-mail address.
FAX1 VARCHAR (32)
NULL
The primary fax number.
FAX2 VARCHAR (32)
NULL
The secondary fax number.
FIELD1 VARCHAR (64)
NULL
Customizable.
FIELD2 VARCHAR (64)
NULL
Customizable.
FIELD3 VARCHAR (64)
NULL
Customizable.
FIRSTNAME VARCHAR (128)
NULL
First name for the contact person.
LASTNAME VARCHAR (128)
NULL
Last name for the contact person.
MEMBER_ID BIGINT
NOT NULL
The owner ID for this entry.
MIDDLENAME VARCHAR (128)
NULL
Middle name for the contact person.
NICKNAME VARCHAR (254)
NOT NULL
Nickname or identifier for the address. Ensure that the nickname is unique for each store.
PERSONTITLE VARCHAR (50)
NULL
Business title for the contact person.
PHONE1 VARCHAR (32)
NULL
The primary phone number.
PHONE2 VARCHAR (32)
NULL
The secondary phone number.
SHIPPINGGEOCODE VARCHAR (254)
NULL
Reserved for IBM internal use.
STADDRESS_ID INTEGER
NOT NULL
Generated unique key.
STATE VARCHAR (128)
NULL
Reserved for IBM internal use.
TAXGEOCODE VARCHAR (254)
NULL
Reserved for IBM internal use.
URL VARCHAR (254)
NULL
The URL of the store.
ZIPCODE VARCHAR (40)
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000231 MEMBER_ID, NICKNAME Unique Index
SQL030416035107110 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 STOREENTDS STADDRESS_ID_CONT Cascade
F_792 STADDRESS_ID STOREENTDS STADDRESS_ID_LOC Cascade
F_902 STADDRESS_ID VENDORDESC STADDRESS_ID Cascade