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. |
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 |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|