WebSphere Commerce 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 Description(s):
Column NameColumn TypeDescription
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_ID, forms a unique key.
TYPE CHAR(1) 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.
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.
DESCRIPTION VARCHAR(254) A description of the address book.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000013 ADDRBOOK_ID+MEMBER_ID Unique Index
SQL050212031156340 ADDRBOOK_ID Primary Key
I0000014 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_57 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_58 ADDRBOOK_ID ADDRESS ADDRBOOK_ID Cascade

Feedback