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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000231 | MEMBER_ID, NICKNAME | Unique Index |
SQL030416035107110 | STADDRESS_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_757 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
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 |