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