STADDRESS

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:

NameTypeDescription
STADDRESS_IDINTEGER NOT NULLGenerated unique key.
ADDRESS1VARCHAR (256)The first line of the store address.
MEMBER_IDBIGINT NOT NULLThe owner of this address.
ADDRESS2VARCHAR (128)The second line of the store address.
ADDRESS3VARCHAR (128)The third line of the store address.
CITYVARCHAR (128)The city within this address.
COUNTRYVARCHAR (128)The country or region within this address.
EMAIL1VARCHAR (254)The primary e-mail address.
EMAIL2VARCHAR (254)The secondary e-mail address.
FAX1VARCHAR (32)The primary fax number.
FAX2VARCHAR (32)The secondary fax number.
FIELD1VARCHAR (64)Customizable.
FIELD2VARCHAR (64)Customizable.
FIELD3VARCHAR (64)Customizable.
PHONE1VARCHAR (32)The primary phone number.
PHONE2VARCHAR (32)The secondary phone number.
STATEVARCHAR (128)The state within this address.
ZIPCODEVARCHAR (40)The ZIP code within this address.
FIRSTNAMEVARCHAR (128)First name for the contact person.
LASTNAMEVARCHAR (128)Last name for the contact person.
MIDDLENAMEVARCHAR (128)Middle name for the contact person.
PERSONTITLEVARCHAR (50)Title of the contact person (for example, Mr or Mrs).
BUSINESSTITLEVARCHAR (128)Occupation of the contact person (for example, Site Administrator or Customer Service Representative).
NICKNAMEVARCHAR (254) NOT NULLNickname or identifier for the address. Ensure that the nickname is unique for each store.
SHIPPINGGEOCODEVARCHAR (254)Reserved for HCL internal use.
TAXGEOCODEVARCHAR (254)Reserved for HCL internal use.
URLVARCHAR (254)The URL of the store.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STADDRESS_IDPrimary Key
I0000231MEMBER_ID+NICKNAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_757MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_314STADDRESS_IDFFMCENTDSSTADDRESS_IDCascade
F_791STADDRESS_IDSTOREENTDSSTADDRESS_ID_CONTCascade
F_792STADDRESS_IDSTOREENTDSSTADDRESS_ID_LOCCascade
F_902STADDRESS_IDVENDORDESCSTADDRESS_IDCascade