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:

ADDRBOOK_IDBIGINT NOT NULLUnique address book reference number, internally generated. This is a primary key.
MEMBER_IDBIGINT NOT NULLForeign key to the MEMBER table. The member who owns this address book. Together with ADDRBOOK.ADDRBOOK_ID column, forms a unique key.
TYPECHAR (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.
DISPLAYNAMEVARCHAR (254) NOT NULLA 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.
DESCRIPTIONVARCHAR (254)A description of the address book.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType
I0000014MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType