Role Assignments (ROLEASSIGHISTORY Table)

The ROLEASSIGMENT table maintains assignment of roles to users. When changes are made to the ROLEASSIGNMENT table, the old information is stored in the ROLEASSIGHISTORY table.

A change to the ROLEASSIGMENT table role is always accompanied with a change to the MEMBER table (the member version is incremented). The ROLEASSIGHISTORY table inherits the member version from the MEMBER table.

This history table has MEMBERID, MEMBERVERSION as the set keys. All roles assigned for the specific version can be found for this combination.