This table stores address information for a gift registry.
Column Descriptions
| Column Name
| Column Type
| Description
|
| ADDRESS_ID
| BIGINT NOT NULL
| Primary key for the address.
|
| FIELD1
| INTEGER
| Customizable.
|
| FIELD2
| INTEGER
| Customizable.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
| 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.
|