WebSphere Commerce database table: 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
Column Name Column 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 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235213800 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

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_454 MEMBER_ID MEMBER MEMBER_ID Cascade
F_452 ORGENTITY_ID ORGENTITY ORGENTITY_ID Cascade
F_453 ROLE_ID ROLE ROLE_ID Cascade