WebSphere Commerce database table: WMMMAP

WebSphere Commerce database table: WMMMAP

This table defines the mapping of member information between the WebSphere Commerce database and the Member Manager member repository (a database or an LDAP repository).
Column Descriptions
Column Name Column Type Description
MEMBER_ID BIGINT NOT NULL The ID for the member. It is the foreign key of the MEMBER_ID column in the MEMBER table.
MEMBER_UNIQUE_ID VARCHAR(36) NOT NULL The ID for the member defined in Member Manager.
LASTSYNC TIMESTAMP The date and time of the last synchronization between WebSphere Commerce and Member Manager, for the current record.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000425 MEMBER_UNIQUE_ID Unique Index
SQL060903235306920 MEMBER_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1084 MEMBER_ID MEMBER MEMBER_ID Cascade

Column Name	Column Type	Description
MEMBER_ID	BIGINT NOT NULL	The ID for the member. It is the foreign key of the MEMBER_ID column in the MEMBER table.
MEMBER_UNIQUE_ID	VARCHAR(36) NOT NULL	The ID for the member defined in Member Manager.
LASTSYNC	TIMESTAMP	The date and time of the last synchronization between WebSphere Commerce and Member Manager, for the current record.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
I0000425	MEMBER_UNIQUE_ID	Unique Index
SQL060903235306920	MEMBER_ID	Primary Key