Reference > Database > WebSphere Commerce database tables > A
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 Name Column 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000013 ADDRBOOK_ID+MEMBER_ID Unique Index SQL100520030255930 ADDRBOOK_ID Primary Key I0000014 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_57 MEMBER_ID MEMBER MEMBER_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_58 ADDRBOOK_ID ADDRESS ADDRBOOK_ID Cascade
Related reference
_vcc_freeselect_bottom_