WMMMAP

This table is used when WebSphere Commerce is configured to use LDAP. It defines the mapping between WebSphere Commerce users and organizations in the MEMBER table, and entities in WebSphere Application Server Federated Repository (LDAP). This Federated Repository is implemented using Virtual Member Manager.


Column Descriptions:

Name 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 (254) NOT NULL The ID for the member defined in Virtual Member Manager.
LASTSYNC TIMESTAMP The date and time of the last synchronization between WebSphere Commerce and Virtual Member Manager, for the current record.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


Indexes:

Name Column Names Type
<SYSTEM-GENERATED> MEMBER_ID Primary Key
I0000425 MEMBER_UNIQUE_ID Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_1084 MEMBER_ID MEMBER MEMBER_ID Cascade