WebSphere Commerce database table: WMMMAP

This table defines the mapping of member information between the WebSphere Commerce database and the WebSphere Member Manager member repository (a database or an LDAP repository).


Column Description(s):
Column NameColumn TypeDescription
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 WebSphere Member Manager.
LASTSYNC TIMESTAMP The date and time of the last synchronization between WebSphere Commerce and WebSphere Member Manager, for the current record.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000425 MEMBER_UNIQUE_ID Unique Index
SQL050212031326820 MEMBER_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1084 MEMBER_ID MEMBER MEMBER_ID Cascade

Feedback