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 Name Column Type Column Description
MEMBER_ID BIGINT
NOT NULL
Foreign key to the MEMBER table for the member who plays this role.
ORGENTITY_ID BIGINT
NOT NULL
Foreign key to the ORGENTITY table for the orgEntity for which the member plays this role.
ROLE_ID INTEGER
NOT NULL
Foreign key to the ROLE table.
Indexes:
Index Name Indexed Column Names Index Type
I0000275 MEMBER_ID, ORGENTITY_ID Non-Unique Index
I0000329 ORGENTITY_ID, ROLE_ID Non-Unique Index
SQL030416035001940 MEMBER_ID, ROLE_ID, ORGENTITY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable