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:

NameTypeDescription
MEMBER_IDBIGINT NOT NULLThe ID for the member. It is the foreign key of the MEMBER_ID column in the MEMBER table.
MEMBER_UNIQUE_IDVARCHAR (254) NOT NULLThe ID for the member defined in Virtual Member Manager.
LASTSYNCTIMESTAMPThe date and time of the last synchronization between WebSphere Commerce and Virtual Member Manager, for the current record.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MEMBER_IDPrimary Key
I0000425MEMBER_UNIQUE_IDUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1084MEMBER_IDMEMBERMEMBER_IDCascade