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 Description(s):
Column NameColumn TypeDescription
MEMBER_ID BIGINT NOT NULL Foreign key to the MEMBER table for the member who plays this role.
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031239300 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
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback