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. |
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 |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_57 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_58 | ADDRBOOK_ID | ADDRESS | ADDRBOOK_ID | Cascade |