This table is used when HCL 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:

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 HCL 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.


NameColumn NamesType
I0000425MEMBER_UNIQUE_IDUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType