Reference > Database > WebSphere Commerce database tables > W
WebSphere Commerce database table: 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).
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(254) 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 SQL100520030446500 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 _vcc_freeselect_bottom_