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 Descriptions:

Name	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. By default, a member can have only one address book, so this column is not populated. It is available for customization.
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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ADDRBOOK_ID	Primary Key
I0000013	ADDRBOOK_ID+MEMBER_ID	Unique Index
I0000014	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_57	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_58	ADDRBOOK_ID	ADDRESS	ADDRBOOK_ID	Cascade

Related reference
Member data model