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 Description(s):
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_ID, 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 is no user interface and 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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000013 |
ADDRBOOK_ID+MEMBER_ID |
Unique Index |
SQL050212031156340 |
ADDRBOOK_ID |
Primary Key |
I0000014 |
MEMBER_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_57 |
MEMBER_ID |
MEMBER |
MEMBER_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_58 |
ADDRBOOK_ID |
ADDRESS |
ADDRBOOK_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.