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 |