Reference > Database > WebSphere Commerce database tables > M
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 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 SQL100520030354750 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
Related reference
_vcc_freeselect_bottom_