Database Table: ADDRBOOK

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 Name Column Type Column Description
ADDRBOOK_ID BIGINT
NOT NULL
Unique address book reference number, internally generated. This is a primary key.
DESCRIPTION VARCHAR (254)
NULL
A description of the address book.
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.
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 CHARACTER (1)
NULL
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.
Indexes:
Index Name Indexed Column Names Index Type
I0000013 ADDRBOOK_ID, MEMBER_ID Unique Index
I0000014 MEMBER_ID Non-Unique Index
SQL030416034834820 ADDRBOOK_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_57 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_58 ADDRBOOK_ID ADDRESS ADDRBOOK_ID Cascade