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 |