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:

NameTypeDescription
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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ADDRBOOK_IDPrimary Key
I0000013ADDRBOOK_ID+MEMBER_IDUnique Index
I0000014MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_57MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_58ADDRBOOK_IDADDRESSADDRBOOK_IDCascade