Each row of this table represents a store address. StoreEntities, FulfillmentCenters, and
Vendors can have store addresses. Store 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 HCL internal use. |
TAXGEOCODE | VARCHAR (254) | Reserved for HCL 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 |