This table contains information about an address book. An address book is a container for addresses owned by a member. A member can only have one address book.
Column Descriptions
| Column Name
| Column Type
| Description
|
| ADDRBOOK_ID
| BIGINT NOT NULL
| Unique address book reference number, internally generated. This is a primary key.
|
| MEMBER_ID
| BIGINT NOT NULL
| Foreign key to the MEMBER table. The member who owns this address book. Together with ADDRBOOK.ADDRBOOK_ID column, forms a unique key.
|
| TYPE
| CHAR(1)
| The type of address book. Valid values are P (primary address book) or S (secondary address book). Only one (primary) address book per member is supported.
|
| DISPLAYNAME
| VARCHAR(254) NOT NULL
| A short name used to refer to the address book. This name is useful when listing an address book on a single line. Currently, there are no user interface or commands to manage the address book, so a default value is generated for the display name.
|
| DESCRIPTION
| VARCHAR(254)
| A description of the address book.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|