Reference > Database > WebSphere Commerce database tables > G
WebSphere Commerce database table: GRADDR
This table stores address information for a gift registry and wish list.
Column Name Column Type Description ADDRESS_ID BIGINT NOT NULL Primary key for the address. FIELD1 INTEGER Customizable. FIELD2 INTEGER Customizable. LASTNAME VARCHAR(128) The last name of the person owning the address. FIRSTNAME VARCHAR(128) The first name of the person owning the address. MIDDLENAME VARCHAR(128) The middle name of the person owning the address. ADDRESS1 VARCHAR(128) Street address line 1 for the address. ADDRESS2 VARCHAR(64) Street address line 2 for the address. ADDRESS3 VARCHAR(50) Street address line 3 for the address. CITY VARCHAR(128) The city for the address. STATE VARCHAR(128) The state or province for the address. COUNTRY VARCHAR(128) The country for the address. ZIPCODE VARCHAR(40) The ZIP or postal code for the address. EMAIL1 VARCHAR(254) The primary e-mail address. EMAIL2 VARCHAR(254) The secondary e-mail address. TITLE VARCHAR(50) The title of the person. PHONE1 VARCHAR(32) The primary phone number for the person. PHONE2 VARCHAR(32) The secondary phone number for the person. PHONE3 VARCHAR(32) A third phone number for the person. SUFFIX VARCHAR(50) The suffix of a name (for example, "Senior" as in "John Smith Senior". FAX VARCHAR(32) The fax number for the person. FIELD3 VARCHAR(64) Customizable. FIELD4 VARCHAR(64) Customizable. FIELD5 VARCHAR(64) Customizable. SEARCHKEYLASTNAME VARCHAR(128) This column holds the generated search key value for last name. By default for english names the SOUNDEX value is generated and stored in this column and the column value is used for similar search scenario. SEARCHKEYFIRSTNAME VARCHAR(128) This column holds the generated search key value for first name. By default for english names the SOUNDEX value is generated and stored in this column and the column value is used for similar search scenario. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030338580 ADDRESS_ID Primary Key GRADDR_INDEX2 LASTNAME+FIRSTNAME+STATE Non-Unique Index I0001300 SEARCHKEYLASTNAME Non-Unique Index I0001301 SEARCHKEYFIRSTNAME Non-Unique Index
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type GRP_CONSTRAINT1 ADDRESS_ID GRPURREC ADDRESS_ID Cascade _vcc_freeselect_bottom_