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 Descriptions:

Name	Type	Description
STADDRESS_ID	INTEGER NOT NULL	Generated unique key.
ADDRESS1	VARCHAR (256)	The first line of the store address.
MEMBER_ID	BIGINT NOT NULL	The owner of this address.
ADDRESS2	VARCHAR (128)	The second line of the store address.
ADDRESS3	VARCHAR (128)	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. Ensure that 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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	STADDRESS_ID	Primary Key
I0000231	MEMBER_ID+NICKNAME	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_757	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	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

Related reference
Fulfillment data model
Store data model
Vendor data model