MBRROLE

This table stores role assignment for members. Each member can play one or more roles in the WebSphere Commerce system. When a member is assigned a role, the orgEntity for which the member plays that role can also be specified.

Column Descriptions:

Name	Type	Description
MEMBER_ID	BIGINT NOT NULL	Foreign key to the MEMBER table for the member who plays this role. This member can be a user or an organizational entity.
ROLE_ID	INTEGER NOT NULL	Foreign key to the ROLE table.
ORGENTITY_ID	BIGINT NOT NULL	Foreign key to the ORGENTITY table for the orgEntity for which the member plays this role.
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+ROLE_ID+ORGENTITY_ID	Primary Key
I0000275	MEMBER_ID+ORGENTITY_ID	Non-Unique Index
I0000329	ORGENTITY_ID+ROLE_ID	Non-Unique Index
I0000617	ROLE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_452	ORGENTITY_ID	ORGENTITY	ORGENTITY_ID	Cascade
F_453	ROLE_ID	ROLE	ROLE_ID	Cascade
F_454	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Related reference
Member data model