This table stores address information for a gift
registry and wish list.
Column Descriptions:
| Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
| UP_FIRSTNAME | VARCHAR (128) | The equivalent value of the FIRSTNAME column in
upper case characters. This column is used only for DB2 (LUW)
database-types to enhance performance of text-based searches issued
from Management Center. |
| UP_LASTNAME | VARCHAR (128) | The equivalent value of the LASTNAME column in
upper case characters. This column is used only for DB2 (LUW)
database-types to enhance performance of text-based searches issued
from Management Center. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | ADDRESS_ID | Primary Key |
| GRADDR_INDEX2 | LASTNAME+FIRSTNAME+STATE | Non-Unique Index |
| I0001300 | SEARCHKEYLASTNAME | Non-Unique Index |
| I0001301 | SEARCHKEYFIRSTNAME | Non-Unique Index |
| IPF00028 | UP_FIRSTNAME | Non-Unique Index |
| IPF00029 | UP_LASTNAME | Non-Unique Index |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| GRP_CONSTRAINT1 | ADDRESS_ID | GRPURREC | ADDRESS_ID | Cascade |