MBRROLE

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:

NameTypeDescription
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.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MEMBER_ID+ROLE_ID+ORGENTITY_IDPrimary Key
I0000275MEMBER_ID+ORGENTITY_IDNon-Unique Index
I0000329ORGENTITY_ID+ROLE_IDNon-Unique Index
I0000617ROLE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_452ORGENTITY_IDORGENTITYORGENTITY_IDCascade
F_453ROLE_IDROLEROLE_IDCascade
F_454MEMBER_IDMEMBERMEMBER_IDCascade