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
|
Related reference