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:

MEMBER_IDBIGINT NOT NULLForeign key to the MEMBER table for the member who plays this role. This member can be a user or an organizational entity.
ROLE_IDINTEGER NOT NULLForeign key to the ROLE table.
ORGENTITY_IDBIGINT NOT NULLForeign key to the ORGENTITY table for the orgEntity for which the member plays this role.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType
I0000275MEMBER_ID+ORGENTITY_IDNon-Unique Index
I0000329ORGENTITY_ID+ROLE_IDNon-Unique Index
I0000617ROLE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType