Database Table: ADDRESS

This table stores the addresses of members in the WebSphere Commerce system. The addresses can be the members own addresses or for their friends, associates, or clients, and so on. Some columns here replace columns used in previous versions.

Column Name Column Type Column Description
ADDRBOOK_ID BIGINT
NOT NULL
Foreign key to the ADDRBOOK table for the address book to which this address belongs, replacing the SASHNBR column in the SHADDR table used in previous versions of WebSohere Commerce or WebSphere Commerce Suite.
ADDRESS1 VARCHAR (50)
NULL
Address line 1, replacing SAADDR1 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
ADDRESS2 VARCHAR (50)
NULL
Address line 2, replacing SAADDR2 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
ADDRESS3 VARCHAR (50)
NULL
Address line 3, replacing SAADDR3 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
ADDRESSTYPE CHARACTER (5)
NULL
Type of address, valid values are configurable by using a properties file: S (shipto), B (billto), and SB (both shipto and billto). A single address may be of different types. If a properties file cannot be found, a default of SB will be used.
ADDRESS_ID BIGINT
NOT NULL
Unique reference number, internally generated. This is a primary key, replacing the SASHNBR column in the SHADDR table used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
BESTCALLINGTIME CHARACTER (1)
NULL
The best time to call, replacing SABTCALL used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. Valid values are D (daytime) and E (evening).
BILLINGCODE VARCHAR (17)
NULL
A code to identify the shipping or billing information.
BILLINGCODETYPE CHARACTER (2)
NULL
The code designating the system or method of code structure used for billing.
BUSINESSTITLE VARCHAR (128)
NULL
The business title. For example, Manager or Chief Executive Officer. LDAP uses a length of 128 characters for title attribute in ePerson. Compare with the BCTITLE column in the BUCONT table.
CITY VARCHAR (128)
NULL
The city, replacing SACITY used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
COUNTRY VARCHAR (128)
NULL
The country or region, replacing SACNTRY used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
EMAIL1 VARCHAR (256)
NULL
The primary e-mail address, replacing SAEMAIL1 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
EMAIL2 VARCHAR (256)
NULL
The secondary e-mail address.
FAX1 VARCHAR (32)
NULL
The primary fax number 1, replacing SAFAX used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
FAX2 VARCHAR (32)
NULL
The secondary fax number.
FIELD1 VARCHAR (64)
NULL
Customizable. This column replaces the SAFIELD1 column in the SHADDR table (used in previous versions of WebSphere Commerce or WebSphere Commerce Suite) and accepts up to 3 characters.
FIELD2 VARCHAR (64)
NULL
Customizable. This column replaces the SAFIELD2 column in the SHADDR table (used in previous versions of WebSphere Commerce or WebSphere Commerce Suite) and accepts up to one character.
FIELD3 VARCHAR (64)
NULL
Compare with the BCFIELD3 column in the BUCONT.
FIRSTNAME VARCHAR (128)
NULL
First name of the person to which this address applies, replacing SAFNAME used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
ISPRIMARY INTEGER
NULL
Specifies whether the address specified is a primary address for the user. Valid values are 1 (primary address) or 0 (non-primary address). This allows multiple addresses of each ADDRESSTYPE and one of them to be designated as primary.
LASTCREATE TIMESTAMP
NULL
The date and time the row was created, replacing SASTMP used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
LASTNAME VARCHAR (128)
NULL
Last name of the person to which this address applies, replacing SALNAME used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
MEMBER_ID BIGINT
NOT NULL
Foreign key to the MEMBER table for the member who owns this address.
MIDDLENAME VARCHAR (128)
NULL
Middle name or initials of the person to which this address applies, replacing SAMNAME used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
NICKNAME VARCHAR (254)
NOT NULL
The nickname or identifier of the address, replacing SANICK used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. Among all the addresses owned by a member, their nicknames must be unique.
OFFICEADDRESS VARCHAR (128)
NULL
Desktop delivery or office address associated with a shipping address.
ORGNAME VARCHAR (128)
NULL
If this is a business address, the name of the organization to for this address. This is not the name of the organization that owns the address book with this address. This column replaces SAREPCOM used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
ORGUNITNAME VARCHAR (128)
NULL
Name of the organizational unit to which this address information applies, if this is a business address. See comment on ORGNAME above.
PACKAGESUPPRESSION INTEGER
NULL
Specifies whether or not to include package inserts. Valid values are 1 (include) or 0 (do not include).
PERSONTITLE VARCHAR (50)
NULL
Title of the person to which this address applies, replacing SATITLE used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. LDAP uses a length of 50. Valid values are Dr, Prof, Rev, Mr, Mrs, Ms, and N (not provided). The default is N.
PHONE1 VARCHAR (32)
NULL
The primary phone number, replacing SAPHONE1 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
PHONE1TYPE CHARACTER (3)
NULL
Phone type for the primary phone number, such as TTY for a teletypewriter for people who have a hearing impairment or PHN for a standard phone. This column replaces SADPHTYP.
PHONE2 VARCHAR (32)
NULL
The secondary phone number, replacing SAPHONE2 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
PHONE2TYPE CHARACTER (3)
NULL
Phone type for the secondary phone number, such as TTY for a teletypewriter for people who have a hearing impairment or PHN for a standard phone. This column replaces SAEPHTYP.
PUBLISHPHONE1 INTEGER
NULL
Specifies whether or not the primary phone number is listed. Valid values are 1 (listed) or 0 (unlisted).
PUBLISHPHONE2 INTEGER
NULL
Specifies whether or not the secondary phone number is listed. Valid values are 1 (listed) or 0 (unlisted).
SELFADDRESS INTEGER
NOT NULL, DEFAULT 0
Specifies whether or not the address belongs to the user. Valid values are 1 (the address belongs to the user) or 0 (the number does not belong to the user; it may belong to a friend, associate, or relative).
SHIPPINGGEOCODE VARCHAR (254)
NULL
Shipping code based on geographical region. This value is used for integration with Taxware.
STATE VARCHAR (128)
NULL
State or province, replacing SASTATE used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
STATUS CHARACTER (1)
NULL
Specifies the status of the address. Valid values are Permanent (current) or temporary (historical). This column replaces SAADRFLAG used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
TAXGEOCODE VARCHAR (254)
NULL
Tax code based on geographical region, used for integration with Taxware.
ZIPCODE VARCHAR (40)
NULL
ZIP or postal code, replacing SAZIPC used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
Indexes:
Index Name Indexed Column Names Index Type
I0000015 ADDRBOOK_ID, ADDRESSTYPE, ISPRIMARY, STATUS Non-Unique Index
I0000016 MEMBER_ID, STATUS, SELFADDRESS, ADDRESSTYPE, ISPRIMARY Non-Unique Index
I0000346 LASTNAME Non-Unique Index
SQL030416034835120 ADDRESS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_58 ADDRBOOK_ID ADDRBOOK ADDRBOOK_ID Cascade
F_59 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_499 ADDRESS_ID ORDERITEMS ALLOCADDRESS_ID Cascade
F_503 ADDRESS_ID ORDERITEMS ADDRESS_ID Cascade
F_515 ADDRESS_ID ORDERS ADDRESS_ID Cascade
F_812 ADDRESS_ID SUBORDERS ADDRESS_ID Cascade