This table stores role assignment for members. Each
member can play one or more roles in the HCL Commerce system.
When a member is assigned a role, the orgEntity for which the
member plays that role can also be specified.
Column Descriptions:
| Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | 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 |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | 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 |